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

Here are the results of your fuzzy-string dictionary search for “spunking” 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
spunking	15	25	806	(None)
skunking	12	25	665	1	skunking
spanking	15	39	1197	1	spanking
bunking	14	40	1619	2	_bunking
chunking	18	32	805	2	chunking
clunking	15	32	943	2	clunking
dunking	13	38	1326	2	_dunking
flunking	16	31	777	2	flunking
funking	15	40	1302	2	_funking
junking	19	39	1007	2	_junking
pinking	14	39	1894	2	_pinking
plunking	15	32	848	2	plunking
puking	13	39	1306	2	_pu_king
punkin	12	36	1152	2	_punkin_
punkins	13	31	1111	2	_punkins
punning	10	34	1499	2	_punning
punting	10	33	1844	2	_punting
saunaing	9	3	701	2	saunaing
sculking	15	30	791	2	sculking
shanking	16	36	1228	2	shanking
shucking	18	33	943	2	shucking
shunning	12	36	784	2	shunning
shunting	12	36	1043	2	shunting
sinking	12	33	2054	2	s_inking
skanking	12	28	874	2	skanking
skinking	12	29	977	2	skinking
skulking	12	24	590	2	skulking
slinking	13	34	1298	2	slinking
sounding	10	27	1287	2	sounding
spankings	16	21	500	2	spankings
spanning	11	33	1108	2	spanning
sparking	15	28	1254	2	sparking
speaking	15	32	1249	2	speaking
specking	17	35	973	2	specking
spelunking	17	11	200	2	spelunking
spending	12	27	1243	2	spending
spiking	14	43	1288	2	sp_iking
spinning	11	33	1081	2	spinning
spoking	14	32	1222	2	sp_oking
sponging	12	3	882	2	sponging
spooking	15	26	980	2	spooking
spudding	13	3	565	2	spudding
spuing	9	43	1336	2	spu__ing
spuming	12	4	852	2	spu_ming
spunkie	13	21	530	2	spunki_e
spunkier	14	23	582	2	spunkier
spunkies	14	22	759	2	spunkies
spunkily	17	3	377	2	spunkily
spurning	11	25	866	2	spurning
spurring	11	33	976	2	spurring
spurting	11	31	1163	2	spurting
stinking	13	31	1354	2	stinking
stunning	9	29	846	2	stunning
stunting	9	28	1150	2	stunting
sucking	14	32	1741	2	s_ucking
sulking	12	45	1431	2	s_ulking
sunning	8	37	1567	2	s_unning
swanking	16	39	996	2	swanking
swinking	16	34	1032	2	swinking
thunking	16	19	695	2	thunking

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	60	3.610	33534.3
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	4.013	44528.0