处理全文本排列SQL Server

We have a database table that holds a list of countries and basic information about them, that we use Full Text Indexing to return data to the user through a web app. I am looking into country names and the different permutations (spellings) that are possible. I will use the below country for instance.

我们有一个数据库表，其中包含国家列表和关于它们的基本信息，我们使用全文索引通过一个web应用程序向用户返回数据。例如，我将使用下面的国家。

St. Martin Saint Martin St. Marteen Sint Maarten

圣马丁圣马丁圣马丁圣马丁

As you can see, depending on the regions, the user can enter any one of those requests and expect to get the same result. I imagine to allow this to work, I lookup table of sorts is needed be able to perform the contains() against. I just wanted to know if there is a blog post, or "Best Practices" way to go about doing this.

如您所见，根据区域的不同，用户可以输入任何一个请求，并期望得到相同的结果。我想要让它工作，我需要查找表的排序才能执行contains()。我只是想知道是否有博客文章，或者“最佳实践”的方法来做这件事。

Let me know if you have any questions.

如果你有任何问题，请告诉我。

1 个解决方案

#1

Try customizing the thesaurus file. See Configure and Manage Thesaurus Files for Full-Text Search.

尝试自定义同义词典文件。有关全文搜索，请参阅配置和管理同义词库文件。