Fuzzy Search to Find Duplicates in Table

[Former Member]

Hi,

I want to find duplicates within a table based on First Name column using Fuzzy Search.

Table Tab_001 Definition:

Contact ID  |  First Name

I tried using FUZZY SEARCH in below statement but I get error saying CONTAINS accepts only string as second parameter.

Statement:

SELECT A.CONTACTID AS CONTACTID_A,

A.FIRSTNAME,

B.CONTACTID AS CONTACTID_B,

B.FIRSTNAME,

SCORE() AS SCORE

FROM Tab_001 A

INNER JOIN Tab_001 B

ON CONTAINS(A.FIRSTNAME, B.FIRSTNAME, FUZZY(0.7));

Error: SAP DBTech JDBC: [8]: invalid argument: The second argument cannot include any column: line 8 col 26 (at pos 230)

Any suggestions?

Thanks,

Anoop

[michael_kozlowski]

Check out this thread for restrictions in CONTAINS Comparing 2 columns in a table using Fuzzy Search | SCN

[Former Member]

Thanks Michael.

Is there any alternative other than fuzzy search to find duplicates in a table (need to identify not just exact duplicates but similar too, just as fuzzy search returns).

Anoop
.