Replace specific string with blank even if partial match with another column value

I have a scenario to replace entire string from a set of comma delimited strings, if partial word matches with another column. I found very complex to explain in words and hence I have explained through a screenshot having various examples. Please help me with stored procedure or a function or query to get results as in **Required_result** column as in below screen shot. I tried STRING_SPLIT function to split values and join the tables. I am struck with the logic to solve this problem.