Query for matching words across multiple records in sql

I am struggling to group records from the same table that have the same words togeth开发者_开发技巧er. Below is an illustration of what I mean.

Record 1- http://www.example.com/abdgc
Record 2- http://www.example.com/gshfd/df

My main interest here is to build a query that looks for a common word (in the example, "example") among multiple records and group all them by this common word.

Thank you for your help.