SQL Statement using LIKE and Subquery?

Thanks for the reply Visakh16, but I want to know the word that was matched and the above query doesn't return that and I'm guessing because it doesn't join on the "Restricted_Words" table?