How can I optimize retrieving lowest edit distance from a large table in SQL?
- by Matt
Hey,
I'm having troubles optimizing this Levenshtein Distance calculation I'm doing. I need to do the following:
Get the record with the minimum distance for the source string as well as a trimmed version of the source string
Pick the record with the minimum distance
If the min distances are equal (original vs trimmed), choose the trimmed one…