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

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

78 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
erasers	7	44	1394	(None)
eraser	6	42	1633	1	eraser_
erases	6	44	2540	1	erase_s
rasers	6	45	2678	1	_rasers
abasers	9	53	1197	2	abasers
bracers	11	46	1670	2	bracers
brasiers	10	37	1051	2	brasiers
bravers	12	47	1552	2	bravers
brayers	12	45	1190	2	brayers
brazers	18	45	1394	2	brazers
chasers	12	37	1492	2	chasers
crases	8	55	3231	2	crase_s
crashers	13	40	1323	2	crashers
craters	9	50	2189	2	craters
cravers	12	44	1655	2	cravers
creasers	10	36	1283	2	creasers
debasers	11	37	790	2	debasers
drapers	10	53	1335	2	drapers
drawers	11	36	1007	2	drawers
eagers	7	45	2368	2	e_agers
earners	7	40	1645	2	earners
easels	6	59	1455	2	e_asels
eases	5	60	4161	2	e_ase_s
easters	7	51	2568	2	e_asters
eaters	6	55	3595	2	e_aters
ecraseurs	11	4	169	2	ecraseurs
elaters	7	44	2019	2	elaters
erase	5	49	2549	2	erase__
erased	7	48	1675	2	erase_d
erasure	7	3	694	2	erasure
erasures	8	3	721	2	erasures
eroses	6	53	2705	2	erose_s
erses	5	58	2680	2	er_se_s
evaders	11	3	693	2	evaders
eyases	9	45	1368	2	eyase_s
framers	12	51	1382	2	framers
fraters	10	35	1721	2	fraters
graders	9	47	1601	2	graders
graspers	11	33	840	2	graspers
graters	8	54	1974	2	graters
gravers	11	45	1527	2	gravers
grazers	17	51	1245	2	grazers
greasers	9	34	1025	2	greasers
kraters	11	42	1234	2	kraters
lasers	6	49	2570	2	_lasers
leasers	7	47	1784	2	leasers
masers	8	46	2345	2	_masers
parsers	9	41	1815	2	parsers
perusers	10	32	880	2	perusers
praisers	10	34	1083	2	praisers
prases	8	44	2902	2	prase_s
praters	9	49	2165	2	praters
prayers	12	42	1285	2	prayers
prosers	9	42	1964	2	prosers
racers	8	47	2543	2	_racers
raisers	7	36	1739	2	_raisers
rakers	10	41	2357	2	_rakers
rapers	8	43	2718	2	_rapers
raser	5	56	3341	2	_raser_
rases	5	54	4721	2	_rase_s
rashers	10	40	2091	2	_rashers
raspers	9	44	1592	2	_raspers
rasters	7	46	2902	2	_rasters
raters	6	39	3658	2	_raters
ravers	9	46	2818	2	_ravers
razers	15	49	1961	2	_razers
readers	8	38	2377	2	readers
reamers	9	42	2108	2	reamers
reapers	9	35	2045	2	reapers
rearers	7	43	2356	2	rearers
reavers	10	83	2074	2	reavers
risers	6	46	2478	2	_risers
teasers	7	53	1724	2	teasers
tracers	9	49	1784	2	tracers
traders	8	43	1695	2	traders
trashers	11	30	1364	2	trashers
urases	6	37	2356	2	urase_s
versers	10	38	1352	2	ver_sers

Search took 8 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.750	238254.7
2	DLD Change Limit	107671	78	7.140	15080.0
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	7.936	22516.5