compare
Table of Contents
Compare
Compare allows you to compare two inputs and return the string similarity using a library of comparison methods.
Algorithms
Comparison Algorithms can be found under the Algorithm selection of the Compare task pane.
These include:
- Jaro Winkler
- Jaro
- Levenshtein Percentage
- Levenshtein Change Count
- Monge Elken
- Needleman Wunsch
- Sift 3
- Smith Waterman Gotoh
- Hamming Percentage
Each algorithm has a unique way of scoring the similarity between two values.
Below is an example of the Jaro Winkler scoring.
| First Input | Second Input | Output |
|---|---|---|
| Microsoft | Microsoft | 100 |
| Giggle | 80 | |
| DQ Global | DQ Globe | 93.05556 |
Custom Functions
DQ.COMPARE
The DQ.COMPARE function compares two values and gets a score between 0 and 100.
Parameters:
value1 (string), first comparison value
value2 (string), second comparison value
algorithm (string), comparison algorithm, from list:
- Jaro_Winkler
- Jaro
- Levenshtein_Percentage
- Levenshtein_Change_Count
- Monge_Elkan
- Needleman_Wunsch
- Sift_3
- Smith_Waterman_Gotoh
- Hamming_Percentage
- Hamming_Change_Count
returns (number), score of out 100
compare.txt · Last modified: 2023/02/23 13:54 by hayden.law