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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
watchcries	20	4	274	(None)
hatcheries	18	4	652	2	hatcheries
watchcases	20	5	278	2	watchcases
witcheries	18	4	546	2	witcheries
archeries	14	4	1122	3	_archeries
bitcheries	17	4	590	3	bitcheries
botcheries	17	4	605	3	botcheries
butcheries	17	4	507	3	butcheries
catchflies	20	4	337	3	catchflies
cutcheries	17	4	508	3	cutcheries
gaucheries	16	4	453	3	gaucheries
watchables	20	4	320	3	watchables
watchcase	19	4	277	3	watchcase_
watchcry	21	4	236	3	watchcr__y
watchers	16	35	1179	3	watcher__s
watches	15	30	1737	3	watch___es
watcheyes	20	10	374	3	watch_eyes
accrues	11	3	532	4	_a_c_crues
actuaries	11	4	756	4	_actuaries
alchemies	16	5	483	4	_alchemies
alchymies	19	4	288	4	_alchymies
anchorites	15	4	775	4	_anchorites
anchovies	17	4	575	4	_anchovies
archpriest	17	4	302	4	_archpriest
batchers	15	36	1327	4	batcher__s
batches	14	40	1961	4	batch___es
batteries	11	6	1511	4	bat_teries
bewitcheries	22	5	147	4	bewitcheries
cachexies	23	6	416	4	ca_chexies
catchers	15	31	1406	4	catcher__s
catches	14	43	2077	4	catch___es
catchier	15	32	986	4	catch__ier
catchiest	16	3	831	4	catch__iest
catchpoles	19	4	378	4	catchpoles
categories	13	4	607	4	categories
catenaries	12	4	866	4	catenaries
catharses	14	4	641	4	cat_harses
catteries	11	8	1552	4	cat_teries
dataries	9	3	1403	4	dat__aries
eateries	8	3	2431	4	eat__eries
factories	14	8	1009	4	fa_ctories
falconries	15	4	394	4	falconries
gaucherie	15	4	342	4	gaucherie_
hachures	16	4	587	4	ha_chur_es
hatchers	16	31	1317	4	hatcher__s
hatches	15	34	2027	4	hatch___es
jaggheries	22	4	242	4	jaggheries
katharses	16	4	387	4	kat_harses
latches	12	33	2012	4	latch___es
latencies	11	4	777	4	latenc_ies
lecheries	14	4	907	4	_lecheries
machrees	15	4	550	4	ma_ch_rees
matchboxes	26	5	255	4	matchboxes
matchers	15	30	1243	4	matcher__s
matches	14	32	1978	4	match___es
matchmakes	23	5	324	4	matchmakes
nitchies	13	3	907	4	nitch__ies
outcharges	16	4	483	4	outcharges
outcries	10	3	1357	4	out__cries
patchers	15	34	1330	4	patcher__s
patches	14	33	2038	4	patch___es
patchier	15	31	966	4	patch__ier
patchiest	16	3	835	4	patch__iest
patchoulies	18	5	186	4	patchoulies
patencies	13	4	917	4	patenc_ies
rancherias	15	4	409	4	rancherias
ratches	12	36	2046	4	ratch___es
saccharides	19	5	375	4	saccharides
saccharins	17	4	476	4	saccharins
stitcheries	16	5	307	4	stitcheries
swatches	16	16	996	4	swatch___es
waggeries	14	12	746	4	wa_ggeries
walkyries	19	4	267	4	wa_lkyries
wardenries	14	4	443	4	wardenries
warhorses	15	4	557	4	wa_rhorses
wasteries	12	11	1534	4	wa_steries
wastries	11	12	1288	4	wa__stries
watchable	19	4	477	4	watchable_
watchbands	21	5	282	4	watchbands
watchdogs	19	4	218	4	watch_dogs
watched	16	30	1282	4	watch___ed
watcher	15	31	1340	4	watch___er
watcheye	19	10	427	4	watch_eye_
watching	17	30	1117	4	watch__ing
watchmaker	24	6	261	4	watchmaker
watchmakers	25	5	223	4	watchmakers
watchmen	18	4	475	4	watch__men
watchouts	17	4	404	4	watch_outs
watchtower	21	7	174	4	watchtower
watchtowers	22	7	147	4	watchtowers
watchwords	22	5	329	4	watchwords
watercress	15	4	338	4	watercress
waterier	11	3	1208	4	wat__erier
wateriest	12	3	1223	4	wat__eriest
waxberries	22	4	313	4	waxberries
weatherizes	26	4	594	4	weat_herizes
witchcraft	23	5	223	4	witchcraft
witchcrafts	24	6	142	4	witchcrafts
witches	15	27	1579	4	witch___es
witchgrass	19	5	198	4	witchgrass
witchier	16	30	788	4	witch__ier
witchiest	17	3	631	4	witch__iest
witherites	16	4	597	4	wit_herites
withies	13	39	1354	4	wit_h__ies

Search took 10 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	161450	0.440	406115.9
2	DLD Change Limit	161450	104	9.373	17225.0
3	Display Results	104	104	0.063	1650.8
	(SQL Overall)	178691	104	9.876	18093.5