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

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

38 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
latchets	13	34	1001	(None)
hatchets	16	33	1038	1	hatchets
latches	12	33	2012	1	latche_s
latchet	12	31	1790	1	latchet_
ratchets	13	31	1026	1	ratchets
batchers	15	36	1327	2	batchers
batches	14	40	1961	2	batche_s
cachets	14	50	1426	2	ca_chets
catchers	15	31	1406	2	catchers
catches	14	43	2077	2	catche_s
fitchets	16	30	741	2	fitchets
hatchels	16	36	867	2	hatchels
hatchers	16	31	1317	2	hatchers
hatches	15	34	2027	2	hatche_s
hatchet	15	33	1756	2	hatchet_
klatches	17	15	713	2	klatche_s
laches	11	65	2834	2	la_che_s
lancets	9	34	1116	2	lanc_ets
larches	12	44	1644	2	larche_s
latched	13	39	1406	2	latche_d
latchkeys	21	4	187	2	latchkeys
lathers	10	43	2188	2	lat_hers
lathes	9	51	2749	2	lat_he_s
letches	12	40	1548	2	letche_s
manchets	15	26	957	2	manchets
matchers	15	30	1243	2	matchers
matches	14	32	1978	2	matche_s
patchers	15	34	1330	2	patchers
patches	14	33	2038	2	patche_s
planchets	16	23	674	2	planchets
rachets	12	45	1683	2	ra_chets
ratches	12	36	2046	2	ratche_s
ratchet	12	42	1833	2	ratchet_
sachets	12	39	1410	2	sa_chets
satchels	13	32	816	2	satchels
slatches	13	15	1152	2	slatche_s
watchers	16	35	1179	2	watchers
watches	15	30	1737	2	watche_s

Search took 5 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.376	475242.0
2	DLD Change Limit	121059	38	3.826	31641.1
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	4.218	42363.9