I have a result like this:

[![enter image description here](https://i.stack.imgur.com/cAxMY.png)](https://i.stack.imgur.com/cAxMY.png)

I need to update "flag" column as duplicate when any one word from the row matches with second row within group of "mfgid" column. 

```
--test dataset
declare @table as table
        (id int,
         mfgid int,
         [desc] varchar(100))
insert into @table
values  (1,111,'abc xyz pqr'),
        (2,111,'abc tyu fgh'),
        (3,222,'abc pqr'),
        (4,222,'lmn stu'),
        (5,333,'pqr spd hki abc'),
        (6,333,'lmn jsk pqr klo')

```

How can I do this?