This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This sounds like an interesting problem! I would suggest a few things to try:
1) If you haven't already, I would parse your email filed with @ as the delimiter so that you can work with just the email ending
2) It wouldn't hurt to do a summary grouping by the new email ending field, just to see how many you're working with. If this is a one-time clean-up, it might not be too much to go through manually.
3) If this is a process you want to implement in the future or if manual fixing is simply not an option, then I suggest you check out the Fuzzy Match tool, in the Join tool set. The Fuzzy Match tool can compare each record to all other records in the same field and put them into like groups. This, taken together with the Make Groups tool, might give you a good match set of emails.
I made a simple example in the attached. It does a pretty good job of grouping the emails, you just might have to adjust the group name at the end.