Based on same email and combination f name and l name population same ID and fuzzy match % of f name and l name for same email. Can any one help me to populate this ID and Fuzzy Match.
if fuzzy match is less than 10% (parameterized) then ID will be different.
sample data provided below:
ID f name l name email Fuzzy Match
P1 Vincent Crisci V4innieman16@gmail.com
P1 Vincent J Crisci V4innieman16@gmail.com
P2 V Thomas V3Thomas714@aol.com
P2 V L THOMAS V3Thomas714@aol.com
P3 Bob Rosenthal R2osie03@msn.com
P3 Robert Rosenthal R2osie03@msn.com
P4 Robert V Olivieri R1ovinol@aol.com
P4 Robert Vincent Olivieri R1ovinol@aol.com
P5 chris brown 8zzzud150@yahoo.com
p6 christen shrum 8zzzud150@yahoo.com
SELECT 'chris ','brown','8zzzud150@yahoo.com' from dual union
SELECT 'christen ','shrum','8zzzud150@yahoo.com' from dual union
SELECT 'Vincent ','Crisci','V4innieman16@gmail.com' from dual union
SELECT 'Vincent ','J Crisci','V4innieman16@gmail.com' from dual union
SELECT 'V ','Thomas','V3Thomas714@aol.com' from dual union
SELECT 'V L ','THOMAS','V3Thomas714@aol.com' from dual union
SELECT 'Bob ','Rosenthal','R2osie03@msn.com' from dual union
SELECT 'Robert ','Rosenthal','R2osie03@msn.com' from dual union
SELECT 'Robert V ','Olivieri','R1ovinol@aol.com' from dual union
SELECT 'Robert Vincent ','Olivieri','R1ovinol@aol.com' from dual