Fuzzy and non-fuzzy search capability over a TEXT index is possible for TEXT indexes of type NGRAM.
Fuzzy Search Over a TEXT Index
Fuzzy search capability over a TEXT index is possible only if the TEXT index is of type NGRAM. The GENERIC TEXT index cannot handle the fuzzy search.
Non-fuzzy Search Over a TEXT Index
Non-fuzzy search on NGRAM breaks the term into corresponding n-grams and searches for the n-grams in the NGRAM TEXT index.