All Forums Database
teradatatester 69 posts Joined 01/10
26 Sep 2012
JARO_WINKLER_SIMILARITY Function for Teradata?

Is there a Teradata way of doing the JARO_WINKLER_SIMILARITY Function that Oracle has?
http://docs.oracle.com/cd/E14072_01/appdev.112/e10577/ u_match.htm
JARO_WINKLER_SIMILARITY Function
This function calculates the measure of agreement between two strings, and returns a score between 0 (no match) and 100 (perfect match).?
Syntax
UTL_MATCH.JARO_WINKLER (
   s1  IN  VARCHAR2,
   s2  IN  VARCHAR2)
 RETURN PLS_INTEGER;?
Parameters
Table 227-6 JARO_WINKLER Function Parameters
Parameter Description
s1
 Input
 
s2
 input
 

Examples
SELECT UTL_MATCH.JARO_WINKLER_SIMILARITY('shackleford', 'shackelford') FROM DUAL;
--------------
returns 98

Qaisar Kiani 337 posts Joined 11/05
26 Sep 2012

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.

teradatatester 69 posts Joined 01/10
13 Jun 2013

Anyone already made a UDF for the JARO_WINKLER_SIMILARITY Function?

You must sign in to leave a comment.