What search engine to choose for the database of items (products, documents, etc.)?

Question

Sphinx

Hello colleagues.
There was a need to expand the possibilities of searching through the database of names (in this case, products) and to achieve a better search selection, to get away from WHERE title LIKE '%$query%'.
Accordingly, now we need to find a solution that will adequately satisfy our needs and, at the same time, not drop the performance of the system as a whole, as well as the integration of which will not take much time.
I'm looking towards ElasticSearch and Sphinx .
The first, of course, is more on hearing lately.
Maybe there are other better solutions?
Thank you.

Answer 1

Maybe there are other better solutions?

You named the most optimal and fastest solutions.
There are configs for a couple of dozen lines and you're done.
And with the sphinx in general, you can talk in the sql dialect, which is quite convenient.

Answer 2

ElasticSearch or Solr
Official solr guide suggester
autocomplete with solr
Solr Ngrams and Twitters typeaheadjs
lucene-vs-solr-vs-sphinx