I am trying to build a google sheet to track win rate in a game.

So far, i am inputting the matchup and the result in one sheet (Matchups).Example Image

Then those values get sent to another sheet (Data), from there i can grab various data entries and list them in (Offense) and (Defense), where i can then cross-reference those Data entries with the Results from (Matchups)

What i am now trying to achieve is using synonyms as possible stand-ins for the full names of the Data Entries specifically in Matchups, but then have their full name show up in the rest of the sheets.
From the Example: Eternal Wanderer Ludwig goes by many names, such as Gamer, ML Ludwig, mlud etc.

Not sure what the best way to go about it is, or if that is even possible.

One idea i came up with was to spam COUNTIF’s for every variation:
= COUNTIF(Matchup, Eternal Wanderer Ludwig) + COUNTIF(Matchup, Gamer) + COUNTIF(Matchup, ML Ludwig) + COUNTIF(Matchup, mlud)

But that would mean manually adding every entry, which would defeat the entire purpose of the sheet.
I want (Offense) and (Defense) to be autofilling and not need any tinkering afterwards.