Partial search for any of multi-select items in string

[Tuesday8093]

Hi there, 

I'm trying to rank titles based on a multi-select. 

This is my setup:

• title = string field containing title of a contact
• prio1_titles = multi-select field where I'm specifying which a preferred contact should have included
• title_rank = the formula I'm trying to create – fine if it gives out '1' for now

What I'm trying to achieve:
If the title of my contact contains any of the multi-select words I want the formula to return true.

I managed to search for the title in prio1_titles but this is not suitable for partial matches. For example if a title contains "co-founder and coo" I still want the formula to return true because of the partial match for "founder".

Would appreciate any help with how to set up this formula.

I'd consider myself an experienced no-coder, have no experience with airtable scripts so far, so I would prefer a formula solution.

Thanks!