views:

33

answers:

0

I am using SQL Server 2008's Full Text Search engine in my website. I have a search SP, which shows results sorted based on ranking.

I break up the search string and pass it to the FTS query engine like so (search string is 'test search':

("*test*" ~ "*search*") OR ("*test*" OR "*search*").

If the results row has the row 'test search', and other has 'test something else'. The latter is being ranked higher.

I don't understand how this could be - obviously the phrase 'test search' is a closer match. I figure it has something to do with the way I'm passing the test string to FTS. Any insights? Suggestions?