Effective full-text search: go relevant
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.
Ranking is the most important when you have a huge pile of data.
Ok maybe AI developers will not agree, but at least both of these are based on statistics.