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

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

115 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
naughtiness	15	4	238	(None)
haughtiness	18	4	223	1	haughtiness
doughtiness	16	4	270	2	doughtiness
naughties	13	4	457	2	naughti_e_s
naughtiest	14	4	273	2	naughti_est
naughtinesses	17	5	241	2	naughtinesses
droughtiness	17	5	191	3	droughtiness
faultiness	13	4	482	3	fau_ltiness
flightiness	18	4	389	3	flightiness
haughtiest	17	4	253	3	haughti_est
haughtinesses	20	4	216	3	haughtinesses
jauntiness	17	4	397	3	jau_ntiness
laughlines	14	4	266	3	laughline_s
mightiness	16	4	509	3	_mightiness
nastiness	9	23	1057	3	na__stiness
nattiness	9	23	933	3	na__ttiness
naughtier	13	4	310	3	naughti_e_r
nuttiness	9	20	756	3	n_u_ttiness
weightiness	18	4	326	3	weightiness
achiness	13	3	970	4	_a_ch_iness
almightiness	18	5	191	4	almightiness
angriness	10	3	645	4	_ang_riness
artiness	8	16	1540	4	_a__rtiness
ashiness	11	3	896	4	_a_sh_iness
augustness	11	4	200	4	_augustness
bagginess	13	5	595	4	ba_g_giness
battiness	11	23	984	4	ba__ttiness
brightness	16	4	457	4	bright_ness
bugginess	13	9	512	4	_bug_giness
bushiness	14	17	776	4	_bush_iness
bustiness	11	18	1047	4	_bu_stiness
caginess	11	3	1030	4	ca_g__iness
cattiness	11	23	1063	4	ca__ttiness
crustiness	12	3	729	4	cru_stiness
cushiness	14	19	718	4	_cush_iness
daintiness	11	4	596	4	da_intiness
daughterless	17	6	94	4	daughterless
daughters	14	4	399	4	daught__ers
dauphines	15	4	434	4	dauph_ine_s
doughtiest	15	4	323	4	doughti_est
doughtinesses	18	5	255	4	doughtinesses
draughtiest	16	6	224	4	draughti_est
dustiness	10	22	1103	4	_du_stiness
earthiness	13	7	724	4	earth_iness
earthliness	14	14	414	4	earthliness
fattiness	12	23	937	4	fa__ttiness
fidgetiness	16	5	191	4	fidgetiness
fruitiness	13	4	599	4	fru_itiness
fustiness	12	19	1024	4	_fu_stiness
gaucheness	16	4	277	4	gauch_eness
gaudiness	11	3	625	4	gau__diness
gauntness	10	4	420	4	gau_nt_ness
gauziness	19	3	461	4	gau__ziness
goutiness	10	3	876	4	gou__tiness
guiltiness	11	4	419	4	_guiltiness
gushiness	13	20	685	4	_gush_iness
gustiness	10	18	989	4	_gu_stiness
hastiness	12	24	1088	4	ha__stiness
haughtier	16	4	274	4	haughti_e_r
knightliness	20	5	273	4	knightliness
laughings	14	4	348	4	laugh_in_gs
laughline	13	4	291	4	laughline__
laughters	13	4	459	4	laught__ers
lengthiness	15	5	232	4	lengthiness
lightness	13	10	743	4	_light_ness
lustiness	9	20	1045	4	_lu_stiness
maltiness	11	29	1057	4	ma__ltiness
manginess	12	20	1041	4	mang__iness
marshiness	15	5	506	4	marsh_iness
matiness	10	21	1475	4	ma___tiness
mugginess	13	5	463	4	_mug_giness
mushiness	14	24	822	4	_mush_iness
mustiness	11	22	1166	4	_mu_stiness
nappiness	13	3	523	4	na__ppiness
narghiles	13	4	354	4	nargh_ile_s
naughtily	16	4	228	4	naughti__ly
naughts	11	44	751	4	naught____s
niftiness	12	3	636	4	n__iftiness
nighness	12	3	610	4	n_igh__ness
nightdress	15	5	298	4	n_ightdress
nighties	12	10	1138	4	n_ighti_e_s
nightless	13	8	607	4	n_ight_less
nubbiness	13	3	417	4	n_u_bbiness
pastiness	11	23	1235	4	pa__stiness
patchiness	17	4	493	4	patch_iness
paunchiness	18	4	234	4	paunchiness
plushiness	15	4	409	4	plush_iness
pugginess	13	8	496	4	_pug_giness
pushiness	14	19	728	4	_push_iness
ranginess	10	16	1021	4	rang__iness
raunchiness	16	4	288	4	raunchiness
rightness	13	11	735	4	_right_ness
roughness	13	4	576	4	rough__ness
runtiness	9	24	1039	4	_ru_ntiness
rustiness	9	21	1193	4	_ru_stiness
ruttiness	9	25	879	4	_ru_ttiness
saltiness	9	33	1211	4	sa__ltiness
sauciness	11	3	804	4	sau__ciness
sightliness	15	7	456	4	_sightliness
slightness	14	5	480	4	slight_ness
slushiness	13	4	464	4	slush_iness
smuttiness	12	4	440	4	smu_ttiness
tanginess	10	23	928	4	tang__iness
tartiness	9	21	1205	4	ta__rtiness
tastiness	9	23	1114	4	ta__stiness
tattiness	9	23	941	4	ta__ttiness
tautness	8	21	718	4	tau__t_ness
tightness	13	8	660	4	_tight_ness
touchiness	15	4	461	4	touch_iness
toughness	13	5	509	4	tough__ness
trustiness	10	3	665	4	tru_stiness
ugliness	9	3	686	4	__ug_liness
unsightliness	17	6	251	4	unsightliness
washiness	15	3	704	4	wa_sh_iness
waughting	17	4	312	4	waughtin__g

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	148819	0.423	422437.4
2	DLD Change Limit	148819	115	7.920	18790.3
3	Display Results	115	115	0.063	1825.4
	(SQL Overall)	178691	115	8.406	21257.6