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

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

328 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
blotch	13	19	714	(None)
blotchy	17	29	397	1	blotchy
botch	12	67	1745	1	b_otch
batch	12	46	2010	2	b_atch
biotech	14	10	449	2	biotech
bitch	12	50	1776	2	b_itch
blanch	13	34	1085	2	blanch
bleach	13	36	1140	2	bleach
blench	13	37	1045	2	blench
bloc	8	50	2327	2	blo_c_
block	13	49	1784	2	blo_ck
blocs	9	52	1965	2	blo_cs
blot	6	58	4232	2	blot__
blotched	16	3	565	2	blotched
blotches	15	3	743	2	blotches
blots	7	56	2617	2	blot_s
blotto	8	19	844	2	blotto
blotty	11	17	834	2	blotty
booth	10	55	2201	2	boot_h
botchy	16	53	782	2	b_otchy
both	9	65	3343	2	b_ot_h
broach	13	36	1111	2	broach
brooch	13	36	844	2	brooch
broth	10	65	2109	2	brot_h
butch	12	54	1654	2	b_utch
cloth	10	58	1754	2	clot_h
clutch	13	36	775	2	clutch
crotch	13	34	1008	2	crotch
fletch	14	38	819	2	fletch
flitch	14	92	817	2	flitch
glitch	12	28	635	2	glitch
hootch	14	38	640	2	hootch
hotch	13	62	1472	2	_hotch
klatch	15	44	593	2	klatch
latch	10	46	2046	2	_latch
letch	10	52	1580	2	_letch
loach	10	51	1636	2	_loach
loch	9	55	2713	2	_lo_ch
lotah	8	53	1585	2	_lotah
loth	7	61	3213	2	_lot_h
notch	10	56	1332	2	_notch
rotch	10	58	1593	2	_rotch
scotch	13	20	751	2	scotch
slatch	11	45	1053	2	slatch
sloth	8	50	1944	2	slot_h
slouch	11	43	852	2	slouch
splotch	14	4	284	2	splotch
zlotych	24	4	141	2	zlotych
abbotcy	16	4	209	3	abbotcy
abroach	14	4	621	3	abroach
aitch	10	52	1616	3	_aitch
avouch	14	3	483	3	avouch
azoth	17	38	990	3	azot_h
bach	11	61	3139	3	b__ach
baith	10	80	2313	3	bait_h
bath	9	59	4008	3	b_at_h
beach	12	46	2389	3	b_each
beech	12	43	1550	3	b_eech
belch	12	44	1550	3	b_elch
bench	12	56	1950	3	b_ench
berth	10	49	1788	3	bert_h
beth	9	66	2923	3	b_et_h
bewitch	17	4	332	3	bewitch
biota	7	45	1682	3	biot_a
biotas	8	43	1392	3	biotas
biotechs	15	12	385	3	biotechs
biotic	10	38	1660	3	biotic
biotics	11	38	1217	3	biotics
biotin	8	32	1582	3	biotin
birch	12	49	1402	3	b_irch
birrotch	15	4	239	3	birrotch
birth	10	56	1987	3	birt_h
bitchy	16	47	920	3	b_itchy
black	13	47	1907	3	bl_ack
blah	9	86	2506	3	bl__ah
blat	6	65	5095	3	blat__
blate	7	59	3378	3	blat_e
blats	7	51	3250	3	blat_s
blet	6	62	4767	3	blet__
blets	7	53	2494	3	blet_s
blite	7	62	2535	3	blit_e
blites	8	47	2121	3	blites
blithe	11	58	1086	3	blithe
blitz	16	53	1813	3	blit_z
bloat	7	52	2992	3	blo_at
bloated	10	45	1343	3	bloated
bloater	9	40	1342	3	bloater
bloats	8	52	1576	3	bloats
blob	8	60	2709	3	blo__b
blobs	9	56	2003	3	blo_bs
blocks	14	45	1394	3	blocks
blocky	17	38	835	3	blocky
blog	7	57	2382	3	blo__g
blogs	8	53	1923	3	blo_gs
bloke	11	43	1663	3	blo_ke
blokes	12	38	1388	3	blokes
blond	8	56	1837	3	blo_nd
blonde	9	48	1329	3	blonde
blonds	9	52	1334	3	blonds
blood	8	53	1952	3	blo_od
bloods	9	46	1484	3	bloods
bloody	12	47	1017	3	bloody
blooey	11	51	1079	3	blooey
blooie	8	39	1319	3	blooie
bloom	9	59	1897	3	blo_om
blooms	10	46	1317	3	blooms
bloomy	13	45	1011	3	bloomy
bloop	9	61	1615	3	blo_op
bloops	10	66	1134	3	bloops
blotchier	16	4	321	3	blotch~~ier~~
blotchily	19	4	268	3	blotch~~ily~~
blotching	17	3	496	3	blotch~~ing~~
blotted	10	39	1183	3	blotted
blotter	9	46	1285	3	blotter
blouse	8	47	1472	3	blouse
blousy	11	45	912	3	blousy
blow	9	58	2719	3	blo__w
blowby	16	46	751	3	blowby
blowed	12	50	1669	3	blowed
blower	11	53	1657	3	blower
blown	10	57	1667	3	blo_wn
blows	10	54	2383	3	blo_ws
blowsy	14	57	945	3	blowsy
blowtorch	19	5	132	3	blowtorch
blowup	13	3	506	3	blowup
blowy	13	43	1532	3	blo_wy
blowzy	23	51	667	3	blowzy
bluish	11	5	924	3	bluish
blush	10	51	1531	3	bl_ush
bocce	11	43	1311	3	b_occe
bocci	11	35	1271	3	b_occi
boche	12	42	1695	3	b_o_che
bock	12	60	3251	3	b_o_ck
bolt	6	62	5417	3	bolt__
bolted	9	46	1780	3	bolted
bolter	8	39	2075	3	bolter
bolts	7	62	3211	3	bolt_s
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
bosh	9	63	2897	3	b_o_sh
bot	5	96	8040	3	b_ot__
bota	6	62	3650	3	b_ot_a
botas	7	53	2878	3	b_otas
botched	15	36	1190	3	b_otched
botcher	14	36	1322	3	b_otcher
botches	14	37	1602	3	b_otches
botel	7	51	2186	3	b_otel
bothy	13	67	1396	3	b_othy
bots	6	64	5395	3	b_ot_s
bott	6	65	4857	3	b_ot_t
botts	7	52	2486	3	b_otts
bough	11	57	1931	3	b_ough
brach	12	61	2330	3	b_rach
branch	13	40	1477	3	branch
breach	13	42	1372	3	breach
breech	13	34	826	3	breech
brith	10	49	2437	3	brit_h
broche	13	36	1210	3	bro_che
brock	13	60	1707	3	bro_ck
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
broths	11	50	1392	3	broths
brothy	14	51	962	3	brothy
brunch	13	32	935	3	brunch
bunch	12	51	1860	3	b_unch
bycatch	19	4	206	3	bycatch
catch	12	51	2037	3	_catch
clach	12	46	1782	3	cl_ach
clench	13	39	1005	3	clench
clinch	13	39	1035	3	clinch
cloaca	10	3	726	3	cloaca
cloche	13	43	1237	3	clo_che
clock	13	49	1798	3	clo_ck
clot	6	65	4242	3	clot__
clothe	11	47	1299	3	clothe
cloths	11	55	1248	3	cloths
clots	7	56	2764	3	clot_s
clotty	11	20	826	3	clotty
clough	12	53	913	3	clough
clutchy	17	32	389	3	clutchy
coach	12	59	1945	3	_coach
conch	12	46	2007	3	_conch
cooch	12	49	1683	3	_cooch
couch	12	53	2011	3	_couch
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
ditch	11	50	1509	3	_ditch
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
fleech	14	36	734	3	fleech
flench	14	40	1081	3	flench
flinch	14	40	1010	3	flinch
floc	9	59	2212	3	flo_c_
flocci	13	3	502	3	flocci
flock	14	47	1742	3	flo_ck
flocs	10	55	1923	3	flo_cs
flota	8	53	1564	3	flot_a
flotas	9	40	1300	3	flotas
flysch	17	3	289	3	flysch
froth	11	59	1928	3	frot_h
glitchy	16	28	308	3	glitchy
glunch	12	5	535	3	glunch
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
hatch	13	57	1959	3	_hatch
hitch	13	45	1547	3	_hitch
hooch	13	58	1370	3	_hooch
hutch	13	54	1409	3	_hutch
isotach	12	4	495	3	isotach
itch	9	56	1917	3	__itch
ketch	14	49	1202	3	_ketch
klatsch	16	5	168	3	klatsch
kvetch	18	3	299	3	kvetch
laich	10	59	2071	3	_laich
larch	10	59	1979	3	_larch
lath	7	66	4038	3	_lat_h
leach	10	54	2252	3	_leach
lech	9	68	2544	3	_l_ech
leech	10	49	1321	3	_leech
lich	9	62	3084	3	_l_ich
litchi	11	3	789	3	_litchi
loath	8	49	1860	3	_loath
loca	6	55	2768	3	_lo_ca
lochs	10	67	1551	3	_lo_chs
loci	6	61	2628	3	_lo_ci
lock	10	61	3436	3	_lo_ck
loco	6	70	3074	3	_lo_co
lot	3	81	7926	3	_lot__
lota	4	72	3350	3	_lot_a
lotahs	9	47	987	3	_lotahs
lotas	5	59	2630	3	_lotas
loti	4	64	3183	3	_lot_i
lotic	7	64	2066	3	_lotic
lotos	5	47	2463	3	_lotos
lots	4	76	5209	3	_lot_s
lotte	5	49	2385	3	_lotte
lotto	5	52	1757	3	_lotto
lotus	5	57	1806	3	_lotus
louche	11	52	1266	3	_louche
lough	9	51	1848	3	_lough
lunch	10	49	1724	3	_lunch
lurch	10	48	1463	3	_lurch
lych	12	60	1576	3	_l_ych
lynch	13	46	898	3	_lynch
match	12	56	2110	3	_match
moloch	13	5	648	3	moloch
mooch	12	53	1361	3	_mooch
moth	9	67	3133	3	_mot_h
mouch	12	47	1580	3	_mouch
mutch	12	50	1617	3	_mutch
natch	10	50	1822	3	_natch
nautch	11	4	481	3	nautch
ouch	9	57	2463	3	__ouch
patch	12	52	2122	3	_patch
pitch	12	50	1841	3	_pitch
planch	13	37	1144	3	planch
pleach	13	42	1124	3	pleach
plench	13	40	1081	3	plench
plot	6	61	4123	3	plot__
plots	7	50	2567	3	plot_s
plotty	11	20	885	3	plotty
plotz	16	46	1699	3	plot_z
plough	12	57	756	3	plough
poach	12	49	1786	3	_poach
pooch	12	48	1530	3	_pooch
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
rotche	11	43	1198	3	_rotche
scooch	13	22	812	3	scooch
scootch	14	3	445	3	scootch
scorch	13	19	809	3	scorch
scutch	13	24	708	3	scutch
sketch	15	3	535	3	sketch
slosh	8	45	1448	3	slo_sh
slot	4	60	4982	3	slot__
sloths	9	49	1188	3	sloths
slots	5	48	3052	3	slot_s
slouchy	15	45	484	3	slouchy
slough	10	53	923	3	slough
smooch	13	26	680	3	smooch
smutch	13	20	584	3	smutch
snatch	11	43	1060	3	snatch
snitch	11	35	794	3	snitch
sooth	8	59	2405	3	soot_h
soth	7	59	3251	3	_sot_h
splotchy	18	4	178	3	splotchy
stitch	11	41	910	3	stitch
swatch	14	54	928	3	swatch
switch	14	45	891	3	switch
thatch	14	3	560	3	thatch
tooth	8	80	2018	3	toot_h
torch	10	74	2093	3	_torch
touch	10	65	1939	3	_touch
troth	8	56	2220	3	trot_h
twitch	14	40	616	3	twitch
unlatch	12	4	505	3	unlatch
vetch	13	44	1184	3	_vetch
vouch	13	46	1190	3	_vouch
watch	13	56	1706	3	_watch
witch	13	45	1756	3	_witch
wretch	14	32	653	3	wretch
wroth	11	68	1588	3	wrot_h
zlote	14	39	1294	3	zlot_e
zloty	17	39	979	3	zlot_y
zlotys	18	37	417	3	zlotys

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	328	6.470	17421.3
3	Display Results	328	328	0.093	3526.9
	(SQL Overall)	178691	328	6.703	26658.4