With SQL Server 2008 and forward some new functions were added for full text indexes. One function, sys.dm_fts_parser, allows you to submit a string and see exactly how it parses. For
example, a version of code that I have posted before:
In this case, using American English, without stop words, "what's" gives me "what's" and "what". You can change those last 3 parameters to match your environment (perhaps you have stop words, etc) and see what your string parses to.
Edited bySQLWorkMVPTuesday, June 26, 2012 10:02 PM