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

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

50 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
peckier	15	39	1052	(None)
peakier	13	44	1144	1	peakier
pecker	14	46	1536	1	peck_er
perkier	13	38	1312	1	perkier
peskier	13	31	911	1	peskier
pickier	15	39	1297	1	pickier
pockier	15	39	1160	1	pockier
beakier	13	40	1216	2	beakier
cockier	15	40	1362	2	cockier
decker	13	52	1599	2	deck_er
decrier	10	27	1356	2	decrier
dickier	14	35	1245	2	dickier
duckier	14	39	1179	2	duckier
geekier	12	28	639	2	geekier
heckler	16	27	857	2	heckler
ickier	12	43	992	2	_ickier
jerkier	18	40	727	2	jerkier
kickier	12	34	905	2	kickier
leakier	11	40	1099	2	leakier
luckier	13	38	1153	2	luckier
muckier	15	34	1148	2	muckier
necker	12	40	1279	2	neck_er
pacier	10	50	1868	2	pac_ier
packer	14	42	2340	2	pack_er
pawkier	16	23	661	2	pawkier
peachier	15	4	862	2	peachier
peatier	9	40	1723	2	peatier
pecked	15	50	1910	2	peck_ed
peckers	15	33	1267	2	peck_ers
peckiest	16	27	1139	2	peckiest
pecking	16	40	1778	2	pecking
peckish	18	22	729	2	peckish
peppier	10	26	832	2	peppier
pestier	9	43	1740	2	pestier
pettier	9	42	1361	2	pettier
pickeer	15	37	1011	2	pickeer
picker	14	44	2217	2	pick_er
pluckier	16	29	507	2	pluckier
pokier	12	49	1463	2	p_okier
porkier	13	37	1234	2	porkier
prickier	16	36	814	2	prickier
pucker	14	38	1763	2	puck_er
punkier	13	35	1279	2	punkier
reekier	11	31	1112	2	reekier
rockier	13	49	1188	2	rockier
suckier	13	36	1397	2	suckier
tackier	13	37	1252	2	tackier
techier	12	6	924	2	techier
wackier	16	36	973	2	wackier
yuckier	16	35	853	2	yuckier

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.390	458182.1
2	DLD Change Limit	107671	50	2.906	37051.3
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	3.312	53952.6