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

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

64 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
promotion	13	5	950	(None)
promotions	14	4	878	1	promotions
prenotion	11	4	917	2	prenotion
proaction	13	4	1010	2	proaction
probation	13	4	1218	2	probation
promoting	14	3	992	2	promoting
promotional	15	5	563	2	promotional
promotive	16	4	803	2	promotive
pronation	11	4	1570	2	pronation
proportion	14	4	899	2	proportion
proration	11	4	1598	2	proration
remotion	10	4	1023	2	_remotion
amotion	9	7	1047	3	__amotion
commotion	15	7	698	3	commotion
cremation	13	5	1164	3	cremation
demotion	11	6	907	3	_demotion
emotion	9	7	1130	3	__emotion
formation	14	3	942	3	formation
locomotion	14	5	259	3	locomotion
motion	8	52	1755	3	___motion
palmation	13	3	1022	3	palmation
peroration	12	3	1600	3	peroration
phonation	14	3	939	3	phonation
portion	9	6	1549	3	p_o_rtion
position	10	9	1219	3	p_osition
potation	10	17	1678	3	p_otation
potion	8	45	1957	3	p___otion
predation	12	3	1346	3	predation
preemption	16	10	525	3	preemption
premonition	15	4	735	3	premonition
prenotions	12	4	829	3	prenotions
preoption	13	4	808	3	preoption
preportion	14	4	887	3	preportion
privation	14	3	1117	3	privation
proabortion	15	5	316	3	proabortion
proactions	14	4	934	3	proactions
probations	14	3	1108	3	probations
production	15	4	789	3	production
profusion	14	4	570	3	profusion
projection	21	5	876	3	projection
prolusion	11	4	636	3	prolusion
promodern	14	4	413	3	promodern
promoing	13	3	1046	3	promo_ing
promote	11	3	1314	3	promot__e
promoted	13	3	1054	3	promot_ed
promoter	12	3	1145	3	promot_er
promoters	13	3	1009	3	promoters
promotes	12	3	1412	3	promot_es
prompting	16	3	720	3	prompting
pronations	12	3	1403	3	pronations
proportions	15	4	846	3	proportions
proposition	15	8	874	3	proposition
prorations	12	3	1446	3	prorations
prorogation	14	4	739	3	prorogation
protection	14	5	1147	3	protection
proton	8	43	1889	3	pr__ot_on
protonation	13	5	1043	3	protonation
protozoon	20	5	441	3	protozoon
prounion	10	4	682	3	pro_union
provision	14	4	763	3	provision
provocation	18	4	735	3	provocation
remotions	11	4	970	3	_remotions
rogation	9	16	1205	3	_rogation
rotation	8	16	1545	3	_rotation

Search took 9 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.470	380193.6
2	DLD Change Limit	148641	64	7.966	18659.4
3	Display Results	64	64	0.063	1015.9
	(SQL Overall)	178691	64	8.499	21024.9