Keith Tate (10/1/2013)
Have you verified that you are not running into a stop word issue? Try setting the index on the table to ignore all stop words (including the system default ones):ALTER FULLTEXT INDEX ON tablename SET STOPLIST = OFF
Doing this the 1st and 3rd query return values, but the 2nd one should also return since it has all the words of the exact search.. shouldn't it?!
I also found a problem with our fulltext, it had change_tracking = auto and since it's a table that has lots of changes the catalog was always being rebuilt and many times didn't return the desired values...
Pedro