How to link different spellings so one spelling references the other

Question

I have several different spelling of team names ie. Los Angeles Lakers, LA Lakers, LAL etc

how can i group these together so when i use xlookup for example with Los Angeles Lakers it can pull data from LAL?

Ive tried to use wildcard combinations with xlookup but i think i need to group these spelling together but not sure how

more specific info: sheet 1, A1, contains Los Angeles Lakers sheet 2, A1:A100, this column contains team id's ie LAL

to pull in data Im reference sheet1 cell A1's value but need it to locate sheet2 LAL value

i think this has to be done on a seperate sheet otherwise i will have to hand code al the ids and names every day

ive seen a video where the user has a separate sheet with all the spelling variations linked?

any help or tutorial links would be great thanks

Answer 1

Use REGEXMATCH

=FILTER(A2:A10,REGEXMATCH(B2:B10,"(?i)Los Angeles Lakers|LA Lakers|LAL"))

Edit

Assuming the list of options is in C2:C10,

=FILTER(A2:A10,REGEXMATCH(B2:B10,"(?i)"&TEXTJOIN("|",1,C2:C10)))