Hi,

Is it possible to incorporate levenshtein edit distance and double-metaphone
matching into Sql Server 2005's Full-Text Search queries using FREETEXTTABLE
or CONTAINSTABLE?

I'm working on a web-site that allows user to search multiple tables, and i
want the ability to pull back rows where the spelling is slightly out, or
contains words that sound like those provided in the query, a bit like
Google.

Also, I'd like to rank the results so that exact matches are returned at the
top of the result-set, and nearest-match or phonetic matches lower down the
list.

I've come across UDF's that provide these features but they don't appear to
be compatible with the FTS engine. I've also heard of alternative to the FTS
engine that integrate with Sql Server but I can't remember what they're
called.

Any suggestions?

Ben