SQL Server 2022

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

-- This table defines character mappings for similar looking characters.
-- The BaseChar value is considered the primary for each equivalence set,
-- while the AltChar values are the alternate characters that should be
-- considered to the base character and to any alternates sharing the same
-- base character.
CREATE TABLE PlateCharacterMap (
    BaseChar CHAR,  -- Source character from reader or database
    AltChar CHAR     -- Equivalent character for comparison purposes
)
INSERT PlateCharacterMap
VALUES
    ('O', '0'),
    ('I', '1'),
    ('S', '5'),
    ('O', 'Q')

SELECT * FROM PlateCharacterMap ORDER BY BaseChar, AltChar

-- Also map any defined base charcaters to themselves
-- to support later processing logic.
INSERT PlateCharacterMap
SELECT DISTINCT BaseChar, BaseChar
FROM PlateCharacterMap

SELECT * FROM PlateCharacterMap ORDER BY BaseChar, AltChar


BaseChar
AltChar


I
1

O
0

O
Q

S
5




BaseChar
AltChar


I
1

I
I

O
0

O
O

O
Q

S
5

S
S


-- This single-row table is used to define translations for comparing any two
-- plate numbers. All alternate characters will be mapped to their associated
-- base characters.
CREATE TABLE PlateTranslateStrings (
    TranslateFrom VARCHAR(1000),
    TranslateTo VARCHAR(1000)
)
INSERT PlateTranslateStrings
SELECT
    STRING_AGG(AltChar, '') WITHIN GROUP(ORDER BY AltChar) AS TranslateFrom,
    STRING_AGG(BaseChar, '') WITHIN GROUP(ORDER BY AltChar) AS TranslateTo
FROM PlateCharacterMap
WHERE AltChar <> BaseChar

SELECT * FROM PlateTranslateStrings


TranslateFrom
TranslateTo


015Q
OISO


-- Map a plate number to a string suitable for fuzzy comparisons
CREATE FUNCTION PlateCompareString(@PlateNumber VARCHAR(10))
RETURNS VARCHAR(10)
AS
BEGIN
    RETURN (
        SELECT TRANSLATE(@PlateNumber, T.TranslateFrom, T.TranslateTo)
        FROM PlateTranslateStrings T
    )
END
-- Perform a fuzzy comparison of plate numbers
CREATE FUNCTION PlateCompare(@Left VARCHAR(10), @Right VARCHAR(10))
RETURNS BIT
AS
BEGIN
    RETURN CASE WHEN dbo.PlateCompareString(@Left) = dbo.PlateCompareString(@Right)
           THEN 1 ELSE 0 END
END
-- Generate a set of similar plates for a given plate number.
CREATE FUNCTION PlatePermutations(@PlateNumber VARCHAR(10))
RETURNS TABLE
AS
RETURN (
    WITH CTE_Permiate AS (
        -- Anchor - Seed with empty result.
        SELECT
            CAST('' AS VARCHAR(10)) AS Result,
            @PlateNumber AS Remaining
        UNION ALL
        -- Map next character to itself.
        SELECT
            CAST(P.Result + LEFT(P.Remaining, 1) AS VARCHAR(10)) AS Result,
            STUFF(P.Remaining, 1, 1, '') AS Remaining
        FROM CTE_Permiate P
        WHERE LEN(P.Remaining) > 0
        UNION ALL
        -- Also map next character to all characters sharing the same base character
        -- except itself.
        SELECT
            CAST(P.Result + ISNULL(M2.AltChar, LEFT(P.Remaining, 1)) AS VARCHAR(10)) AS Result,
            STUFF(P.Remaining, 1, 1, '') AS Remaining
        FROM CTE_Permiate P
        JOIN PlateCharacterMap M1 ON M1.AltChar = LEFT(P.Remaining, 1)
        JOIN PlateCharacterMap M2 ON M2.BaseChar = M1.BaseChar
        WHERE LEN(P.Remaining) > 0
        AND M2.AltChar <> M1.AltChar -- Exclude self (already included above)
    )
    SELECT P.Result AS PlatePermutation
    FROM CTE_Permiate P
    WHERE LEN(P.Remaining) = 0  -- Only include the completed mappings
)
-- Plate comparison test
WITH CTE_TestData AS (
    SELECT *
    FROM (
        VALUES
            ('ABC-XYZ'),
            ('ABC-OIS'), ('ABC-O15'), ('ABC-015'),
            ('PASSWORD'), ('PA55W0RD')
    ) V(PlateNumber)
)
SELECT
    P1.PlateNumber AS PlateNumber1,
    P2.PlateNumber AS PlateNumber2,
    dbo.PlateCompareString(P1.PlateNumber) AS CompareString1,
    dbo.PlateCompareString(P2.PlateNumber) AS CompareString2,
    CASE WHEN dbo.PlateCompare(P1.PlateNumber, P2.PlateNumber) = 1
         THEN 'Match' ELSE '' END AS Match 
FROM CTE_TestData P1
JOIN CTE_TestData P2
    ON P2.PlateNumber > P1.PlateNumber
ORDER BY P1.PlateNumber, P2.PlateNumber


PlateNumber1
PlateNumber2
CompareString1
CompareString2
Match


ABC-015
ABC-O15
ABC-OIS
ABC-OIS
Match

ABC-015
ABC-OIS
ABC-OIS
ABC-OIS
Match

ABC-015
ABC-XYZ
ABC-OIS
ABC-XYZ


ABC-015
PA55W0RD
ABC-OIS
PASSWORD


ABC-015
PASSWORD
ABC-OIS
PASSWORD


ABC-O15
ABC-OIS
ABC-OIS
ABC-OIS
Match

ABC-O15
ABC-XYZ
ABC-OIS
ABC-XYZ


ABC-O15
PA55W0RD
ABC-OIS
PASSWORD


ABC-O15
PASSWORD
ABC-OIS
PASSWORD


ABC-OIS
ABC-XYZ
ABC-OIS
ABC-XYZ


ABC-OIS
PA55W0RD
ABC-OIS
PASSWORD


ABC-OIS
PASSWORD
ABC-OIS
PASSWORD


ABC-XYZ
PA55W0RD
ABC-XYZ
PASSWORD


ABC-XYZ
PASSWORD
ABC-XYZ
PASSWORD


PA55W0RD
PASSWORD
PASSWORD
PASSWORD
Match


-- Permutation demo
SELECT P.PlateNumber, PERM.PlatePermutation,
    COUNT(*) OVER(PARTITION BY P.PlateNumber) AS PermutationCount
FROM (
    VALUES
        ('A-ZZZ'),  -- just this one
        ('B-1'),    -- 2 permutations
        ('C-S'),    -- 2 permutations
        ('D-Q'),    -- 3 permutations
        ('E-15'),   -- 2 x 2 = 4 permutations
        ('F-ISQ'),  -- 2 x 2 x 3 = 12 permutations
        ('G-OQ0'),  -- 3 x 3 x 3 = 27 permutations
        ('H-O0Q15') -- 3 x 3 x 3 x 2 x 2 = 108 permutations
) P(PlateNumber)
CROSS APPLY dbo.PlatePermutations(P.PlateNumber) PERM
ORDER BY P.PlateNumber, PERM.PlatePermutation


PlateNumber
PlatePermutation
PermutationCount


A-ZZZ
A-ZZZ
1

B-1
B-1
2

B-1
B-I
2

C-S
C-5
2

C-S
C-S
2

D-Q
D-0
3

D-Q
D-O
3

D-Q
D-Q
3

E-15
E-15
4

E-15
E-1S
4

E-15
E-I5
4

E-15
E-IS
4

F-ISQ
F-150
12

F-ISQ
F-15O
12

F-ISQ
F-15Q
12

F-ISQ
F-1S0
12

F-ISQ
F-1SO
12

F-ISQ
F-1SQ
12

F-ISQ
F-I50
12

F-ISQ
F-I5O
12

F-ISQ
F-I5Q
12

F-ISQ
F-IS0
12

F-ISQ
F-ISO
12

F-ISQ
F-ISQ
12

G-OQ0
G-000
27

G-OQ0
G-00O
27

G-OQ0
G-00Q
27

G-OQ0
G-0O0
27

G-OQ0
G-0OO
27

G-OQ0
G-0OQ
27

G-OQ0
G-0Q0
27

G-OQ0
G-0QO
27

G-OQ0
G-0QQ
27

G-OQ0
G-O00
27

G-OQ0
G-O0O
27

G-OQ0
G-O0Q
27

G-OQ0
G-OO0
27

G-OQ0
G-OOO
27

G-OQ0
G-OOQ
27

G-OQ0
G-OQ0
27

G-OQ0
G-OQO
27

G-OQ0
G-OQQ
27

G-OQ0
G-Q00
27

G-OQ0
G-Q0O
27

G-OQ0
G-Q0Q
27

G-OQ0
G-QO0
27

G-OQ0
G-QOO
27

G-OQ0
G-QOQ
27

G-OQ0
G-QQ0
27

G-OQ0
G-QQO
27

G-OQ0
G-QQQ
27

H-O0Q15
H-00015
108

H-O0Q15
H-0001S
108

H-O0Q15
H-000I5
108

H-O0Q15
H-000IS
108

H-O0Q15
H-00O15
108

H-O0Q15
H-00O1S
108

H-O0Q15
H-00OI5
108

H-O0Q15
H-00OIS
108

H-O0Q15
H-00Q15
108

H-O0Q15
H-00Q1S
108

H-O0Q15
H-00QI5
108

H-O0Q15
H-00QIS
108

H-O0Q15
H-0O015
108

H-O0Q15
H-0O01S
108

H-O0Q15
H-0O0I5
108

H-O0Q15
H-0O0IS
108

H-O0Q15
H-0OO15
108

H-O0Q15
H-0OO1S
108

H-O0Q15
H-0OOI5
108

H-O0Q15
H-0OOIS
108

H-O0Q15
H-0OQ15
108

H-O0Q15
H-0OQ1S
108

H-O0Q15
H-0OQI5
108

H-O0Q15
H-0OQIS
108

H-O0Q15
H-0Q015
108

H-O0Q15
H-0Q01S
108

H-O0Q15
H-0Q0I5
108

H-O0Q15
H-0Q0IS
108

H-O0Q15
H-0QO15
108

H-O0Q15
H-0QO1S
108

H-O0Q15
H-0QOI5
108

H-O0Q15
H-0QOIS
108

H-O0Q15
H-0QQ15
108

H-O0Q15
H-0QQ1S
108

H-O0Q15
H-0QQI5
108

H-O0Q15
H-0QQIS
108

H-O0Q15
H-O0015
108

H-O0Q15
H-O001S
108

H-O0Q15
H-O00I5
108

H-O0Q15
H-O00IS
108

H-O0Q15
H-O0O15
108

H-O0Q15
H-O0O1S
108

H-O0Q15
H-O0OI5
108

H-O0Q15
H-O0OIS
108

H-O0Q15
H-O0Q15
108

H-O0Q15
H-O0Q1S
108

H-O0Q15
H-O0QI5
108

H-O0Q15
H-O0QIS
108

H-O0Q15
H-OO015
108

H-O0Q15
H-OO01S
108

H-O0Q15
H-OO0I5
108

H-O0Q15
H-OO0IS
108

H-O0Q15
H-OOO15
108

H-O0Q15
H-OOO1S
108

H-O0Q15
H-OOOI5
108

H-O0Q15
H-OOOIS
108

H-O0Q15
H-OOQ15
108

H-O0Q15
H-OOQ1S
108

H-O0Q15
H-OOQI5
108

H-O0Q15
H-OOQIS
108

H-O0Q15
H-OQ015
108

H-O0Q15
H-OQ01S
108

H-O0Q15
H-OQ0I5
108

H-O0Q15
H-OQ0IS
108

H-O0Q15
H-OQO15
108

H-O0Q15
H-OQO1S
108

H-O0Q15
H-OQOI5
108

H-O0Q15
H-OQOIS
108

H-O0Q15
H-OQQ15
108

H-O0Q15
H-OQQ1S
108

H-O0Q15
H-OQQI5
108

H-O0Q15
H-OQQIS
108

H-O0Q15
H-Q0015
108

H-O0Q15
H-Q001S
108

H-O0Q15
H-Q00I5
108

H-O0Q15
H-Q00IS
108

H-O0Q15
H-Q0O15
108

H-O0Q15
H-Q0O1S
108

H-O0Q15
H-Q0OI5
108

H-O0Q15
H-Q0OIS
108

H-O0Q15
H-Q0Q15
108

H-O0Q15
H-Q0Q1S
108

H-O0Q15
H-Q0QI5
108

H-O0Q15
H-Q0QIS
108

H-O0Q15
H-QO015
108

H-O0Q15
H-QO01S
108

H-O0Q15
H-QO0I5
108

H-O0Q15
H-QO0IS
108

H-O0Q15
H-QOO15
108

H-O0Q15
H-QOO1S
108

H-O0Q15
H-QOOI5
108

H-O0Q15
H-QOOIS
108

H-O0Q15
H-QOQ15
108

H-O0Q15
H-QOQ1S
108

H-O0Q15
H-QOQI5
108

H-O0Q15
H-QOQIS
108

H-O0Q15
H-QQ015
108

H-O0Q15
H-QQ01S
108

H-O0Q15
H-QQ0I5
108

H-O0Q15
H-QQ0IS
108

H-O0Q15
H-QQO15
108

H-O0Q15
H-QQO1S
108

H-O0Q15
H-QQOI5
108

H-O0Q15
H-QQOIS
108

H-O0Q15
H-QQQ15
108

H-O0Q15
H-QQQ1S
108

H-O0Q15
H-QQQI5
108

H-O0Q15
H-QQQIS
108


-- Where clause demo
SELECT
    P.PlateNumber,
    'WHERE X.PlateNumber IN ('
        + STRING_AGG(QUOTENAME(PERM.PlatePermutation, ''''), ', ')
        + ')' AS WhereClause
FROM (
    VALUES
        ('A-ZZZ'),  -- just this one
        ('B-1'),    -- 2 permutations
        ('C-S'),    -- 2 permutations
        ('D-Q'),    -- 3 permutations
        ('E-15'),   -- 2 x 2 = 4 permutations
        ('F-ISQ'),  -- 2 x 2 x 3 = 12 permutations
        ('G-OQ0'),  -- 3 x 3 x 3 = 27 permutations
        ('H-O0Q15') -- 3 x 3 x 3 x 2 x 2 = 108 permutations
) P(PlateNumber)
CROSS APPLY dbo.PlatePermutations(P.PlateNumber) PERM
GROUP BY P.PlateNumber
ORDER BY P.PlateNumber


PlateNumber
WhereClause


A-ZZZ
WHERE X.PlateNumber IN ('A-ZZZ')

B-1
WHERE X.PlateNumber IN ('B-1', 'B-I')

C-S
WHERE X.PlateNumber IN ('C-S', 'C-5')

D-Q
WHERE X.PlateNumber IN ('D-Q', 'D-0', 'D-O')

E-15
WHERE X.PlateNumber IN ('E-I5', 'E-IS', 'E-15', 'E-1S')

F-ISQ
WHERE X.PlateNumber IN ('F-15Q', 'F-150', 'F-15O', 'F-1SQ', 'F-1S0', 'F-1SO', 'F-I5Q', 'F-I50', 'F-I5O', 'F-ISQ', 'F-IS0', 'F-ISO')

G-OQ0
WHERE X.PlateNumber IN ('G-QO0', 'G-QOQ', 'G-QOO', 'G-Q00', 'G-Q0Q', 'G-Q0O', 'G-QQ0', 'G-QQQ', 'G-QQO', 'G-0O0', 'G-0OQ', 'G-0OO', 'G-000', 'G-00Q', 'G-00O', 'G-0Q0', 'G-0QQ', 'G-0QO', 'G-OO0', 'G-OOQ', 'G-OOO', 'G-O00', 'G-O0Q', 'G-O0O', 'G-OQ0', 'G-OQQ', 'G-OQO')

H-O0Q15
WHERE X.PlateNumber IN ('H-QOOI5', 'H-QOOIS', 'H-QOO15', 'H-QOO1S', 'H-QO0I5', 'H-QO0IS', 'H-QO015', 'H-QO01S', 'H-QOQI5', 'H-QOQIS', 'H-QOQ15', 'H-QOQ1S', 'H-QQOI5', 'H-QQOIS', 'H-QQO15', 'H-QQO1S', 'H-QQ0I5', 'H-QQ0IS', 'H-QQ015', 'H-QQ01S', 'H-QQQI5', 'H-QQQIS', 'H-QQQ15', 'H-QQQ1S', 'H-Q0OI5', 'H-Q0OIS', 'H-Q0O15', 'H-Q0O1S', 'H-Q00I5', 'H-Q00IS', 'H-Q0015', 'H-Q001S', 'H-Q0QI5', 'H-Q0QIS', 'H-Q0Q15', 'H-Q0Q1S', 'H-0OOI5', 'H-0OOIS', 'H-0OO15', 'H-0OO1S', 'H-0O0I5', 'H-0O0IS', 'H-0O015', 'H-0O01S', 'H-0OQI5', 'H-0OQIS', 'H-0OQ15', 'H-0OQ1S', 'H-0QOI5', 'H-0QOIS', 'H-0QO15', 'H-0QO1S', 'H-0Q0I5', 'H-0Q0IS', 'H-0Q015', 'H-0Q01S', 'H-0QQI5', 'H-0QQIS', 'H-0QQ15', 'H-0QQ1S', 'H-00OI5', 'H-00OIS', 'H-00O15', 'H-00O1S', 'H-000I5', 'H-000IS', 'H-00015', 'H-0001S', 'H-00QI5', 'H-00QIS', 'H-00Q15', 'H-00Q1S', 'H-OOOI5', 'H-OOOIS', 'H-OOO15', 'H-OOO1S', 'H-OO0I5', 'H-OO0IS', 'H-OO015', 'H-OO01S', 'H-OOQI5', 'H-OOQIS', 'H-OOQ15', 'H-OOQ1S', 'H-OQOI5', 'H-OQOIS', 'H-OQO15', 'H-OQO1S', 'H-OQ0I5', 'H-OQ0IS', 'H-OQ015', 'H-OQ01S', 'H-OQQI5', 'H-OQQIS', 'H-OQQ15', 'H-OQQ1S', 'H-O0OI5', 'H-O0OIS', 'H-O0O15', 'H-O0O1S', 'H-O00I5', 'H-O00IS', 'H-O0015', 'H-O001S', 'H-O0QI5', 'H-O0QIS', 'H-O0Q15', 'H-O0Q1S')


CREATE TABLE PlateDatabase (
    PlateNumber VARCHAR(10)
)
INSERT PlateDatabase
VALUES
    ('ABC-XYZ'),
    ('ABC-OIS'), ('ABC-O15'), ('ABC-015'),
    ('PASSWORD'), ('PA55W0RD')

SELECT *
FROM PlateDatabase P
WHERE dbo.PlateCompare(P.PlateNumber, 'PASSW0RD') = 1

SELECT *
FROM PlateDatabase P
WHERE P.PlateNumber IN (SELECT * FROM dbo.PlatePermutations('ABC-OI5'))

SELECT P.*
FROM dbo.PlatePermutations('ABC-OI5') PERM
JOIN PlateDatabase P ON P.PlateNumber = PERM.PlatePermutation


PlateNumber


PASSWORD

PA55W0RD




PlateNumber


ABC-OIS

ABC-O15

ABC-015




PlateNumber


ABC-OIS

ABC-O15

ABC-015

PlateNumber1	PlateNumber2	CompareString1	CompareString2	Match
ABC-015	ABC-O15	ABC-OIS	ABC-OIS	Match
ABC-015	ABC-OIS	ABC-OIS	ABC-OIS	Match
ABC-015	ABC-XYZ	ABC-OIS	ABC-XYZ
ABC-015	PA55W0RD	ABC-OIS	PASSWORD
ABC-015	PASSWORD	ABC-OIS	PASSWORD
ABC-O15	ABC-OIS	ABC-OIS	ABC-OIS	Match
ABC-O15	ABC-XYZ	ABC-OIS	ABC-XYZ
ABC-O15	PA55W0RD	ABC-OIS	PASSWORD
ABC-O15	PASSWORD	ABC-OIS	PASSWORD
ABC-OIS	ABC-XYZ	ABC-OIS	ABC-XYZ
ABC-OIS	PA55W0RD	ABC-OIS	PASSWORD
ABC-OIS	PASSWORD	ABC-OIS	PASSWORD
ABC-XYZ	PA55W0RD	ABC-XYZ	PASSWORD
ABC-XYZ	PASSWORD	ABC-XYZ	PASSWORD
PA55W0RD	PASSWORD	PASSWORD	PASSWORD	Match

PlateNumber	PlatePermutation	PermutationCount
A-ZZZ	A-ZZZ	1
B-1	B-1	2
B-1	B-I	2
C-S	C-5	2
C-S	C-S	2
D-Q	D-0	3
D-Q	D-O	3
D-Q	D-Q	3
E-15	E-15	4
E-15	E-1S	4
E-15	E-I5	4
E-15	E-IS	4
F-ISQ	F-150	12
F-ISQ	F-15O	12
F-ISQ	F-15Q	12
F-ISQ	F-1S0	12
F-ISQ	F-1SO	12
F-ISQ	F-1SQ	12
F-ISQ	F-I50	12
F-ISQ	F-I5O	12
F-ISQ	F-I5Q	12
F-ISQ	F-IS0	12
F-ISQ	F-ISO	12
F-ISQ	F-ISQ	12
G-OQ0	G-000	27
G-OQ0	G-00O	27
G-OQ0	G-00Q	27
G-OQ0	G-0O0	27
G-OQ0	G-0OO	27
G-OQ0	G-0OQ	27
G-OQ0	G-0Q0	27
G-OQ0	G-0QO	27
G-OQ0	G-0QQ	27
G-OQ0	G-O00	27
G-OQ0	G-O0O	27
G-OQ0	G-O0Q	27
G-OQ0	G-OO0	27
G-OQ0	G-OOO	27
G-OQ0	G-OOQ	27
G-OQ0	G-OQ0	27
G-OQ0	G-OQO	27
G-OQ0	G-OQQ	27
G-OQ0	G-Q00	27
G-OQ0	G-Q0O	27
G-OQ0	G-Q0Q	27
G-OQ0	G-QO0	27
G-OQ0	G-QOO	27
G-OQ0	G-QOQ	27
G-OQ0	G-QQ0	27
G-OQ0	G-QQO	27
G-OQ0	G-QQQ	27
H-O0Q15	H-00015	108
H-O0Q15	H-0001S	108
H-O0Q15	H-000I5	108
H-O0Q15	H-000IS	108
H-O0Q15	H-00O15	108
H-O0Q15	H-00O1S	108
H-O0Q15	H-00OI5	108
H-O0Q15	H-00OIS	108
H-O0Q15	H-00Q15	108
H-O0Q15	H-00Q1S	108
H-O0Q15	H-00QI5	108
H-O0Q15	H-00QIS	108
H-O0Q15	H-0O015	108
H-O0Q15	H-0O01S	108
H-O0Q15	H-0O0I5	108
H-O0Q15	H-0O0IS	108
H-O0Q15	H-0OO15	108
H-O0Q15	H-0OO1S	108
H-O0Q15	H-0OOI5	108
H-O0Q15	H-0OOIS	108
H-O0Q15	H-0OQ15	108
H-O0Q15	H-0OQ1S	108
H-O0Q15	H-0OQI5	108
H-O0Q15	H-0OQIS	108
H-O0Q15	H-0Q015	108
H-O0Q15	H-0Q01S	108
H-O0Q15	H-0Q0I5	108
H-O0Q15	H-0Q0IS	108
H-O0Q15	H-0QO15	108
H-O0Q15	H-0QO1S	108
H-O0Q15	H-0QOI5	108
H-O0Q15	H-0QOIS	108
H-O0Q15	H-0QQ15	108
H-O0Q15	H-0QQ1S	108
H-O0Q15	H-0QQI5	108
H-O0Q15	H-0QQIS	108
H-O0Q15	H-O0015	108
H-O0Q15	H-O001S	108
H-O0Q15	H-O00I5	108
H-O0Q15	H-O00IS	108
H-O0Q15	H-O0O15	108
H-O0Q15	H-O0O1S	108
H-O0Q15	H-O0OI5	108
H-O0Q15	H-O0OIS	108
H-O0Q15	H-O0Q15	108
H-O0Q15	H-O0Q1S	108
H-O0Q15	H-O0QI5	108
H-O0Q15	H-O0QIS	108
H-O0Q15	H-OO015	108
H-O0Q15	H-OO01S	108
H-O0Q15	H-OO0I5	108
H-O0Q15	H-OO0IS	108
H-O0Q15	H-OOO15	108
H-O0Q15	H-OOO1S	108
H-O0Q15	H-OOOI5	108
H-O0Q15	H-OOOIS	108
H-O0Q15	H-OOQ15	108
H-O0Q15	H-OOQ1S	108
H-O0Q15	H-OOQI5	108
H-O0Q15	H-OOQIS	108
H-O0Q15	H-OQ015	108
H-O0Q15	H-OQ01S	108
H-O0Q15	H-OQ0I5	108
H-O0Q15	H-OQ0IS	108
H-O0Q15	H-OQO15	108
H-O0Q15	H-OQO1S	108
H-O0Q15	H-OQOI5	108
H-O0Q15	H-OQOIS	108
H-O0Q15	H-OQQ15	108
H-O0Q15	H-OQQ1S	108
H-O0Q15	H-OQQI5	108
H-O0Q15	H-OQQIS	108
H-O0Q15	H-Q0015	108
H-O0Q15	H-Q001S	108
H-O0Q15	H-Q00I5	108
H-O0Q15	H-Q00IS	108
H-O0Q15	H-Q0O15	108
H-O0Q15	H-Q0O1S	108
H-O0Q15	H-Q0OI5	108
H-O0Q15	H-Q0OIS	108
H-O0Q15	H-Q0Q15	108
H-O0Q15	H-Q0Q1S	108
H-O0Q15	H-Q0QI5	108
H-O0Q15	H-Q0QIS	108
H-O0Q15	H-QO015	108
H-O0Q15	H-QO01S	108
H-O0Q15	H-QO0I5	108
H-O0Q15	H-QO0IS	108
H-O0Q15	H-QOO15	108
H-O0Q15	H-QOO1S	108
H-O0Q15	H-QOOI5	108
H-O0Q15	H-QOOIS	108
H-O0Q15	H-QOQ15	108
H-O0Q15	H-QOQ1S	108
H-O0Q15	H-QOQI5	108
H-O0Q15	H-QOQIS	108
H-O0Q15	H-QQ015	108
H-O0Q15	H-QQ01S	108
H-O0Q15	H-QQ0I5	108
H-O0Q15	H-QQ0IS	108
H-O0Q15	H-QQO15	108
H-O0Q15	H-QQO1S	108
H-O0Q15	H-QQOI5	108
H-O0Q15	H-QQOIS	108
H-O0Q15	H-QQQ15	108
H-O0Q15	H-QQQ1S	108
H-O0Q15	H-QQQI5	108
H-O0Q15	H-QQQIS	108

PlateNumber	WhereClause
A-ZZZ	WHERE X.PlateNumber IN ('A-ZZZ')
B-1	WHERE X.PlateNumber IN ('B-1', 'B-I')
C-S	WHERE X.PlateNumber IN ('C-S', 'C-5')
D-Q	WHERE X.PlateNumber IN ('D-Q', 'D-0', 'D-O')
E-15	WHERE X.PlateNumber IN ('E-I5', 'E-IS', 'E-15', 'E-1S')
F-ISQ	WHERE X.PlateNumber IN ('F-15Q', 'F-150', 'F-15O', 'F-1SQ', 'F-1S0', 'F-1SO', 'F-I5Q', 'F-I50', 'F-I5O', 'F-ISQ', 'F-IS0', 'F-ISO')
G-OQ0	WHERE X.PlateNumber IN ('G-QO0', 'G-QOQ', 'G-QOO', 'G-Q00', 'G-Q0Q', 'G-Q0O', 'G-QQ0', 'G-QQQ', 'G-QQO', 'G-0O0', 'G-0OQ', 'G-0OO', 'G-000', 'G-00Q', 'G-00O', 'G-0Q0', 'G-0QQ', 'G-0QO', 'G-OO0', 'G-OOQ', 'G-OOO', 'G-O00', 'G-O0Q', 'G-O0O', 'G-OQ0', 'G-OQQ', 'G-OQO')
H-O0Q15	WHERE X.PlateNumber IN ('H-QOOI5', 'H-QOOIS', 'H-QOO15', 'H-QOO1S', 'H-QO0I5', 'H-QO0IS', 'H-QO015', 'H-QO01S', 'H-QOQI5', 'H-QOQIS', 'H-QOQ15', 'H-QOQ1S', 'H-QQOI5', 'H-QQOIS', 'H-QQO15', 'H-QQO1S', 'H-QQ0I5', 'H-QQ0IS', 'H-QQ015', 'H-QQ01S', 'H-QQQI5', 'H-QQQIS', 'H-QQQ15', 'H-QQQ1S', 'H-Q0OI5', 'H-Q0OIS', 'H-Q0O15', 'H-Q0O1S', 'H-Q00I5', 'H-Q00IS', 'H-Q0015', 'H-Q001S', 'H-Q0QI5', 'H-Q0QIS', 'H-Q0Q15', 'H-Q0Q1S', 'H-0OOI5', 'H-0OOIS', 'H-0OO15', 'H-0OO1S', 'H-0O0I5', 'H-0O0IS', 'H-0O015', 'H-0O01S', 'H-0OQI5', 'H-0OQIS', 'H-0OQ15', 'H-0OQ1S', 'H-0QOI5', 'H-0QOIS', 'H-0QO15', 'H-0QO1S', 'H-0Q0I5', 'H-0Q0IS', 'H-0Q015', 'H-0Q01S', 'H-0QQI5', 'H-0QQIS', 'H-0QQ15', 'H-0QQ1S', 'H-00OI5', 'H-00OIS', 'H-00O15', 'H-00O1S', 'H-000I5', 'H-000IS', 'H-00015', 'H-0001S', 'H-00QI5', 'H-00QIS', 'H-00Q15', 'H-00Q1S', 'H-OOOI5', 'H-OOOIS', 'H-OOO15', 'H-OOO1S', 'H-OO0I5', 'H-OO0IS', 'H-OO015', 'H-OO01S', 'H-OOQI5', 'H-OOQIS', 'H-OOQ15', 'H-OOQ1S', 'H-OQOI5', 'H-OQOIS', 'H-OQO15', 'H-OQO1S', 'H-OQ0I5', 'H-OQ0IS', 'H-OQ015', 'H-OQ01S', 'H-OQQI5', 'H-OQQIS', 'H-OQQ15', 'H-OQQ1S', 'H-O0OI5', 'H-O0OIS', 'H-O0O15', 'H-O0O1S', 'H-O00I5', 'H-O00IS', 'H-O0015', 'H-O001S', 'H-O0QI5', 'H-O0QIS', 'H-O0Q15', 'H-O0Q1S')