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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

159 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
preelection	15	13	648	(None)
prelection	14	15	1129	1	pr_election
preselection	16	15	488	1	preselection
reelection	12	19	863	1	_reelection
predilection	17	5	410	2	predilection
preelecting	16	4	647	2	preelecting
prelections	15	12	1047	2	pr_elections
preselections	17	14	444	2	preselections
reelections	13	16	794	2	_reelections
reflection	15	16	899	2	_reflection
deflection	16	14	773	3	_deflection
dereliction	14	4	457	3	dereliction
election	10	20	1535	3	___election
nonelection	13	4	720	3	nonelection
perfection	17	4	836	3	p_erfection
postelection	16	5	455	3	postelection
praelecting	16	4	453	3	praelecting
prediction	15	4	1030	3	pr_ediction
predilections	18	5	356	3	predilections
preelect	12	4	964	3	preelect___
preelected	15	4	578	3	preelect_ed
preelectric	17	5	351	3	preelectric
preelects	13	5	608	3	preelect__s
preemption	16	10	525	3	pree_mption
preerecting	16	4	614	3	preerecting
prelecting	15	3	1016	3	pr_electing
prelector	13	4	809	3	pr_elect_or
preselecting	17	4	429	3	preselecting
prevention	15	4	917	3	pr_evention
projection	21	5	876	3	pr_ojection
protection	14	5	1147	3	pr_otection
reelecting	13	3	878	3	_reelecting
refection	14	15	1228	3	_r_efection
reflections	16	17	855	3	_reflections
rejection	18	17	1025	3	_r_ejection
reliction	11	3	1069	3	_r_eliction
repletion	11	4	769	3	_reple_tion
resection	11	16	1327	3	_r_esection
selection	11	3	1127	3	__selection
bilection	13	15	680	4	__bilection
bolection	13	11	767	4	__bolection
collection	14	4	820	4	_collection
crenelation	13	4	685	4	crenel_ation
crenellation	14	5	391	4	crenellation
defection	15	16	1064	4	__defection
deflections	17	18	732	4	_deflections
dejection	19	17	866	4	__dejection
deletion	9	20	1197	4	__dele_tion
depletion	12	5	666	4	_deple_tion
derelictions	15	4	433	4	derelictions
detection	12	13	1041	4	__detection
ejection	17	25	1004	4	___ejection
elections	11	24	1497	4	___elections
electron	10	26	1141	4	___electron
erection	10	21	1551	4	___erection
evection	13	19	1083	4	___evection
exsection	18	4	749	4	__exsection
flection	13	23	956	4	___flection
inflection	15	4	763	4	_inflection
intellection	14	6	617	4	intellection
lection	9	26	1486	4	____lection
nonelections	14	5	639	4	nonelections
peltation	11	3	1296	4	p__eltation
perception	16	8	861	4	p_erception
perennation	13	4	808	4	perennation
perfections	18	4	814	4	p_erfections
permeation	14	4	1056	4	p_ermeation
persecution	15	6	478	4	p_ersecution
plectron	12	22	802	4	p___lectron
praelect	12	4	753	4	praelect___
praelected	15	4	439	4	praelect_ed
praelects	13	5	435	4	praelect__s
precaution	14	4	724	4	pr_ecaution
precession	14	4	882	4	pr_ecession
preclusion	14	4	521	4	precl_usion
predation	12	3	1346	4	pr_e_dation
predication	16	4	1243	4	predication
predictions	16	4	965	4	pr_edictions
predigestion	16	7	382	4	predigestion
preemptions	17	13	485	4	pree_mptions
preenacting	16	12	537	4	preenacting
preerect	12	5	927	4	preerect___
preerected	15	4	557	4	preerect_ed
preerects	13	4	541	4	preerect__s
prehension	15	4	631	4	pr_ehension
preignition	14	5	443	4	preignition
preinduction	17	5	378	4	preinduction
prelect	11	10	1383	4	pr_elect___
prelected	14	3	913	4	pr_elect_ed
prelectors	14	4	787	4	pr_electors
prelects	12	9	972	4	pr_elect__s
prelibation	15	12	866	4	prelibation
prelusion	11	5	660	4	pr_el_usion
premonition	15	4	735	4	premonition
premunition	15	4	557	4	premunition
prenotion	11	4	917	4	pr_e_notion
preoption	13	4	808	4	pr_e_option
preparation	15	4	927	4	preparation
preportion	14	4	887	4	pr_eportion
preposition	15	10	858	4	preposition
prerecession	16	8	357	4	prerecession
preselect	13	4	698	4	preselect___
preselected	16	4	396	4	preselect_ed
preselects	14	6	436	4	preselect__s
presentation	14	4	899	4	presentation
preservation	17	7	628	4	preservation
presumption	17	15	417	4	presumption
pretelevision	18	7	76	4	pretelevision
pretension	12	4	753	4	pr_etension
preventions	16	4	853	4	pr_eventions
proaction	13	4	1010	4	pr__oaction
procreation	15	4	795	4	procreation
production	15	4	789	4	pr_oduction
projections	22	5	847	4	pr_ojections
prolactin	13	4	777	4	pr_olacti_n
prosecution	15	4	607	4	pr_osecution
protections	15	5	1070	4	pr_otections
protraction	15	4	721	4	protraction
reaction	10	6	1260	4	_r_e_action
reception	13	4	1033	4	_r_eception
recollection	16	5	485	4	_recollection
recreation	12	4	1361	4	_recreation
redaction	12	5	966	4	_r_edaction
redirection	14	4	605	4	_redirection
reduction	12	5	990	4	_r_eduction
reedition	10	4	783	4	_ree_dition
reeducation	14	4	593	4	_reeducation
reejecting	20	4	581	4	_reejecting
reelect	9	115	1563	4	_reelect___
reelected	12	3	831	4	_reelect_ed
reelects	10	31	1088	4	_reelect__s
reerecting	13	3	997	4	_reerecting
refections	15	18	1164	4	_r_efections
reflation	12	4	1233	4	_refl_ation
reflecting	16	3	882	4	_reflecting
reflectional	17	5	399	4	_reflectional
reflective	18	5	712	4	_reflective
reflector	14	4	573	4	_reflect_or
reflexion	19	4	361	4	_refle_xion
refraction	15	13	790	4	_refraction
reinfection	16	4	544	4	_reinfection
reinjection	20	4	458	4	_reinjection
rejections	19	15	1010	4	_r_ejections
relation	8	26	1977	4	_r_el_ation
relegation	11	6	1002	4	_relegation
relictions	12	3	1002	4	_r_elictions
relocation	12	3	1211	4	_r_elocation
repletions	12	4	747	4	_reple_tions
replication	15	7	1201	4	_replication
resections	12	15	1303	4	_r_esections
reselecting	14	4	602	4	_reselecting
retention	9	16	1148	4	_r_etention
retraction	12	13	1053	4	_retraction
revelation	13	4	1092	4	_revel_ation
selections	12	3	1087	4	__selections
trajection	19	4	469	4	tr_ajection
transection	13	5	737	4	transection
trisection	12	4	598	4	tr_isection
venesection	16	5	294	4	venesection

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.440	406115.9
2	DLD Change Limit	148819	159	8.750	17007.9
3	Display Results	159	159	0.076	2092.1
	(SQL Overall)	178691	159	9.266	19284.6