Find similar strings in T-SQL table

I'm working on number plate recognition project. After number plate is recognized it is stored in MS SQL database. We have two cameras, and we get two images of one car, from front and from behind. Sometimes the recognizer recognize the number plate incorrectly from one of image. For example, the car with number plate 'AA1111' from first camera is recognized as 'AA111' and from second as 'AA1111'.

In my SQL table I have such records:

From every record in example table we create an incident in a client app. But this is incorrect because the plates 'AA11' and 'AA111' is the same plate as 'AA1111'.

My goal is to create incident in client app only for unique number, in my example it should be: 'AA1111' and 'BB2222'

Have you any ideas how to perform this in MS SQL?

The database is hosted in Azure SQL Server

UPD: I've write the SQL, but stuck with recursion limitation, may you hav some advice?

CREATE TABLE Plates(
  id INT not null,
  plate NVARCHAR(10),
  CreatedAtTime NVARCHAR(20),
  Confidence DECIMAL(18,5)
  )

INSERT INTO Plates
VALUES
(1,'LK2873','13:00:00',100),
(2,'LK287','13:00:10',70),
(3,'LK287','13:00:12',65),
(4,'AZ4875','14:00:00',100),
(5,'TR3345','14:15:32',100),
(6,'TR33','14:15:36',45),
(7,'TR334','14:15:40',70),
(8,'AA76','14:12:36',100),
(9,'DF324','14:13:00',100),
(9,'LK28','13:00:09',64)



;WITH tmp(plate,lvl,snd,ln)  as(
    SELECT Plate,1 lvl,soundex(Plate),LEN(Plate) FROM Plates 
        WHERE LEN(Plate)=(SELECT max(LEN(Plate)) FROM Plates)
    UNION ALL
    SELECT tb.plate, lvl+1,SOUNDEX(tb.Plate),LEN(tb.Plate)
        FROM Plates tb
        INNER JOIn tmp  t ON tb.Plate =LEFT(tb.plate,LEN(t.plate))

)
SELECT * FROM tmp