SQL Server can use a thesaurus file to do substitutions in free text queries, so that a search for 'IE' might return results with 'Internet Explorer' or 'Quirky Browser' in the text.
SQL Server可以使用同义词库文件在*文本查询中进行替换,因此搜索“IE”可能会返回文本中带有“Internet Explorer”或“Quirky Browser”的结果。
Unfortunately the thesaurus file with SQL Server 2008 is empty! Are there any predefined English SQL Server thesaurus files available out there? I can't find any obvious source from searches.
不幸的是,SQL Server 2008的同义词库文件是空的!是否有可用的预定义英文SQL Server同义词库文件?我无法从搜索中找到任何明显的来源。
(Yes, I can build one if needed)
(是的,我可以根据需要建立一个)
Thanks
Ryan
1 个解决方案
#1
10
You can get one from here: SQL Server English Thesaurus for FULLTEXT Search; the site also provides instructions on how to install it.
你可以从这里得到一个:用于FULLTEXT搜索的SQL Server英文词库;该网站还提供了有关如何安装它的说明。
I haven't used it myself so I can't say if it's good or bad though.
我自己没有用它,所以我不能说它是好还是坏。
#1
10
You can get one from here: SQL Server English Thesaurus for FULLTEXT Search; the site also provides instructions on how to install it.
你可以从这里得到一个:用于FULLTEXT搜索的SQL Server英文词库;该网站还提供了有关如何安装它的说明。
I haven't used it myself so I can't say if it's good or bad though.
我自己没有用它,所以我不能说它是好还是坏。