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

Here are the results of your fuzzy-string dictionary search for “blotches” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

39 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
blotches	15	3	743	(None)
blotched	16	3	565	1	blotched
botches	14	37	1602	1	b_otches
batches	14	40	1961	2	b_atches
bitches	14	41	1706	2	b_itches
blanches	15	33	1160	2	blanches
bleaches	15	34	1067	2	bleaches
blenches	15	33	1076	2	blenches
blotch	13	19	714	2	blotch__
blotchier	16	4	321	2	blotchier
blotchiest	17	4	352	2	blotchiest
blotchy	17	29	397	2	blotch_y
boches	13	46	1852	2	b_o_ches
botched	15	36	1190	2	b_otched
botcher	14	36	1322	2	b_otcher
botchers	15	35	1154	2	b_otchers
britches	15	27	868	2	britches
broaches	15	32	1162	2	broaches
brooches	15	28	819	2	brooches
butches	14	43	1536	2	b_utches
cloches	14	41	1371	2	clo_ches
clothes	12	45	1381	2	clot_hes
clutches	15	30	792	2	clutches
crotches	15	34	1130	2	crotches
fletches	16	30	885	2	fletches
flitches	16	38	846	2	flitches
glitches	14	29	665	2	glitches
hootches	16	5	697	2	hootches
hotches	15	38	1436	2	_hotches
klatches	17	15	713	2	klatches
latches	12	33	2012	2	_latches
letches	12	40	1548	2	_letches
loaches	12	36	1398	2	_loaches
notches	12	35	1365	2	_notches
rotches	12	35	1570	2	_rotches
scotches	15	17	947	2	scotches
slatches	13	15	1152	2	slatches
slouches	13	20	807	2	slouches
splotches	16	4	391	2	splotches

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	121059	0.280	638182.1
2	DLD Change Limit	121059	39	7.046	17181.2
3	Display Results	39	39	0.016	2437.5
	(SQL Overall)	178691	39	7.342	24338.2