Is there a Teradata way of doing the JARO_WINKLER_SIMILARITY Function that Oracle has?
This function calculates the measure of agreement between two strings, and returns a score between 0 (no match) and 100 (perfect match).?
s1 IN VARCHAR2,
s2 IN VARCHAR2)
Table 227-6 JARO_WINKLER Function Parameters
SELECT UTL_MATCH.JARO_WINKLER_SIMILARITY('shackleford', 'shackelford') FROM DUAL;
No I don't thik there is any such function in Teradata that returns the similarity comparison of two strings. But I think the algorithm of this function can be implemented in a UDF.