SELECT identity(int,1,1) AS id, * INTO #temp FROM MyTable
go
DELETE #temp WHERE id NOT IN (SELECT MAX(id) FROM #temp GROUP BY Word)
go
DELETE MyTable
go
INSERT INTO MyTable SELECT Code,Word,Acceptation,TimeCollect from #temp
go
SELECT identity(int,1,1) AS id, * INTO #temp FROM MyTable
go
DELETE #temp WHERE id NOT IN (SELECT MAX(id) FROM #temp GROUP BY Word)
go
DELETE MyTable
go
INSERT INTO MyTable SELECT Code,Word,Acceptation,TimeCollect from #temp
go