我认为您遇到的问题是，不幸的是，无法在FTS中使用领先的通配符进行搜索.如果使用CONTAINS短语搜索，则不能使用前导，而只能使用尾随功能.寻找领先的通配符搜索的解决方法.是my造成mywebsite.net中没有显示问题的原因.结合已经提到的DOT问题.有一些解决方法，但对我来说似乎很棘手-并研究FREETEXT以提高性能.

I think the problem you are having is that, unforutnately, it is not possible to search with a leading wildcard in FTS. If you are searching with the CONTAINS phrase, you cannot use leading, only the trailing functionally. Look for a workaround to leading wildcard searches. IT IS THE MY that is creating the problem in the mywebsite.net not showing. This in combination with the DOT issue already mentioned. There have been some workarounds but they seem hacky to me - and also research FREETEXT for performance gain possibility.