If I understood your problem, this is a possible solution for the attached txt:
SELECT
Id
, [Name]
, Descr
, OtherDesc
FROM
@CatalogSearch
INNER JOIN @TempKeys ON [Name] LIKE keyw OR Descr LIKE keyw OR OtherDesc LIKE keyw
GROUP BY
Id
, [Name]
, Descr
, OtherDesc
HAVING
COUNT(1) = (SELECT COUNT(1) FROM @TempKeys)