SQL Select records where any word / value contained within one string is also contained within another string I need to find a SQL select query that will allow me to find records in [KnowledgeArticle] Where any word contained in the string [KnowledgeArticle].[Keywords] is contained within [Incident].[Description].

I'm working with an IT Service Management application, and want to provide a list of Knowledge articles that match an Incident record's description, automatically. I don't have direct access to change the way this ITSM application queries the database, it's all managed via a series of GUI's.

However, I can connect the ITSM app to views that I create in the database, and filter results of the view from there.

So, my challenge is that I need to get, within a view, a list of all [KnowledgeArticle] records, duplicated once for each [Incident] record, where any word within [Incident].[Description] is contained within [KnowledgeArticle].[Keywords].

This query on it's own would be quite ridiculous, and would present a very large subset of records, however once I have the query built and set up as a view, I'll be able to configure the ITSM application to filter the results of this query / view to only the current [Incident] record, providing me with the data that I need (Knowledge articles where any keyword in the knowledge article is present on the Incident).

Hopefully this makes sense, I'm not sure what kind of operator I might be able to use in a comparison clause to bring up that list of knowledge article records.

(If you're not familiar with IT Service Management jargon, the words Incident and KnowledgeArticle are just table names, what they do is less important to the technical question being asked).
I don't know the requirements of your project but with the info you provided on this post, this qualify for a data quality project from Data Quality Services (DQS):

Data Quality Project (DQS)