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

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

58 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
trashers	11	30	1364	(None)
crashers	13	40	1323	1	crashers
rashers	10	40	2091	1	_rashers
thrashers	15	6	531	1	thrashers
trasher	10	44	1613	1	trasher_
trashes	10	41	1926	1	trashe_s
bashers	12	48	2083	2	_bashers
brasher	12	45	1524	2	brasher_
brashes	12	45	1846	2	brashe_s
brasiers	10	37	1051	2	brasiers
brushers	13	42	1057	2	brushers
clashers	13	42	1399	2	clashers
crasher	12	46	1616	2	crasher_
crashes	12	46	1840	2	crashe_s
crushers	13	40	1009	2	crushers
dashers	11	50	1686	2	_dashers
erasers	7	44	1394	2	eras_ers
flashers	14	39	1265	2	flashers
graspers	11	33	840	2	graspers
kashers	14	39	1402	2	_kashers
lashers	10	41	2183	2	_lashers
mashers	12	46	2105	2	_mashers
plashers	13	38	1345	2	plashers
quashers	20	18	681	2	quashers
rasers	6	45	2678	2	_ras_ers
rasher	9	50	2412	2	_rasher_
rashes	9	53	3015	2	_rashe_s
raspers	9	44	1592	2	_raspers
rasters	7	46	2902	2	_rasters
rushers	10	38	1610	2	_rushers
slashers	11	33	1361	2	slashers
smashers	13	33	959	2	smashers
swashers	14	38	953	2	swashers
tarsiers	8	29	853	2	tarsiers
tasters	7	42	2564	2	t_asters
teachers	13	32	1239	2	teachers
teasers	7	53	1724	2	teas_ers
thrasher	14	5	574	2	thrasher_
thrashes	14	8	765	2	thrashe_s
threshers	15	4	542	2	threshers
toasters	8	39	1272	2	toasters
tracers	9	49	1784	2	tra_cers
tracheas	13	4	1027	2	tracheas
trackers	14	35	1285	2	trackers
traders	8	43	1695	2	tra_ders
trailers	8	29	1293	2	trailers
trainers	8	31	1465	2	trainers
trampers	12	32	1039	2	trampers
transfers	12	3	805	2	transfers
trappers	12	37	1104	2	trappers
trashed	11	35	1470	2	trashe_d
trashier	11	32	1010	2	trashier_
trasses	7	48	1932	2	trasse_s
trawlers	11	33	1020	2	trawlers
trussers	8	34	828	2	trussers
trusters	8	31	1226	2	trusters
trysters	11	29	837	2	trysters
washers	13	45	1752	2	_washers

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	121059	0.390	458182.1
2	DLD Change Limit	121059	58	3.546	34139.6
3	Display Results	58	58	0.016	3625.0
	(SQL Overall)	178691	58	3.952	45215.3