Netezza Fuzzy String search Functions and Examples
If you ever wondered how to verify how similar or different strings are. The Netezza SQL language supports two Netezza fuzzy string search functions: Levenshtein Edit Distance and Damerau-Levenshtein Edit Distance. You can perform the fuzzy search with help of these functions. Basically, Netezza fuzzy string search function supports a search in a form of approximate string matching that is based on the defined technique or algorithms. These functions compare two strings to show how similar or different they are. These two fuzzy functions support only VARCHAR or CHAR data…