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

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

73 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
torchiers	14	4	507	(None)
torchier	13	3	746	1	torchier_
torchiere	14	4	357	1	torchiere
torchieres	15	4	324	1	torchieres
tochers	12	34	1309	2	to_ch_ers
torchere	13	4	768	2	torch_ere
torcheres	14	4	686	2	torch_eres
torches	12	37	1543	2	torch_e_s
torchiest	14	3	803	2	torchiest
touchers	13	36	1121	2	touch_ers
touchier	13	4	738	2	touchier_
archers	12	44	1457	3	_arch_ers
botchers	15	35	1154	3	botch_ers
botchier	15	28	714	3	botchier_
coachers	15	43	1230	3	coach_ers
conchies	15	32	1485	3	conchie_s
couchers	15	35	1386	3	couch_ers
forcers	12	42	1571	3	forc__ers
hoochies	16	3	960	3	hoochie_s
kerchiefs	21	4	176	3	kerchiefs
lurchers	13	30	715	3	lurch_ers
marchers	15	37	1081	3	march_ers
moochers	15	36	912	3	mooch_ers
northers	11	3	933	3	north_ers
notchers	13	27	942	3	notch_ers
ochers	11	39	1530	3	_o_ch_ers
orchids	13	7	721	3	_orchi_ds
orchils	12	7	770	3	_orchi_ls
orchis	11	7	1077	3	_orchi__s
orchises	13	3	877	3	_orchises
orchitis	13	4	642	3	_orchitis
perchers	15	36	1152	3	perch_ers
poachers	15	29	1076	3	poach_ers
poachier	15	5	682	3	poachier_
porches	14	38	1567	3	porch_e_s
pouchier	15	4	680	3	pouchier_
scorchers	16	14	551	3	scorch_ers
sorcerers	11	4	532	3	sorcerers
starchier	14	3	664	3	starchier_
tarriers	8	34	1171	3	tar_riers
tarsiers	8	29	853	3	tar_siers
teachers	13	32	1239	3	teach_ers
techier	12	6	924	3	t_echier_
techies	12	5	1360	3	t_echie_s
terriers	8	42	1082	3	ter_riers
tetchier	13	3	645	3	tetchier_
tocher	11	40	1491	3	to_ch_er_
toothier	11	3	642	3	toothier_
torched	13	35	1135	3	torch_e_d
torching	14	25	1008	3	torchi_ng
torchons	13	3	750	3	torch_ons
tories	6	54	3588	3	tor__ie_s
torquers	17	20	430	3	tor_quers
torturers	9	4	434	3	torturers
toucher	12	48	1435	3	touch_er_
touches	12	51	1834	3	touch_e_s
touchiest	14	3	708	3	touchiest
touchiness	15	4	461	3	touchiness
toughies	12	7	824	3	toughie_s
triers	6	43	2152	3	t_r__iers
trochars	13	7	785	3	troch_ars
trochees	13	25	1018	3	troch_ees
troches	12	37	1534	3	troch_e_s
trochils	13	8	858	3	trochi_ls
trochilus	14	7	471	3	trochilus
trochlears	15	4	314	3	trochlears
trochleas	14	4	471	3	trochleas
trophies	13	4	1367	3	trophie_s
vouchers	16	41	862	3	vouch_ers
worriers	11	25	781	3	wor_riers
worshipers	18	4	252	3	worshipers
worthier	14	3	671	3	worthier_
worthies	14	3	1028	3	worthie_s

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.436	409841.7
2	DLD Change Limit	148641	73	6.593	22545.3
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.059	25313.9