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

Here are the results of your fuzzy-string dictionary search for “buckets” 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
buckets	15	38	1169	(None)
beckets	15	39	982	1	beckets
buckers	15	35	1745	1	buckers
bucket	14	46	2073	1	bucket_
tuckets	13	48	1033	1	tuckets
backers	15	38	2188	2	backers
backsets	16	3	885	2	backsets
baskets	13	51	1183	2	baskets
becket	14	46	1988	2	becket_
bickers	15	43	1655	2	bickers
boskets	13	40	947	2	boskets
brackets	16	33	1043	2	brackets
brockets	16	32	812	2	brockets
bubkes	14	46	1262	2	bubke_s
bucked	15	51	2106	2	bucke_d
buckeen	15	3	670	2	buckeen
buckeens	16	3	485	2	buckeens
bucker	14	54	2046	2	bucke_r
bucketed	17	3	676	2	bucketed
buckeye	18	3	568	2	buckeye
buckeyes	19	4	526	2	buckeyes
bucklers	16	34	950	2	bucklers
buckles	15	34	1609	2	buckles
buckoes	15	38	1039	2	buckoes
buckos	14	37	1089	2	buck_os
buckras	15	3	734	2	buckras
bucks	13	48	2429	2	buck__s
budgets	11	48	986	2	budgets
buffets	15	31	759	2	buffets
bullets	9	35	1639	2	bullets
bunkers	13	37	1595	2	bunkers
bupkes	14	48	1148	2	bupke_s
burets	8	43	2126	2	bu_rets
burkers	13	37	1662	2	burkers
burkes	12	44	2131	2	burke_s
burnets	9	38	1326	2	burnets
buskers	13	34	1409	2	buskers
dockets	14	44	1224	2	dockets
duckers	14	32	1471	2	duckers
fuckers	16	36	1159	2	fuckers
jackets	20	50	1137	2	jackets
junkets	18	37	762	2	junkets
lockets	13	46	1220	2	lockets
muckers	15	36	1280	2	muckers
muskets	13	25	864	2	muskets
packets	15	51	1477	2	packets
pickets	15	43	1418	2	pickets
pockets	15	46	1225	2	pockets
puckers	15	35	1467	2	puckers
rackets	13	49	1687	2	rackets
rickets	13	49	1509	2	rickets
rockets	13	46	1536	2	rockets
sockets	13	40	1298	2	sockets
suckers	13	37	1762	2	suckers
sunkets	11	35	1128	2	sunkets
tackets	13	49	1436	2	tackets
tickets	13	41	1368	2	tickets
tuckers	13	40	1435	2	tuckers
tucket	12	42	1948	2	tucket_
wickets	16	40	1094	2	wickets

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.373	479064.3
2	DLD Change Limit	107671	60	3.376	31893.1
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	3.762	47498.9