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

Here are the results of your fuzzy-string dictionary search for “grazers” 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.

88 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
grazers	17	51	1245	(None)
brazers	18	45	1394	1	brazers
gazers	16	45	1630	1	g_azers
glazers	17	44	1004	1	glazers
graders	9	47	1601	1	graders
graters	8	54	1974	1	graters
gravers	11	45	1527	1	gravers
grazer	16	48	1576	1	grazer_
grazes	16	45	1964	1	graze_s
graziers	18	38	712	1	graziers
razers	15	49	1961	1	_razers
blazers	18	48	1168	2	blazers
bracers	11	46	1670	2	bracers
bravers	12	47	1552	2	bravers
brayers	12	45	1190	2	brayers
brazens	18	41	871	2	brazens
brazer	17	49	1753	2	brazer_
brazes	17	55	2219	2	braze_s
braziers	19	39	719	2	braziers
craters	9	50	2189	2	craters
cravers	12	44	1656	2	cravers
crazes	17	47	2013	2	craze_s
crozers	18	41	1108	2	crozers
drapers	10	53	1335	2	drapers
drawers	11	36	1007	2	drawers
erasers	7	44	1394	2	erasers
framers	12	51	1382	2	framers
fraters	10	35	1721	2	fraters
frizers	19	32	955	2	frizers
gagers	8	40	2133	2	g_agers
gamers	9	44	2083	2	g_amers
gapers	9	45	2047	2	g_apers
garners	8	38	1598	2	garners
garters	8	42	1823	2	garters
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
glazer	16	42	1226	2	glazer_
glazes	16	53	1564	2	glaze_s
glaziers	18	40	656	2	glaziers
gnawers	11	35	639	2	gnawers
grabbers	13	33	788	2	grabbers
grabens	10	36	700	2	grabens
graces	9	45	2349	2	grace_s
grader	8	49	1969	2	grader_
grades	8	49	2631	2	grade_s
grafters	12	40	919	2	grafters
grainers	9	30	1207	2	grainers
grangers	10	30	1197	2	grangers
granters	9	36	1414	2	granters
grapery	13	45	795	2	grapery
grapes	9	51	2312	2	grape_s
graspers	11	33	840	2	graspers
grater	7	46	2544	2	grater_
grates	7	54	2989	2	grate_s
gravels	11	36	1114	2	gravels
graver	10	50	1859	2	graver_
graves	10	46	2400	2	grave_s
grayer	10	60	1454	2	grayer_
graze	15	58	2005	2	graze__
grazed	17	41	1591	2	graze_d
grazier	17	36	1113	2	grazier_
greasers	9	34	1025	2	greasers
gripers	10	40	1146	2	gripers
groaners	9	24	850	2	groaners
grocers	10	35	1125	2	grocers
gropers	10	48	1385	2	gropers
growers	11	36	1272	2	growers
hazers	18	46	1595	2	_hazers
kraters	11	42	1234	2	kraters
mazers	17	39	1709	2	_mazers
praters	9	49	2165	2	praters
prayers	12	42	1285	2	prayers
prizers	18	39	1184	2	prizers
racers	8	47	2543	2	_racers
rakers	10	41	2357	2	_rakers
rapers	8	43	2718	2	_rapers
rasers	6	45	2678	2	_rasers
raters	6	39	3658	2	_raters
ravers	9	46	2818	2	_ravers
razees	15	43	1476	2	_razees
razer	14	48	2427	2	_razer_
razes	14	50	3270	2	_raze_s
razors	15	47	1166	2	_razors
tracers	9	49	1784	2	tracers
traders	8	43	1695	2	traders

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	88	3.393	31733.3
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.796	47073.5