Search for several phrases should be AND not OR

[rschwietzke]

When you search for "cream with" you get more results than for "cream", which indicates we run an "or" search, not an "AND".

[freddyka]

@rschwietzke These search results are because we also search inside the product description, not only the name. When we include an AND instead of an OR it will only select the products with the same text inside the description and the name.

Wouldn't it be better to only search for the name of the products instead of both description and name?

[rschwietzke]

This is, because the search is incorrect. Commerce search uses all intel of a product such as name, title, description, and attributes and indexes it. In addition, weights are added too. So you can have a RED in the title and a CAR in the desc and will find it but the resulting weight will be lower than RED and CAR in the title only.
Some reading: https://www.slideshare.net/VincenzoDAmore/ecommerce-search-engine-with-apache-lucenesolr-81760501

[rschwietzke]

It is suggested to use Lucene for search and implement a basic version of a store search based on common attributes. In addition, we can add "search as you type" support as well.