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

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

98 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
pecky	16	55	1509	(None)
peaky	14	57	1815	1	peaky
peck	12	57	3068	1	peck_
pecks	13	57	2443	1	pecks
perky	14	53	1948	1	perky
pesky	14	59	1156	1	pesky
picky	16	54	1694	1	picky
pocky	16	53	1460	1	pocky
beaky	14	61	1802	2	beaky
beck	12	62	2657	2	beck_
becks	13	55	2201	2	becks
cocky	16	42	1593	2	cocky
decay	11	47	1848	2	decay
deck	11	58	2775	2	deck_
decks	12	48	2219	2	decks
decoy	11	57	1631	2	decoy
decry	11	55	1435	2	decry
dicky	15	48	1624	2	dicky
drecky	16	48	633	2	drecky
ducky	15	42	1611	2	ducky
feck	13	49	2343	2	feck_
feckly	18	33	596	2	feckly
fecks	14	54	1785	2	fecks
flecky	18	38	765	2	flecky
geck	11	57	2199	2	geck_
gecko	12	45	1111	2	gecko
gecks	12	51	1709	2	gecks
geeky	13	47	1073	2	geeky
heck	13	58	2649	2	heck_
hecks	14	52	2065	2	hecks
icky	13	63	1575	2	_icky
jacky	21	54	1234	2	jacky
jerky	19	67	1242	2	jerky
keck	9	49	2071	2	keck_
kecks	10	54	1657	2	kecks
kicky	13	50	1233	2	kicky
leaky	12	52	1772	2	leaky
lucky	14	55	1501	2	lucky
mucky	16	50	1525	2	mucky
neck	10	54	2366	2	neck_
necks	11	51	1933	2	necks
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	pac_y
pawky	17	38	1015	2	pawky
peachy	16	45	1084	2	peachy
peak	10	65	3520	2	peak_
peaks	11	48	2562	2	peaks
peaty	10	57	2569	2	peaty
peavy	13	50	1484	2	peavy
pec	7	67	4441	2	pec__
pecan	9	19	1903	2	pecan
pech	11	61	2545	2	pec_h
pechs	12	55	1620	2	pechs
pecked	15	50	1910	2	pecked
pecker	14	46	1536	2	pecker
pecs	8	46	3410	2	pec_s
peek	10	60	3143	2	peek_
peeks	11	50	2111	2	peeks
peery	10	57	1944	2	peery
peke	10	59	2620	2	pe_ke
penny	10	51	1945	2	penny
peony	10	57	1756	2	peony
peppy	11	43	1036	2	peppy
perdy	11	54	1733	2	perdy
perk	10	62	3284	2	perk_
perks	11	53	2580	2	perks
perry	10	52	2271	2	perry
pesty	10	64	2171	2	pesty
petty	10	53	2029	2	petty
pick	12	59	3381	2	pick_
picks	13	52	2614	2	picks
pinky	14	58	2340	2	pinky
plucky	17	40	658	2	plucky
pock	12	61	2929	2	pock_
pocks	13	50	2296	2	pocks
poky	13	59	2215	2	p_oky
porky	14	50	1933	2	porky
pricky	17	42	1034	2	pricky
puck	12	49	2794	2	puck_
pucka	13	34	1280	2	pucka
pucks	13	43	2210	2	pucks
punky	14	44	1939	2	punky
reck	10	61	3056	2	reck_
recks	11	56	2513	2	recks
reeky	12	54	1626	2	reeky
rocky	14	45	1385	2	rocky
speck	13	51	1565	2	speck_
specks	14	43	1270	2	specks
sucky	14	44	1550	2	sucky
tacky	14	56	1744	2	tacky
techy	13	56	1201	2	techy
wacky	17	47	1493	2	wacky
yechy	16	51	908	2	yechy
yeuky	15	54	703	2	yeuky
yucky	17	54	1169	2	yucky

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.296	603685.8
2	DLD Change Limit	53800	98	1.656	32487.9
3	Display Results	98	98	0.016	6125.0
	(SQL Overall)	178691	98	1.968	90798.3