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

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

117 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
prosecutions	16	4	561	(None)
prosecution	15	4	607	1	prosecution_
persecutions	16	5	479	2	persecutions
projections	22	5	847	2	projec_tions
prosecuting	16	4	502	2	prosecuti_ng
prosecutors	15	6	446	2	prosecut_ors
protections	15	5	1070	2	protec_tions
consecutions	16	4	705	3	consecutions
persecution	15	6	478	3	persecution_
precautions	15	4	655	3	pr__ecautions
prelections	15	12	1047	3	prelec_tions
proactions	14	4	934	3	pro_ac_tions
productions	16	4	753	3	produc_tions
projection	21	5	876	3	projec_tion_
prosecting	15	18	981	3	prosec_ti_ng
prosectors	14	19	912	3	prosec_t_ors
prosecutes	14	4	566	3	prosecut__es
prosecutor	14	4	441	3	prosecut_o_r
prostitutions	15	5	425	3	prostitutions
prostrations	14	4	976	3	prostrations
protection	14	5	1147	3	protec_tion_
provocations	19	5	687	3	provocations
resections	12	15	1303	3	_resec_tions
trisections	13	4	564	3	trisec_tions
bisections	14	13	673	4	_bisec_tions
bolections	14	13	729	4	_bolec_tions
consecution	15	4	731	4	consecution_
corrections	15	4	886	4	correc_tions
dissections	14	19	826	4	dissec_tions
elocutions	12	4	596	4	elo__cutions
erections	11	25	1521	4	er__ec_tions
executions	19	4	639	4	__executions
exsections	19	4	763	4	_exsec_tions
locutions	11	20	706	4	_lo__cutions
midsections	16	4	440	4	midsec_tions
perfections	18	4	814	4	perfec_tions
persecuting	16	4	383	4	persecuti_ng
persecutors	15	5	315	4	persecut_ors
pollutions	12	4	543	4	p_o_llutions
positions	11	8	1150	4	p_os__itions
precaution	14	4	724	4	pr__ecaution_
precisions	14	4	937	4	pr__ecisions
preclusions	15	4	466	4	pr__eclusions
predations	13	8	1215	4	pr__edations
predications	17	4	1118	4	predications
predictions	16	4	965	4	predic_tions
preemptions	17	13	485	4	pr_eemptions
prelection	14	15	1129	4	prelec_tion_
prelusions	12	5	637	4	pr__elusions
prenotions	12	4	829	4	pr__enotions
preoptions	14	4	764	4	pr__eoptions
preselections	17	14	444	4	preselections
presentations	15	4	813	4	presentations
preservations	18	9	554	4	preservations
presumptions	18	15	388	4	presumptions
preunions	11	4	648	4	pr__e_unions
preventions	16	4	853	4	preve_ntions
proaction	13	4	1010	4	pro_ac_tion_
probations	14	3	1108	4	pro__bations
processions	15	4	815	4	proce_ssions
procreations	16	4	727	4	procreations
procurations	16	4	740	4	procurations
production	15	4	789	4	produc_tion_
profanations	17	17	525	4	profanations
professions	16	4	663	4	profe_ssions
profusions	15	4	525	4	pro__fusions
progestins	13	4	866	4	proge_sti_ns
prohibitions	19	5	383	4	prohibitions
projectiles	22	4	380	4	projec_tiles
projecting	22	17	724	4	projec_ti_ng
projectional	23	5	542	4	projec_tional
projectionist	24	8	525	4	projec_tionist
projectors	21	18	717	4	projec_t_ors
prolactins	14	4	715	4	prolac_ti_ns
prolocutors	15	6	311	4	prolocut_ors
prolusions	12	4	588	4	pro__lusions
promotions	14	4	878	4	pro__motions
pronations	12	3	1403	4	pro__nations
propagations	17	4	555	4	propagations
proportions	15	4	846	4	pro_portions
propositions	16	10	831	4	propositions
prorations	12	3	1446	4	pro__rations
prorogations	15	5	672	4	prorogations
prosciuttos	15	5	177	4	prosciutto_s
proscriptions	19	11	416	4	proscriptions
prosector	13	20	853	4	prosec_t_o_r
prosects	12	3	947	4	prosec_t___s
prosecutable	18	5	179	4	prosecutable
prosecute	13	4	595	4	prosecut___e
prosecuted	15	4	428	4	prosecut__ed
proselyting	17	4	390	4	proselyti_ng
proselytises	17	5	281	4	proselytises
proselytisms	19	6	211	4	proselytisms
proselytizes	26	5	243	4	proselytizes
prospecting	18	4	585	4	prospec_ti_ng
prospectors	17	5	458	4	prospec_t_ors
prostitution	14	5	460	4	prostitution_
prostration	13	4	1079	4	prostration_
protecting	15	19	1021	4	protec_ti_ng
protectionism	19	8	494	4	protec_tionism
protectionist	17	11	668	4	protec_tionist
protectors	14	20	1014	4	protec_t_ors
protestations	15	5	581	4	protestations
protonations	14	4	907	4	protonations
protractions	16	4	664	4	protractions
protrusions	13	5	414	4	pro_trusions
provocation	18	4	735	4	provocation_
recautions	12	4	781	4	_r__ecautions
refections	15	18	1164	4	_refec_tions
rejections	19	15	1010	4	_rejec_tions
resection	11	16	1327	4	_resec_tion_
resolutions	11	11	779	4	_resolutions
sections	10	27	1470	4	___sec_tions
subsections	15	9	710	4	subsec_tions
trajections	20	4	451	4	trajec_tions
transections	14	4	676	4	transec_tions
trisection	12	4	598	4	trisec_tion_

Search took 8 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	124790	0.403	443402.0
2	DLD Change Limit	124790	117	7.126	17511.9
3	Display Results	117	117	0.063	1857.1
	(SQL Overall)	178691	117	7.592	23536.7