Effective full-text search: go relevant

Using pure CONTAINS can be painful. Not for you as a developer, but for your users. There is a reason why Google Search became an industry standard and even Microsoft copied Google search results to improve Bing when they saved the searches in Internet Explorer.

Ok maybe AI developers will not agree, but at least both of these are based on statistics.

Ranking in T-SQL