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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

108 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
spunk	11	45	1340	(None)
punk	10	57	2997	1	_punk
skunk	8	50	1176	1	skunk
slunk	9	50	1630	1	slunk
spank	11	59	1957	1	spank
spun	6	62	2146	1	spun_
spunks	12	34	933	1	spunks
spunky	15	42	716	1	spunky
stunk	9	46	1629	1	stunk
sunk	8	50	3181	1	s_unk
bunk	10	57	3135	2	_bunk
chunk	14	48	1238	2	chunk
clunk	11	42	1508	2	clunk
drunk	10	54	984	2	drunk
dunk	9	62	2857	2	_dunk
flunk	12	50	1438	2	flunk
funk	11	58	2562	2	_funk
gunk	9	54	2357	2	_gunk
hunk	11	60	2954	2	_hunk
junk	15	51	2103	2	_junk
lunk	8	60	3072	2	_lunk
pink	10	70	3938	2	_pink
plunk	11	45	1440	2	plunk
puck	12	49	2794	2	_puck
pun	5	88	4651	2	_pun_
puna	6	53	3165	2	_puna
pung	7	54	2963	2	_pung
punka	11	45	1548	2	_punka
punks	11	48	2268	2	_punks
punky	14	44	1939	2	_punky
puns	6	66	4148	2	_puns
punt	6	57	4720	2	_punt
puny	9	55	2699	2	_puny
sank	8	52	3683	2	s_ank
sauna	5	41	1755	2	sauna
sculk	11	51	1246	2	sculk
shank	12	54	2219	2	shank
shrunk	13	35	706	2	shrunk
shuck	14	43	1453	2	shuck
shun	7	51	2277	2	shun_
shuns	8	50	1814	2	shuns
shunt	8	52	2651	2	shunt
sink	8	66	4014	2	s_ink
skank	8	44	1558	2	skank
skink	8	59	1685	2	skink
skulk	8	47	962	2	skulk
skunks	9	46	816	2	skunks
skunky	12	43	616	2	skunky
slank	9	58	2277	2	slank
slink	9	54	2291	2	slink
slung	6	51	1783	2	slung
snuck	11	44	1191	2	snuck
souk	8	61	2717	2	sou_k
sound	6	44	2002	2	sound
span	6	52	3466	2	span_
spang	8	49	1973	2	spang
spanks	12	45	1412	2	spanks
spans	7	45	2873	2	spans
spark	11	49	2089	2	spark
speak	11	46	1867	2	speak
speck	13	51	1565	2	speck
spelunk	13	4	320	2	spelunk
spend	8	56	1933	2	spend
spent	7	55	3283	2	spent
spick	13	45	1907	2	spick
spik	10	54	1971	2	sp_ik
spin	6	62	3130	2	spin_
spine	7	65	3442	2	spine
spins	7	53	2798	2	spins
spiny	10	49	2130	2	spiny
spook	11	54	1604	2	spook
sprung	9	46	1003	2	sprung
spud	7	58	1849	2	spu_d
spuds	8	51	1367	2	spuds
spue	6	60	2552	2	spu_e
spued	8	49	1847	2	spued
spues	7	50	2538	2	spues
spuing	9	43	1336	2	spuing
spume	9	58	1731	2	spume
spumy	12	46	1036	2	spumy
spunked	14	30	778	2	spunked
spunkie	13	21	530	2	spunkie
spur	6	53	2119	2	spu_r
spurn	7	48	1545	2	spurn
spurns	8	48	1138	2	spurns
spurs	7	46	2152	2	spurs
spurt	7	72	2798	2	spurt
sputa	7	46	1296	2	sputa
sputnik	13	7	227	2	sputnik
stank	9	58	2330	2	stank
stink	9	51	2250	2	stink
stuck	11	45	1577	2	stuck
stun	4	56	2345	2	stun_
stung	6	54	1715	2	stung
stuns	5	47	1949	2	stuns
stunt	5	53	2817	2	stunt
suck	10	61	3173	2	s_uck
suk	7	56	3297	2	s_u_k
sulk	8	53	2665	2	s_ulk
sun	3	71	4903	2	s_un_
sung	5	58	3217	2	s_ung
sunn	4	54	2359	2	s_unn
suns	4	58	4190	2	s_uns
swank	12	53	1823	2	swank
swink	12	51	1635	2	swink
swung	9	56	1056	2	swung
thunk	12	49	1185	2	thunk
trunk	9	47	1304	2	trunk

Search took 2 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	53800	0.310	576422.6
2	DLD Change Limit	53800	108	1.393	38621.7
3	Display Results	108	108	0.030	3600.0
	(SQL Overall)	178691	108	1.733	103110.8