I prefer to write something like below:

EXISTS avoids creating a potentially large result set in memory and is often more efficient.

SELECT a.*
FROM TableA a
WHERE EXISTS (
    SELECT 1
    FROM TermsTable t
    WHERE a.Description LIKE '%' + t.Terms + '%'
)