How to find a similarity in email address

Community Extensions
1

Hi All, 

I am a new KNIME user, I am wondering is there any way for KNIME to detect an email address similarity to measure a fraud ?

example

christiandy@gmail.com

c.hristiandy@gmail.com

c.h.ristiandy@gmail.com

christiandy@hotmail.com

christiandy1@gmail.com

christiandy12@gmail.com

I need to detect this kind of pattern and then clean up my email list from this kind of email

Thanks,

2

edit (levensthein) distance as well as jaro Winkler should help you detect duplicates. Fir more efficient treatment consider separating domain from user name (cell splitter) and then to do the similarity search on the user name only.