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

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

87 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
peching	15	45	1390	(None)
eching	12	63	1556	1	_eching
leching	13	46	1365	1	leching
peaching	16	36	1364	1	peaching
pecking	16	40	1778	1	pecking
perching	16	37	1163	1	perching
aching	12	65	2197	2	_aching
arching	13	62	1669	2	arching
baching	15	60	1775	2	baching
beaching	16	41	1414	2	beaching
becking	16	44	1607	2	becking
belching	16	34	915	2	belching
benching	16	34	1134	2	benching
caching	15	63	1750	2	caching
decking	15	39	1559	2	decking
echini	11	47	1043	2	_echini
echoing	13	5	861	2	_echoing
etching	13	45	1184	2	etching
fetching	17	29	841	2	fetching
gecking	15	41	1136	2	gecking
inching	13	44	1432	2	inching
itching	13	40	1168	2	itching
kecking	13	41	1188	2	kecking
leaching	14	30	1283	2	leaching
leeching	14	31	837	2	leeching
letching	14	38	1026	2	letching
meshing	13	45	1381	2	meshing
miching	15	29	1180	2	miching
necking	14	39	1389	2	necking
niching	13	36	1243	2	niching
ouching	13	43	1490	2	ouching
pacing	11	45	2275	2	pac_ing
packing	16	44	2072	2	packing
parching	16	43	1305	2	parching
pashing	13	51	2051	2	pashing
patching	16	32	1275	2	patching
peacing	12	41	1707	2	peacing
peaking	14	43	1769	2	peaking
pealing	10	41	2320	2	pealing
pechan	13	5	1154	2	pechan_
pechans	14	8	1050	2	pechans
pectin	10	26	1553	2	pectin_
pectins	11	23	1523	2	pectins
peeing	9	46	1808	2	pe_eing
peeking	14	44	1495	2	peeking
peeling	10	29	1987	2	peeling
peening	10	33	1830	2	peening
peeping	12	36	1521	2	peeping
peering	10	35	2035	2	peering
peeving	13	51	1224	2	peeving
pegging	12	28	1113	2	pegging
peining	10	46	1915	2	peining
peising	10	34	1676	2	peising
pelting	10	29	1727	2	pelting
pending	11	41	1977	2	pending
penning	10	36	1649	2	penning
pepping	11	35	1162	2	pepping
perking	14	37	1646	2	perking
perming	12	34	1609	2	perming
petting	10	37	2095	2	petting
picking	16	34	1833	2	picking
piecing	12	4	1045	2	piec_ing
pinching	16	37	1105	2	pinching
pishing	13	43	1437	2	pishing
pitching	16	34	1111	2	pitching
pithing	13	40	1405	2	pithing
pleaching	17	25	708	2	pleaching
poaching	16	35	1083	2	poaching
pocking	16	39	1676	2	pocking
pooching	16	32	898	2	pooching
poohing	13	31	1232	2	poohing
pouching	16	32	1041	2	pouching
preaching	17	28	1116	2	preaching
psyching	19	3	448	2	psyching
punching	16	33	1012	2	punching
pushing	13	36	1545	2	pushing
reaching	14	33	1720	2	reaching
recking	14	43	1992	2	recking
retching	14	34	1217	2	retching
ruching	13	36	1293	2	ruching
speccing	15	30	664	2	speccing
specking	17	35	973	2	specking
teaching	14	36	1260	2	teaching
welching	17	28	736	2	welching
wenching	17	32	886	2	wenching
zechin	20	13	770	2	zechin_
zechins	21	13	712	2	zechins

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.360	496363.9
2	DLD Change Limit	107671	87	3.470	31029.1
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.860	46293.0