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

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

40 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
hatchets	16	33	1038	(None)
hatchels	16	36	867	1	hatchels
hatchers	16	31	1317	1	hatchers
hatches	15	34	2027	1	hatche_s
hatchet	15	33	1756	1	hatchet_
latchets	13	34	1001	1	latchets
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
hatcheck	22	4	401	2	hatcheck
hatchecks	23	4	359	2	hatchecks
hatched	16	34	1446	2	hatche_d
hatchel	15	35	1075	2	hatche_l
hatcher	15	33	1472	2	hatche_r
hatchery	19	32	638	2	hatchery
hatchments	20	4	388	2	hatchments
hitchers	16	37	999	2	hitchers
hitches	15	36	1627	2	hitche_s
hotches	15	38	1436	2	hotche_s
hutches	15	36	1352	2	hutche_s
latches	12	33	2012	2	latche_s
latchet	12	31	1790	2	latchet_
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
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
thatchers	17	4	458	2	thatchers
thatches	16	3	751	2	thatche_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.390	458182.1
2	DLD Change Limit	121059	40	3.983	30393.9
3	Display Results	40	40	0.016	2500.0
	(SQL Overall)	178691	40	4.389	40713.4