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

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

83 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	1	spunking
punkin	12	36	1152	2	_punkin_
punkins	13	31	1111	2	_punkins
punkish	16	25	769	2	_punkish
skunking	12	25	665	2	skunking
spanking	15	39	1197	2	spanking
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
bunking	14	40	1619	3	_bunking
chunking	18	32	805	3	chunking
clunking	15	32	943	3	clunking
dunking	13	38	1326	3	_dunking
flunking	16	31	777	3	flunking
funking	15	40	1302	3	_funking
junking	19	39	1007	3	_junking
pinking	14	39	1894	3	_pinking
pinkish	16	27	911	3	_pinkish
plunking	15	32	848	3	plunking
puckish	18	23	721	3	_puckish
puking	13	39	1306	3	_pu_king
punish	11	14	1150	3	_pun_ish
punkah	15	34	709	3	_punk_ah
punkie	12	35	1361	3	_punki_e
punkier	13	35	1279	3	_punkier
punkies	13	42	1680	3	_punkies
punning	10	34	1499	3	_punning
punting	10	33	1844	3	_punting
saunaing	9	3	701	3	saunaing
sculking	15	30	791	3	sculking
shanking	16	36	1228	3	shanking
shucking	18	33	943	3	shucking
shunning	12	36	784	3	shunning
shunting	12	36	1043	3	shunting
sinking	12	33	2054	3	s_inking
skanking	12	28	874	3	skanking
skinking	12	29	977	3	skinking
skulking	12	24	590	3	skulking
skunkier	11	17	428	3	skunkier
slinking	13	34	1298	3	slinking
sounding	10	27	1287	3	sounding
spankings	16	21	500	3	spankings
spanning	11	33	1108	3	spanning
sparking	15	28	1254	3	sparking
sparkish	17	27	697	3	sparkish
speaking	15	32	1249	3	speaking
specking	17	35	973	3	specking
spelunking	17	11	200	3	spelunking
spending	12	27	1243	3	spending
spiking	14	43	1288	3	sp_iking
spinning	11	33	1081	3	spinning
spoking	14	32	1222	3	sp_oking
spongin	10	3	637	3	spongin_
sponging	12	3	882	3	sponging
spongins	11	3	656	3	spongins
spooking	15	26	980	3	spooking
spookish	17	4	464	3	spookish
spudding	13	3	565	3	spudding
spuing	9	43	1336	3	spu__ing
spuming	12	4	852	3	spu_ming
spunk	11	45	1340	3	spunk___
spunked	14	30	778	3	spunk_ed
spunkiest	15	16	657	3	spunkiest
spunkiness	16	4	417	3	spunkiness
spunks	12	34	933	3	spunk__s
spunky	15	42	716	3	spunk__y
spurning	11	25	866	3	spurning
spurring	11	33	976	3	spurring
spurting	11	31	1163	3	spurting
stinking	13	31	1354	3	stinking
stunning	9	29	846	3	stunning
stunting	9	28	1150	3	stunting
sucking	14	32	1741	3	s_ucking
sulking	12	45	1431	3	s_ulking
sunfish	13	3	888	3	s_unfish
sunken	10	35	1178	3	s_unken_
sunning	8	37	1567	3	s_unning
swanking	16	39	996	3	swanking
swinking	16	34	1032	3	swinking
thunking	16	19	695	3	thunking
unkind	11	33	1057	3	__unkind
unkink	9	30	871	3	__unkink

Search took 8 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.470	380193.6
2	DLD Change Limit	146162	83	7.360	19859.0
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	7.860	22734.2