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

Here are the results of your fuzzy-string dictionary search for “leacher” 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
leacher	12	40	1484	(None)
bleacher	15	35	888	1	bleacher
leached	13	37	1504	1	leached
leachers	13	37	1281	1	leachers
leaches	12	33	1934	1	leaches
leachier	13	3	725	1	leachier
leather	10	38	1578	1	leather
lecher	11	34	1585	1	le_cher
peacher	14	42	1607	1	peacher
reacher	12	37	1829	1	reacher
teacher	12	37	1483	1	teacher
beached	15	45	1655	2	beached
beaches	14	41	2065	2	beaches
beachier	15	3	880	2	beachier
belcher	14	35	1149	2	belcher
bencher	14	41	1348	2	bencher
bleached	16	37	856	2	bleached
bleachers	16	29	792	2	bleachers
bleaches	15	34	1067	2	bleaches
blencher	15	30	839	2	blencher
breacher	15	30	1150	2	breacher
clencher	15	27	797	2	clencher
coacher	14	37	1412	2	coacher
detacher	14	3	754	2	detacher
etcher	11	39	1294	2	_etcher
feather	13	36	1350	2	feather
fetcher	15	35	1039	2	fetcher
fletcher	16	30	666	2	fletcher
heather	13	39	1485	2	heather
lacer	7	58	3375	2	l_ac_er
laches	11	65	2835	2	l_aches
lacier	8	40	2009	2	l_acier
lacker	12	53	2562	2	l_acker
lasher	9	48	2453	2	l_asher
lather	9	51	2436	2	l_ather
leach	10	54	2252	2	leach__
leachy	14	41	973	2	leach_y
leader	7	48	2465	2	lea_der
leadier	8	32	1272	2	leadier
leafier	10	32	983	2	leafier
leaguer	8	3	579	2	leaguer
leaker	10	46	2007	2	lea_ker
leakier	11	40	1099	2	leakier
leaner	6	40	2219	2	lea_ner
leaper	8	81	1894	2	lea_per
learier	7	34	1566	2	learier
learner	7	31	938	2	learner
leaser	6	53	2267	2	lea_ser
leashed	11	32	1116	2	leashed
leashes	10	35	1440	2	leashes
leathern	11	39	891	2	leathern
leathers	11	42	1508	2	leathers
leathery	14	43	897	2	leathery
leaver	9	43	2151	2	lea_ver
leavier	10	31	999	2	leavier
leched	12	37	1600	2	le_ched
lechers	12	33	1396	2	le_chers
lechery	15	25	764	2	le_chery
leches	11	54	2131	2	le_ches
leeched	13	36	950	2	leeched
leeches	12	39	1193	2	leeches
letched	13	39	1205	2	letched
letches	12	40	1548	2	letches
loaches	12	36	1398	2	loaches
loather	10	37	1100	2	loather
luncher	12	31	1141	2	luncher
lurcher	12	33	813	2	lurcher
lyncher	15	36	655	2	lyncher
peached	15	43	1588	2	peached
peachers	15	32	1384	2	peachers
peaches	14	41	2005	2	peaches
peachier	15	4	862	2	peachier
percher	14	33	1342	2	percher
pleached	16	33	806	2	pleached
pleaches	15	32	1043	2	pleaches
pleather	13	5	665	2	pleather
poacher	14	39	1232	2	poacher
preacher	15	32	1137	2	preacher
reached	13	46	1908	2	reached
reachers	13	35	1572	2	reachers
reaches	12	34	2320	2	reaches
searcher	13	20	910	2	searcher
teachers	13	32	1239	2	teachers
teaches	12	27	1835	2	teaches
weather	13	35	1322	2	weather
welcher	15	31	939	2	welcher
wencher	15	38	1113	2	wencher

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.656	272394.8
2	DLD Change Limit	107671	87	3.500	30763.1
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	4.202	42525.2