SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select *
into t
from (values
             (1, 'Swetha working', 'Swetha is working in Chennai'),
             (2, 'Raju 10th', 'Raju is studying 10th std'),
             (3, 'ranjith', 'Rantith played yesterday'),
             (4, 'how to play', 'how to play Cricket'),
             (5, 'My name is', 'my name is john')
     ) v (id, col1, col2)
5 rows affected

select * 
from t


id
col1
col2


1
Swetha working
Swetha is working in Chennai

2
Raju 10th
Raju is studying 10th std

3
ranjith
Rantith played yesterday

4
how to play
how to play Cricket

5
My name is
my name is john


with words as (
      select t.*, s.*,
             max(s.seqnum) over (partition by t.id) as max_seqnum
      from t cross apply
           (select s.value as word,
                   row_number() over (order by (select null)) as seqnum
            from string_split(col1, ' ') s
           ) s
     ),
     cte as (
      select id, col1, col2,
             replace(' ' + col2 + ' ', ' ' + word + ' ', ' ') as result,
             word, seqnum, max_seqnum
      from words
      where seqnum = 1
      union all
      select cte.id, cte.col1, cte.col2,
             replace(cte.result, ' ' + w.word + ' ', ' '),
             w.word, w.seqnum, cte.max_seqnum
      from cte join
           words w
           on w.id = cte.id and w.seqnum = cte.seqnum + 1
     )
select id, col1, col2, trim(result) as result
from cte
where max_seqnum = seqnum


id
col1
col2
result


3
ranjith
Rantith played yesterday
Rantith played yesterday

5
My name is
my name is john
john

4
how to play
how to play Cricket
Cricket

2
Raju 10th
Raju is studying 10th std
is studying std

1
Swetha working
Swetha is working in Chennai
is in Chennai

id	col1	col2
1	Swetha working	Swetha is working in Chennai
2	Raju 10th	Raju is studying 10th std
3	ranjith	Rantith played yesterday
4	how to play	how to play Cricket
5	My name is	my name is john