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

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

58 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
prosperities	16	5	549	(None)
coprosperities	20	7	197	2	coprosperities
posterities	13	6	904	2	p_osterities
properties	14	14	1189	2	pro_per_ties
asperities	12	4	977	3	__asperities
prespecifies	21	5	293	3	prespecifies
propensities	16	5	526	3	pro_pensities
propertied	15	13	726	3	pro_per_tied
proprieties	15	5	618	3	pro_p_rieties
prosperity	17	5	451	3	prosperit__y
austerities	11	4	572	4	_austerities
disparities	14	4	679	4	_disparities
erosivities	14	5	591	4	eros_ivities
nonparities	13	4	858	4	_nonparities
phosphites	20	8	704	4	phosp_hit_es
phosphorites	22	5	469	4	phosphorit_es
piosities	11	3	1172	4	pios___ities
polarities	12	12	1177	4	p_o_larities
pomposities	17	6	571	4	p_omposities
poperies	12	3	1679	4	p_o_per__ies
porosities	12	4	1148	4	poros___ities
poverties	14	3	951	4	p_o_ver_ties
prespecified	22	5	259	4	prespecified
presterilizes	24	10	327	4	presterilizes
preterites	12	4	1180	4	pr_eterit_es
priorities	12	4	916	4	pr__iorities
probities	13	3	1265	4	pro___bities
proclivities	19	6	468	4	proclivities
profanities	16	7	625	4	pro_fanities
profundities	18	5	262	4	profundities
prolixities	20	4	636	4	pro_lixities
properdins	15	4	601	4	pro_per_dins
propylites	17	4	630	4	pro_pylit_es
proscribes	16	12	535	4	pros_cri_bes
prosecutes	14	4	567	4	pros_ecut_es
proselytes	15	4	474	4	pros_elyt_es
proselytise	16	5	275	4	pros_elytise
proselytises	17	5	281	4	pros_elytises
proselytizes	26	5	243	4	pros_elytizes
prospected	17	4	487	4	prospe_ct_ed
prospecting	18	4	585	4	prospe_cting
prospective	20	5	540	4	prospe_ctive
prospectors	17	5	458	4	prospe_ctors
prospects	15	4	510	4	prospe_ct__s
prospectus	16	4	341	4	prospe_ct_us
prospectuses	18	5	248	4	prospectuses
prospered	14	4	697	4	prosper___ed
prospering	15	4	717	4	prosper__ing
prosperous	14	4	548	4	prosper__ous
prospers	12	30	1226	4	prosper____s
prostatitis	13	5	587	4	prostatiti_s
prostatitises	15	5	382	4	prostatitises
prosties	10	14	2119	4	pros____ties
prostrates	12	4	1199	4	pros_trat_es
proximities	22	5	588	4	pro_ximities
respecifies	18	5	372	4	_respecifies
roperies	10	3	1577	4	_ro_per__ies
roseries	8	3	1732	4	_ros_er__ies

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.393	454684.5
2	DLD Change Limit	124790	58	7.373	16925.3
3	Display Results	58	58	0.033	1757.6
	(SQL Overall)	178691	58	7.799	22912.0