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

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

125 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
prosecution	15	4	607	(None)
prosecutions	16	4	561	1	prosecutions
persecution	15	6	478	2	persecution
projection	21	5	876	2	projec_tion
prosecuting	16	4	502	2	prosecuting
prosecutor	14	4	441	2	prosecut_or
protection	14	5	1147	2	protec_tion
consecution	15	4	731	3	consecution
persecutions	16	5	479	3	persecutions
precaution	14	4	724	3	pr__ecaution
prelection	14	15	1129	3	prelec_tion
proaction	13	4	1010	3	pro_ac_tion
production	15	4	789	3	produc_tion
projections	22	5	847	3	projec_tions
prosecting	15	18	981	3	prosec_ting
prosector	13	20	853	3	prosec_t_or
prosecute	13	4	595	3	prosecut__e
prosecuted	15	4	428	3	prosecut_ed
prosecutes	14	4	566	3	prosecut_es
prosecutors	15	6	446	3	prosecutors
prostitution	14	5	460	3	prostitution
prostration	13	4	1079	3	prostration
protections	15	5	1070	3	protec_tions
provocation	18	4	735	3	provocation
resection	11	16	1327	3	_resec_tion
trisection	12	4	598	3	trisec_tion
bisection	13	13	698	4	_bisec_tion
bolection	13	11	767	4	_bolec_tion
consecutions	16	4	705	4	consecutions
correction	14	4	881	4	correc_tion
dissection	13	15	861	4	dissec_tion
elocution	11	4	567	4	elo__cution
erection	10	21	1551	4	er__ec_tion
execution	18	4	630	4	__execution
exsection	18	4	749	4	_exsec_tion
locution	10	22	766	4	_lo__cution
midsection	15	4	443	4	midsec_tion
perfection	17	4	836	4	perfec_tion
persecuting	16	4	383	4	persecuting
persecutive	18	5	393	4	persecutive
persecutor	14	5	324	4	persecut_or
pollution	11	4	600	4	p_o_llution
position	10	9	1219	4	p_os__ition
precautions	15	4	655	4	pr__ecautions
precision	13	4	1005	4	pr__ecision
preclusion	14	4	521	4	pr__eclusion
predation	12	3	1346	4	pr__edation
predication	16	4	1243	4	predication
prediction	15	4	1030	4	predic_tion
preelection	15	13	648	4	preelec_tion
preemption	16	10	525	4	pr_eemption
prelections	15	12	1047	4	prelec_tions
prelusion	11	5	660	4	pr__elusion
prenotion	11	4	917	4	pr__enotion
preoption	13	4	808	4	pr__eoption
preselection	16	15	488	4	preselection
presentation	14	4	899	4	presentation
preservation	17	7	628	4	preservation
presumption	17	15	417	4	presumption
preunion	10	4	689	4	pr__e_union
prevention	15	4	917	4	preve_ntion
proabortion	15	5	316	4	proabortion
proactions	14	4	934	4	pro_ac_tions
probation	13	4	1218	4	pro__bation
procession	14	4	841	4	proce_ssion
procreation	15	4	795	4	procreation
procuration	15	4	829	4	procuration
productions	16	4	753	4	produc_tions
profanation	16	18	610	4	profanation
profession	15	4	659	4	profe_ssion
profusion	14	4	570	4	pro__fusion
progestin	12	4	842	4	proge_sti_n
prohibition	18	5	426	4	prohibition
projectile	21	4	455	4	projec_tile
projecting	22	17	724	4	projec_ting
projectional	23	5	542	4	projec_tional
projective	24	4	681	4	projec_tive
projector	20	18	668	4	projec_t_or
prolactin	13	4	777	4	prolac_ti_n
prolocutor	14	5	307	4	prolocut_or
prolusion	11	4	636	4	pro__lusion
promotion	13	5	950	4	pro__motion
pronation	11	4	1570	4	pro__nation
propagation	16	4	644	4	propagation
proportion	14	4	899	4	pro_portion
proposition	15	8	874	4	proposition
proration	11	4	1598	4	pro__ration
prorogation	14	4	739	4	prorogation
prosciutto	14	5	207	4	prosciutto_
prosciuttos	15	5	177	4	prosciuttos
proscription	18	12	451	4	proscription
prosect	11	3	1339	4	prosec_t___
prosected	14	15	863	4	prosec_t_ed
prosectors	14	19	912	4	prosec_tors
prosects	12	3	947	4	prosec_t__s
prosecutable	18	5	179	4	prosecutable
prosecutorial	17	6	249	4	prosecutorial
proselyting	17	4	390	4	proselyting
proselytise	16	5	275	4	proselytise
proselytism	18	5	255	4	proselytism
proselytize	25	5	262	4	proselytize
prospecting	18	4	585	4	prospec_ting
prospective	20	5	540	4	prospec_tive
prospector	16	4	436	4	prospec_t_or
prostitutions	15	5	425	4	prostitutions
prostrations	14	4	976	4	prostrations
protecting	15	19	1021	4	protec_ting
protective	17	4	842	4	protec_tive
protector	13	16	953	4	protec_t_or
protestation	14	5	636	4	protestation
protonation	13	5	1043	4	protonation
protraction	15	4	721	4	protraction
protrusion	12	5	435	4	pro_trusion
prounion	10	4	682	4	pro___union
provocations	19	5	687	4	provocations
recaution	11	4	809	4	_r__ecaution
refection	14	15	1228	4	_refec_tion
rejection	18	17	1025	4	_rejec_tion
resections	12	15	1303	4	_resec_tions
resolution	10	9	773	4	_resolution
section	9	25	1566	4	___sec_tion
subsection	14	9	678	4	subsec_tion
trajection	19	4	469	4	trajec_tion
transection	13	5	737	4	transec_tion
trisections	13	4	564	4	trisec_tions

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.423	422437.4
2	DLD Change Limit	148819	125	9.220	16140.9
3	Display Results	125	125	0.060	2083.3
	(SQL Overall)	178691	125	9.703	18416.1