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

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

83 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
leching	13	46	1365	(None)
eching	12	63	1556	1	_eching
leaching	14	30	1283	1	leaching
leeching	14	31	837	1	leeching
letching	14	38	1026	1	letching
peching	15	45	1390	1	peching
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
bleaching	17	28	709	2	bleaching
blenching	17	27	650	2	blenching
caching	15	63	1750	2	caching
clenching	17	26	630	2	clenching
decking	15	39	1559	2	decking
echini	11	47	1043	2	_echini
echoing	13	5	861	2	_echoing
electing	11	21	1378	2	electing
etching	13	45	1184	2	etching
fetching	17	29	841	2	fetching
flecking	18	40	823	2	flecking
fleeching	18	30	501	2	fleeching
flenching	18	29	670	2	flenching
fleshing	15	33	930	2	fleshing
fletching	18	25	614	2	fletching
gecking	15	41	1136	2	gecking
inching	13	44	1432	2	inching
itching	13	40	1168	2	itching
kecking	13	41	1188	2	kecking
lacing	9	46	2623	2	lac_ing
lacking	14	38	2154	2	lacking
lashing	11	44	2289	2	lashing
latching	14	37	1202	2	latching
lathing	11	43	1569	2	lathing
leading	9	34	1955	2	leading
leafing	11	33	1358	2	leafing
leaking	12	36	1697	2	leaking
leaning	8	37	2120	2	leaning
leaping	10	32	1599	2	leaping
leashing	12	33	1031	2	leashing
leasing	8	39	2016	2	leasing
leaving	11	42	1685	2	leaving
lechering	15	3	844	2	lechering
lectin	8	25	1501	2	lectin_
lectins	9	25	1500	2	lectins
leering	8	34	1764	2	leering
legging	10	39	1264	2	legging
lekking	11	30	650	2	lekking
lemming	12	26	939	2	lemming
lending	9	41	1853	2	lending
lensing	8	40	1510	2	lensing
letting	8	32	1853	2	letting
levying	14	3	587	2	levying
lichting	14	26	851	2	lichting
licking	14	41	1828	2	licking
locking	14	37	1815	2	locking
locoing	10	28	1097	2	locoing
lucking	14	36	1583	2	lucking
lunching	14	31	1000	2	lunching
lurching	14	27	733	2	lurching
lushing	11	43	1611	2	lushing
lynching	17	33	608	2	lynching
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
peaching	16	36	1364	2	peaching
pecking	16	40	1778	2	pecking
perching	16	37	1163	2	perching
pleaching	17	25	708	2	pleaching
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
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 5 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.406	440125.6
2	DLD Change Limit	107671	83	3.923	27446.1
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	4.359	40993.6