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

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

120 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
clevernesses	17	4	362	(None)
clearnesses	13	10	615	2	cle_arnesses
cleverness	15	4	322	2	cleverne_s_s
levelnesses	14	4	553	2	_levelnesses
alivenesses	14	4	885	3	alive_nesses
cheerinesses	17	6	582	3	che_erinesses
cleannesses	13	13	582	3	cle_annesses
closenesses	13	4	784	3	close_nesses
covertnesses	17	4	631	3	c_overtnesses
cravennesses	17	4	410	3	cravennesses
evennesses	13	4	592	3	__evennesses
fleetnesses	14	4	548	3	fle_etnesses
forevernesses	19	5	285	3	forevernesses
governesses	15	4	671	3	_governesses
invernesses	14	4	702	3	_invernesses
leerinesses	11	11	947	3	_le_erinesses
livenesses	13	4	1105	3	_live_nesses
queernesses	20	4	456	3	que_ernesses
severenesses	15	4	558	3	_severenesses
sheernesses	14	4	584	3	she_ernesses
sleeknesses	15	4	527	3	sle_eknesses
slendernesses	14	5	313	3	slendernesses
unevennesses	15	4	407	3	unevennesses
activenesses	17	5	818	4	active_nesses
alertnesses	11	4	722	4	ale_rtnesses
aliennesses	11	4	586	4	al_iennesses
alikenesses	15	4	719	4	alike_nesses
alonenesses	11	4	721	4	alone_nesses
beerinesses	13	9	890	4	_be_erinesses
bitternesses	14	4	453	4	bitternesses
bleaknesses	17	4	403	4	ble_aknesses
blearinesses	14	4	654	4	blearinesses
blessednesses	15	5	284	4	blessednesses
bluenesses	12	3	792	4	bl_ue_nesses
bravenesses	16	4	794	4	brave_nesses
cageynesses	17	4	387	4	c_ageynesses
cateresses	12	4	835	4	c_ater_esses
cheapnesses	18	10	402	4	che_apnesses
cheekinesses	21	6	420	4	cheekinesses
cheesinesses	17	6	537	4	cheesinesses
chewinesses	19	4	514	4	che_winesses
civilnesses	16	4	484	4	c_ivilnesses
clamminesses	18	7	379	4	clamminesses
classinesses	13	6	611	4	classinesses
cleanlinesses	15	5	388	4	cleanlinesses
clearness	11	3	563	4	cle_arne_s_s
cleverest	14	4	450	4	clever_e_s_t
cloudinesses	15	4	512	4	cloudinesses
cloverleaves	20	5	82	4	cloverleaves
clubbinesses	18	4	315	4	clubbinesses
clumsinesses	16	4	475	4	clumsinesses
creakinesses	18	4	598	4	creakinesses
creaminesses	16	4	612	4	creaminesses
creepinesses	16	4	525	4	creepinesses
crudenesses	14	7	665	4	crude_nesses
cruelnesses	13	4	624	4	c_ruelnesses
cursednesses	15	5	496	4	cursednesses
cussednesses	14	4	353	4	cussednesses
cutenesses	12	9	1087	4	c_ute_nesses
dappernesses	17	4	324	4	dappernesses
dearnesses	11	3	957	4	_de_arnesses
deepnesses	13	6	667	4	_de_epnesses
drivennesses	16	4	381	4	drivennesses
eagernesses	12	4	697	4	_eagernesses
eerinesses	10	6	1257	4	__e_erinesses
elatednesses	13	4	609	4	elatednesses
electresses	13	4	595	4	electr_esses
elevenses	12	4	433	4	eleve_n__ses
evilnesses	13	4	598	4	__evilnesses
eyednesses	14	4	580	4	__eyednesses
fleshinesses	18	11	436	4	fleshinesses
flowerinesses	19	4	290	4	flowerinesses
freenesses	13	3	986	4	fre_e_nesses
glegnesses	12	4	507	4	gl__egnesses
glueynesses	15	4	370	4	gl_ueynesses
gravenesses	15	4	816	4	grave_nesses
greennesses	12	4	702	4	gre_ennesses
innernesses	11	4	673	4	_innernesses
keennesses	14	4	532	4	_ke_ennesses
lamenesses	12	6	1056	4	_lame_nesses
latenesses	10	4	1335	4	_late_nesses
leadennesses	13	5	457	4	_leadennesses
leafinesses	14	3	787	4	_leafinesses
leakinesses	15	3	847	4	_leakinesses
leannesses	10	10	834	4	_le_annesses
legginesses	13	4	529	4	_legginesses
levelness	12	4	545	4	_levelne_s_s
lewdnesses	14	3	539	4	_le_wdnesses
likenesses	14	4	953	4	_like_nesses
limbernesses	16	4	315	4	limbernesses
litenesses	10	5	1300	4	_lite_nesses
livelinesses	15	14	562	4	_livelinesses
lividnesses	15	4	501	4	_lividnesses
lonenesses	10	3	1134	4	_lone_nesses
lovelinesses	15	12	533	4	_lovelinesses
meagernesses	15	4	443	4	meagernesses
meeknesses	16	4	480	4	_me_eknesses
meetnesses	12	3	744	4	_me_etnesses
naivenesses	14	4	908	4	naive_nesses
nearnesses	10	3	909	4	_ne_arnesses
obesenesses	13	4	674	4	obese_nesses
othernesses	14	7	541	4	_othernesses
overtnesses	14	4	869	4	__overtnesses
peeresses	11	3	845	4	_pe_er_esses
planenesses	13	4	903	4	plane_nesses
propernesses	16	4	500	4	propernesses
seeresses	9	3	905	4	_se_er_esses
silverinesses	16	4	368	4	silverinesses
sleazinesses	21	4	537	4	sleazinesses
sleepinesses	14	4	567	4	sleepinesses
sobernesses	13	4	659	4	_sobernesses
sombernesses	16	4	361	4	sombernesses
steepnesses	13	4	591	4	ste_epnesses
suavenesses	14	4	839	4	suave_nesses
sweetnesses	14	4	572	4	swe_etnesses
tendernesses	13	4	506	4	tendernesses
tweenesses	13	4	580	4	twe_e_nesses
utternesses	11	4	587	4	_utternesses
vexednesses	22	4	458	4	_vexednesses
wildernesses	16	4	362	4	wildernesses

Search took 8 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.156	1145455.1
2	DLD Change Limit	124790	120	7.250	17212.4
3	Display Results	120	120	0.063	1904.8
	(SQL Overall)	178691	120	7.469	23924.4