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

Here are the results of your fuzzy-string dictionary search for “treachery” with Change Limit: [1] [2] [3] [4]

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.

76 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
treachery	17	4	469	(None)
breacher	15	30	1150	2	breacher_
breachers	16	36	985	2	breachers
preacher	15	32	1137	2	preacher_
preachers	16	33	957	2	preachers
reacher	12	37	1829	2	_reacher_
reachers	13	35	1572	2	_reachers
teacher	12	37	1483	2	t_eacher_
teacherly	17	4	351	2	t_eacherly
teachers	13	32	1239	2	t_eachers
tracery	12	39	979	2	tr_ac_ery
tracheary	17	4	480	2	tr_acheary
trencher	13	27	931	2	trencher_
trenchers	14	28	807	2	trenchers
archery	15	47	806	3	ar__chery
bleacher	15	35	888	3	bleacher_
bleachers	16	29	792	3	bleachers
breached	16	34	1164	3	breache_d
breaches	15	37	1412	3	breache_s
breather	13	36	1059	3	breather_
breathers	14	31	910	3	breathers
broacher	15	32	926	3	broacher_
broachers	16	32	815	3	broachers
creamery	15	38	598	3	crea_mery
drencher	14	25	721	3	drencher_
drenchers	15	29	610	3	drenchers
feathery	17	36	807	3	_feathery
heathery	17	34	908	3	_heathery
leacher	12	40	1484	3	_leacher_
leachers	13	37	1281	3	_leachers
leathery	14	43	897	3	_leathery
lechery	15	25	764	3	_le_chery
peacher	14	42	1607	3	_peacher_
peachers	15	32	1384	3	_peachers
preached	16	34	1206	3	preache_d
preaches	15	32	1489	3	preache_s
preachier	16	4	692	3	preachier_
preachify	22	4	305	3	preachify
preachily	19	4	514	3	preachily
preachy	17	30	731	3	preach__y
reached	13	46	1908	3	_reache_d
reaches	12	34	2320	3	_reache_s
stretcher	14	4	629	3	stretcher_
stretchers	15	4	517	3	stretchers
teaches	12	27	1835	3	t_eache_s
tracer	8	48	2023	3	tr_ac_er_
tracers	9	49	1784	3	tr_ac_ers
trachea	12	3	1167	3	tr_ache_a
tracheae	13	4	911	3	tr_acheae
tracheal	13	4	825	3	tr_acheal
tracheas	13	4	1027	3	tr_acheas
tracheid	14	3	758	3	tr_acheid
tracker	13	35	1517	3	tr_acker_
trackers	14	35	1285	3	tr_ackers
trasher	10	44	1613	3	tr_asher_
trashers	11	30	1364	3	tr_ashers
treacheries	16	4	537	3	treacheries
treacherous	16	5	279	3	treacherous
treacle	9	3	997	3	treacle__
treacles	10	3	970	3	treacle_s
treaclier	11	4	415	3	treaclier_
treacly	12	3	709	3	treac__ly
treader	8	41	1383	3	trea_der_
treaders	9	33	1184	3	trea_ders
treadler	9	3	686	3	treadler_
treadlers	10	4	589	3	treadlers
treasury	11	4	379	3	trea_sury
treater	7	42	1983	3	trea_ter_
treaters	8	36	1584	3	trea_ters
trenched	14	28	985	3	trenche_d
trenches	13	35	1260	3	trenche_s
trickery	17	29	734	3	tr_ickery
wreather	14	26	860	3	wreather_
wreathers	15	25	749	3	wreathers
wrencher	16	28	778	3	wrencher_
wrenchers	17	25	633	3	wrenchers

Search took 8 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	148641	0.420	425454.8
2	DLD Change Limit	148641	76	6.936	21430.4
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	7.389	24183.4