http://www.sqlservercentral.com/Content tagged SS2K - Full Text Searching posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Full-text Search (SQL FTS) is an optional component of SQL Server 7 and later, which allows fast and efficient querying when you have large amounts of unstructured data. This is the first of a two-part article that explores the full-text language features that ship with SQL Server versions 7, 2000, and 2005, with particular focus on the new language features in SQL 2005.http://www.sqlservercentral.com/redirect/articles/2395/2006/05/02http://www.sqlservercentral.com/redirect/articles/2395/One of the features of SQL Server 2000 is the Soundex feature that allows phonetic matching. Michael Coles brings us a new toolkit that solves some of the issues that occur with soundex as well as an explanation why this occurs. http://www.sqlservercentral.com/articles/SS2K+-+Full+Text+Searching/soundmatchingandaphonetictoolkit/1978/2005/08/03http://www.sqlservercentral.com/articles/SS2K+-+Full+Text+Searching/soundmatchingandaphonetictoolkit/1978/