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

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

56 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
accountancies	16	7	190	(None)
accountancy	17	6	192	3	accountanc__y
accountants	15	5	283	3	accountan__ts
acceptances	16	5	317	4	acc_eptanc_es
accompanies	19	5	337	4	acco_mpan_ies
accordances	15	5	319	4	acco_rdanc_es
accountable	17	5	297	4	accounta_ble_
accountant	14	5	354	4	accountan___t
accountantships	24	13	104	4	accountantships
accountings	16	5	254	4	accountin__gs
accuracies	13	5	351	4	acc_u_ra_cies
acutances	13	4	576	4	a_c_u_tanc_es
adjutancies	21	5	196	4	a_dju_tancies
ascendancies	17	11	262	4	asc_endancies
constancies	15	4	664	4	__constancies
inconstancies	17	6	339	4	inconstancies
occupancies	16	5	207	4	occ_u_pancies
absorbancies	18	5	219	5	abso_rbancies
absorptances	18	6	167	5	absorptanc_es
abundances	15	4	331	5	a__bundanc_es
acceptance	15	5	325	5	acc_eptanc_e_
accompanied	20	5	227	5	acco_mpan_ied
accordance	14	5	335	5	acco_rdanc_e_
accountability	23	6	261	5	accountability
accountableness	21	6	183	5	accountableness
accountably	20	5	236	5	accounta__bly
accountantship	23	10	105	5	accountantship
accounted	14	4	482	5	account____ed
accounting	15	4	492	5	account___ing
accounts	12	8	584	5	account_____s
accoutres	13	4	438	5	accou_t___res
acquaintances	26	6	80	5	acquaintanc_es
acquittances	25	6	150	5	acquittanc_es
acutance	12	4	630	5	a_c_u_tanc_e_
apostacies	14	4	560	5	a_po_sta_cies
arrogancies	14	5	407	5	arro__gancies
ascendances	16	12	383	5	asc_endanc_es
ascendencies	17	10	308	5	asc_endencies
assonances	12	4	391	5	asso_n_anc_es
attractancies	17	6	130	5	attractancies
backcountries	23	6	114	5	backcount__ries
consultancies	17	8	265	5	consultancies
cotenancies	15	4	507	5	__cotenancies
countenances	16	5	573	5	__countenanc_es
countercries	16	4	899	5	__countercries
counties	10	3	1628	5	__count___ies
countries	11	3	1361	5	__count__ries
exultancies	20	14	245	5	__exultancies
importancies	18	5	327	5	impo_rtancies
oscitancies	15	5	288	5	osc__itancies
recusancies	15	5	354	5	rec_u_sancies
redundancies	16	5	195	5	_redundancies
reluctancies	16	12	245	5	_reluctancies
sycophancies	24	5	248	5	syco_phancies
upcountries	15	5	201	5	upcount__ries
viscountcies	19	6	208	5	viscount__cies

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.390	458182.1
2	DLD Change Limit	124790	56	8.236	15151.8
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	8.656	20643.6