Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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:

...