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

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

79 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
middled	12	33	1189	(None)
diddled	11	42	1205	1	diddled
fiddled	13	32	963	1	fiddled
meddled	12	32	1002	1	meddled
middle	10	34	1498	1	middle_
middler	11	27	1227	1	middler
middles	11	34	1530	1	middles
muddled	12	41	1158	1	muddled
piddled	12	33	1125	1	piddled
riddled	10	30	1204	1	riddled
widdled	13	35	1123	1	widdled
addled	9	41	1251	2	_addled
coddled	12	34	1057	2	coddled
cuddled	12	41	1076	2	cuddled
daddled	11	38	1074	2	daddled
diddle	9	49	1521	2	diddle_
diddler	10	35	1151	2	diddler
diddles	10	39	1507	2	diddles
diddley	13	38	810	2	diddley
dindled	10	44	1272	2	dindled
fiddle	11	36	1338	2	fiddle_
fiddler	12	30	995	2	fiddler
fiddles	12	32	1260	2	fiddles
fuddled	13	30	939	2	fuddled
giddied	11	25	771	2	giddied
girdled	10	21	745	2	girdled
griddled	12	4	420	2	griddled
huddled	13	34	978	2	huddled
idled	7	49	1521	2	_i_dled
kidded	13	29	938	2	kidd_ed
kindled	13	34	1054	2	kindled
lidded	9	34	1024	2	lidd_ed
madded	11	35	1355	2	madd_ed
medaled	11	34	1160	2	medaled
meddle	10	33	1276	2	meddle_
meddler	11	31	995	2	meddler
meddles	11	32	1325	2	meddles
miauled	10	3	666	2	miauled
midden	10	41	1285	2	midd_en
middies	11	31	1615	2	middies
middlers	12	34	1019	2	middlers
midleg	10	3	855	2	mi_dleg
milded	10	44	1615	2	mild_ed
milled	9	43	2617	2	mi_lled
minded	10	38	1783	2	mind_ed
mingled	11	36	1273	2	mingled
misdeed	11	32	1105	2	misdeed
misled	9	47	1931	2	mi_sled
mispled	12	3	1046	2	mispled
mizzled	18	32	763	2	mizzled
modeled	11	3	945	2	modeled
mudded	11	45	1138	2	mudd_ed
muddied	12	33	921	2	muddied
muddle	10	34	1463	2	muddle_
muddler	11	34	1162	2	muddler
muddles	11	29	1435	2	muddles
noddled	10	35	856	2	noddled
paddled	12	36	1202	2	paddled
peddled	12	34	1053	2	peddled
piddle	10	35	1491	2	piddle_
piddler	11	29	1152	2	piddler
piddles	11	43	1427	2	piddles
puddled	12	30	1119	2	puddled
raddled	10	38	1222	2	raddled
reddled	10	29	1232	2	reddled
ridded	9	36	1512	2	ridd_ed
riddle	8	39	1571	2	riddle_
riddler	9	34	1126	2	riddler
riddles	9	32	1502	2	riddles
ruddled	10	30	1087	2	ruddled
saddled	10	31	1203	2	saddled
sidled	8	42	1517	2	si_dled
tiddler	9	31	1000	2	tiddler
toddled	10	32	882	2	toddled
twiddled	14	28	463	2	twiddled
waddled	13	36	1164	2	waddled
widdle	11	38	1484	2	widdle_
widdles	12	35	1434	2	widdles
windled	12	37	1348	2	windled

Search took 5 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	79	3.893	27657.6
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	4.063	43980.1