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

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

59 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
mottler	9	44	1034	(None)
bottler	9	42	1188	1	bottler
mottle	8	41	1605	1	mottle_
mottled	10	40	997	1	mottled
mottlers	10	38	818	1	mottlers
mottles	9	34	1580	1	mottles
battler	9	41	1338	2	battler
bottle	8	49	1607	2	bottle_
bottled	10	46	1123	2	bottled
bottlers	10	38	1001	2	bottlers
bottles	9	42	1627	2	bottles
cotter	8	49	2667	2	cott_er
cottier	9	38	1417	2	cottier
dotter	7	44	1934	2	dott_er
dottier	8	39	1092	2	dottier
dottle	7	42	1250	2	dottle_
dottles	8	39	1228	2	dottles
footler	10	40	1187	2	footler
guttler	8	36	916	2	guttler
hostler	10	34	1102	2	hostler
hotter	9	47	2008	2	hott_er
jostler	14	28	822	2	jostler
jotter	13	43	1563	2	jott_er
kittler	11	33	816	2	kittler
littler	7	34	855	2	littler
lotter	6	40	2560	2	lott_er
matter	8	43	2534	2	matt_er
mettle	8	38	1572	2	mettle_
mettled	10	35	1054	2	mettled
mettles	9	41	1502	2	mettles
modeler	10	3	929	2	modeler
moiler	8	40	1726	2	mo_iler
molter	8	41	1942	2	molt_er
mooter	8	39	2109	2	moot_er
mother	11	37	1864	2	mo_ther
mothier	12	19	1021	2	mothier
motile	8	38	1834	2	motile_
motiles	9	33	1743	2	motiles
motley	11	3	938	2	mo_tley
motlier	9	20	1058	2	motlier
motte	7	55	2697	2	mott_e_
mottes	8	55	2369	2	mott_es
mottoes	9	34	1219	2	mottoes
moulter	9	38	1242	2	moulter
mouther	12	38	1281	2	mouther
mutter	8	44	1888	2	mutt_er
nettler	7	34	950	2	nettler
ostler	6	33	1219	2	_ostler
otter	5	44	2397	2	_ott_er
potter	8	39	2698	2	pott_er
pottier	9	35	1649	2	pottier
pottle	8	44	1610	2	pottle_
pottles	9	38	1698	2	pottles
rattler	7	40	1274	2	rattler
rotter	6	43	2546	2	rott_er
settler	7	34	1065	2	settler
tattler	7	31	1221	2	tattler
tootler	7	35	1112	2	tootler
totter	6	50	2146	2	tott_er

Search took 4 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.406	440125.6
2	DLD Change Limit	107671	59	3.326	32372.5
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	3.762	47498.9