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

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

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

152 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
clenchers	16	27	655	(None)
blenchers	16	35	672	1	blenchers
clencher	15	27	797	1	clencher_
clenches	15	29	1095	1	clenche_s
clinchers	16	33	626	1	clinchers
benchers	15	36	1101	2	_benchers
blanchers	16	30	743	2	blanchers
bleachers	16	29	792	2	bleachers
blencher	15	30	839	2	blencher_
blenches	15	33	1076	2	blenche_s
clenched	16	25	776	2	clenche_d
clincher	15	34	766	2	clincher_
clinches	15	39	1036	2	clinche_s
crunchers	16	31	624	2	crunchers
drenchers	15	29	610	2	drenchers
flenches	16	34	1053	2	flenche_s
fletchers	17	33	553	2	fletchers
flinchers	17	29	547	2	flinchers
leachers	13	37	1281	2	_leachers
lechers	12	33	1396	2	_le_chers
lunchers	13	34	956	2	_lunchers
lynchers	16	28	545	2	_lynchers
plenches	15	31	1062	2	plenche_s
quenchers	23	4	317	2	quenchers
trenchers	14	28	807	2	trenchers
wenchers	16	31	921	2	_wenchers
wrenchers	17	25	633	2	wrenchers
belchers	15	35	1002	3	_belchers
bencher	14	41	1348	3	_bencher_
benches	14	39	1860	3	_benche_s
blancher	15	33	863	3	blancher_
blanches	15	33	1160	3	blanche_s
bleacher	15	35	888	3	bleacher_
bleaches	15	34	1067	3	bleache_s
blenched	16	35	805	3	blenche_d
blenders	11	52	1099	3	blen_ders
blethers	13	42	961	3	ble_thers
bluchers	15	35	903	3	bl_uchers
breachers	16	36	985	3	breachers
brunchers	16	29	625	3	brunchers
caleches	15	26	993	3	cale_che_s
calenders	12	3	740	3	calen_ders
cancers	11	40	1858	3	c_anc_ers
catchers	15	31	1405	3	c_atchers
censers	9	43	1390	3	c_en_sers
centers	9	44	2059	3	c_en_ters
centners	10	5	724	3	c_entners
chancers	15	43	1348	3	chanc_ers
checkers	19	31	784	3	che_ckers
chinches	18	36	936	3	chinche_s
cinches	14	42	1577	3	c_inche_s
clackers	16	39	1170	3	cl_ackers
clangers	11	43	1234	3	clan_gers
clashers	13	42	1399	3	cl_ashers
cleaners	10	36	1053	3	cle_aners
cleansers	11	33	506	3	cleansers
clearers	10	34	929	3	cle_arers
cleavers	13	39	886	3	cle_avers
clench	13	39	1005	3	clench___
clenching	17	26	630	3	clenching
clerihews	17	4	155	3	clerihews
cliches	14	42	1374	3	cl_iche_s
clickers	16	39	1020	3	cl_ickers
clinched	16	34	738	3	clinche_d
clingers	11	38	1066	3	clin_gers
clinkers	14	33	983	3	clin_kers
cloches	14	41	1371	3	cl_oche_s
clockers	16	36	981	3	cl_ockers
cloners	9	45	1482	3	clon__ers
clunkers	14	32	754	3	clun_kers
clutches	15	30	791	3	clutche_s
coachers	15	43	1229	3	c_oachers
coanchors	16	4	571	3	coanchors
coercers	12	3	765	3	coerc_ers
conches	14	40	1981	3	c_onche_s
couchers	15	35	1384	3	c_ouchers
cranches	15	31	1454	3	cranche_s
creches	14	3	1309	3	cre_che_s
cruncher	15	33	807	3	cruncher_
crunches	15	37	1135	3	crunche_s
drencher	14	25	721	3	drencher_
drenches	14	30	980	3	drenche_s
elenchus	13	4	363	3	elench_us
etchers	12	34	1129	3	__etchers
fencers	12	38	1062	3	_fenc_ers
fetchers	16	32	886	3	_fetchers
fleches	15	34	1144	3	fle_che_s
fleecers	13	32	593	3	fleec_ers
fleeches	16	28	708	3	fleeche_s
flenched	17	26	796	3	flenche_d
flensers	11	3	546	3	flen_sers
fleshers	14	33	944	3	fle_shers
fletcher	16	30	666	3	fletcher_
fletches	16	30	885	3	fletche_s
flincher	16	25	658	3	flincher_
flinches	16	35	895	3	flinche_s
frenches	16	33	1163	3	frenche_s
glancers	11	40	800	3	glanc_ers
glunches	14	3	626	3	glunche_s
inchers	12	39	1252	3	__inchers
kenches	16	39	1227	3	_kenche_s
kvetchers	21	4	237	3	kvetchers
lancers	9	36	1664	3	_lanc_ers
lanciers	10	30	854	3	_lanciers
launchers	14	5	433	3	launchers
leacher	12	40	1484	3	_leacher_
leaches	12	33	1934	3	_leache_s
leathers	11	42	1508	3	_leathers
lecher	11	34	1585	3	_le_cher_
lechery	15	25	764	3	_le_chery
leches	11	54	2131	3	_le_che_s
leeches	12	39	1193	3	_leeche_s
lenders	8	44	1964	3	_len_ders
letches	12	40	1548	3	_letche_s
luncher	12	31	1141	3	_luncher_
lunches	12	41	1544	3	_lunche_s
lurchers	13	30	715	3	_lurchers
lyncher	15	36	655	3	_lyncher_
lynches	15	37	887	3	_lynche_s
munchers	15	31	877	3	_munchers
peachers	15	32	1384	3	_peachers
perchers	15	36	1152	3	_perchers
pinchers	15	35	1061	3	_pinchers
planches	15	31	1186	3	planche_s
planchets	16	23	674	3	planchets
pleaches	15	32	1043	3	pleache_s
pleathers	14	4	645	3	pleathers
preachers	16	33	957	3	preachers
punchers	15	26	1007	3	_punchers
quencher	22	3	412	3	quencher_
quenches	22	3	601	3	quenche_s
ranchers	13	33	1179	3	_ranchers
reachers	13	35	1572	3	_reachers
screechers	17	14	367	3	screechers
silencers	11	4	528	3	silenc_ers
sketchers	18	3	451	3	sketchers
sleighers	13	4	370	3	sleighers
slouchers	14	18	562	3	slouchers
spencers	12	26	919	3	spenc_ers
stanchers	14	20	680	3	stanchers
stenches	13	21	1029	3	stenche_s
teachers	13	32	1239	3	_teachers
tenches	12	35	1552	3	_tenche_s
trencher	13	27	931	3	trencher_
trenches	13	35	1260	3	trenche_s
unclenches	17	4	379	3	unclenche_s
welchers	16	33	805	3	_welchers
wencher	15	38	1113	3	_wencher_
wenches	15	29	1413	3	_wenche_s
winchers	16	31	922	3	_winchers
wrencher	16	28	778	3	wrencher_
wrenches	16	32	1023	3	wrenche_s

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	148641	0.173	1032896.0
2	DLD Change Limit	148641	152	7.046	21095.8
3	Display Results	152	152	0.063	2412.7
	(SQL Overall)	178691	152	7.282	24538.7