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

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

85 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
pawky	17	38	1015	(None)
gawky	16	56	999	1	gawky
alky	11	59	2034	2	_alky
away	10	80	2422	2	_away
awny	10	59	1930	2	_awny
awry	10	76	1968	2	_awry
balky	14	54	1824	2	balky
barky	14	57	2161	2	barky
bawdy	14	75	1328	2	bawdy
bawty	13	56	1410	2	bawty
caky	13	62	2244	2	ca_ky
casky	14	45	1268	2	casky
darky	13	60	1883	2	darky
dawk	12	61	1728	2	dawk_
dawks	13	52	1349	2	dawks
fawny	14	47	1171	2	fawny
gawk	12	67	1669	2	gawk_
gawks	13	68	1163	2	gawks
gawsy	12	45	909	2	gawsy
hanky	15	54	1829	2	hanky
hawk	14	55	2115	2	hawk_
hawkey	19	50	763	2	hawkey
hawks	15	54	1570	2	hawks
jacky	21	54	1234	2	jacky
laky	11	67	2582	2	la_ky
lanky	12	55	1748	2	lanky
larky	12	52	1887	2	larky
lawny	11	59	1201	2	lawny
narky	12	60	1780	2	narky
oaky	11	64	1995	2	oa_ky
pacey	12	67	2028	2	pacey
pack	12	55	3544	2	pack_
packly	17	22	833	2	packly
packs	13	55	2893	2	packs
pacy	11	53	2868	2	pa_cy
paddy	12	59	1359	2	paddy
paik	10	57	2680	2	paik_
paiks	11	47	1985	2	paiks
pally	10	57	2712	2	pally
palmy	12	60	1673	2	palmy
palsy	10	54	1746	2	palsy
paly	9	58	3553	2	pa_ly
pandy	11	50	2117	2	pandy
pansy	10	57	1797	2	pansy
panty	10	59	2930	2	panty
pappy	11	47	1380	2	pappy
pardy	11	55	2395	2	pardy
park	10	52	3749	2	park_
parka	11	51	2088	2	parka
parks	11	61	3446	2	parks
parry	10	53	2375	2	parry
party	10	66	3061	2	party
pasty	10	57	2505	2	pasty
patly	10	50	2058	2	patly
patsy	10	57	1720	2	patsy
patty	10	47	2361	2	patty
paty	9	52	3456	2	pa_ty
paw	8	76	5117	2	paw__
pawed	11	57	2561	2	pawed
pawer	10	44	2297	2	pawer
pawkily	19	3	420	2	pawkily
pawl	9	51	2326	2	paw_l
pawls	10	56	1766	2	pawls
pawn	9	46	2530	2	paw_n
pawns	10	88	1813	2	pawns
paws	9	60	3818	2	paw_s
pay	8	84	6118	2	pa__y
peaky	14	57	1815	2	peaky
pecky	16	55	1509	2	pecky
perky	14	53	1948	2	perky
pesky	14	59	1156	2	pesky
picky	16	54	1694	2	picky
pinky	14	58	2340	2	pinky
pocky	16	53	1460	2	pocky
poky	13	59	2215	2	p_oky
porky	14	50	1933	2	porky
punky	14	44	1939	2	punky
rawly	11	51	1583	2	rawly
sarky	12	55	2178	2	sarky
sparky	15	45	1152	2	sparky
tacky	14	56	1744	2	tacky
talky	12	62	1568	2	talky
tawny	11	47	1365	2	tawny
wacky	17	47	1493	2	wacky
yawey	14	45	827	2	yawey

Search took 3 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.093	1921408.6
2	DLD Change Limit	53800	85	1.826	29463.3
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	1.965	90936.9