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

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

60 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
buckler	15	41	1203	(None)
bucker	14	54	2046	1	buck_er
buckle	14	48	1519	1	buckle_
buckled	16	44	1188	1	buckled
bucklers	16	34	950	1	bucklers
buckles	15	34	1609	1	buckles
suckler	13	34	1309	1	suckler
backer	14	45	2552	2	back_er
bicker	14	48	1917	2	bick_er
bubbler	10	36	1178	2	bubbler
bucked	15	51	2106	2	buck_ed
buckeen	15	3	670	2	buckeen
buckers	15	35	1745	2	buck_ers
bucket	14	46	2073	2	buck_et
bucklered	18	4	454	2	bucklered
buckoes	15	38	1039	2	buckoes
bugler	9	47	1772	2	bu_gler
bulkier	13	41	1151	2	bulkier
bumbler	13	40	1323	2	bumbler
bundler	10	40	1172	2	bundler
bungler	10	46	1148	2	bungler
bunker	12	45	1937	2	bunk_er
burbler	11	44	1242	2	burbler
burker	12	52	2117	2	burk_er
burler	8	47	2383	2	bu_rler
busker	12	55	1783	2	busk_er
bustler	9	40	1257	2	bustler
butler	8	42	2003	2	bu_tler
cackler	15	38	1257	2	cackler
chuckler	19	3	555	2	chuckler
ducker	13	43	1799	2	duck_er
duckier	14	39	1179	2	duckier
fickler	16	34	842	2	fickler
fucker	15	34	1442	2	fuck_er
hackler	16	35	1235	2	hackler
heckler	16	27	857	2	heckler
huckle	15	39	1307	2	huckle_
huckles	16	36	1262	2	huckles
knuckler	13	8	362	2	knuckler
luckier	13	38	1153	2	luckier
mickler	15	33	1023	2	mickler
mucker	14	38	1639	2	muck_er
muckier	15	34	1148	2	muckier
muckle	14	34	1358	2	muckle_
muckles	15	34	1325	2	muckles
pucker	14	38	1763	2	puck_er
ruckle	12	44	1458	2	ruckle_
ruckled	14	41	1103	2	ruckled
ruckles	13	34	1460	2	ruckles
sucker	12	41	2066	2	suck_er
suckier	13	36	1397	2	suckier
suckle	12	40	1596	2	suckle_
suckled	14	42	1251	2	suckled
sucklers	14	37	996	2	sucklers
suckles	13	45	1674	2	suckles
tackler	13	40	1332	2	tackler
tickler	13	36	1265	2	tickler
truckler	14	29	745	2	truckler
tucker	12	43	1695	2	tuck_er
yuckier	16	35	853	2	yuckier

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.360	496363.9
2	DLD Change Limit	107671	60	2.983	36094.9
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	3.376	52929.8