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

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

46 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
mercenarinesses	19	6	177	(None)
mercenariness	17	6	258	2	mercenarine_s_s
drearinesses	13	4	744	4	_dr_e_arinesses
mercenaries	15	5	544	4	mercenari____es
merrinesses	13	5	826	4	mer____rinesses
momentarinesses	19	7	234	4	m_omentarinesses
ordinarinesses	15	5	235	4	_ordinarinesses
secondarinesses	18	6	156	4	se_condarinesses
beerinesses	13	9	892	5	be__e__rinesses
blearinesses	14	4	654	5	__ble_arinesses
charinesses	16	3	956	5	___c_harinesses
circularnesses	18	6	141	5	circular_nesses
creakinesses	18	4	599	5	_cr_e_akinesses
creaminesses	16	4	613	5	_cr_e_aminesses
debonairnesses	17	7	144	5	de_bonairnesses
dreaminesses	15	4	571	5	_dr_e_aminesses
eerinesses	10	6	1260	5	_e__e__rinesses
freakinesses	19	4	559	5	_fr_e_akinesses
friendlinesses	18	5	221	5	_friendlinesses
greasinesses	13	4	704	5	_gr_e_asinesses
heavenlinesses	20	5	180	5	heaven_linesses
imaginarinesses	18	6	167	5	imaginarinesses
leerinesses	11	11	948	5	le__e__rinesses
literarinesses	14	8	335	5	_literarinesses
maidenlinesses	17	5	197	5	maiden_linesses
meagernesses	15	4	444	5	meage__r_nesses
mealinesses	13	3	1097	5	m___e_alinesses
meatinesses	13	3	1198	5	m___e_atinesses
mercerises	14	4	619	5	merce__ri___ses
mercifulnesses	21	5	427	5	merc_ifulnesses
mercilessnesses	18	10	453	5	mercilessnesses
mercurialnesses	19	8	143	5	mercurialnesses
ornerinesses	12	4	657	5	_or__nerinesses
pepperinesses	16	5	327	5	peppe__rinesses
readinesses	12	6	1127	5	__r_e_adinesses
recentnesses	14	6	537	5	re_cen__tnesses
scarinesses	13	3	990	5	__sc__arinesses
serenenesses	12	11	711	5	ser_en__enesses
streakinesses	17	4	363	5	str_e_akinesses
tearinesses	11	3	1169	5	___te_arinesses
temporarinesses	19	6	198	5	temporarinesses
threadinesses	17	5	334	5	thr_e_adinesses
trendinesses	13	4	632	5	_tr_en_dinesses
unreadinesses	14	8	458	5	unr_e_adinesses
visionarinesses	18	6	166	5	visionarinesses
wearinesses	14	3	1021	5	___we_arinesses

Search took 5 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	65874	0.313	570897.8
2	DLD Change Limit	65874	46	4.546	14490.5
3	Display Results	46	46	0.030	1533.3
	(SQL Overall)	178691	46	4.889	36549.6