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

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

83 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
presumption	17	15	417	(None)
presumptions	18	15	388	1	presumptions
resumption	14	12	473	1	_resumption
preemption	16	10	525	2	pre_emption
presumptive	20	6	306	2	presumptive
resumptions	15	15	459	2	_resumptions
assumption	14	8	302	3	_assumption
consumption	17	4	542	3	consumption
preemptions	17	13	485	3	pre_emptions
premunition	15	4	557	3	premunition
preoption	13	4	808	3	pre__option
prescription	18	14	534	3	prescription
presumptuous	18	7	95	3	presumptuous
redemption	15	4	388	3	_redemption
resorption	12	4	725	3	_resorption
subsumption	17	5	262	3	subsumption
ademption	14	4	349	4	ade__mption
assumptions	15	6	273	4	_assumptions
consumptions	18	4	514	4	consumptions
cremation	13	5	1164	4	cre__mation
crenulation	13	4	757	4	crenulation
desorption	13	4	622	4	_desorption
eruption	10	4	704	4	__eru_ption
exemption	20	6	494	4	__exemption
gumption	13	4	398	4	___gumption
irruption	11	4	378	4	ir_ru_ption
peculation	14	3	1199	4	p_eculation
perception	16	8	861	4	p_erception
permutation	15	4	747	4	permutation
persecution	15	6	478	4	persecution
personation	13	4	948	4	personation
persuasion	12	9	419	4	persu_asion
precaution	14	4	724	4	pre_caution
predation	12	3	1346	4	pre__dation
predication	16	4	1243	4	predication
prediction	15	4	1030	4	pre_diction
preelection	15	13	648	4	preelection
preempting	17	4	539	4	pre_empting
preemptive	19	4	414	4	pre_emptive
preemptor	15	4	415	4	pre_empt_or
preformation	19	4	647	4	preformation
preignition	14	5	443	4	preignition
prelection	14	15	1129	4	pre_lection
prelibation	15	12	866	4	prelibation
prelusion	11	5	660	4	prelu__sion
premonition	15	4	735	4	premonition
premunitions	16	4	498	4	premunitions
prenotion	11	4	917	4	pre__notion
prenuptial	14	5	339	4	prenu_ptial
preoptions	14	4	764	4	pre__options
preparation	15	4	927	4	preparation
preportion	14	4	887	4	pre_portion
preposition	15	10	858	4	preposition
prescriptions	19	13	533	4	prescriptions
preselection	16	15	488	4	preselection
presentation	14	4	899	4	presentation
preservation	17	7	628	4	preservation
presuming	14	3	766	4	presum__ing
presummit	15	5	313	4	presum_mi_t
presummits	16	5	234	4	presum_mits
presumptively	25	9	222	4	presumptively
presupposition	17	6	162	4	presupp~~osi~~tion
preunion	10	4	689	4	pre_u__nion
prevention	15	4	917	4	pre_vention
procuration	15	4	829	4	procuration
production	15	4	789	4	produ_ction
promotion	13	5	950	4	pr__omotion
proscription	18	12	451	4	proscription
prosecution	15	4	607	4	prosecution
prostration	13	4	1079	4	prostration
reception	13	4	1033	4	_re_ception
redemptions	16	4	373	4	_redemptions
reduction	12	5	990	4	_redu_ction
refutation	13	4	991	4	_refutation
regulation	11	3	1205	4	_regulation
remotion	10	4	1023	4	_re__motion
reputation	12	4	1188	4	_reputation
resection	11	16	1327	4	_res_ection
resolution	10	9	773	4	_resolution
resorptions	13	4	723	4	_resorptions
restation	9	3	1691	4	_res_tation
resummon	12	4	223	4	_resum__mon
subsumptions	18	5	261	4	subsumptions

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.453	394461.4
2	DLD Change Limit	148819	83	9.330	15950.6
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	9.829	18180.0