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

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

91 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
duckers	14	32	1471	(None)
buckers	15	35	1745	1	buckers
dackers	14	34	1704	1	dackers
deckers	14	44	1383	1	deckers
dickers	14	41	1766	1	dickers
dockers	14	37	1500	1	dockers
ducker	13	43	1799	1	ducker_
duikers	12	36	938	1	duikers
dunkers	12	35	1219	1	dunkers
fuckers	16	36	1159	1	fuckers
muckers	15	36	1280	1	muckers
puckers	15	35	1467	1	puckers
suckers	13	37	1762	1	suckers
tuckers	13	40	1435	1	tuckers
backers	15	38	2188	2	backers
bickers	15	43	1655	2	bickers
bucker	14	54	2046	2	bucker_
buckets	15	38	1169	2	buckets
bucklers	16	34	950	2	bucklers
bunkers	13	37	1595	2	bunkers
burkers	13	37	1662	2	burkers
buskers	13	34	1409	2	buskers
cockers	15	36	1833	2	cockers
dacker	13	49	2075	2	dacker_
daikers	12	40	1031	2	daikers
deckels	14	36	736	2	deckels
decker	13	52	1599	2	decker_
dicers	9	47	2074	2	dic_ers
dickens	14	44	1013	2	dickens
dicker	13	45	2140	2	dicker_
dickeys	17	47	930	2	dickeys
dikers	11	44	1879	2	d_ikers
docker	13	44	1765	2	docker_
dockets	14	44	1224	2	dockets
dubbers	12	40	1182	2	dubbers
duces	8	63	2747	2	duc_e_s
duchess	13	3	555	2	duchess
ducked	14	47	1801	2	ducke_d
duckier	14	39	1179	2	duckier_
duckies	14	36	1381	2	duckies
ducks	12	48	2321	2	duck__s
duelers	8	34	1205	2	duelers
duffers	14	34	1009	2	duffers
duiker	11	41	1059	2	duiker_
dukes	10	50	2347	2	du_ke_s
dumpers	12	34	1266	2	dumpers
dunker	11	36	1646	2	dunker_
dupers	9	46	1560	2	du_pers
dusters	8	49	1836	2	dusters
fucker	15	34	1442	2	fucker_
funkers	14	37	1206	2	funkers
hackers	16	46	1904	2	hackers
hockers	16	39	1591	2	hockers
hunkers	14	33	1433	2	hunkers
huskers	14	35	1004	2	huskers
ickers	12	39	1418	2	_ickers
jackers	20	42	1445	2	jackers
junkers	18	40	1086	2	junkers
kickers	12	40	1329	2	kickers
lackers	13	41	2054	2	lackers
lickers	13	41	1825	2	lickers
lockers	13	35	1692	2	lockers
lunkers	11	34	1460	2	lunkers
lurkers	11	39	1008	2	lurkers
mockers	15	38	1294	2	mockers
mucker	14	38	1639	2	mucker_
neckers	13	42	1046	2	neckers
nickers	13	44	1509	2	nickers
ockers	12	38	1390	2	_ockers
packers	15	38	1889	2	packers
peckers	15	33	1267	2	peckers
pickers	15	37	1809	2	pickers
pluckers	16	31	655	2	pluckers
pucker	14	38	1763	2	pucker_
puckery	18	30	626	2	puckery
punkers	13	37	1485	2	punkers
quakers	20	30	969	2	quakers
rackers	13	43	2045	2	rackers
rockers	13	39	1655	2	rockers
sackers	13	38	2022	2	sackers
shuckers	17	38	813	2	shuckers
sucker	12	41	2066	2	sucker_
sucklers	14	37	996	2	sucklers
sulkers	11	36	1334	2	sulkers
tackers	13	43	1962	2	tackers
tickers	13	36	1772	2	tickers
truckers	14	27	901	2	truckers
tucker	12	43	1695	2	tucker_
tuckets	13	48	1033	2	tuckets
tuskers	11	37	1004	2	tuskers
wickers	16	41	1470	2	wickers

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.376	475242.0
2	DLD Change Limit	107671	91	2.890	37256.4
3	Display Results	91	91	0.030	3033.3
	(SQL Overall)	178691	91	3.296	54214.5