• Actually, I wrote of this just a week ago. The Contains function is often not sufficient for end user search. It doesn't handle misspellings, suggested search, implied "AND", and crashes on use of a noise word.

    FTS is not simply an inverted index of words, but is dependent on the query pipelining that happens before the index is accessed.