find Word similarity in oracle

İki metin arasındaki benzerliği puanlayarak arama yapmak bazı konularda işimize yarayabilir.

http://www.deep-data-mining.com/2012/08/calculate-similarity-between-two.html

select utl_match.edit_distance_similarity(‘Hello’, ‘Hello’) dis from dual;
100

/*case sensitive */
select utl_match.edit_distance_similarity(‘Hello’, ‘hello’) dis from dual;
80

/*case sensitive */
select utl_match.edit_distance_similarity(‘Hello’, ‘HELLO’) dis from dual;
20

select utl_match.edit_distance_similarity(‘Hello’, ‘HLO’) dis from dual;
20

select utl_match.edit_distance_similarity(‘Hello’, ‘X’) dis from dual;
0

select utl_match.edit_distance_similarity(‘Hello’, ‘ ‘) dis from dual;
0

select utl_match.edit_distance_similarity(‘Hello’, NULL) dis from dual;

0fin Word similarity

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: