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

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

308 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
crunch	13	34	950	(None)
brunch	13	32	935	1	brunch
cranch	13	36	1353	1	cranch
craunch	14	6	444	1	craunch
crunchy	17	32	476	1	crunchy
crutch	13	40	824	1	crutch
scrunch	14	4	403	1	scrunch
branch	13	40	1477	2	branch
bunch	12	51	1860	2	_bunch
chinch	16	39	1123	2	chinch
church	16	3	648	2	church
cinch	12	45	1624	2	c_inch
clench	13	39	1005	2	clench
clinch	13	39	1035	2	clinch
clutch	13	36	775	2	clutch
conch	12	46	2007	2	c_onch
couch	12	53	2011	2	cou_ch
cratch	13	41	1079	2	cratch
crotch	13	34	1008	2	crotch
crouch	13	39	1020	2	crouch
cruck	13	56	1532	2	cru_ck
crunched	16	32	816	2	crunched
cruncher	15	33	807	2	cruncher
crunches	15	37	1135	2	crunches
crush	10	68	1599	2	cru_sh
culch	12	45	1283	2	c_ulch
curch	12	44	1541	2	c_urch
cutch	12	51	1619	2	c_utch
drench	12	36	959	2	drench
dunch	11	53	1626	2	_dunch
french	14	35	1121	2	french
glunch	12	5	535	2	glunch
grinch	12	3	848	2	grinch
grutch	12	28	556	2	grutch
haunch	14	37	734	2	haunch
hunch	13	64	1621	2	_hunch
launch	11	36	806	2	launch
lunch	10	49	1724	2	_lunch
munch	12	49	1710	2	_munch
paunch	13	36	985	2	paunch
punch	12	51	1842	2	_punch
ranch	10	50	1979	2	_ranch
raunch	11	35	843	2	raunch
scrunchy	18	5	238	2	scrunchy
trench	11	42	1161	2	trench
wrench	14	43	935	2	wrench
adunc	8	3	743	3	adunc_
arch	9	86	2844	3	ar__ch
bench	12	56	1950	3	_bench
blanch	13	34	1085	3	blanch
blench	13	37	1045	3	blench
bounce	10	40	1483	3	bounce
bouncy	13	40	907	3	bouncy
brach	12	61	2330	3	br_ach
branchy	17	35	791	3	branchy
breach	13	42	1372	3	breach
breech	13	34	826	3	breech
broach	13	36	1111	3	broach
bronc	9	17	1434	3	bronc_
bronchi	14	17	631	3	bronchi
broncho	14	20	646	3	broncho
bronco	10	17	949	3	bronco
broncs	10	16	1115	3	broncs
brooch	13	36	844	3	brooch
brugh	11	54	1429	3	bru_gh
brunched	16	31	785	3	brunched
bruncher	15	34	778	3	bruncher
brunches	15	37	1045	3	brunches
brunet	8	44	1929	3	brunet
brung	8	46	1391	3	brun_g
brunt	7	57	2875	3	brun_t
brunts	8	52	1545	3	brunts
brush	10	59	1747	3	bru_sh
bunchy	16	43	746	3	_bunchy
bunco	9	46	1608	3	_bunco
butch	12	54	1654	3	_butch
cancha	13	44	1161	3	c_ancha
caroach	14	8	886	3	caroach
caroch	13	9	1176	3	caroch
carroch	14	3	709	3	carroch
caruncle	12	4	471	3	caruncle
catch	12	51	2037	3	c_atch
chance	13	46	1709	3	chance
chancy	16	40	1086	3	chancy
chinchy	20	33	551	3	chinchy
chuck	16	48	1487	3	chu_ck
chunk	14	48	1238	3	chun_k
chunks	15	42	1033	3	chunks
chunky	18	46	827	3	chunky
churchy	20	4	418	3	churchy
clach	12	46	1782	3	c_lach
cluck	13	49	1489	3	clu_ck
clung	8	60	1360	3	clun_g
clunk	11	42	1508	3	clun_k
clunks	12	48	1101	3	clunks
clunky	15	44	789	3	clunky
clutchy	17	32	389	3	clutchy
coach	12	59	1945	3	c_oach
concha	13	42	1328	3	c_oncha
concho	13	44	1426	3	c_oncho
conchs	13	47	1490	3	c_onchs
conchy	16	37	1022	3	c_onchy
cooch	12	49	1683	3	c_ooch
coronach	15	4	576	3	coronach
cough	11	58	1964	3	cou_gh
council	11	3	747	3	council
count	7	49	3205	3	coun_t
counts	8	46	1827	3	counts
county	11	43	1332	3	county
couth	10	61	2249	3	cou_th
crack	13	41	2053	3	cr_ack
cranched	16	32	1041	3	cranched
cranches	15	31	1454	3	cranches
crane	7	53	3160	3	cran_e
craned	9	61	2165	3	craned
cranes	8	43	3075	3	cranes
crania	8	24	1843	3	crania
crank	11	48	1961	3	cran_k
cranks	12	50	1531	3	cranks
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
crash	10	91	2001	3	cr_ash
craunched	17	6	402	3	craunched
craunches	16	5	572	3	craunches
creche	13	3	1076	3	cr_eche
creesh	11	32	833	3	creesh
crenel	8	42	1306	3	crenel
crick	13	51	1875	3	cr_ick
cringe	9	35	1548	3	cringe
crinum	10	3	933	3	crinum
croc	8	57	2373	3	cr_oc_
croci	9	58	1813	3	cr_oci
crock	13	59	2199	3	cr_ock
crocs	9	57	2243	3	cr_ocs
crone	7	52	3133	3	cron_e
crones	8	47	2924	3	crones
cronish	12	3	1086	3	cronish
crony	10	59	1867	3	cron_y
cru	5	71	2956	3	cru___
cruces	10	51	1754	3	cruces
crucks	14	44	1258	3	crucks
crud	7	52	1961	3	cru__d
cruddy	13	3	419	3	cruddy
crude	8	60	1857	3	cru_de
cruder	9	56	1238	3	cruder
crudes	9	62	1862	3	crudes
cruds	8	58	1585	3	cru_ds
cruel	7	48	1590	3	cru_el
cruet	7	48	3184	3	cru_et
cruets	8	53	1495	3	cruets
cruise	8	43	1404	3	cruise
crumb	11	43	1359	3	cru_mb
crumbs	12	40	923	3	crumbs
crumby	15	40	811	3	crumby
crummy	15	36	589	3	crummy
crump	11	56	1642	3	cru_mp
crumps	12	45	1434	3	crumps
crunchers	16	31	624	3	crunch~~ers~~
crunchier	16	4	468	3	crunch~~ier~~
crunchily	19	4	319	3	crunch~~ily~~
crunching	17	29	700	3	crunch~~ing~~
crunode	10	3	471	3	crunode
cruor	7	3	1045	3	cru_or
cruors	8	3	864	3	cruors
crura	7	3	1258	3	cru_ra
crural	8	6	1063	3	crural
crus	6	58	2848	3	cru__s
cruse	7	57	2610	3	cru_se
cruses	8	81	2771	3	cruses
cruset	8	44	2509	3	cruset
crust	7	58	2766	3	cru_st
crusts	8	49	1654	3	crusts
crusty	11	49	1134	3	crusty
crutched	16	30	746	3	crutched
crutches	15	35	959	3	crutches
crux	13	54	1500	3	cru__x
cruxes	15	49	1156	3	cruxes
crwth	13	3	748	3	cr_wth
cuish	10	3	1317	3	c_uish
cultch	13	38	595	3	cultch
cunt	6	62	4367	3	c_un_t
cunts	7	61	2512	3	c_unts
curacy	13	3	959	3	curacy
curagh	12	3	655	3	curagh
curn	6	67	3189	3	curn__
curns	7	49	2428	3	curn_s
currach	14	4	645	3	currach
dreich	12	37	772	3	dreich
drunk	10	54	984	3	drun_k
drunks	11	42	751	3	drunks
dunce	8	63	1926	3	_dunce
dutch	11	47	1382	3	_dutch
eruct	7	40	2235	3	eru_ct
eunuch	11	5	436	3	_eunuch
finch	13	54	1697	3	_finch
flench	14	40	1081	3	flench
flinch	14	40	1010	3	flinch
franc	10	46	1541	3	franc_
francs	11	41	1219	3	francs
frounce	12	3	615	3	frounce
grouch	12	31	847	3	grouch
grunge	8	35	958	3	grunge
grungy	11	34	597	3	grungy
grunt	6	55	2354	3	grun_t
grunts	7	55	1185	3	grunts
gulch	11	38	1060	3	_gulch
heuch	13	53	1233	3	heu_ch
hunh	10	63	2373	3	_hun_h
hutch	13	54	1409	3	_hutch
inch	9	54	2082	3	__inch
jaunce	15	36	743	3	jaunce
jounce	15	33	1073	3	jounce
jouncy	18	33	620	3	jouncy
junco	14	46	1220	3	_junco
kench	14	55	1392	3	_kench
launce	8	46	918	3	launce
lurch	10	48	1463	3	_lurch
lynch	13	46	898	3	_lynch
mouch	12	47	1580	3	mou_ch
much	11	52	2403	3	_mu_ch
mulch	12	40	1297	3	_mulch
mutch	12	50	1617	3	_mutch
nautch	11	4	481	3	nautch
orach	10	52	1923	3	or_ach
ouch	9	57	2463	3	_ou_ch
ounce	7	70	1993	3	_ounce
painch	13	35	1132	3	painch
paunchy	17	32	444	3	paunchy
pinch	12	56	1930	3	_pinch
planch	13	37	1144	3	planch
plench	13	40	1081	3	plench
pouch	12	46	1708	3	pou_ch
pounce	10	52	1409	3	pounce
prance	10	43	1857	3	prance
preach	13	36	1392	3	preach
prelunch	15	4	343	3	prelunch
prepunch	17	4	364	3	prepunch
prince	10	41	1476	3	prince
prune	7	51	1963	3	prun_e
pruned	9	34	1311	3	pruned
pruner	8	34	1345	3	pruner
prunes	8	34	1906	3	prunes
prunus	8	39	936	3	prunus
prutah	11	3	658	3	prutah
punchy	16	39	852	3	_punchy
quench	20	3	663	3	quench
rance	7	50	2851	3	_rance
rancho	11	43	1085	3	_rancho
ratch	10	42	2136	3	_ratch
raunchy	15	28	431	3	raunchy
reach	10	51	2388	3	_reach
retch	10	48	1830	3	_retch
rich	9	70	2554	3	_r_ich
roach	10	57	1700	3	_roach
rotch	10	58	1593	3	_rotch
ruche	10	42	1676	3	_ru_che
ruck	10	47	2833	3	_ru_ck
run	3	62	4499	3	_run__
rune	4	52	3630	3	_run_e
runes	5	55	3022	3	_runes
rung	5	64	2998	3	_run_g
rungs	6	118	1940	3	_rungs
runic	7	36	1577	3	_runic
runny	8	46	1348	3	_runny
runs	4	64	3808	3	_run_s
runt	4	66	4799	3	_run_t
runts	5	59	2763	3	_runts
runty	8	61	1904	3	_runty
rush	7	66	2818	3	_ru_sh
ruth	7	68	2599	3	_ru_th
sauch	10	49	1877	3	sau_ch
scraich	14	3	676	3	scraich
scratch	14	4	601	3	scratch
screech	14	3	522	3	screech
scrooch	14	4	496	3	scrooch
scrunched	17	4	403	3	scrunched
scrunches	16	3	540	3	scrunches
scrunchie	16	4	303	3	scrunchie
sculch	13	22	621	3	sculch
scutch	13	24	708	3	scutch
smutch	13	20	584	3	smutch
squinch	21	3	483	3	squinch
stanch	11	38	1237	3	stanch
staunch	12	4	427	3	staunch
stench	11	41	1116	3	stench
such	9	64	2481	3	_su_ch
synch	13	50	1179	3	_synch
tench	10	56	2000	3	_tench
teuch	10	52	1485	3	teu_ch
touch	10	65	1939	3	tou_ch
trance	8	47	1876	3	trance
tranche	12	33	1222	3	tranche
trounce	9	3	682	3	trounce
truancy	12	4	499	3	truancy
truce	7	51	1869	3	tru_ce
truck	11	61	1546	3	tru_ck
trunk	9	47	1304	3	trun_k
trunks	10	42	975	3	trunks
truth	8	52	1415	3	tru_th
unci	6	50	1946	3	__unci
unco	6	60	2140	3	__unco
vouch	13	46	1190	3	vou_ch
wench	13	62	1478	3	_wench
winch	13	50	1666	3	_winch
wretch	14	32	653	3	wretch
wrung	9	54	980	3	wrun_g
yucch	15	41	743	3	_yucch
yuch	12	58	1853	3	_yu_ch

Search took 7 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	112716	0.406	440125.6
2	DLD Change Limit	112716	308	5.783	19490.9
3	Display Results	308	308	0.093	3311.8
	(SQL Overall)	178691	308	6.282	28444.9