Check raws if they contain any text from a range of other raws

I would like to check each B raw if it contains anything from F1:F619 and E raws should display „draft“ if it does and „publish“ if it doesn’t.

I’ve looked everywhere in the Google Sheets documentation and everywhere and I cannot find any formula to do that.

Here is the spreadsheet: https://docs.google.com/spreadsheets/d/1_zH5ty4ADUv12eaNgH_16qyYTDRo-LC7g50GfuYklsI/edit?usp=sharing

Video describing the issue: https://streamable.com/a6u6b