Identifying duplications and possible duplicities through scores / ranking

0

I have a database in mysql that has user information where I have to define what is duplicity or not.

Notes: The fields MA_NAME and DATA_NASC are not required. Examples of records:

Only sounding the name of the person and the mother's name does not help, for as in the example the word IGNACIO (I252) gives a soundex different from INACIO (I520). He wanted to do a score system to identify duplicity and possible duplicities. I'll add the variable INITIAL_NAME to help with the soundex problem. But I have no idea how to mount this SCORE. Some help?? Can be in PHP or MYSQL. Thanks!

    
asked by anonymous 06.02.2017 / 14:44

0 answers