finding several words in a column and avoiding duplicates

Vnibsen89 

Perhaps this one:

=LET(
    FindTerms, LAMBDA(row,
        LET(words, TEXTSPLIT(row, "/"), SUM(IFNA(XMATCH("*" & words & "*", ListofTerms, 2), 0)))
    ),
    BYROW(terms, FindTerms)
)

There's still the issue of using a wildcard match with terms with few characters such as "as" where we get a false positive where it matches "ashes".