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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

150 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
sprucenesses	16	9	461	(None)
spruceness	14	4	410	2	sprucene_s_s
crudenesses	14	7	665	3	_crudenesses
primenesses	15	4	897	3	_primenesses
pronenesses	13	7	925	3	_pronenesses
purenesses	12	8	1072	3	_p_urenesses
rudenesses	11	8	886	3	__rudenesses
saucinesses	13	3	895	3	s_aucinesses
scarcenesses	16	4	449	3	scarcenesses
securenesses	14	4	566	3	securenesses
serenenesses	12	11	709	3	serenenesses
sorceresses	13	4	337	3	sor_ceresses
sorenesses	10	13	1348	3	sor__enesses
spacinesses	15	3	809	3	sp_acinesses
sparenesses	13	3	917	3	sp_arenesses
sparsenesses	13	4	580	3	sparsenesses
spicinesses	15	4	709	3	sp_icinesses
sprynesses	15	4	497	3	spr__ynesses
strictnesses	14	4	540	3	strictnesses
suchnesses	15	3	665	3	s__uchnesses
supremenesses	17	5	317	3	supremenesses
surenesses	10	12	1220	3	s__urenesses
truenesses	10	3	931	3	_tru_enesses
abruptnesses	16	5	261	4	abruptnesses
abstrusenesses	15	5	255	4	abstrusenesses
acutenesses	13	12	695	4	_acutenesses
archnesses	15	4	717	4	_ar_chnesses
astutenesses	12	4	558	4	astutenesses
barenesses	12	3	1169	4	bar__enesses
bluenesses	12	3	792	4	_blu_enesses
bravenesses	16	4	794	4	_bravenesses
choicenesses	19	4	466	4	choicenesses
cruelnesses	13	4	624	4	_cruelnesses
cutenesses	12	9	1087	4	__cutenesses
demurenesses	15	4	474	4	demurenesses
dilutenesses	13	4	610	4	dilutenesses
directnesses	15	9	526	4	directnesses
direnesses	11	3	1148	4	dir__enesses
duenesses	10	3	932	4	__du_enesses
erectnesses	13	4	744	4	_erectnesses
fiercenesses	17	4	429	4	fiercenesses
freenesses	13	3	986	4	_fr_eenesses
gauchenesses	18	4	331	4	_gauchenesses
gravenesses	15	4	816	4	_gravenesses
gruffnesses	18	4	292	4	_gruffnesses
hirsutenesses	16	5	356	4	hirsutenesses
hugenesses	14	3	713	4	__hugenesses
impurenesses	16	16	443	4	impurenesses
iratenesses	11	4	1140	4	_iratenesses
jejunenesses	18	5	262	4	jejunenesses
largenesses	12	4	755	4	lar_genesses
minutenesses	14	7	616	4	minutenesses
morenesses	12	8	1138	4	mor__enesses
morosenesses	14	4	685	4	morosenesses
muchnesses	17	4	469	4	__muchnesses
mutenesses	12	8	993	4	__mutenesses
nicenesses	12	3	1033	4	__nicenesses
nudenesses	11	5	785	4	__nudenesses
obtusenesses	14	4	503	4	obtusenesses
opaquenesses	23	5	295	4	opaquenesses
operosenesses	15	7	531	4	operosenesses
packnesses	18	5	662	4	_p_acknesses
palenesses	12	3	1265	4	_p_alenesses
planenesses	13	4	903	4	_planenesses
pluckinesses	20	4	398	4	_pluckinesses
plumbnesses	17	5	307	4	_plumbnesses
plumpnesses	17	5	326	4	_plumpnesses
plushnesses	16	4	557	4	_plushnesses
precesses	13	3	1046	4	_pr__ecesses
precisenesses	17	5	625	4	_precisenesses
primnesses	14	9	780	4	_pr_imnesses
processes	13	3	1023	4	_proc__esses
procuresses	15	4	381	4	_procuresses
profusenesses	18	11	386	4	_profusenesses
propernesses	16	4	500	4	_propernesses
prosinesses	13	3	1084	4	_prosinesses
proudnesses	14	4	748	4	_proudnesses
puninesses	12	11	1074	4	_p_uninesses
pursinesses	13	3	872	4	_pursinesses
racinesses	12	3	1349	4	__racinesses
rarenesses	10	3	1309	4	__rarenesses
richnesses	15	3	779	4	__richnesses
rifenesses	13	3	993	4	__rifenesses
ripenesses	12	3	1036	4	__ripenesses
safenesses	13	4	937	4	s__afenesses
sagenesses	11	5	1082	4	s__agenesses
samenesses	12	4	1085	4	s__amenesses
sanenesses	10	4	1269	4	s__anenesses
savagenesses	16	4	422	4	savagenesses
screwinesses	17	4	474	4	screwinesses
scruffinesses	21	5	156	4	scruffinesses
scurvinesses	17	4	392	4	scurvinesses
sedatenesses	13	4	694	4	sedatenesses
seductresses	15	5	204	4	seductresses
selectnesses	14	4	610	4	selectnesses
separatenesses	16	5	425	4	separatenesses
serriednesses	14	5	424	4	serriednesses
servilenesses	16	4	626	4	servilenesses
severenesses	15	4	558	4	severenesses
shrewdnesses	19	4	292	4	shrewdnesses
shrillnesses	15	4	349	4	shrillnesses
sicknesses	16	3	675	4	s__icknesses
simplenesses	16	4	561	4	simplenesses
singlenesses	13	4	609	4	singlenesses
slacknesses	17	4	523	4	s_lacknesses
slicknesses	17	4	518	4	s_licknesses
slouchinesses	18	4	280	4	slouchinesses
smugnesses	13	4	456	4	s_mu_gnesses
snidenesses	12	4	865	4	s_nidenesses
snubnesses	12	4	540	4	s_nu_bnesses
snugnesses	11	6	542	4	s_nu_gnesses
solenesses	10	4	1270	4	s__olenesses
sordidnesses	14	4	516	4	sordidnesses
sorrinesses	11	3	1008	4	sor_rinesses
soundnesses	12	4	752	4	s_oundnesses
sournesses	10	3	1001	4	s_ou_rnesses
speedinesses	15	4	559	4	speedinesses
spiffinesses	20	4	301	4	spiffinesses
spikinesses	17	4	652	4	sp_ikinesses
spininesses	13	5	845	4	sp_ininesses
spiritednesses	17	5	319	4	spiritednesses
sponginesses	15	4	477	4	sponginesses
spookinesses	18	4	409	4	spookinesses
sporogeneses	15	5	485	4	sporogene_ses
sportinesses	14	4	786	4	sportinesses
sportivenesses	19	5	627	4	sportivenesses
spottinesses	14	4	568	4	spottinesses
springinesses	16	10	406	4	springinesses
spunkinesses	18	4	438	4	spunkinesses
squarenesses	21	4	493	4	squarenesses
squatnesses	20	4	518	4	s_quatnesses
stablenesses	14	4	807	4	stablenesses
stalenesses	11	3	1108	4	s_talenesses
staunchnesses	18	5	146	4	staunchnesses
stoutnesses	11	4	697	4	stou_tnesses
straitnesses	12	4	620	4	straitnesses
strangenesses	14	5	495	4	strangenesses
sturdinesses	13	4	579	4	sturdinesses
suavenesses	14	4	839	4	s_uavenesses
subtlenesses	14	8	524	4	subtlenesses
successes	13	4	564	4	s__uc_cesses
supinenesses	14	4	599	4	supinenesses
supplenesses	16	4	397	4	supplenesses
surlinesses	11	3	1004	4	sur_linesses
sveltenesses	15	4	521	4	sveltenesses
tersenesses	11	4	902	4	ter_senesses
tritenesses	11	7	1035	4	_tritenesses
unripenesses	14	4	599	4	unripenesses
unrulinesses	12	4	580	4	unrulinesses
vaguenesses	15	4	481	4	vagu_enesses

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.140	1276364.3
2	DLD Change Limit	124790	150	8.580	14544.3
3	Display Results	150	150	0.093	1612.9
	(SQL Overall)	178691	150	8.813	20275.8