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.
The Fuzzy Matching tool will work for you, but there is prep that needs to happen before using the tool.
First, you will need a Record ID field which right now you are using just your Name field. Add A Record ID tool before the Fuzzy Matching tool. 2nd, you will want to make sure that you have removed any extraneous characters or words to improve the matching algorithms. The 3rd thing is that you do not have any Advanced Options selected so the tool will result in what you see. The Fuzzy Matching tool needs the Record ID and at the very least the Match Score for you to see what matched. The tool will not change your data, the tool is there to alert you which data match and where it is. You can then use the record ID to match against your original data.
@JordyMicheal take a look at the Multi-Row Formula tool. You can do grouping within that tool and that should help you pull out. Before you do that though, as a best practice I would filter out your 100% matches since you don't needs those and it will make it easier to look at.