microsoft access training - Fuzzy matches to a look-up table

I have a table of contacts where one of the fields is Job Title. I also have a look-up table that contains a list of job titles.

I would like to know how I can pull all of the contacts that have a match to the job title field in the look-up table. An exact match is easy, I can just create a query and link the two fields.

I would like to know if I can pull all contacts that has a 'contains' match. So if one of the job titles in look-up table is analyst, the search would also find data analyst.

I could enter in the criteria section of the query *analyst* which would find data analyst, but I have over 100 job titles in the look-up table that I would have to manually enter.

Is there a way of running a contains across these job titles?

Thanks