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

Here are the results of your fuzzy-string dictionary search for “discreditable” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

72 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
discreditable	19	6	232	(None)
discreditably	22	6	220	1	discreditably
accreditable	19	5	180	3	_accreditable
creditable	15	4	600	3	___creditable
discriminable	20	6	301	3	discriminable
disreputable	17	5	276	3	dis_reputable
creditably	18	4	454	4	___creditably
describable	18	5	301	4	descr__ibable
discardable	17	5	346	4	discard__able
discernable	16	5	445	4	disc_e_rnable
discernible	16	5	336	4	discerni__ble
disciplinable	20	7	281	4	disciplinable
discountable	17	5	385	4	disc_ountable
discredit	13	4	536	4	discredit____
discredited	16	5	360	4	discredit__ed
discrediting	17	5	321	4	discredit_ing
discredits	14	5	377	4	discredit___s
discriminably	23	6	280	4	discriminably
disreputably	20	6	243	4	dis_reputably
distractable	17	5	360	4	distr_actable
distrainable	15	5	363	4	distr_ainable
incredible	15	5	480	4	_incredi__ble
ascribable	16	4	348	5	_ascr__ibable
creatable	13	3	956	5	___cre_atable
credible	13	4	602	5	___credi__ble
deceivable	18	4	502	5	d_ec_e_ivable
decrepitate	16	9	309	5	d_ecrepita_te
depreciable	18	5	455	5	d_epreci_able
descendible	17	5	272	5	descendi__ble
differentiable	23	7	220	5	differentiable
disagreeable	16	6	216	5	disagre__eable
discernibly	19	5	273	5	discerni__bly
dischargeable	22	6	167	5	dischargeable
discomfortable	24	7	152	5	discomfortable
discoverable	20	11	330	5	disc_overable
discreetly	16	5	351	5	discre_et__ly
discrete	11	4	1028	5	discre__t___e
discretely	16	5	369	5	discre__t_ely
discriminate	17	16	480	5	discrimina_te
discussable	16	5	355	5	disc__ussable
discussible	16	5	338	5	discussi__ble
disenable	12	4	967	5	dis__e__nable
dislikable	17	4	432	5	dis___likable
dispensable	16	5	498	5	dis_pe_nsable
dispersible	16	5	440	5	dispersi__ble
disprovable	19	5	346	5	dispr__ovable
disputable	15	4	506	5	dis___putable
disrespectable	21	6	136	5	dis_respectable
disserviceable	22	11	80	5	disserviceable
dissociable	16	5	397	5	dis_soci_able
distractible	17	6	354	5	distr_actible
editable	11	3	1042	5	_____editable
escheatable	18	6	192	5	_esche_atable
extraditable	22	5	305	5	_extraditable
immedicable	20	5	321	5	_i_mmedicable
incitable	13	3	1043	5	_inc___itable
increasable	15	5	539	5	_incre_asable
incredibly	18	5	410	5	_incredi__bly
ineradicable	17	5	428	5	_ineradicable
inevitable	15	5	764	5	_i__nevitable
inheritable	16	4	724	5	_i_nheritable
inscrutable	15	5	467	5	inscr__utable
irradicable	16	18	407	5	_i_rradicable
irrefutable	16	5	398	5	_i_rrefutable
irritable	11	4	805	5	_i__r_ritable
predicable	17	4	719	5	___predicable
predictable	18	4	499	5	___predictable
screenable	14	4	370	5	__scre_enable
screwable	16	4	484	5	__scre__wable
scrutable	13	4	604	5	__scr__utable
unpredictable	20	5	295	5	_unpredictable
visitable	14	4	587	5	vis____itable

Search took 9 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.406	440125.6
2	DLD Change Limit	124790	72	8.516	14653.6
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	8.968	19925.4