If you want to find and filter some text that looks alike, in order to fix typos for example, you can use the Match Similar Text function.
This function creates a new column with the value true if the pattern matches and false if it does not.
Procedure
-
Fill in the options according to your needs.
The Reference field corresponds to some text you enter, and the Fuzziness field corresponds to the number of characters that can be added, removed or different from the Reference. This number is called the Levenshtein distance.
Note that the Reference field is case sensitive. In this example, the Reference text is new and the Levenshtein distance (Fuzziness) is 1.
In this example, the function would match words such as "few", "now", "net" or "news", but not "bow", "nap" or "led".
Results
This creates a new column with the value true if the pattern matches and false if it does not.
For more information on the Levenshtein distance, see https://en.wikipedia.org/wiki/Levenshtein_distance