Oracle function/package same as SAS spedis function [message #617209] |
Thu, 26 June 2014 02:45 |
|
rahul1982
Messages: 53 Registered: November 2011 Location: Pune
|
Member |
|
|
Hi,
As per our project requirement, we are converting SAS code to oracle PL/SQL. In SAS code we have observed spedis function is used several times for fuzzy matching. In oracle, i tried to use UTL_MATCH package but the output of this package is not same as spedis. Do we have any other oracle function/package which work exact like spedis.
Below is the sample result -
Quote:UTL_MATCH.JARO_WINKLER_SIMILARITY(input,stringcompare)
INPUT STRINGCOMPARE UTL_MATCH.JARO_WINKLER_SIMILAR Spedis_Output
session session 100 0
ession session 89 16
sxssion session 91 14
sdession session 96 12
sssion session 95 7
sessions session 97 3
sessio session 97 8
seession session 96 6
sesion session 96 4
ksession session 95 25
mession session 84 28
saccion session 74 42
|
|
|
|
|
|
Re: Oracle function/package same as SAS spedis function [message #617214 is a reply to message #617211] |
Thu, 26 June 2014 03:02 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
I don't believe that Oracle has an equivalent algorithm, however the page that you linked to looks like it gives you all the information that you need to create your own function. However, you only need to do that if the specific value is of importance. If the reason that you are using it is to create a comparison value (string 1 is closer to string 2 than string 3 is therefor use string 1) then you don't specifically need the spedis value, all you need is jw or lev values to draw that comparison.
Ed: Beaten to it by Lalit whilst typing a response.
[Updated on: Thu, 26 June 2014 03:11] Report message to a moderator
|
|
|