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

Here are the results of your fuzzy-string dictionary search for “duckpins” with Change Limit: [1] [2] [3] [4]

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.

64 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
duckpins	17	4	369	(None)
duckpin	16	4	346	1	duckpin_
duckies	14	36	1381	2	duck_ies
ducking	15	43	1505	2	duck_ing
duckling	16	24	770	2	duckling
ducklings	17	20	401	2	ducklings
backspins	19	4	570	3	backspins
buckeens	16	3	485	3	buckeens
bucking	16	36	1757	3	buck_ing
buckling	17	25	911	3	buckling
buckskins	16	4	348	3	buckskins
bumkins	15	31	801	3	bumk_ins
bumpkins	18	4	370	3	bumpkins
buskins	13	33	1094	3	busk_ins
cockpits	18	4	574	3	cockpits
decking	15	39	1559	3	deck_ing
deckings	16	34	668	3	deck_ings
dickens	14	44	1013	3	dick_ens
dickies	14	34	1634	3	dick_ies
dicking	15	36	1761	3	dick_ing
docking	15	36	1501	3	dock_ing
dubbins	12	35	880	3	du_bbins
duchies	13	33	1231	3	duc_hies
duckbill	17	4	294	3	duckbill
duckbills	18	4	242	3	duckbills
duckers	14	32	1471	3	duck_ers
duckie	13	35	1166	3	duck_i_e
duckier	14	39	1179	3	duck_ier
duckiest	15	32	1186	3	duck_iest
ducks	12	48	2321	3	duck___s
ducktails	16	5	281	3	ducktails
ducting	11	37	1359	3	duc_ting
ductings	12	34	667	3	duc_tings
duking	12	47	1513	3	du_k_ing
dumping	13	37	1291	3	du_mping
dumpings	14	29	576	3	du_mpings
dunking	13	38	1326	3	dunk_ing
dunlins	8	4	955	3	du_nlins
duping	10	41	1363	3	du__ping
dupping	13	37	1104	3	du_pping
dusking	13	39	1205	3	dusk_ing
dustbins	11	4	459	3	dustbins
dustpans	11	4	323	3	dustpans
fuchsins	16	10	426	3	fuchsins
fucking	17	32	1228	3	fuck_ing
luckies	13	33	1368	3	luck_ies
lucking	14	36	1583	3	luck_ing
lupins	8	45	1446	3	lu__pins
mucins	10	27	1251	3	muc__ins
mucking	16	32	1382	3	muck_ing
nucleins	10	4	608	3	nucleins
pumpkins	18	4	385	3	pumpkins
punkins	13	31	1111	3	punk_ins
pushpins	15	4	334	3	pushpins
rucking	14	32	1667	3	ruck_ing
ruckling	15	25	857	3	ruckling
sculpins	12	21	647	3	sculpins
stickpins	17	4	409	3	stickpins
sucking	14	32	1741	3	suck_ing
suckling	15	24	1002	3	suckling
sucklings	16	22	511	3	sucklings
tucking	14	34	1518	3	tuck_ing
unpins	8	23	1238	3	_u_npins
yucking	17	32	1169	3	yuck_ing

Search took 7 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	146162	0.403	443402.0
2	DLD Change Limit	146162	64	6.220	23498.7
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	6.653	26858.7