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