如何通过与SQL Server中的其他列进行比较从一列中删除类似的文本

I have the following example

我有以下例子

addressid  23915031 
customerid 13154569
address1   FLAT NO 23 3Road Floor KRISH  BUILDING ANUSHKTI  
address2   GAR BARC COLONY Near SECTOR MARKET
address3   MANKHURoad MUMBAI
landmark   ANUOHAKTING  
zipcode    400094   
addresstype RESIDENCE ADDRESS
cityname   MUMBAI   
statedesc  MAHARASHTRA
address