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

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

71 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
distributing	16	5	474	(None)
distribution	15	5	536	2	distribution
distributions	16	6	512	2	distributions
distributive	18	5	372	2	distributive
districting	15	5	900	2	distri_cting
redistributing	18	6	267	2	redistributing
attributing	14	5	313	3	_attributing
contributing	17	5	430	3	contributing
destituting	13	15	516	3	dest_ituting
disorienting	14	15	565	3	disorienting
distracting	15	6	925	3	distr_acting
distributary	18	6	234	3	distributary
distribute	13	14	552	3	distribut__e
distributed	15	14	475	3	distribut_ed
distributee	14	12	492	3	distribut_ee
distributees	15	14	336	3	distributees
distributes	14	13	528	3	distribut_es
distributional	17	6	296	3	distributional
distributor	14	5	355	3	distribut_or
distributors	15	5	303	3	distributors
distrusting	13	8	649	3	distr_usting
misattributing	19	6	183	3	misattributing
abstricting	16	5	450	4	abstri_cting
astricting	13	5	783	4	_astri_cting
describing	16	4	507	4	describ__ing
destructing	15	4	611	4	destr_ucting
disabusing	14	4	461	4	dis__abusing
discrediting	17	5	321	4	discrediting
disfiguring	17	5	248	4	dis_figuring
disheriting	16	4	645	4	disheri__ting
disinhibiting	20	6	249	4	disinhibiting
disjointing	20	4	529	4	disjoi_nting
dispiriting	15	4	594	4	dis_piriting
disprizing	23	4	792	4	dispri__zing
disputing	13	3	776	4	dis___puting
disquieting	22	4	430	4	disqui_eting
disrating	11	7	1455	4	dis_r__ating
disrobing	13	4	770	4	dis_rob__ing
disrooting	12	4	774	4	dis_r_ooting
disrupting	14	4	634	4	dis_r_upting
dissipating	15	5	631	4	dis_sipating
distaining	12	4	890	4	distai__ning
distasting	12	4	802	4	dist__asting
distilling	12	4	779	4	dist_i_lling
distorting	12	3	958	4	dist__orting
distraining	13	4	698	4	distr_aining
distressing	13	8	597	4	distr_essing
distributaries	17	6	177	4	distributaries
distributively	23	6	225	4	distributively
distributivity	23	7	158	4	distributivity
disturbing	14	4	565	4	disturb__ing
disuniting	12	4	740	4	disuni__ting
divaricating	19	5	359	4	divaricating
instituting	12	4	480	4	inst_ituting
intriguing	12	4	510	4	_intrigu_ing
misorienting	15	15	496	4	misorienting
misprinting	16	4	682	4	mispri_nting
misrouting	13	4	722	4	mis_r_outing
mistreating	14	4	928	4	mistr_eating
mistrusting	14	6	592	4	mistr_usting
mistrysting	17	7	431	4	mistr_ysting
miswriting	16	4	684	4	miswri__ting
reattributing	16	9	211	4	reattributing
redistribution	17	17	348	4	redistribution
redistributions	18	22	340	4	redistributions
redistributive	20	7	238	4	redistributive
redistricting	17	5	378	4	redistri_cting
restituting	12	15	656	4	rest_ituting
restricting	14	4	930	4	restri_cting
striating	10	9	1419	4	__stri_ating
vestibuling	17	5	207	4	vest_ibuling

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.140	1276364.3
2	DLD Change Limit	124790	71	7.690	16227.6
3	Display Results	71	71	0.046	1543.5
	(SQL Overall)	178691	71	7.876	22688.0