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

Here are the results of your fuzzy-string dictionary search for “firstnesses” with Change Limit: [1] [2] [3] [4]

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.

72 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
firstnesses	14	4	573	(None)
fastnesses	13	8	908	2	f_astnesses
firmnesses	15	3	561	2	fir_mnesses
firstness	12	4	501	2	firstne_s_s
fitnesses	12	21	937	2	fi__tnesses
airinesses	10	26	1361	3	air_inesses
biasnesses	12	3	696	3	bias_nesses
brisknesses	17	4	558	3	brisknesses
crispnesses	15	4	594	3	crispnesses
curtnesses	12	3	837	3	cur_tnesses
directnesses	15	9	528	3	directnesses
direnesses	11	3	1148	3	dir_enesses
dirtinesses	12	3	988	3	dirtinesses
distresses	11	4	885	3	di_stresses
ditsinesses	12	10	876	3	ditsinesses
faintnesses	14	4	714	3	faintnesses
fairnesses	13	5	738	3	fair__nesses
falsenesses	14	4	674	3	falsenesses
farnesses	12	23	1081	3	far__nesses
fatnesses	12	17	1046	3	f__atnesses
feistinesses	15	5	589	3	feistinesses
fiercenesses	17	4	431	3	fiercenesses
fierinesses	14	3	923	3	fierinesses
filminesses	16	3	623	3	filminesses
finenesses	13	3	1071	3	fi_nenesses
finesses	11	19	1234	3	fi___nesses
finitenesses	15	5	772	3	finitenesses
fishinesses	17	10	724	3	fishinesses
fixednesses	22	4	485	3	fixednesses
flatnesses	13	3	776	3	f_latnesses
fleetnesses	14	4	548	3	fleetnesses
flimsinesses	17	4	399	3	flimsinesses
flushnesses	17	4	538	3	flushnesses
forkinesses	18	4	800	3	forkinesses
fortresses	13	4	566	3	for_tresses
freenesses	13	3	987	3	f_reenesses
freshnesses	17	4	610	3	freshnesses
friskinesses	19	4	477	3	friskinesses
frostinesses	15	4	653	3	frostinesses
furrinesses	14	3	718	3	furrinesses
fussinesses	13	12	694	3	fussinesses
fustinesses	14	12	978	3	f_ustinesses
gastnesses	11	12	914	3	_gastnesses
harshnesses	17	4	585	3	harshnesses
hirsutenesses	16	5	359	3	hirsutenesses
horsinesses	14	3	955	3	horsinesses
iratenesses	11	4	1144	3	_iratenesses
ironnesses	10	4	783	3	_ironnesses
justnesses	17	3	649	3	_justnesses
licitnesses	13	4	641	3	licitnesses
lightnesses	15	4	614	3	lightnesses
lostnesses	10	4	930	3	_lostnesses
mirinesses	12	15	1231	3	mir_inesses
mistinesses	13	13	1062	3	mi_stinesses
mistresses	12	4	799	3	mi_stresses
moistnesses	13	4	715	3	moistnesses
pastnesses	12	9	1051	3	_pastnesses
pertnesses	12	3	1031	3	per_tnesses
pursinesses	13	3	874	3	pursinesses
rightnesses	15	4	623	3	rightnesses
sissinesses	9	11	831	3	sissinesses
sissynesses	12	12	342	3	sissynesses
tartnesses	10	11	1071	3	tar_tnesses
tersenesses	11	4	904	3	tersenesses
thirstinesses	16	4	258	3	thirstinesses
tightnesses	15	6	558	3	tightnesses
tipsinesses	13	3	636	3	tipsinesses
tirednesses	12	4	774	3	tirednesses
vastnesses	13	12	820	3	_vastnesses
wirinesses	13	18	1152	3	wir_inesses
wisenesses	13	3	1082	3	wi_senesses
witnesses	12	21	992	3	wi__tnesses

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	121633	0.406	440125.6
2	DLD Change Limit	121633	72	4.406	27606.2
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	4.858	36782.8