FORMSOF Thesaurus in SQL Server

Posted by Coolcoder on Stack Overflow See other posts from Stack Overflow or by Coolcoder
Published on 2010-01-29T09:08:08Z Indexed on 2010/03/12 14:37 UTC
Read the original article Hit count: 284

Has anyone done any performance measures with this in terms of speed where there is a high number of substitutes for any given word. For instance, I want to use this to store common misspellings; expecting to have 4-10 variations of a word.

<expansion>
   <sub>administration</sub>
   <sub>administraton</sub>
   <sub>aministraton</sub>
</expansion>

When you run a fulltext search, how does performance degrade with that number of variations? for instance, I assume it has to do a separate fulltext search performing an OR?

Also, having say 20/30K entries in the Thesaurus xml file - does this impact performance?

© Stack Overflow or respective owner

Related posts about full-text-search

Related posts about tsql