Search engine for product picker

I'm making a product picker like this one. The information about the products are stored in a MySQL database.

I'd like a search engine in order to narrow down the search results and display fewer products. How would you do this?

Use a third-party library or provider (I have some willingness to pay)? If so, which and why?

Or build it from scratch? If so, why and roughly how?