Look up for data in excel table using Leveinshtein similarity distance Share & earn cash
Here we offer a code that can substitute the built-in search functions. Frequently when you search a word or string on an excel table you often make spelling mistakes. An effective function search must at least allow us to correct the situation and to realize our error. The proposed functions are based on The Levenshtein distance between two strings. This distance computes the minimum number of single-character edits (insertions, deletions, or substitutions) required to change one word into another.