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

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

85 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
disorienting	14	15	565	(None)
misorienting	15	15	496	1	misorienting
disorientating	16	8	270	2	disorientating
discontenting	17	5	507	3	discontenting
disjointing	20	4	529	3	disjoi_nting
disordering	14	4	438	3	disorde_ring
disorient	10	4	1252	3	disorient___
disorientate	13	6	338	3	disorientate
disoriented	13	5	526	3	disorient_ed
disorients	11	7	779	3	disorient__s
disquieting	22	4	430	3	disquie_ting
dissenting	12	13	1029	3	dis__senting
distributing	16	5	474	3	distributing
districting	15	5	900	3	distri_cting
misprinting	16	4	682	3	mispri_nting
orienting	10	3	872	3	___orienting
reorienting	12	4	635	3	_reorienting
deforesting	16	5	479	4	defor_esting
directing	13	3	882	4	di__r_ecting
disaffecting	22	5	293	4	disaffecting
disarranging	15	7	312	4	disarranging
disburdening	17	7	210	4	disburden_ing
discanting	14	4	945	4	dis__canting
discepting	16	5	847	4	dis__cepting
discommending	22	6	191	4	discommending
disconcerting	19	5	457	4	disconcerting
disconnecting	19	5	388	4	disconnecting
discounting	15	4	744	4	dis_counting
discrediting	17	5	321	4	discrediting
discriminating	20	6	395	4	discriminating
discrowning	18	4	380	4	discrown_ing
disdaining	13	4	599	4	disdai_n_ing
disgruntling	15	5	175	4	disgr_untling
disheriting	16	4	645	4	disheri__ting
disinfecting	19	5	469	4	disinfecting
disinfesting	17	5	443	4	disinfesting
disinvesting	17	5	420	4	disinvesting
disjecting	21	7	724	4	dis__jecting
disjoining	19	6	572	4	disjoi_n_ing
dislimning	14	4	488	4	dis_limn_ing
dismounting	15	4	508	4	dis_mounting
disobeying	17	4	380	4	diso_be_ying
disorganizing	25	5	263	4	disorganizing
disorientated	15	6	236	4	disorientated
disorientates	14	6	285	4	disorientates
disorientation	15	8	377	4	disorientation
disorientations	16	8	362	4	disorientations
disowning	14	4	611	4	diso__wn_ing
dispending	15	4	792	4	dis__pending
dispensing	14	4	823	4	dis__pensing
dispiriting	15	4	594	4	dis_piriting
displanting	15	4	604	4	dis_planting
disporting	14	3	982	4	dispor___ting
dispreading	16	4	591	4	dispr_eading
disprizing	23	4	792	4	dispri__zing
disrating	11	7	1455	4	dis_r__ating
disrooting	12	4	774	4	dis_r_ooting
disrupting	14	4	634	4	dis_r_upting
disseating	12	11	1178	4	dis__seating
dissecting	14	13	947	4	dis__secting
disserting	12	13	1085	4	dis__serting
dissipating	15	5	631	4	dis_sipating
dissociating	16	5	536	4	dissoci_ating
distaining	12	4	890	4	distai_n_ing
distending	13	4	833	4	dis__tending
distorting	12	3	958	4	distor___ting
distracting	15	6	925	4	distr_acting
distraining	13	4	698	4	distrain_ing
distressing	13	8	597	4	distr_essing
distrusting	13	8	649	4	distr_usting
disuniting	12	4	740	4	disuni__ting
divaricating	19	5	359	4	divaricating
imprinting	15	4	602	4	_impri_nting
miscreating	16	4	849	4	miscr_eating
misdirecting	18	5	324	4	misdirecting
misordering	15	4	403	4	misorde_ring
misorient	11	5	1089	4	misorient___
misoriented	14	5	394	4	misorient_ed
misorients	12	5	600	4	misorient__s
mispainting	16	4	529	4	mispai_nting
mispointing	16	4	579	4	mispoi_nting
mistreating	14	4	928	4	mistr_eating
miswriting	16	4	684	4	miswri__ting
sprinting	12	3	1003	4	__spri_nting
tormenting	13	4	569	4	__tormenting

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.406	440125.6
2	DLD Change Limit	124790	85	6.530	19110.3
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	6.982	25593.1