I have a database we are porting from Oracle to SQL 2008. One of our tables is 22,000,000 rows of data and need to do a full text index on it. There are 3-4 fields that need to be part of the index. I need to do fuzzy logic searching. Ideally, I would like to have a spelling checker, custom stop words and synonym database. There is between 10K lookups per day returning average of 500 results that will come via .NET web application. Around 5000 Add/Delete/Updates per day on low side, 10,000 on the high.
Should I be using SQL 2008 out of the box or look at 3rd party indexer or applications. I have not had much luck finding expert level articles on how to maximize the Full text index of SQL Server. Does anyone have more feedback or resources for information.