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

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

295 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
zilches	21	32	630	(None)
filches	15	34	1072	1	filches
aitches	12	30	1436	2	aitches
belches	14	35	1434	2	belches
birches	14	34	1232	2	birches
bitches	14	41	1706	2	bitches
cinches	14	42	1577	2	cinches
cliches	14	42	1374	2	cliches
culches	14	37	1074	2	culches
ditches	13	32	1571	2	ditches
fiches	14	52	1953	2	fi_ches
filched	16	30	742	2	filched
filcher	15	37	779	2	filcher
filchers	16	28	686	2	filchers
finches	15	39	1419	2	finches
fitches	15	35	1619	2	fitches
gulches	13	39	810	2	gulches
hitches	15	36	1627	2	hitches
inches	11	44	1967	2	_inches
itches	11	49	1621	2	_itches
liches	11	47	2429	2	li_ches
miches	13	43	2073	2	mi_ches
mulches	14	32	1067	2	mulches
niches	11	44	1914	2	ni_ches
pinches	14	41	1793	2	pinches
pitches	14	36	1775	2	pitches
riches	11	50	2208	2	ri_ches
welches	15	37	1031	2	welches
wiches	14	44	1875	2	wi_ches
winches	15	47	1437	2	winches
witches	15	27	1579	2	witches
zilch	19	43	812	2	zilch__
aches	10	61	3229	3	__aches
apaches	14	34	1183	3	apaches
arches	11	48	2204	3	_arches
baches	13	54	2694	3	_baches
batches	14	40	1961	3	batches
beaches	14	41	2065	3	beaches
beeches	14	34	1388	3	beeches
belched	15	40	1184	3	belched
belcher	14	35	1149	3	belcher
belchers	15	35	1002	3	belchers
benches	14	39	1860	3	benches
bices	9	50	2996	3	bi_c_es
bilbies	11	47	1234	3	bilbies
bilboes	11	44	1024	3	bilboes
biles	7	55	4214	3	bil__es
bilges	9	49	1563	3	bil_ges
billies	9	39	2350	3	billies
birched	15	34	991	3	birched
birchen	14	34	788	3	birchen
bitched	15	32	1292	3	bitched
bitchen	14	34	973	3	bitchen
boches	13	46	1852	3	_boches
botches	14	37	1602	3	botches
braches	14	46	2122	3	braches
brioches	15	22	725	3	brioches
britches	15	27	868	3	britches
bunches	14	41	1603	3	bunches
butches	14	43	1536	3	butches
caches	13	79	2691	3	_caches
calces	10	44	2005	3	calc_es
caleches	15	26	993	3	caleches
caliches	15	38	1226	3	caliches
catches	14	43	2077	3	catches
chinches	18	36	936	3	chinches
cilices	11	38	1402	3	cilices
cinched	15	39	1086	3	cinched
circles	11	3	990	3	circles
ciscoes	11	36	1073	3	ciscoes
cliche	13	37	1245	3	cliche_
cliched	15	37	1102	3	cliched
clinches	15	39	1036	3	clinches
cloches	14	41	1371	3	cloches
coaches	14	40	1869	3	coaches
conches	14	40	1981	3	conches
cooches	14	35	1583	3	cooches
couches	14	40	2047	3	couches
creches	14	3	1309	3	creches
cultches	15	31	653	3	cultches
curches	14	35	1274	3	curches
cutches	14	32	1646	3	cutches
dices	8	64	3424	3	di_c_es
dilates	8	32	2066	3	dilates
dildoes	9	22	924	3	dildoes
dillies	8	41	2216	3	dillies
dilutes	8	29	1197	3	dilutes
dishes	10	46	2265	3	di_shes
ditched	14	37	1190	3	ditched
ditcher	13	40	1200	3	ditcher
ditchers	14	36	1036	3	ditchers
douches	13	43	1523	3	douches
dunches	13	33	1258	3	dunches
eches	10	63	2216	3	__eches
etches	11	42	1776	3	_etches
falces	11	52	1600	3	falc_es
fetches	15	34	1389	3	fetches
fiacres	12	3	725	3	fiacres
fices	10	60	3116	3	fi_c_es
fiche	13	46	1674	3	fi_che_
fichus	14	38	811	3	fi_chus
ficoes	11	46	1346	3	fi_coes
filch	13	48	1332	3	filch__
files	8	54	4127	3	fil__es
filles	9	42	2452	3	fil_les
fillies	10	34	2025	3	fillies
filths	12	38	978	3	filth_s
fishes	12	52	2134	3	fi_shes
fitchee	15	27	1078	3	fitchee
fitchet	15	31	1356	3	fitchet
fitchets	16	30	741	3	fitchets
fitchew	18	27	680	3	fitchew
fitchews	19	27	477	3	fitchews
fleches	15	34	1144	3	fleches
flinches	16	35	895	3	flinches
flitches	16	38	846	3	flitches
gillies	8	41	2096	3	gillies
girshes	11	24	829	3	girshes
glitches	14	29	665	3	glitches
grinches	14	3	694	3	grinches
hatches	15	34	2027	3	hatches
hilloes	10	38	1596	3	hilloes
hitched	16	33	1225	3	hitched
hitcher	15	37	1200	3	hitcher
hitchers	16	37	999	3	hitchers
hooches	15	38	1252	3	hooches
hotches	15	38	1436	3	hotches
hunches	15	39	1346	3	hunches
hutches	15	36	1352	3	hutches
ices	6	61	2964	3	_i_c_es
ichs	9	62	1471	3	_i_ch_s
ilexes	13	45	1025	3	_ilexes
inched	12	45	1448	3	_inched
incher	11	41	1403	3	_incher
inchers	12	39	1252	3	_inchers
itched	12	38	1202	3	_itched
kenches	16	39	1227	3	kenches
ketches	16	40	1219	3	ketches
killies	11	33	1811	3	killies
kilties	11	30	1414	3	kilties
kimchee	18	4	560	3	kimchee
kimchees	19	4	294	3	kimchees
kimchis	18	4	373	3	kimchis
kirsches	17	4	384	3	kirsches
kitchen	16	28	768	3	kitchen
kitchens	17	19	578	3	kitchens
kithes	13	50	1665	3	ki_thes
kitsches	17	3	407	3	kitsches
laches	11	65	2834	3	_laches
larches	12	44	1644	3	larches
latches	12	33	2012	3	latches
leaches	12	33	1934	3	leaches
leches	11	54	2131	3	_leches
leeches	12	39	1193	3	leeches
letches	12	40	1548	3	letches
lichee	11	40	1797	3	li_chee
lichees	12	35	1278	3	li_chees
lichen	11	40	1274	3	li_chen
lichens	12	35	1068	3	li_chens
lichis	11	52	1259	3	li_chis
lichts	11	37	1238	3	li_chts
lilies	6	30	2141	3	lil_ies
litchis	12	3	837	3	litchis
loaches	12	36	1398	3	loaches
lunches	12	41	1544	3	lunches
lurches	12	33	1166	3	lurches
lyches	14	42	1361	3	_lyches
lynches	15	37	887	3	lynches
maches	13	48	2723	3	_maches
manches	14	38	1862	3	manches
marches	14	39	2117	3	marches
matches	14	32	1978	3	matches
merches	14	40	1376	3	merches
miche	12	62	1924	3	mi_che_
miched	14	39	1339	3	mi_ched
milages	10	31	1440	3	milages
milch	12	44	1337	3	milch__
milchig	15	4	365	3	milchig
miles	7	46	4507	3	mil__es
milles	8	45	2656	3	mil_les
minces	10	44	2080	3	minc_es
miscues	11	3	1239	3	miscues
mooches	14	37	1445	3	mooches
mouches	14	38	1596	3	mouches
muches	13	47	1899	3	_muches
mulched	15	30	776	3	mulched
munches	14	42	1579	3	munches
mutches	14	33	1428	3	mutches
naches	11	46	2241	3	_naches
niche	10	50	1679	3	ni_che_
niched	12	55	1406	3	ni_ched
nieces	8	41	1271	3	niec_es
nitchies	13	3	907	3	nitchies
notches	12	35	1365	3	notches
oilcans	9	3	681	3	oilcans
oilcups	11	4	333	3	oilcups
oraches	12	42	1647	3	oraches
ouches	11	43	2218	3	_ouches
painches	15	8	891	3	painches
parches	14	37	2000	3	parches
patches	14	33	2038	3	patches
peaches	14	41	2005	3	peaches
perches	14	37	1795	3	perches
pieces	10	42	1727	3	piec_es
piles	7	47	4261	3	pil__es
pilules	9	5	1062	3	pilules
pinched	15	38	1245	3	pinched
pincher	14	38	1271	3	pincher
pinchers	15	35	1061	3	pinchers
pishes	11	47	2210	3	pi_shes
pitched	15	35	1292	3	pitched
pitcher	14	38	1371	3	pitcher
pitchers	15	32	1148	3	pitchers
poaches	14	44	1694	3	poaches
pooches	14	32	1416	3	pooches
porches	14	38	1567	3	porches
pouches	14	41	1674	3	pouches
psyches	17	5	580	3	psyches
punches	14	48	1613	3	punches
quiches	21	3	933	3	quiches
quitches	22	3	619	3	quitches
ranches	12	36	2011	3	ranches
ratches	12	36	2046	3	ratches
reaches	12	34	2320	3	reaches
retches	12	33	1851	3	retches
rices	7	55	3615	3	ri_c_es
richen	11	38	1251	3	ri_chen
richens	12	34	973	3	ri_chens
richer	11	40	1504	3	ri_cher
richest	12	28	1368	3	ri_chest
riles	5	53	4364	3	ril__es
rilles	6	47	2550	3	ril_les
roaches	12	36	1621	3	roaches
rotches	12	35	1570	3	rotches
rouches	12	42	1789	3	rouches
ruches	11	48	1958	3	_ruches
sculches	15	17	627	3	sculches
seiches	12	5	1381	3	seiches
sices	7	56	3727	3	si_c_es
silages	8	25	1444	3	silages
silanes	7	25	1716	3	silanes
silexes	14	3	865	3	silexes
silicles	10	3	707	3	silicles
silkies	11	37	1569	3	silkies
sillies	7	34	2508	3	sillies
slices	8	40	2285	3	slic_es
smirches	15	3	599	3	smirches
snitches	13	14	898	3	snitches
stitches	13	14	1059	3	stitches
switches	16	15	913	3	switches
taches	11	42	2417	3	_taches
teaches	12	27	1835	3	teaches
tenches	12	35	1552	3	tenches
tildes	7	45	1396	3	til_des
tiles	5	55	4210	3	til__es
tilths	9	45	937	3	tilth_s
tithes	9	47	2021	3	ti_thes
torches	12	37	1543	3	torches
touches	12	51	1834	3	touches
troches	12	37	1534	3	troches
tusches	12	3	790	3	tusches
twitches	16	15	637	3	twitches
vetches	15	34	1126	3	vetches
vices	10	57	2553	3	vi_c_es
vichies	15	3	1062	3	vi_chies
vouches	15	39	1411	3	vouches
watches	15	30	1737	3	watches
welched	16	29	883	3	welched
welcher	15	31	939	3	welcher
welchers	16	33	805	3	welchers
welshes	13	37	909	3	welshes
wenches	15	29	1413	3	wenches
wiles	8	54	3787	3	wil__es
willies	10	39	2015	3	willies
winces	11	48	1911	3	winc_es
winched	16	31	1059	3	winched
wincher	15	34	1065	3	wincher
winchers	16	31	922	3	winchers
wishes	12	49	2095	3	wi_shes
witched	16	30	1219	3	witched
withes	12	46	2084	3	wi_thes
wyches	17	38	791	3	_wyches
zillahs	19	3	538	3	zillahs
zills	14	40	2078	3	zil__ls
zincates	19	3	774	3	zincates
zinced	18	41	941	3	zinc_ed
zincites	19	4	663	3	zincites
zincked	23	3	423	3	zincked
zincous	18	3	705	3	zincous
zincs	16	53	1293	3	zinc__s
zines	14	52	3265	3	zi__nes
zircons	18	5	496	3	zircons
zither	18	38	1308	3	zi_ther
zithers	19	39	1197	3	zi_thers
zizzles	14	30	709	3	zizzles

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	134027	0.453	394461.4
2	DLD Change Limit	134027	295	6.640	20184.8
3	Display Results	295	295	0.110	2681.8
	(SQL Overall)	178691	295	7.203	24807.9