| alternatives for utlmatch? [message #386460] |
Sun, 15 February 2009 05:41  |
ledo
Messages: 7
Registered: February 2009
|
Junior Member |
|
|
I am using the oracle built-in utl_match functions to a specific operation.
(URGENT) is there a utl_match
{utl_match.edit_distance, utl_match.edit_distance_similarity, utl_match.jaro_winkler, utl_match.jaro_winkler_similarity}
in SQL SERVER?
if not what are the alternatives for these methods with the same performance?
Thanks in advance,
LEDO
|
|
|
|
|
|
| Re: alternatives for utlmatch? [message #386462 is a reply to message #386461] |
Sun, 15 February 2009 05:55  |
ledo
Messages: 7
Registered: February 2009
|
Junior Member |
|
|
yea, am really sorry it is my fault.
I just got all what I want by using UTL_MATCH so I am asking/searching for getting an alternative because it is required to add SQL SERVER to the database layer...
anyway thanks.
|
|
|
|
|
|
| Re: alternatives for utlmatch? [message #386486 is a reply to message #386460] |
Sun, 15 February 2009 20:06 |
 |
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
The Oracle utl_match.edit_distance function is an implementation of the Levenshtein distance formula, so if you google for Levenshtein distance you should find implementations in various languages. Similary you can search for the Jaro Winkler algorithm. The similarity functions are modifications such that they return a score of 0 to 100 where 100 is an exact match, based on the algorithms. You won't find any SQL function that will work in multiple languages. You will need a separate function for each database language that you need to use it on. Although there are ANSI standards, there are still vast differences between languages.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
