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

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

65 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
marchionesses	20	5	236	(None)
marchioness	18	4	273	2	marchione_s_s
marshinesses	17	4	496	2	marshi_nesses
achinesses	15	3	930	3	_a_chi_nesses
archnesses	15	4	717	3	_arch__nesses
earthinesses	15	4	582	3	earthi_nesses
patchinesses	19	4	436	3	patchi_nesses
starchinesses	18	4	321	3	starchi_nesses
acidnesses	13	3	725	4	_a_c_idnesses
acridnesses	14	4	578	4	_a_cridnesses
anchoresses	16	5	380	4	_anch_oresses
archdioceses	20	6	162	4	_archdioce_ses
aridnesses	11	3	993	4	_ar__idnesses
artinesses	10	8	1521	4	_ar_ti_nesses
artsinesses	11	3	871	4	_artsi_nesses
ashinesses	13	3	916	4	_a_shi_nesses
baronesses	12	3	891	4	bar___onesses
bitchinesses	19	4	352	4	bitchi_nesses
chicnesses	17	4	521	4	___chicnesses
earlinesses	11	3	1104	4	ear_li_nesses
earthlinesses	16	4	391	4	earthlinesses
earwitnesses	15	4	378	4	ear_witnesses
fancinesses	16	3	814	4	fanc_i_nesses
gauchenesses	18	4	332	4	gauch_enesses
graphicnesses	21	5	184	4	graphicnesses
hardinesses	15	11	1022	4	har_di_nesses
harshnesses	17	4	585	4	harsh__nesses
itchinesses	16	4	461	4	_itchi_nesses
lacinesses	12	3	1212	4	la_c_i_nesses
larkinesses	15	3	899	4	lar_ki_nesses
machineries	18	5	379	4	ma_chi_neries
maltinesses	13	3	1023	4	ma_lti_nesses
manginesses	14	9	959	4	ma_ngi_nesses
manlinesses	13	9	1019	4	ma_nli_nesses
marionettes	13	5	300	4	mar__ionettes
markednesses	19	4	418	4	mar_kednesses
marshiness	15	5	506	4	marshi_ne_s_s
massinesses	12	12	869	4	ma_ssi_nesses
matinesses	12	3	1454	4	ma__ti_nesses
mazinesses	21	3	992	4	ma__zi_nesses
merrinesses	13	5	826	4	mer_ri_nesses
mirinesses	12	15	1231	4	mir__i_nesses
morbidnesses	17	4	397	4	mor_bidnesses
muchnesses	17	4	471	4	m_uch__nesses
murkinesses	17	13	678	4	mur_ki_nesses
mushinesses	16	12	732	4	m_ushi_nesses
paunchinesses	20	4	234	4	paunchi_nesses
racinesses	12	3	1351	4	ra_c_i_nesses
rancidnesses	15	4	488	4	ranc_idnesses
raunchinesses	18	4	263	4	raunchi_nesses
saucinesses	13	3	898	4	sauc_i_nesses
smarminesses	16	4	510	4	smar_mi_nesses
swarthinesses	19	4	345	4	swarthi_nesses
tacitnesses	13	3	632	4	ta_c_itnesses
tackinesses	17	3	725	4	ta_cki_nesses
tardinesses	12	11	1025	4	tar_di_nesses
tarrinesses	11	12	908	4	tar_ri_nesses
tartinesses	11	10	1150	4	tar_ti_nesses
tetchinesses	17	5	355	4	tetchi_nesses
touchinesses	17	4	424	4	touchi_nesses
trashinesses	15	4	611	4	trashi_nesses
wackinesses	20	3	665	4	wa_cki_nesses
warinesses	13	15	1452	4	war__i_nesses
washinesses	17	3	726	4	wa_shi_nesses
worthinesses	18	4	576	4	worthi_nesses

Search took 6 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	95024	0.340	525561.8
2	DLD Change Limit	95024	65	4.626	20541.3
3	Display Results	65	65	0.046	1413.0
	(SQL Overall)	178691	65	5.012	35652.6