Similar name identification - UCIC

See more:

VB

ASP

SQL

SQL-Server

SQLite

I have SQL table in which lakhs of customer data is there like custid,name,dob,mob, etc. I want to identify similar customer name with different custid. Criteria is name , dob and 50% name shall be matched.

example Hemil Gandhi & Gandhi Hemil shall be identified by system.

What I have tried:

SELECT customer_id, name, dob, mobile_number
FROM customer_details
WHERE (dob, mobile_number, name) IN (
    SELECT dob, mobile_number, name
    FROM customer_details
    GROUP BY dob, mobile_number, name
    HAVING COUNT(*) > 1
)
ORDER BY dob, mobile_number, name;