Fuzzy match formula to match partial email string in another list?

Hi all is it possible to get some help please with matching email addresses from one column to another please?

Column A contains email addresses as entered by several users. Column B contains email addresses that need to be excluded.

BUT, sometimes column A isn't always entered in the correct format so doesn't match anything in column B when doing an exact match so I need a way to match it based on a similar string contained in both columns. Just the formula to use will help.

I've attached an example list here:

User entered emails (sample)

ianstudd@btopenworld.com
leegoacher@aol.com
leegoacher@aol.com
markmoore517@gmail.com
markmoore517@gmail.com
annstudd@outlook.com
rasalthouse61@gmail.com
juliefranco1@outlook.com
debmurray1975@yahoo.co.uk
ksastewart@googlemail.com
ksastewart@googlemail.com
miss-nicole1994@hotmail.com
mistybirrell@hotmail.com
jmr@boysandmaughan.co.uk


Emails to exclude (sample)

kerry.ann128@hotmail.co.uk
jessicarichards82@outlook.com
johnevans72@gmail.com
lewiskeller96@gmail.com
lewiskeller@gmail.com
aleonards@talktalk-mail.com
acunningham@plusnetmail.co.uk
ali_white@plusnetmail.co.uk
aswift@talktalk-mail.com
ambers@plusnetmail.co.uk
aroberts@btinternet.uk.com
apowell@btinternet.uk.com
Hanson-a1452@plusnetmail.co.uk
aanderson@plusnetmail.co.uk
acarter@talktalk-mail.com


Thanks in advance.