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

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

63 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
buckle	14	48	1519	(None)
buckled	16	44	1188	1	buckled
buckler	15	41	1203	1	buckler
buckles	15	34	1609	1	buckles
huckle	15	39	1307	1	huckle
muckle	14	34	1358	1	muckle
ruckle	12	44	1458	1	ruckle
suckle	12	40	1596	1	suckle
boucle	10	37	1278	2	bouc_le
brickle	15	27	993	2	brickle
bubale	10	40	1462	2	bubale
bubble	9	40	1659	2	bubble
buck	12	51	2990	2	buck__
bucked	15	51	2106	2	bucked
buckeen	15	3	670	2	buckeen
bucker	14	54	2046	2	bucker
bucket	14	46	2073	2	bucket
buckeye	18	3	568	2	buckeye
bucklers	16	34	950	2	bucklers
bucko	13	46	1402	2	buck_o
buckoes	15	38	1039	2	buckoes
buckos	14	37	1089	2	buckos
buckra	14	3	675	2	buckra
bucks	13	48	2429	2	buck_s
buddle	10	43	1308	2	buddle
bugle	8	47	2194	2	bu_gle
bumble	12	42	1689	2	bumble
bundle	9	43	1557	2	bundle
bungle	9	71	1611	2	bungle
burble	10	46	1770	2	burble
burgle	9	48	1586	2	burgle
burke	11	51	2276	2	burk_e
bustle	8	40	1548	2	bustle
butle	7	50	2310	2	bu_tle
cackle	14	34	1692	2	cackle
chuckle	18	3	644	2	chuckle
cockle	14	39	1357	2	cockle
deckle	13	120	1245	2	deckle
duckie	13	35	1166	2	duckie
fickle	15	39	1297	2	fickle
hackle	15	49	1681	2	hackle
heckle	15	31	1209	2	heckle
huckles	16	36	1262	2	huckles
keckle	11	35	942	2	keckle
knuckle	12	5	423	2	knuckle
luckie	12	36	1141	2	luckie
mackle	14	37	1643	2	mackle
mickle	14	37	1513	2	mickle
muckles	15	34	1325	2	muckles
nickle	12	38	1448	2	nickle
pickle	14	42	1565	2	pickle
rackle	12	39	1729	2	rackle
ruckled	14	41	1103	2	ruckled
ruckles	13	34	1460	2	ruckles
runkle	10	36	1154	2	runkle
sickle	12	44	1832	2	sickle
suckled	14	42	1251	2	suckled
suckler	13	34	1309	2	suckler
suckles	13	45	1674	2	suckles
tackle	12	38	1573	2	tackle
tickle	12	46	1674	2	tickle
truckle	13	35	886	2	truckle
unbuckle	16	4	386	2	unbuckle

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	82551	0.173	1032896.0
2	DLD Change Limit	82551	63	2.860	28864.0
3	Display Results	63	63	0.013	4846.2
	(SQL Overall)	178691	63	3.046	58664.1