Attach existing search

It is because it is OR style search. To me it is more intuitive way. Somethign you expect out of the search. Isn't it?

Yes, but the problem is when you have 200 records with word "hotel" and "Lion hotel" is on 150 position. In this case users might think there is no "Lion hotel". I'm right?

Personally, I would expect to show results which include ALL of my terms. Actually, I am responsible for the input... if it does not return a match... I try to reduce or change MY terms... until it shows proper results. (just my 2 cents)

Isn't it a special case here? It is a search input for titles, and I would expect it to find exact matches (where the title begins with my terms). Comparable to an AJAX powered filter.

So, OR might not be the best choice in this particular dialog.

pepperstreet It is a search input for titles, and I would expect it to find exact matches

Fulltext natural language search does that but with relevance. It means that if there is exact match, that result will be on top of the search and then the rest. The less it conform to search pattern the less is the relevance of the search result.

It is not very obvious feature but you can even order by search relevance after search.

Sergey Fulltext natural language search does that but with relevance

Interesting. Always wondered when and why I got this extra option in "Sort by" menu ;)

Anyway, klox7 was referring to the modal window dialog:

"...attaching existing record to parent record and when you search in modal..."

Where do I enable this order by text search relevance?

It only appear when fulltext search have been applied.