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

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

61 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
preterites	12	4	1179	(None)
preterite	11	6	1320	1	preterite_
preterits	11	4	1096	1	preterit_s
preterit	10	3	1584	2	preterit__
pretermits	14	4	503	2	pretermit_s
arteries	8	3	2148	3	ar_teri_es
arteritis	9	4	975	3	ar_teritis
breweries	14	4	758	3	breweri_es
elaterites	10	4	827	3	elaterites
erythrites	16	10	444	3	erythrites
feteritas	12	6	489	3	_feteritas
freewrites	16	4	357	3	freewrites
kieserites	14	4	364	3	kieserites
laterites	9	7	1505	3	_laterites
meteorites	12	4	761	3	_meteorites
papeteries	14	4	655	3	papeteri_es
peeries	9	36	2302	3	p_e_eri_es
pelerines	11	3	1184	3	p_elerines
petites	9	38	2020	3	p_et__ites
poetries	10	3	1558	3	poet_ri_es
posterities	13	6	903	3	posterities
potteries	11	3	1359	3	potteri_es
predefines	16	4	543	3	predefines
predries	11	27	1438	3	pre_dri_es
preedited	13	3	763	3	pre_edited
preedits	11	6	876	3	pre_edit_s
preemies	12	5	1219	3	pre_emi_es
preexcites	21	4	416	3	preexcites
preinvites	15	6	480	3	preinvites
preliterates	14	5	534	3	preliterates
preprices	15	6	926	3	pre_prices
prescribes	16	10	628	3	prescribes
preserves	14	10	907	3	preser_ves
pretastes	11	11	942	3	pret_astes
pretences	13	23	1261	3	prete_nces
pretenses	11	22	1059	3	prete_nses
pretermit	13	4	713	3	pretermit__
pretermitted	17	5	226	3	pretermitted
preterms	12	3	722	3	preter__ms
pretested	12	14	911	3	prete_sted
pretests	10	3	1001	3	prete_st_s
pretexted	19	13	568	3	prete_xted
pretexts	17	3	560	3	prete_xt_s
pretorians	12	5	831	3	pretorians
pretreated	13	4	762	3	pretreated
pretreats	11	4	693	3	pretreat_s
pretrials	11	5	814	3	pret_rials
pretrims	12	3	898	3	pret_ri_ms
pretties	10	6	1513	3	pret_ti_es
preunites	11	3	893	3	pre_unites
printeries	12	4	1063	3	printeri_es
properties	14	14	1188	3	properties
proteides	12	23	878	3	prote_ides
pruderies	12	4	787	3	pruderi_es
reiterates	10	4	1200	3	_reiterates
retinites	9	3	1350	3	_retinites
retries	7	41	2907	3	_ret_ri_es
reveries	11	25	1851	3	_reveri_es
rewrites	11	3	1106	3	_re_writes
urethritis	13	5	329	3	urethritis
wernerites	13	4	494	3	wernerites

Search took 7 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	140603	0.156	1145455.1
2	DLD Change Limit	140603	61	5.860	23993.7
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	6.046	29555.2