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

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

63 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
discrediting	17	5	321	(None)
accrediting	17	5	246	3	_accrediting
crediting	13	3	884	3	___crediting
discepting	16	5	847	3	disc_e_pting
discomfiting	21	5	314	3	discomfiting
discredit	13	4	536	3	discredit___
discredited	16	5	360	3	discredit_ed
discredits	14	5	377	3	discredit__s
disheriting	16	4	645	3	dis_heriting
miscreating	16	4	849	3	miscre_ating
misediting	14	4	657	3	mis__editing
coediting	13	3	833	4	___coediting
depredating	16	5	569	4	d_epredating
describing	16	4	507	4	descr__ibing
directing	13	3	881	4	di__re_cting
discanting	14	4	945	4	disc__anting
discarding	15	4	734	4	discard__ing
discerning	14	4	786	4	disc_e_rning
disciplining	18	5	338	4	disciplining
disclaiming	17	4	432	4	disc_laiming
discording	15	4	766	4	discord__ing
discounting	15	4	744	4	disc_ounting
discreditable	19	6	232	4	discreditable
discreditably	22	6	220	4	discreditably
discretion	13	4	752	4	discre__tion
discretions	14	4	722	4	discreti_ons
discriminating	20	6	395	4	discriminating
discrowning	18	4	380	4	discr_owning
disinheriting	18	5	347	4	disinheriting
disinviting	16	6	470	4	dis_inviting
disjecting	21	7	724	4	dis_je_cting
disordering	14	4	438	4	disor_dering
disorienting	14	15	565	4	disorienting
dispiriting	15	4	594	4	dis_piriting
dispraising	15	4	604	4	dispr_aising
dispreading	16	4	591	4	dispre_ading
disprizing	23	4	792	4	dispr__izing
disrating	11	7	1455	4	dis_r__ating
disrelishing	17	5	252	4	dis_relishing
disrooting	12	4	774	4	dis_r_ooting
disrupting	14	4	634	4	dis_r_upting
disseating	12	11	1178	4	dis_se_ating
dissecting	14	13	947	4	dis_se_cting
disseising	12	4	764	4	dis_se_ising
disseizing	21	4	700	4	dis_se_izing
dissenting	12	13	1029	4	dis_se_nting
dissertating	14	7	479	4	dissertating
disserting	12	13	1085	4	dis_se_rting
distracting	15	6	925	4	distr_acting
distraining	13	4	698	4	distr_aining
distressing	13	8	597	4	distre_ssing
distributing	16	5	474	4	distributing
districting	15	5	900	4	distr_icting
distrusting	13	8	649	4	distr_usting
disuniting	12	4	740	4	dis__uniting
misciting	14	3	967	4	misc___iting
misrelating	14	4	727	4	mis_relating
mistreating	14	4	928	4	mistre_ating
miswriting	16	4	684	4	miswr__iting
overediting	16	4	804	4	_overediting
postediting	15	5	445	4	pos_tediting
reaccrediting	19	6	148	4	reaccrediting
subediting	14	4	530	4	__subediting

Search took 7 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	63	6.593	18927.7
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	6.766	26410.1