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

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

286 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
hootch	14	38	640	(None)
hooch	13	58	1370	1	hoo_ch
hotch	13	62	1472	1	h_otch
blotch	13	19	714	2	blotch
booth	10	55	2201	2	boot_h
botch	12	67	1745	2	_botch
cooch	12	49	1683	2	coo_ch
crotch	13	34	1008	2	crotch
hatch	13	57	1959	2	h_atch
hitch	13	45	1547	2	h_itch
hookah	16	48	824	2	hookah
hoorah	12	44	1111	2	hoorah
hoot	7	57	5209	2	hoot__
hootches	16	5	697	2	hootches
hooted	10	44	2265	2	hooted
hooter	9	41	2392	2	hooter
hoots	8	48	3024	2	hoot_s
hooty	11	50	2243	2	hoot_y
hutch	13	54	1409	2	h_utch
mooch	12	53	1361	2	moo_ch
notch	10	56	1332	2	_notch
pooch	12	48	1530	2	poo_ch
rotch	10	58	1593	2	_rotch
scootch	14	3	445	2	scootch
scotch	13	20	751	2	scotch
sooth	8	59	2405	2	soot_h
tooth	8	80	2018	2	toot_h
aitch	10	52	1616	3	_aitch
avouch	14	3	483	3	avouch
azoth	17	38	990	3	azot_h
batch	12	46	2010	3	_batch
bhoot	10	43	2209	3	bhoot__
bhoots	11	45	990	3	bhoot_s
biotech	14	10	449	3	biotech
bitch	12	50	1776	3	_bitch
blotchy	17	29	397	3	blotchy
boot	6	77	5937	3	boot__
booted	9	48	2273	3	booted
bootee	8	43	2302	3	bootee
booths	11	53	1379	3	booths
bootie	8	54	2115	3	bootie
boots	7	58	3797	3	boot_s
booty	10	61	2591	3	boot_y
borsch	13	3	613	3	borsch
botchy	16	53	782	3	_botchy
both	9	65	3343	3	_bot_h
broach	13	36	1111	3	broach
brooch	13	36	844	3	brooch
broth	10	65	2109	3	brot_h
butch	12	54	1654	3	_butch
catch	12	51	2037	3	_catch
cloth	10	58	1754	3	clot_h
clutch	13	36	775	3	clutch
coach	12	59	1945	3	_coach
conch	12	46	2007	3	_conch
coolth	11	3	951	3	coolth
coot	6	78	6038	3	coot__
cooter	8	51	2861	3	cooter
cootie	8	42	2307	3	cootie
coots	7	56	3684	3	coot_s
couch	12	53	2011	3	_couch
couth	10	61	2248	3	cout_h
cratch	13	41	1079	3	cratch
crouch	13	39	1020	3	crouch
crutch	13	40	824	3	crutch
cultch	13	38	595	3	cultch
cutch	12	51	1619	3	_cutch
dhooti	10	3	564	3	dhoot_i
dhootie	11	3	645	3	dhootie
dhootis	11	3	566	3	dhootis
ditch	11	50	1509	3	_ditch
doeth	9	4	1198	3	doet_h
doth	8	62	2571	3	_dot_h
dutch	11	47	1382	3	_dutch
epoch	12	4	820	3	epo_ch
etch	9	54	1914	3	__etch
fetch	13	49	1347	3	_fetch
fitch	13	48	1687	3	_fitch
fletch	14	38	819	3	fletch
flitch	14	92	817	3	flitch
foot	7	62	4801	3	foot__
footed	10	44	1862	3	footed
footer	9	43	2076	3	footer
footie	9	47	1813	3	footie
footle	9	39	1438	3	footle
foots	8	55	2828	3	foot_s
footsy	12	58	793	3	footsy
footy	11	58	2053	3	foot_y
forth	11	62	2267	3	fort_h
froth	11	59	1928	3	frot_h
glitch	12	28	635	3	glitch
gotcha	12	3	463	3	_gotcha
goth	8	68	2508	3	_got_h
grouch	12	31	847	3	grouch
grutch	12	28	556	3	grutch
hath	10	59	3391	3	h_at_h
haunch	14	37	734	3	haunch
heath	11	57	2428	3	heat_h
heth	10	70	2802	3	h_et_h
heuch	13	53	1233	3	h_euch
hock	13	60	3130	3	h_o_ck
hogtie	10	27	1176	3	hogtie
hoick	14	52	1068	3	h_oick
holt	7	78	5258	3	holt__
holts	8	56	2791	3	holt_s
honcho	14	38	938	3	h_oncho
hooches	15	38	1252	3	hoo_ches
hoochie	15	3	778	3	hoo_chie
hood	8	51	3233	3	hoo__d
hooded	11	46	1674	3	hooded
hoodie	10	51	1613	3	hoodie
hoodoo	10	10	998	3	hoodoo
hoods	9	51	2408	3	hoo_ds
hoody	12	49	1972	3	hoo_dy
hooey	11	49	2660	3	hoo_ey
hooeys	12	55	1231	3	hooeys
hoof	10	60	3658	3	hoo__f
hoofed	13	46	1489	3	hoofed
hoofer	12	40	1495	3	hoofer
hoofs	11	57	2104	3	hoo_fs
hook	11	61	3328	3	hoo__k
hooka	12	55	1390	3	hoo_ka
hookahs	17	44	665	3	hookahs
hookas	13	53	1249	3	hookas
hooked	14	53	2055	3	hooked
hooker	13	48	2017	3	hooker
hookey	16	47	1393	3	hookey
hooks	12	50	2712	3	hoo_ks
hookup	15	3	442	3	hookup
hooky	15	52	2026	3	hoo_ky
hoolie	9	32	1777	3	hoolie
hooly	11	50	2222	3	hoo_ly
hoop	9	61	2998	3	hoo__p
hooped	12	55	1818	3	hooped
hooper	11	45	1831	3	hooper
hoopla	11	4	763	3	hoopla
hoopoe	11	9	1123	3	hoopoe
hoopoo	11	9	875	3	hoopoo
hoops	10	56	2107	3	hoo_ps
hoorahs	13	39	960	3	hoorahs
hooray	12	30	1137	3	hooray
hooters	10	45	2046	3	hooters
hootier	10	49	1534	3	hootier
hooting	11	39	1987	3	hooting
hooved	13	47	1312	3	hooved
hoover	12	43	1443	3	hoover
hooves	12	48	1548	3	hooves
hopscotch	21	5	149	3	ho~~psc~~otch
horah	11	79	2204	3	h_orah
host	7	78	5283	3	host__
hosta	8	59	1783	3	host_a
hostas	9	45	1582	3	hostas
hosted	10	50	2034	3	hosted
hostel	9	39	1415	3	hostel
hostly	12	42	1086	3	hostly
hosts	8	55	2670	3	host_s
hot	6	77	7605	3	h_ot__
hotched	16	36	1092	3	h_otched
hotches	15	38	1436	3	h_otches
hotel	8	55	2074	3	h_otel
hotly	11	58	1547	3	h_otly
hots	7	83	4932	3	h_ot_s
hotted	10	43	1993	3	hotted
hotter	9	47	2007	3	hotter
hottie	9	25	1436	3	hottie
hottish	13	11	789	3	hottish
houdah	13	3	517	3	houdah
howdah	16	3	472	3	howdah
hunch	13	64	1621	3	h_unch
isotach	12	4	495	3	isotach
itch	9	56	1917	3	__itch
ketch	14	49	1202	3	_ketch
klatch	15	44	593	3	klatch
kvetch	18	3	299	3	kvetch
latch	10	46	2046	3	_latch
letch	10	52	1580	3	_letch
loach	10	51	1636	3	_loach
loath	8	49	1860	3	loat_h
loch	9	55	2713	3	_lo_ch
loofah	12	37	581	3	loofah
loot	4	69	5582	3	loot__
looted	7	44	2111	3	looted
looter	6	42	2232	3	looter
loots	5	54	3142	3	loot_s
lotah	8	53	1585	3	_lotah
loth	7	61	3213	3	_lot_h
match	12	56	2110	3	_match
moloch	13	5	648	3	moloch
month	10	48	1842	3	mont_h
moolah	11	40	919	3	moolah
moot	6	76	5362	3	moot__
mooted	9	41	2037	3	mooted
mooter	8	39	2109	3	mooter
moots	7	58	3166	3	moot_s
moth	9	67	3133	3	_mot_h
mouch	12	47	1580	3	_mouch
mouth	10	54	2029	3	mout_h
mutch	12	50	1617	3	_mutch
natch	10	50	1822	3	_natch
nautch	11	4	481	3	nautch
north	8	60	1827	3	nort_h
oath	7	61	3215	3	_oat_h
ooh	6	76	3709	3	_oo__h
oomph	12	3	697	3	_oomph
oot	3	112	7469	3	_oot__
ootid	6	14	1669	3	_ootid
oots	4	64	4644	3	_oot_s
orach	10	52	1923	3	_orach
ouch	9	57	2463	3	__ouch
patch	12	52	2122	3	_patch
pitch	12	50	1841	3	_pitch
poach	12	49	1786	3	_poach
pooftah	15	4	314	3	pooftah
pooh	9	60	2738	3	poo__h
porch	12	59	1862	3	_porch
pouch	12	46	1708	3	_pouch
quitch	20	3	641	3	quitch
quoth	17	33	1035	3	quot_h
ratch	10	42	2136	3	_ratch
retch	10	48	1830	3	_retch
roach	10	57	1700	3	_roach
root	4	56	5592	3	root__
rootcap	11	4	397	3	rootcap
rooted	7	54	2400	3	rooted
rooter	6	49	2603	3	rooter
rootle	6	32	1445	3	rootle
roots	5	59	3367	3	root_s
rooty	8	64	2302	3	root_y
rotche	11	43	1198	3	_rotche
routh	8	64	2307	3	rout_h
rowth	11	57	1323	3	rowt_h
scooch	13	22	812	3	scooch
scorch	13	19	809	3	scorch
scrootch	15	4	281	3	scrootch
scutch	13	24	708	3	scutch
shoot	8	42	3589	3	shoot__
shooter	10	30	1397	3	shooter
shoots	9	46	1934	3	shoot_s
sketch	15	3	535	3	sketch
slatch	11	45	1053	3	slatch
sloth	8	50	1944	3	slot_h
slouch	11	43	852	3	slouch
smooch	13	26	680	3	smooch
smooth	11	25	919	3	smoot_h
smutch	13	20	584	3	smutch
snatch	11	43	1060	3	snatch
snitch	11	35	794	3	snitch
soot	4	57	6105	3	soot__
sooted	7	39	2258	3	sooted
soothe	9	42	1484	3	soothe
sooths	9	57	1558	3	sooths
soots	5	55	3620	3	soot_s
sooty	8	49	2483	3	soot_y
soth	7	59	3251	3	_sot_h
south	8	52	2357	3	sout_h
splotch	14	4	284	3	splotch
stitch	11	41	910	3	stitch
swatch	14	54	928	3	swatch
switch	14	45	891	3	switch
thatch	14	3	560	3	thatch
toot	4	59	5888	3	toot__
tooted	7	46	2012	3	tooted
tooter	6	44	2080	3	tooter
tooths	9	60	1380	3	tooths
toothy	12	52	969	3	toothy
tootle	6	26	1381	3	tootle
toots	5	53	3187	3	toot_s
tootsy	9	43	798	3	tootsy
topnotch	15	4	233	3	topnotch
torch	10	74	2093	3	_torch
toroth	9	55	1296	3	torot_h
touch	10	65	1939	3	_touch
troth	8	56	2220	3	trot_h
twitch	14	40	616	3	twitch
vetch	13	44	1184	3	_vetch
vouch	13	46	1190	3	_vouch
watch	13	56	1706	3	_watch
whoosh	15	24	435	3	whoo_sh
witch	13	45	1756	3	_witch
woosh	11	37	1073	3	woo_sh
worth	11	71	2052	3	wort_h
wretch	14	32	653	3	wretch
wroth	11	68	1588	3	wrot_h
youth	11	53	1504	3	yout_h
zlotych	24	4	141	3	zlotych
zooty	17	54	1535	3	zoot_y

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.140	1276364.3
2	DLD Change Limit	112716	286	6.563	17174.5
3	Display Results	286	286	0.076	3763.2
	(SQL Overall)	178691	286	6.779	26359.5