• Todd,

    This is why FTS is hard. splitting some text by whitespace, building a list of "words" and pointers back to the text isn't difficult.

    Knowing when and how to group a some characters as a word is hard, detecting mispellings is hard. MSSQL handles the first using its parsing methods, but does not handle the second at all. Perhaps all queries need to be spell checked before going to the index.