Expand description
Name tokens and spelling similarity for labels and properties. Names of labels and properties compared the way people misspell them: tokens split on case and separators with plural endings dropped, then a spelling score. Shared by the catalog’s name suggestions and SQL’s “did you mean” errors.
Functions§
- closest
- The best-scoring candidates for
wanted(score at least 0.5), best first. - name_
similarity - Spelling similarity of two names from 0 to 1: 1 when their tokens are equal (case, separators and plural endings ignored), else the larger of the edit-distance ratio and the token overlap of the joined forms.
- name_
tokens - Lowercase name tokens: camelCase and every non-alphanumeric character
split words, and a plural ending is dropped (
ies->y;esafter o, s, x, z, ch, sh; else a finals), as the Core platform’s relationship analysis does (it dropsies/sonly).