I've been using FTS on a view composed of several tables, and this method works pretty well, as I can return ranked results using "contains table". Not sure if the method above allows for ranked results?

Also, you don't mention what happens if someone searches for "Hex Nuts" as opposed to "Hex Nut"...how do you account for that? I've resorted to stemming the search terms when the last characters are "s", "es", etc.

Does anyone have any links for "predictive" search solutions in MSSQL, to catch misspellings, etc?