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

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

77 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
eching	12	63	1556	(None)
aching	12	65	2197	1	aching
echini	11	47	1043	1	echini
echoing	13	5	861	1	echoing
etching	13	45	1184	1	etching
leching	13	46	1365	1	leching
peching	15	45	1390	1	peching
aahing	10	190	1576	2	aahing
acing	8	74	2915	2	ac_ing
acting	9	59	2098	2	acting
ahing	9	89	2834	2	_ahing
arching	13	62	1669	2	arching
ashing	10	78	2409	2	ashing
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
ceding	10	40	1480	2	ceding
cering	9	45	2253	2	cering
chang	11	54	1856	2	_chang
chin	9	69	3474	2	_chin_
china	10	50	2247	2	_china
chine	10	52	3172	2	_chine
chink	14	53	2159	2	_chink
chino	10	58	2331	2	_chino
chins	10	56	3146	2	_chins
cling	8	64	2467	2	_cling
cuing	8	54	2019	2	_cuing
decking	15	39	1559	2	decking
earing	7	52	3548	2	earing
easing	7	49	2646	2	easing
eating	7	51	3440	2	eating
ebbing	11	3	706	2	ebbing
echidna	13	4	372	2	echidna
echinus	12	3	620	2	echinus
edging	9	35	1071	2	edging
egging	9	32	1098	2	egging
eking	10	66	1498	2	e_king
ending	8	32	2025	2	ending
erring	7	38	1647	2	erring
etchings	14	39	629	2	etchings
euchring	14	3	661	2	euchring
exing	13	60	1681	2	e_xing
eyeing	10	42	936	2	eyeing
eying	9	61	1792	2	e_ying
fetching	17	29	841	2	fetching
gecking	15	41	1136	2	gecking
icing	8	60	1774	2	ic_ing
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
ochring	13	15	667	2	ochring
ohing	9	60	1880	2	_ohing
oohing	10	44	1293	2	oohing
ouching	13	43	1490	2	ouching
peaching	16	36	1364	2	peaching
pecking	16	40	1778	2	pecking
perching	16	37	1163	2	perching
reaching	14	33	1720	2	reaching
recking	14	43	1992	2	recking
retching	14	34	1217	2	retching
ruching	13	36	1293	2	ruching
teaching	14	36	1260	2	teaching
thing	9	66	2296	2	_thing
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 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	82551	0.110	1624463.6
2	DLD Change Limit	82551	77	2.686	30733.8
3	Display Results	77	77	0.033	2333.3
	(SQL Overall)	178691	77	2.829	63164.0