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

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

77 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
punkies	13	42	1680	(None)
hunkies	14	32	1450	1	hunkies
junkies	18	37	1169	1	junkies
pinkies	13	38	1826	1	pinkies
punkie	12	35	1361	1	punkie_
punkier	13	35	1279	1	punkier
punkiest	14	93	1266	1	punkiest
punkins	13	31	1111	1	punkins
punties	9	45	2078	1	punties
spunkies	14	22	759	1	spunkies
aunties	7	39	2007	2	aunties
bunnies	9	44	1500	2	bunnies
dinkies	12	37	1603	2	dinkies
duckies	14	36	1381	2	duckies
flunkies	15	3	639	2	flunkies
funkias	14	3	538	2	funkias
funkier	14	34	998	2	funkier
funkiest	15	28	1097	2	funkiest
funnies	10	41	1360	2	funnies
gunkier	12	36	955	2	gunkier
gunkiest	13	26	1057	2	gunkiest
gunnies	8	34	1312	2	gunnies
hankies	14	36	1776	2	hankies
honkies	14	30	1514	2	honkies
hunkie	13	38	1238	2	hunkie_
hunkier	14	45	1214	2	hunkier
hunkiest	15	38	1233	2	hunkiest
huskies	14	32	1208	2	huskies
junkie	17	33	960	2	junkie_
junkier	18	33	949	2	junkier
junkiest	19	26	1017	2	junkiest
luckies	13	33	1368	2	luckies
lunies	6	47	2301	2	lun_ies
muskies	13	36	1467	2	muskies
pandies	10	42	2450	2	pandies
pansies	9	45	2198	2	pansies
panties	9	42	3093	2	panties
pennies	9	42	1881	2	pennies
pinkie	12	44	1427	2	pinkie_
pinkoes	13	55	1231	2	pinkoes
pinnies	9	33	1844	2	pinnies
plunkier	14	30	532	2	plunkier
plunkiest	15	3	550	2	plunkiest
pokies	12	59	2133	2	p_okies
ponies	8	48	3346	2	pon_ies
porkies	13	34	1649	2	porkies
pukes	11	45	2302	2	pu_k_es
punches	14	48	1613	2	punches
pundits	10	37	929	2	pundits
pungles	10	40	1371	2	pungles
punier	8	45	1922	2	pun_ier
puniest	9	29	1809	2	pun_iest
punjis	15	3	669	2	punji_s
punkahs	16	28	478	2	punkahs
punkas	12	34	1067	2	punk_as
punker	12	37	1882	2	punk_er
punkers	13	37	1485	2	punkers
punkest	13	26	1169	2	punk_est
punkey	15	40	1117	2	punk_ey
punkeys	16	36	649	2	punkeys
punkin	12	36	1152	2	punki_n
punkiness	15	22	698	2	punkiness
punkish	16	25	769	2	punkish
punks	11	48	2268	2	punk__s
punnier	9	35	1126	2	punnier
punniest	10	25	1158	2	punniest
puppies	10	32	1261	2	puppies
pussies	9	36	1569	2	pussies
putties	9	44	2002	2	putties
runkles	11	41	1194	2	runkles
spunkie	13	21	530	2	spunkie_
spunkier	14	23	582	2	spunkier
spunkiest	15	16	656	2	spunkiest
sulkies	11	43	1576	2	sulkies
tunnies	7	36	1426	2	tunnies
undies	7	38	2196	2	_undies
unties	6	43	2692	2	_unties

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.393	454684.5
2	DLD Change Limit	107671	77	3.390	31761.4
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	3.813	46863.6