Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “glazers” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

74 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
glazers	17	44	1004	(None)
blazers	18	48	1168	1	blazers
gazers	16	45	1630	1	g_azers
glazer	16	42	1226	1	glazer_
glazes	16	53	1564	1	glaze_s
glaziers	18	40	656	1	glaziers
grazers	17	51	1245	1	grazers
bladers	10	42	1468	2	bladers
blamers	11	53	1421	2	blamers
blazer	17	44	1402	2	blazer_
blazes	17	48	1735	2	blaze_s
brazers	18	45	1394	2	brazers
clavers	12	43	1490	2	clavers
clawers	12	39	1097	2	clawers
elaters	7	44	2019	2	elaters
flakers	14	36	1327	2	flakers
flamers	12	46	1636	2	flamers
flayers	13	39	1203	2	flayers
gagers	8	40	2133	2	g_agers
gamers	9	44	2083	2	g_amers
gapers	9	45	2047	2	g_apers
gaters	7	47	2864	2	g_aters
gazars	16	48	1155	2	g_azars
gazer	15	57	2007	2	g_azer_
gazes	15	54	2591	2	g_aze_s
geezers	17	28	651	2	geezers
glaces	9	42	1803	2	glace_s
glaciers	11	27	790	2	glaciers
glades	8	48	2034	2	glade_s
glaires	8	40	1014	2	glaires
glairs	7	52	1133	2	gla_irs
glamors	10	6	812	2	glamors
glancers	11	40	800	2	glancers
glanders	10	38	1150	2	glanders
glares	7	55	1887	2	glare_s
glaze	15	54	1816	2	glaze__
glazed	17	47	1177	2	glaze_d
glazier	17	40	935	2	glazier_
glaziery	21	41	369	2	glaziery
gleamers	11	30	656	2	gleamers
gleaners	9	34	807	2	gleaners
gliders	9	48	1184	2	gliders
gloaters	9	28	886	2	gloaters
glovers	11	43	1088	2	glovers
glowers	11	34	1209	2	glowers
glozes	16	43	1335	2	gloze_s
gluers	7	50	1115	2	gl_uers
gnawers	11	35	639	2	gnawers
graders	9	47	1601	2	graders
graters	8	54	1974	2	graters
gravers	11	45	1527	2	gravers
grazer	16	48	1576	2	grazer_
grazes	16	45	1964	2	graze_s
graziers	18	38	712	2	graziers
hazers	18	46	1595	2	_hazers
lacers	8	52	2525	2	_lacers
laders	7	49	2776	2	_laders
lagers	7	48	2614	2	_lagers
lakers	10	52	2515	2	_lakers
lasers	6	49	2570	2	_lasers
lavers	9	45	2636	2	_lavers
layers	9	39	2118	2	_layers
lazars	15	38	1239	2	_lazars
lazes	14	51	2957	2	_laze_s
mazers	17	39	1709	2	_mazers
placers	11	45	1526	2	placers
planers	9	45	1794	2	planers
platers	9	39	2409	2	platers
players	12	43	1376	2	players
razers	15	49	1961	2	_razers
slakers	11	41	1575	2	slakers
slaters	7	31	2373	2	slaters
slavers	10	37	1650	2	slavers
slayers	10	45	1332	2	slayers

Search took 4 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	107671	0.373	479064.3
2	DLD Change Limit	107671	74	2.983	36094.9
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	3.389	52726.8