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

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

217 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
blotched	16	3	565	(None)
blotches	15	3	743	1	blotches
botched	15	36	1190	1	b_otched
batched	15	41	1424	2	b_atched
bitched	15	32	1292	2	b_itched
blanched	16	30	860	2	blanched
bleached	16	37	856	2	bleached
blenched	16	35	805	2	blenched
blocked	16	44	998	2	blo_cked
blotch	13	19	714	2	blotch__
blotchier	16	4	321	2	blotchier
blotchy	17	29	397	2	blotch_y
blotted	10	39	1183	2	blot_ted
botcher	14	36	1322	2	b_otcher
botches	14	37	1602	2	b_otches
broached	16	30	912	2	broached
clothed	13	40	1028	2	clot_hed
clutched	16	35	603	2	clutched
crotched	16	42	859	2	crotched
fletched	17	30	669	2	fletched
flitched	17	25	629	2	flitched
hotched	16	36	1092	2	_hotched
latched	13	39	1406	2	_latched
letched	13	39	1205	2	_letched
notched	13	42	1030	2	_notched
scotched	16	18	793	2	scotched
slouched	14	20	674	2	slouched
splotched	17	4	282	2	splotched
avouched	17	4	358	3	avouched
bached	14	55	1989	3	b__ached
batcher	14	44	1485	3	b_atcher
batches	14	40	1961	3	b_atches
bathed	12	55	1874	3	b_at_hed
beached	15	45	1655	3	b_eached
beclothed	17	4	412	3	beclot_hed
belched	15	40	1184	3	b_elched
benched	15	47	1394	3	b_enched
berthed	13	25	912	3	bert_hed
bewitched	20	4	323	3	bewitched
birched	15	34	991	3	b_irched
birthed	13	22	859	3	birt_hed
bitchen	14	34	973	3	b_itchen
bitches	14	41	1706	3	b_itches
blacked	16	36	1337	3	bl_acked
blancher	15	33	863	3	blancher
blanches	15	33	1160	3	blanches
blather	12	53	1420	3	blat_her
blatted	10	48	1271	3	blat_ted
bleacher	15	35	888	3	bleacher
bleaches	15	34	1067	3	bleaches
blencher	15	30	839	3	blencher
blenches	15	33	1076	3	blenches
blether	12	45	991	3	blet_her
blithe	11	58	1086	3	blit_he_
blither	12	48	1217	3	blit_her
blitzed	19	33	653	3	blit_zed
bloated	10	45	1343	3	blo_ated
blobbed	11	36	656	3	blo_bbed
blocker	15	41	992	3	blo_cker
blockhead	21	5	273	3	blockhead
blooded	11	37	980	3	blo_oded
bloodied	12	4	597	3	bloodied
bloodred	12	3	408	3	bloodred
bloodshed	16	4	323	3	bloodshed
bloomed	12	43	943	3	blo_omed
blooped	12	39	854	3	blo_oped
blotchiest	17	4	352	3	blotchiest
blotchily	19	4	268	3	blotchily
blotching	17	3	496	3	blotching
blotter	9	46	1285	3	blot_ter
blottier	10	33	641	3	blottier
bloused	10	43	1064	3	blo_used
blowed	12	50	1669	3	blo__wed
blowsed	13	44	902	3	blo_wsed
blowtorched	22	5	90	3	blowtorched
blowzed	22	43	597	3	blo_wzed
blucher	14	33	1022	3	bl_ucher
blushed	13	44	1175	3	bl_ushed
boche	12	42	1695	3	b_o_che_
boches	13	46	1852	3	b_o_ches
bolted	9	46	1780	3	bolt__ed
bolthead	14	4	590	3	bolt_head
booted	9	48	2273	3	boot__ed
botch	12	67	1745	3	b_otch__
botchedly	20	4	259	3	b_otchedly
botchers	15	35	1154	3	b_otchers
botchery	18	36	676	3	b_otchery
botchier	15	28	714	3	b_otchier
botchy	16	53	782	3	b_otch_y
bother	11	52	1806	3	b_ot_her
bottled	10	46	1123	3	b_ottled
bouchee	14	33	1354	3	b_ouchee
boughed	14	38	1026	3	b_oughed
branched	16	32	1045	3	branched
breached	16	34	1164	3	breached
breeched	16	33	738	3	breeched
britches	15	27	868	3	britches
broacher	15	32	926	3	broacher
broaches	15	32	1162	3	broaches
broche	13	36	1210	3	bro_che_
brooches	15	28	819	3	brooches
brothel	12	31	819	3	brot_hel
brother	12	33	1133	3	brot_her
brunched	16	31	785	3	brunched
bunched	15	43	1241	3	b_unched
butcher	14	34	1116	3	b_utcher
butches	14	43	1536	3	b_utches
clenched	16	25	776	3	clenched
cliched	15	37	1102	3	cl_iched
clinched	16	34	738	3	clinched
cloche	13	43	1237	3	clo_che_
cloches	14	41	1371	3	clo_ches
clocked	16	41	1283	3	clo_cked
clothe	11	47	1299	3	clot_he_
clothes	12	45	1381	3	clot_hes
clotted	10	40	1182	3	clot_ted
clotured	11	24	616	3	clotured
clutches	15	30	792	3	clutches
coached	15	33	1384	3	_coached
couched	15	41	1579	3	_couched
crotches	15	34	1130	3	crotches
crotchet	15	27	1199	3	crotchet
crouched	16	35	914	3	crouched
crutched	16	30	746	3	crutched
ditched	14	37	1190	3	_ditched
douched	14	40	1211	3	_douched
etched	12	36	1370	3	__etched
fetched	16	37	1047	3	_fetched
fleeched	17	34	582	3	fleeched
flenched	17	26	796	3	flenched
fletcher	16	30	666	3	fletcher
fletches	16	30	885	3	fletches
flinched	17	31	670	3	flinched
flitches	16	38	846	3	flitches
flocced	15	36	548	3	flo_cced
flocked	17	45	1025	3	flo_cked
frothed	14	28	878	3	frot_hed
glitches	14	29	665	3	glitches
glochid	14	4	526	3	glo_chid
glunched	15	4	426	3	glunched
grouched	15	35	666	3	grouched
grutched	15	28	467	3	grutched
hatched	16	34	1446	3	_hatched
hitched	16	33	1225	3	_hitched
hootches	16	5	697	3	hootches
hotches	15	38	1436	3	_hotches
hutched	16	35	988	3	_hutched
itched	12	38	1202	3	__itched
klatches	17	15	713	3	klatches
kvetched	21	4	278	3	kvetched
latches	12	33	2012	3	_latches
latchet	12	31	1790	3	_latchet
lathed	10	47	1845	3	_lat_hed
leached	13	37	1504	3	_leached
leched	12	37	1600	3	_l_eched
leeched	13	36	950	3	_leeched
letches	12	40	1548	3	_letches
loaches	12	36	1398	3	_loaches
loathed	11	41	944	3	_loathed
locked	13	49	2166	3	_lo_cked
locoed	9	43	1219	3	_lo_coed
lotted	7	42	2240	3	_lot_ted
louche	11	52	1266	3	_louche_
lunched	13	39	1182	3	_lunched
lurched	13	35	803	3	_lurched
lynched	16	37	675	3	_lynched
matched	15	35	1396	3	_matched
mooched	15	39	1053	3	_mooched
mouched	15	36	1259	3	_mouched
notcher	12	36	1093	3	_notcher
notches	12	35	1365	3	_notches
ouched	12	43	1693	3	__ouched
patched	15	35	1462	3	_patched
pitched	15	35	1292	3	_pitched
pleached	16	33	806	3	pleached
plotted	10	46	1237	3	plot_ted
plotzed	19	37	622	3	plot_zed
ploughed	15	20	430	3	ploughed
poached	15	42	1240	3	_poached
pooched	15	28	1008	3	_pooched
pouched	15	36	1277	3	_pouched
retched	13	38	1427	3	_retched
roached	13	32	1183	3	_roached
rotche	11	43	1198	3	_rotche_
rotches	12	35	1570	3	_rotches
scooched	16	20	668	3	scooched
scootched	17	6	396	3	scootched
scorched	16	18	719	3	scorched
scotches	15	17	947	3	scotches
scutched	16	18	689	3	scutched
sketched	18	3	539	3	sketched
slatches	13	15	1152	3	slatches
sloshed	11	32	982	3	slo_shed
slotted	8	46	1388	3	slot_ted
sloucher	13	20	681	3	sloucher
slouches	13	20	807	3	slouches
sloughed	13	30	558	3	sloughed
smooched	16	18	598	3	smooched
smutched	16	16	592	3	smutched
snatched	14	15	763	3	snatched
snitched	14	16	686	3	snitched
soothed	11	37	1274	3	soot_hed
splotches	16	4	391	3	splotches
stitched	14	14	820	3	stitched
switched	17	15	713	3	switched
tetched	13	30	1077	3	_tetched
thatched	17	3	543	3	thatched
toothed	11	33	1024	3	toot_hed
torched	13	35	1135	3	_torched
touched	13	49	1496	3	_touched
trothed	11	40	1097	3	trot_hed
twitched	17	15	503	3	twitched
unlatched	15	4	421	3	unlatched
vouched	16	39	1056	3	_vouched
watched	16	30	1282	3	_watched
witched	16	30	1219	3	_witched
wretched	17	27	653	3	wretched

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	146162	0.173	1032896.0
2	DLD Change Limit	146162	217	7.216	20255.3
3	Display Results	217	217	0.080	2712.5
	(SQL Overall)	178691	217	7.469	23924.4