JARO_WINKLER_SIMILARITY Function for Teradata?

Database
Junior Supporter

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

2 REPLIES
Enthusiast

Re: JARO_WINKLER_SIMILARITY Function for Teradata?

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.

Junior Supporter

Re: JARO_WINKLER_SIMILARITY Function for Teradata?

Anyone already made a UDF for the JARO_WINKLER_SIMILARITY Function?