Sql Server 全文目录可以找到以下内容吗？

发布于 2024-07-14 15:47:09 字数 741 浏览 3 评论 0原文

我的字段中有以下数据，该字段由全文目录索引。

帕莫拉马市，洛杉矶，美国加利福尼亚州

简单。（我还有很多其他的，但它们工作得很好）。

现在，如果用户提供了这个不正确的拼写错误搜索词

pamorma city <-- 注意中间的“a” 第 6 个字符槽缺失

，则不会返回此数据字段。

那么，目录上的 Sql 2008 FTS 可以返回它认为接近的单词吗？

这是 sql，顺便说一句，如果这有帮助的话......

SELECT TOP(10) a.Address, AddressSearch.RANK AS TopRank
FROM Addresses a WITH (NOLOCK)
    INNER JOIN CONTAINSTABLE (Addresses, FormattedAddress, 
                             'panorma NEAR city') AS AddressSearch 
        ON a.IdAddress = AddressSearch.[KEY]

如果是这样......你也可以为 ' 定义一个权重吗？近'字也？比如 90% 匹配之类的？干杯:)

原文

i have the following data in a field, which is being indexed by a Full Text Catalog.

Pamorama City, Los Angeles,
California, United States

Simple. (I also have lots of others, but they are working fine).

Now, if the user provides this incorrect, mispelt search word

pamorma city <-- notice the middle 'a'
is missing from the 6th character slot

then this data field isn't being returned.

So, can a Sql 2008 FTS on a catalog return words which it THINKS it's close?

this is the sql, btw, if this helps...

SELECT TOP(10) a.Address, AddressSearch.RANK AS TopRank
FROM Addresses a WITH (NOLOCK)
    INNER JOIN CONTAINSTABLE (Addresses, FormattedAddress, 
                             'panorma NEAR city') AS AddressSearch 
        ON a.IdAddress = AddressSearch.[KEY]

If so .. can u also define a weight for 'close' words also? like a 90% match or something?
cheers :)

分享到QQ

分享到微博