Search For Multiple Text Strings

Hello,

I'm trying to create a function that allows me to search a range of comments based upon multiple search keywords. For example, the user would type in a single cell "dog, cat, par". The function would then search a range of comments and return, "Burt pet shop is great because of the cute dogs and cats, but their parrot selection is limited". I cannot use a VBA for this. The text will be partial strings and the user will only input by typing words and seperating via comma. Any thoughts on how to accomplish this? I have attached an image to better represent what I'm trying to accomplish.

Thank you for your help with this. I want to try and avoid using VBAs if possible. Please find my sample file attached. thanks!