Search a cell for multiple words and return multiple results in one cell

Hi,

I have a spreadsheet that has titles and keywords. The keywords are a long list (approx. 4,500 rows) and I have a list of titles (approx. 30k rows). What I need is to search the titles for keywords and have these keywords returned. Either in one row (with a , as a separator) or in separate rows.

For example:

Title Keywords Result Required

Title One for Research 1 Research Research
Title Two for Research 2 Two Research, Two
Title for Research in Keyboards Keyboard Research, Keyboards

I have searched the Internet until I cannot search any more.

Any help would be much appreciated!

Thanks

Sam