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

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

(Search took more than 30 seconds, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

87 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
presummits	16	5	235	(None)
presummit	15	5	314	1	presummit_
resubmits	13	4	280	2	_resubmits
preadmits	14	4	493	3	pre_admits
preaudits	12	6	503	3	preau_dits
prelimits	13	6	602	3	pre_limits
presumers	13	3	638	3	presu_mers
presumes	12	3	985	3	presu_m_es
presuming	14	3	767	3	presu_ming
pretermits	14	4	505	3	pretermits
recommits	15	4	470	3	_recommits
resubmit	12	4	357	3	_resubmit_
resummons	13	4	230	3	_resummons
summits	11	3	798	3	___summits
crummies	14	3	764	4	cr__ummies
gremmies	13	5	599	4	gre__mmies
grummets	13	27	503	4	gr__ummets
jesuits	14	3	632	4	_jesu__its
permits	11	3	1400	4	p_e__rmits
persimmons	16	5	205	4	persimmons
pessimist	13	4	527	4	p_essimist
pessimists	14	5	386	4	p_essimists
plummets	14	30	477	4	p__lummets
preadmit	13	4	681	4	pre_admit_
preaudit	11	7	702	4	preau_dit_
prebudgets	16	4	172	4	prebudgets
precuts	11	17	1047	4	precu___ts
preedits	11	6	877	4	pre__edits
preemies	12	5	1220	4	pre__emies
preempts	14	4	455	4	pre__empts
preexempts	23	5	138	4	preexempts
preformats	17	4	441	4	preformats
prehumans	16	4	332	4	prehu_mans
prelimit	12	5	912	4	pre_limit_
premies	11	38	2307	4	pre___mies
premiss	11	35	1382	4	pre___miss
prenumbers	16	4	271	4	prenumbers
prepubis	14	4	365	4	prepu_bi_s
prescripts	16	4	475	4	prescripts
preselects	14	6	437	4	preselects
presentist	12	4	1010	4	presentist
presents	10	33	1565	4	pres__ents
presets	9	42	1643	4	pres___ets
preships	15	3	932	4	pres__hips
presidents	13	4	703	4	presidents
presidios	12	4	579	4	pres_idios
presifts	13	6	661	4	pres__ifts
presorts	10	53	1169	4	pres__orts
presplit	12	4	776	4	pres_plit_
pressmarks	18	4	234	4	pressmarks
prestamps	15	4	353	4	prestam_ps
prests	8	40	2127	4	pres____ts
presumable	16	4	520	4	presumable
presumably	19	5	388	4	presumably
presume	11	3	1030	4	presu_m__e
presumed	13	3	797	4	presu_m_ed
presumedly	18	5	254	4	presumedly
presumer	12	4	758	4	presu_m_er
presumption	17	15	418	4	presumption
presumptions	18	15	389	4	presumptions
presumptive	20	6	307	4	presumptive
presurveys	18	4	255	4	presurveys
preterits	11	4	1098	4	pre_terits
pretermit	13	4	713	4	pretermit_
preunite	10	3	957	4	pre_u_nite
preunites	11	3	893	4	pre_u_nites
previsits	14	4	681	4	pre_visits
prismoids	14	4	363	4	pris_moids
psammite	14	4	298	4	p__sammite
psammites	15	4	284	4	p__sammites
pursuits	10	4	504	4	pursu__its
readmits	11	3	665	4	_re_admits
recommit	14	4	555	4	_recommit_
reemits	9	6	1130	4	_re__emits
remits	8	56	2295	4	_re___mits
reoutfits	12	8	199	4	_reoutfits
resits	6	47	2558	4	_res___its
resmelts	10	4	614	4	_res_melts
resplits	10	3	773	4	_res_plits
results	7	3	983	4	_resu__lts
resumers	10	3	808	4	_resu_mers
resumes	9	3	1337	4	_resu_m_es
resuming	11	3	1008	4	_resu_ming
resummon	12	4	223	4	_resumm_on
rummies	11	32	1279	4	_r__ummies
submits	11	3	975	4	___submits
summit	10	3	1154	4	___summit_

Search took 33 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	161450	2.910	61405.8
2	DLD Change Limit	161450	87	29.013	5564.7
3	Display Results	87	87	0.046	1891.3
	(SQL Overall)	178691	87	31.969	5589.5