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

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

87 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
subprocess	16	6	254	(None)
subprocesses	18	5	192	2	subprocesses
preprocess	16	4	405	3	preprocess
process	11	3	1040	3	___process
reprocess	13	4	593	3	_reprocess
subproblems	19	5	110	3	subproblems
subproject	23	5	243	3	subproject
subprojects	24	5	162	3	subprojects
subraces	12	3	1303	3	sub_race_s
suppress	12	3	644	3	suppr__ess
baroness	10	12	1006	4	__baroness
ibuprofens	17	5	73	4	ibuprofens
outpress	10	11	818	4	outpr__ess
outprices	13	3	762	4	outprice_s
overprocess	18	5	395	4	overprocess
precess	11	3	1086	4	___precess
profess	12	3	771	4	___profess
prowess	12	3	790	4	___prowess
saprobes	12	3	703	4	s_aprobe_s
sapropels	13	4	364	4	s_apropels
soberness	11	8	646	4	sober_ness
sprockets	17	4	325	4	s__prockets
spruces	11	38	1050	4	s__pruce_s
sprucest	12	29	578	4	s__prucest
spryness	13	3	400	4	s__pryness
subareas	10	3	862	4	subar__eas
subblocks	19	4	300	4	subbloc_ks
subbreeds	14	4	357	4	subbr_eeds
subcodes	13	3	814	4	sub_code_s
subduces	13	9	726	4	sub_duce_s
subepochs	18	5	182	4	subepoc_hs
suberises	11	8	1345	4	suberise_s
suberizes	20	8	1183	4	suberize_s
suberose	10	10	969	4	subero__se
suberous	10	3	1179	4	subero__us
subframes	16	4	585	4	subframe_s
subgrades	13	4	631	4	subgrade_s
subgroups	14	4	249	4	subgro_ups
subocean	12	4	480	4	sub__ocean
suborders	12	4	550	4	subor_ders
suborners	11	4	631	4	subor_ners
subpanels	13	4	439	4	subp_anels
subphases	16	4	575	4	subphase_s
subplots	12	5	577	4	subplo__ts
subpoena	12	4	470	4	subp_o_ena
subpoenas	13	4	441	4	subp_oenas
subpotent	13	4	621	4	subp_otent
subproblem	18	5	157	4	subproblem
subproduct	17	5	278	4	subproduct
subproducts	18	5	218	4	subproducts
subprogram	17	5	296	4	subprogram
subprograms	18	5	273	4	subprograms
subrace	11	3	1300	4	sub_race__
subrules	10	3	972	4	sub_rule_s
subspaces	15	4	567	4	subspace_s
subtleness	12	4	544	4	subtleness
subtones	10	3	1138	4	sub_tone_s
subtracters	15	7	380	4	subtracters
subtracts	13	4	636	4	subtrac_ts
subtribes	13	4	623	4	subtribe_s
subtropics	16	5	333	4	subtropics
subwoofers	18	5	157	4	subwoofers
subwriters	15	4	441	4	subwriters
subzones	19	4	722	4	sub_zone_s
success	11	4	640	4	su___ccess
sucroses	10	3	993	4	su_crose_s
sugarless	10	4	367	4	sugar_less
sulphones	14	4	606	4	sulphone_s
sultriness	10	4	556	4	sultriness
sundress	9	3	698	4	sundr__ess
sunporches	17	5	193	4	sunporches
superbness	14	4	666	4	superbness
suppleness	14	4	445	4	suppleness
supporters	14	4	409	4	supporters
supposers	13	4	453	4	su_pposers
supposes	12	3	820	4	su_ppose_s
suppresses	14	4	625	4	suppresses
supremes	12	3	836	4	su_preme_s
supremest	13	4	703	4	su_premest
sureness	8	9	1290	4	su__reness
surplices	13	4	604	4	surplice_s
surprisers	12	4	363	4	surprisers
surprises	11	3	743	4	surprise_s
surprizes	20	4	559	4	surprize_s
tuberoses	11	9	537	4	tuberose_s
unprocessed	16	5	284	4	_unprocessed
uprouses	10	3	755	4	_u_prouses

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	161450	0.436	409841.7
2	DLD Change Limit	161450	87	9.393	17188.3
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	9.859	18124.7