Search / Find formula use case help

Can airtable search for a number specific keyword from a “long text” column
ie. search for all cat, dog, lion, horse and if any keyword from the target list is found

then add found keyword to separate column.

im looking for a way to search and identify keywords from large text then tag the record with the keywords found.

is this possible if so how, thx