Full text search and typo?

I am a newbie in full text search. Please bare with me if this has been asked a thousand times, coz I couldn't seems to find anything related to this on google or this forumn.

I am just wondering how I can implement my MS SQL server (with full text search) that can handle typo?

For example, if someone enters "mirosoft" to search for microsoft, how can I handle stuff like that ?

Thx a lot

I don't think it is possible the same in SQL Server, as I have never come across of correcting the typo. Probably you need to have a applet that checks for such corrections as similar to Word.|||

While spelling corrections and google-like "suggestions" are not directly supported using MS SQL Server with Full text Search (FTS), if you are using SQL Server 2005 FTS, you can use the Thesaurus function and XML Thesaurus file to get close to what you are looking for. However, you will need first to identify the miss-spelled words and place them in the Thesaurus file (see SQL Server 2005 BOL "Configuring Thesaurus Files" for details). Let me know if you need more details on this.

Thanks,
John

SQL Full Text Search Blog
http://jtkane.spaces.live.com/