• tnolan (7/21/2008)


    Not a single reference to SOUNDEX? That doesn't seem right in a spelling suggestion article.

    Soundex is horrible. And the SQL Server implementation doesn't match with the NARA Soundex standard anyway. If you want to do phonetic matching, I'd recommend starting with a better phonetic match algorithm. For spell-checking you'll get better accuracy using LCS, edit distance, or n-gram matching. Set-based operations work well with n-gram matching.