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

Here are the results of your fuzzy-string dictionary search for “hatcheck” with Change Limit: [1] [2] [3] [4]

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.

76 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
hatcheck	22	4	401	(None)
hatchecks	23	4	359	1	hatchecks
hatchback	25	6	331	2	hatchback
hatched	16	34	1446	2	hatche_d
hatchel	15	35	1075	2	hatche_l
hatchels	16	36	867	2	hatchels
hatcher	15	33	1472	2	hatche_r
hatchers	16	31	1317	2	hatchers
hatchery	19	32	638	2	hatchery
hatches	15	34	2027	2	hatche_s
hatchet	15	33	1756	2	hatche_t
hatchets	16	33	1038	2	hatchets
paycheck	24	4	255	2	paycheck
aircheck	19	4	290	3	aircheck
backcheck	20	9	272	3	backcheck
batched	15	41	1424	3	batche_d
batcher	14	44	1485	3	batche_r
batchers	15	36	1327	3	batchers
batches	14	40	1961	3	batche_s
catcher	14	31	1582	3	catche_r
catchers	15	31	1406	3	catchers
catches	14	43	2077	3	catche_s
cathect	14	3	986	3	cat_hect
check	16	47	1471	3	___check
dabchick	22	4	197	3	dabchick
hacek	14	54	1184	3	ha_c_e_k
hardhack	21	4	384	3	hardhack
hatch	13	57	1959	3	hatch___
hatchbacks	26	8	308	3	hatchbacks
hatcheled	18	4	422	3	hatcheled
hatching	17	33	1221	3	hatching
hatchment	19	4	531	3	hatchment
hatchway	22	4	329	3	hatchway
hatrack	16	3	821	3	hat_rack
haycock	21	4	431	3	hayc_ock
hitched	16	33	1225	3	hitche_d
hitcher	15	37	1200	3	hitche_r
hitchers	16	37	999	3	hitchers
hitches	15	36	1627	3	hitche_s
hotched	16	36	1092	3	hotche_d
hotches	15	38	1436	3	hotche_s
hutched	16	35	988	3	hutche_d
hutches	15	36	1352	3	hutche_s
latched	13	39	1406	3	latche_d
latches	12	33	2012	3	latche_s
latchet	12	31	1790	3	latche_t
latchets	13	34	1001	3	latchets
matched	15	35	1396	3	matche_d
matcher	14	32	1428	3	matche_r
matchers	15	30	1243	3	matchers
matches	14	32	1978	3	matche_s
matchlock	22	5	240	3	matchlock
patched	15	35	1462	3	patche_d
patcher	14	35	1514	3	patche_r
patchers	15	34	1330	3	patchers
patches	14	33	2038	3	patche_s
paychecks	25	4	224	3	paychecks
pincheck	21	4	338	3	pincheck
precheck	21	4	415	3	precheck
raincheck	20	4	189	3	raincheck
ratches	12	36	2046	3	ratche_s
ratchet	12	42	1833	3	ratche_t
ratchets	13	31	1026	3	ratchets
recheck	18	3	561	3	_recheck
saltchuck	20	15	157	3	saltchuck
satchel	12	33	1030	3	satche_l
satchels	13	32	816	3	satchels
thatched	17	3	543	3	thatche_d
thatcher	16	3	566	3	thatche_r
thatchers	17	4	458	3	thatchers
thatches	16	3	751	3	thatche_s
watched	16	30	1282	3	watche_d
watcher	15	31	1340	3	watche_r
watchers	16	35	1179	3	watchers
watches	15	30	1737	3	watche_s
watcheye	19	10	427	3	watcheye

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	146162	0.423	422437.4
2	DLD Change Limit	146162	76	7.470	19566.5
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	7.923	22553.5