Issue with search

Hi!

The search looks great but I need it to function in a slightly different way - to search with words (or part words) in any order. For example, if the product is called "colour copy paper", I want to be able to find it by either "paper", "copy paper", "paper copy colour", "copy paper col" etc. Using something like FTS for this purpose seems to be a major overkill...

Any help much appreciated!

view this post:
https://www.nopcommerce.com/boards/topic.aspx?topicid=3230

Thanks very much for that!! That does seem to work for most of the time, but not with all the combinations of words... Am I missing something?

tlp560 wrote:

masterslave, this topic was dupilicated here:
https://www.nopcommerce.com/boards/topic.aspx?topicid=3231&p=2


but this second link has answers which will take you forward a little further

Thanks haydie, I must admit I'm not that much closer now...

Apart from SET @Keywords = REPLACE (@Keywords, ' ', '%')
is there a further improvement that can be made to the search?

From my experience with FTS it's not the best road to take, that's all
and perhaps someone can suggest another way to optimize it!