The requirement does not yield to correct information as the example you have given...How can Gravy - veg be chicken stew..
For better results.. refine table 1 category key words and then use the query below:
select table1.receipename, table1.preparationsteps, table2.category
from table1
left join table2 on table1.receipename like '%' + table2.category + '%'