The TEXT-DISTANCE directive measures the difference between two sequences of characters, using a specified method of measuring the distance between strings.
Syntax
Code Block |
---|
text-distance 'method' :column1 :column2 :destination |
...
Note: If either or both of the two columns do not exist, no error will be returned, and the destination column will still be created or overwritten.
Usage Notes
These distance measure methods are supported:
block-distance
block
cosine
damerau-levenshtein
dice
euclidean
generalized-jaccard
identity
jaccard
jaro
levenshtein
longest-common-subsequence
longest-common-substring
overlap-cofficient
simon-white
Example
Using this record as an example:
...