Transforming a filter term

Hi, is there a way to transform a term used in a text search field to another term and then let it filter a larger textual data set? If a user inputs a stock ticker I would like to change it to the company name and then use that term to search the text data.

Example: input MSFT --> change to 'Microsoft' --> search the text data

Example: input Microsoft --> change nothing --> search the text data

Thanks in advance, I am really stuck on this one.

EDIT: I have a translation table already set up. So the stock tickers are already mapped to the company name. I just dont know how to pass the translated company name to the text filter.