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

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

89 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
peckers	15	33	1267	(None)
deckers	14	44	1383	1	deckers
neckers	13	42	1046	1	neckers
packers	15	38	1889	1	packers
pecker	14	46	1536	1	pecker_
pickers	15	37	1809	1	pickers
puckers	15	35	1467	1	puckers
backers	15	38	2188	2	backers
beakers	13	42	1687	2	beakers
beckets	15	39	982	2	beckets
bickers	15	43	1655	2	bickers
buckers	15	35	1745	2	buckers
checkers	19	31	784	2	checkers
cockers	15	36	1833	2	cockers
dackers	14	34	1704	2	dackers
deckels	14	36	736	2	deckels
decker	13	52	1599	2	decker_
dickers	14	41	1766	2	dickers
dockers	14	37	1500	2	dockers
duckers	14	32	1471	2	duckers
eskers	10	53	1222	2	_eskers
fuckers	16	36	1159	2	fuckers
hackers	16	46	1904	2	hackers
hecklers	17	35	712	2	hecklers
hockers	16	39	1591	2	hockers
ickers	12	39	1418	2	_ickers
jackers	20	42	1445	2	jackers
jerkers	18	28	708	2	jerkers
kickers	12	40	1329	2	kickers
lackers	13	41	2054	2	lackers
leakers	11	34	1542	2	leakers
lechers	12	33	1396	2	lechers
lickers	13	41	1825	2	lickers
lockers	13	35	1692	2	lockers
mockers	15	38	1294	2	mockers
muckers	15	36	1280	2	muckers
necker	12	40	1279	2	necker_
nickers	13	44	1509	2	nickers
ockers	12	38	1390	2	_ockers
oxpeckers	24	4	176	2	oxpeckers
pacers	10	51	2454	2	pac_ers
packer	14	42	2340	2	packer_
packets	15	51	1477	2	packets
parkers	13	38	1687	2	parkers
peachers	15	32	1384	2	peachers
pecked	15	50	1910	2	pecke_d
peckier	15	39	1052	2	peckier_
pecks	13	57	2443	2	peck__s
pectens	11	18	920	2	pectens
pedlers	10	30	1327	2	pedlers
peelers	9	36	1559	2	peelers
peepers	11	37	1367	2	peepers
peers	7	51	3027	2	pe__ers
pekes	11	46	2356	2	pe_ke_s
pelters	9	37	2031	2	pelters
penners	9	34	1418	2	penners
peppers	10	33	1144	2	peppers
perchers	15	36	1152	2	perchers
pesters	9	38	2709	2	pesters
peters	8	66	2459	2	pe_ters
petters	9	37	2236	2	petters
pewters	12	41	1335	2	pewters
pickeers	16	34	724	2	pickeers
picker	14	44	2217	2	picker_
pickets	15	43	1418	2	pickets
piecers	11	41	1225	2	piec_ers
pikers	12	47	1739	2	p_ikers
pinkers	13	41	1860	2	pinkers
pluckers	16	31	655	2	pluckers
pockets	15	46	1225	2	pockets
pokers	12	46	1792	2	p_okers
porkers	13	43	1493	2	porkers
prickers	16	37	1067	2	prickers
pucker	14	38	1763	2	pucker_
puckery	18	30	626	2	puckery
punkers	13	37	1485	2	punkers
rackers	13	43	2045	2	rackers
reekers	11	36	1314	2	reekers
rockers	13	39	1655	2	rockers
sackers	13	38	2022	2	sackers
seekers	11	37	1233	2	seekers
speakers	14	29	945	2	speakers
specters	12	28	1106	2	specters
suckers	13	37	1762	2	suckers
tackers	13	43	1962	2	tackers
tickers	13	36	1772	2	tickers
tuckers	13	40	1435	2	tuckers
wickers	16	41	1470	2	wickers
wreckers	17	31	597	2	wreckers

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.376	475242.0
2	DLD Change Limit	107671	89	3.360	32044.9
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	3.766	47448.5