SQL Statement using LIKE and Subquery?

try below

 SELECT short_desc,word
 FROM Content a INNER JOIN Restricted_Words b
 on short_desc like '%'+word+'%'