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

Here are the results of your fuzzy-string dictionary search for “preterite” 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
preterite	11	6	1320	(None)
preterit	10	3	1584	1	preterit_
preterites	12	4	1179	1	preterites
preterits	11	4	1096	1	preterits
pretermit	13	4	713	2	pretermit_
pretermits	14	4	503	2	pretermits
elaterite	9	4	972	3	elaterite
erythrite	15	12	470	3	erythrite
feterita	11	6	646	3	_feterita
freewrite	15	4	360	3	freewrite
kieserite	13	4	362	3	kieserite
laterite	8	7	1633	3	_laterite
meteorite	11	4	817	3	_meteorite
papeterie	13	4	519	3	papeteri_e
peerie	8	36	1789	3	p_e_eri_e
pelerine	10	3	1301	3	p_elerine
petering	11	25	1681	3	p_etering
petite	8	43	2065	3	p_et__ite
posterity	14	4	869	3	posterity
predebate	14	4	616	3	predebate
predefine	15	4	617	3	predefine
preedit	10	5	1246	3	pre_edit_
preedited	13	3	763	3	pre_edited
preedits	11	6	876	3	pre_edits
preemie	11	3	1056	3	pre_emi_e
preexcite	20	4	468	3	preexcite
preinvite	14	8	544	3	preinvite
preliterate	13	6	595	3	preliterate
preprice	14	8	887	3	pre_price
prescribe	15	10	667	3	prescribe
preserve	13	10	880	3	preser_ve
preservice	17	4	449	3	preservice
prestrike	15	4	749	3	prestrike
pretaste	10	13	952	3	pret_aste
pretence	12	23	1212	3	prete_nce
pretense	10	19	982	3	prete_nse
preterm	11	3	1016	3	preter__m
pretermitted	17	5	226	3	pretermitted
preterms	12	3	722	3	preter_ms
pretest	9	5	1763	3	prete_st_
pretested	12	14	911	3	prete_sted
pretests	10	3	1001	3	prete_sts
pretext	16	3	966	3	prete_xt_
pretexted	19	13	569	3	prete_xted
pretexts	17	3	560	3	prete_xts
pretorial	11	5	1265	3	pretorial
pretorian	11	5	1155	3	pretorian
pretreat	10	3	1192	3	pretreat_
pretreated	13	4	762	3	pretreated
pretreats	11	4	693	3	pretreats
pretrial	10	5	1198	3	pret_rial
pretrim	11	3	1078	3	pret_ri_m
pretrims	12	3	898	3	pret_rims
preunite	10	3	957	3	pre_unite
proteide	11	23	972	3	prote_ide
reiterate	9	4	1293	3	_reiterate
retinite	8	3	1485	3	_retinite
reverie	10	36	1516	3	_reveri_e
rewrite	10	3	1114	3	_re_write
ureteric	10	4	623	3	ureteri_c
wernerite	12	4	517	3	wernerite

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	61	7.406	20070.3
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	7.856	22745.8