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

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

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.

37 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
offertories	17	5	265	(None)
feretories	13	4	860	3	__feretories
offerors	14	4	353	3	offer_or__s
offertory	18	5	209	3	offertor__y
olfactories	16	5	354	3	olfactories
overstories	14	4	714	3	o_verstories
refectories	16	4	642	3	refectories
repertories	13	5	583	3	repertories
directories	14	4	601	4	directories
effectors	17	5	503	4	effector__s
excretories	20	5	290	4	excretories
factories	14	8	1009	4	__factories
ferneries	12	3	904	4	__ferneries
ferries	10	35	2108	4	__fer__ries
forestries	13	4	855	4	forest_ries
fumatories	15	4	473	4	_fumatories
fumitories	15	4	406	4	_fumitories
herstories	13	4	860	4	__herstories
inventories	14	5	470	4	inventories
observatories	18	6	167	4	observatories
offerers	14	3	493	4	offer_er__s
offeror	13	4	294	4	offer_or___
officiaries	19	5	250	4	officiaries
offshores	18	4	235	4	off_shor_es
oratories	9	4	1064	4	o__ratories
ostensories	11	5	356	4	ostensories
osteotomies	13	5	489	4	osteotomies
overdries	13	3	1088	4	o_ver_dries
overtires	12	14	1237	4	o_vertir_es
overtoils	12	3	708	4	o_verto_ils
overtones	12	10	1185	4	o_verto_nes
overtrims	14	4	750	4	o_vert_rims
overtures	12	16	1145	4	o_vertur_es
rectories	11	3	1464	4	__rectories
repertoires	13	5	265	4	repertoires
secretories	13	4	594	4	secretories
understories	13	6	556	4	understories

Search took 10 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	148819	0.420	425454.8
2	DLD Change Limit	148819	37	8.580	17344.9
3	Display Results	37	37	0.016	2312.5
	(SQL Overall)	178691	37	9.016	19819.3