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

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

68 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
earnestnesses	13	5	366	(None)
earnestness	11	5	281	2	earnestne_s_s
earwitnesses	15	4	378	3	ear_witnesses
erectnesses	13	4	747	3	e_r_ectnesses
fearlessnesses	16	6	674	3	fearlessnesses
learnednesses	14	4	364	3	learne_dnesses
abjectnesses	23	5	256	4	_abjectnesses
adeptnesses	14	4	483	4	_a_deptnesses
airlessnesses	12	11	799	4	airlessnesses
alertnesses	11	4	723	4	_a_lertnesses
ancestresses	14	9	327	4	_ancestresses
antsinesses	11	4	875	4	_a_ntsinesses
artlessnesses	12	4	766	4	_artlessnesses
artsinesses	11	3	871	4	_ar_tsinesses
augustnesses	13	5	268	4	_augustnesses
barenesses	12	3	1170	4	bar_e__nesses
barrennesses	14	4	343	4	barre_nnesses
beardednesses	17	4	414	4	bearde_dnesses
bearishnesses	18	4	484	4	bear_ishnesses
carelessnesses	15	4	772	4	carelessnesses
correctnesses	17	5	421	4	correctnesses
currentnesses	15	5	299	4	currentnesses
directnesses	15	9	528	4	dir_ectnesses
eagernesses	12	4	698	4	ea_ge_rnesses
earlinesses	11	3	1104	4	ear__linesses
earthinesses	15	4	582	4	ear_thinesses
earthlinesses	16	4	391	4	earthlinesses
easinesses	10	3	1444	4	ea___sinesses
endlessnesses	13	5	676	4	endlessnesses
expertnesses	21	4	484	4	e_xpertnesses
faintnesses	14	4	714	4	fain__tnesses
fastnesses	13	8	908	4	fa___stnesses
firstnesses	14	4	573	4	fir__stnesses
freshnesses	17	4	610	4	_fr_eshnesses
garishnesses	16	4	588	4	gar_ishnesses
gastnesses	11	12	914	4	ga___stnesses
gauntnesses	12	4	517	4	gaun__tnesses
greatnesses	12	4	779	4	_gr_eatnesses
hairlessnesses	16	12	663	4	hairlessnesses
haplessnesses	17	4	725	4	haplessnesses
harmlessnesses	18	7	641	4	harmlessnesses
harshnesses	17	4	585	4	har__shnesses
headlessnesses	17	13	706	4	headlessnesses
heartlessnesses	17	6	577	4	heartlessnesses
hornednesses	16	4	551	4	horne_dnesses
hornlessnesses	16	5	627	4	hornlessnesses
ineptnesses	13	9	638	4	__ineptnesses
inertnesses	11	9	872	4	__inertnesses
largenesses	12	4	755	4	large__nesses
lawlessnesses	15	4	638	4	lawlessnesses
mannishnesses	18	7	396	4	mannishnesses
markednesses	19	4	418	4	marke_dnesses
neatnesses	10	3	1001	4	___neatnesses
ornerinesses	12	4	657	4	_ornerinesses
painlessnesses	15	4	674	4	painlessnesses
pastnesses	12	9	1051	4	pa___stnesses
peartnesses	13	3	874	4	pear___tnesses
perfectnesses	20	5	335	4	perfectnesses
prestresses	13	4	672	4	_pr_estresses
priestesses	13	10	427	4	_priest_esses
rarenesses	10	3	1311	4	rar_e__nesses
raylessnesses	15	4	650	4	raylessnesses
restresses	10	4	931	4	__r_estresses
sanenesses	10	4	1269	4	sa_ne__nesses
saplessnesses	13	4	727	4	saplessnesses
seamlessnesses	14	4	697	4	seamlessnesses
tartnesses	10	11	1071	4	tar___tnesses
vastnesses	13	12	820	4	va___stnesses

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.360	496363.9
2	DLD Change Limit	95024	68	5.300	17929.1
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	5.690	31404.4