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

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

65 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
bottler	9	42	1188	(None)
battler	9	41	1338	1	battler
bottle	8	49	1607	1	bottle_
bottled	10	46	1123	1	bottled
bottlers	10	38	1001	1	bottlers
bottles	9	42	1627	1	bottles
mottler	9	44	1034	1	mottler
batter	8	49	2887	2	batt_er
battier	9	35	1571	2	battier
battle	8	52	1786	2	battle_
battled	10	42	1312	2	battled
battlers	10	41	1097	2	battlers
battles	9	45	1768	2	battles
beetler	9	3	803	2	beetler
better	8	47	2370	2	bett_er
bitter	8	46	2267	2	bitt_er
bittier	9	42	1166	2	bittier
blotter	9	46	1285	2	blott_er
blottier	10	33	641	2	blottier
boater	8	46	2209	2	boat_er
boggler	11	39	1008	2	boggler
boiler	8	43	1927	2	bo_iler
bolter	8	39	2075	2	bolt_er
boodler	10	33	1200	2	boodler
bootleg	10	27	663	2	bootleg
botcher	14	36	1322	2	botcher
bother	11	52	1806	2	bo_ther
bottomer	12	4	510	2	bottomer
bowler	11	42	1731	2	bo_wler
brittler	10	16	598	2	brittler
bustler	9	40	1256	2	bustler
butler	8	42	2003	2	b_utler
butter	8	47	2423	2	butt_er
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
mottle	8	41	1605	2	mottle_
mottled	10	40	997	2	mottled
mottlers	10	38	818	2	mottlers
mottles	9	34	1580	2	mottles
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.123	1452772.4
2	DLD Change Limit	107671	65	3.033	35499.8
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	3.186	56086.3