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

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

130 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
smoothnesses	17	6	265	(None)
mootnesses	12	3	715	2	_moot_nesses
smoothness	15	4	304	2	smoothne_s_s
snootinesses	12	6	580	2	snootinesses
sootinesses	11	4	1005	2	s_ootinesses
loathnesses	14	4	586	3	_loathnesses
moodinesses	14	14	764	3	_moodinesses
mooninesses	13	12	794	3	_mooninesses
rootinesses	11	3	952	3	_rootinesses
shortnesses	14	4	679	3	short_nesses
smartnesses	13	3	714	3	smart_nesses
smokinesses	17	3	625	3	sm_okinesses
smuttinesses	14	13	508	3	smuttinesses
snottinesses	12	5	584	3	snottinesses
softnesses	13	3	760	3	s_oft_nesses
spookinesses	18	4	409	3	spookinesses
sportinesses	14	4	787	3	sportinesses
spottinesses	14	4	568	3	spottinesses
stoutnesses	11	4	697	3	stout_nesses
aloofnesses	14	4	341	4	aloo_fnesses
amorousnesses	15	4	782	4	amorousnesses
bloodinesses	15	4	427	4	bloodinesses
boozinesses	22	17	580	4	_boozinesses
broodinesses	15	4	474	4	broodinesses
coolnesses	12	3	719	4	_coo_lnesses
dottinesses	12	3	813	4	_dottinesses
emptinesses	15	4	599	4	em_ptinesses
frostinesses	15	4	653	4	frostinesses
frothinesses	18	4	559	4	_frothinesses
gloominesses	15	4	412	4	gloominesses
goodnesses	12	3	643	4	_goo_dnesses
gooeynesses	15	4	419	4	_gooeynesses
goofinesses	15	3	596	4	_goofinesses
goutinesses	12	3	998	4	_goutinesses
growthinesses	20	4	261	4	growthinesses
hotnesses	12	3	890	4	__hot_nesses
impishnesses	19	4	429	4	impishnesses
knottinesses	16	4	391	4	knottinesses
kookinesses	14	3	537	4	_kookinesses
loftinesses	14	3	792	4	_loftinesses
looninesses	11	9	799	4	_looninesses
loopinesses	13	11	673	4	_loopinesses
loosenesses	11	4	724	4	_loosenesses
lostnesses	10	4	930	4	_lost_nesses
maltinesses	13	3	1023	4	_maltinesses
matinesses	12	3	1454	4	_m_atinesses
meatinesses	13	3	1198	4	_meatinesses
meetnesses	12	3	745	4	_meet_nesses
mistinesses	13	13	1062	4	_mistinesses
modishnesses	18	4	473	4	_modishnesses
moistnesses	13	4	715	4	_moistnesses
moldinesses	14	13	804	4	_moldinesses
mootness	10	3	675	4	_moot_ne_s_s
mopinesses	14	13	912	4	_m_opinesses
morenesses	12	8	1139	4	_m_orenesses
morosenesses	14	4	686	4	_morosenesses
mossinesses	12	11	746	4	_mossinesses
mousinesses	13	12	984	4	_mousinesses
muchnesses	17	4	471	4	_m_uchnesses
mustinesses	13	10	1041	4	_mustinesses
mutenesses	12	8	997	4	_m_utenesses
oozinesses	19	17	802	4	__oozinesses
poornesses	12	3	680	4	_poo_rnesses
poshnesses	15	3	746	4	__poshnesses
pottinesses	13	3	910	4	_pottinesses
remotenesses	14	4	681	4	remotenesses
roominesses	13	3	743	4	_roominesses
rootednesses	13	4	533	4	_rootednesses
roughnesses	15	10	513	4	_roughnesses
saltinesses	11	3	1145	4	s_altinesses
saltnesses	10	3	1016	4	s_alt_nesses
savorinesses	15	4	461	4	savorinesses
scantinesses	14	3	731	4	scantinesses
scantnesses	13	7	653	4	scant_nesses
sedatenesses	13	4	696	4	sedatenesses
shiftinesses	18	10	524	4	shiftinesses
shoddinesses	17	4	378	4	shoddinesses
showinesses	17	3	599	4	s_howinesses
slatinesses	11	3	1163	4	s_latinesses
slightnesses	16	5	462	4	slightnesses
sloppinesses	16	4	405	4	sloppinesses
slouchinesses	18	4	280	4	slouchinesses
slownesses	13	4	494	4	s_lo_wnesses
smallnesses	13	4	496	4	sm_allnesses
smarminesses	16	4	510	4	smarminesses
smoothbores	18	5	133	4	smooth_bores
smoothened	16	4	248	4	smooth_e_ned
smoothens	14	19	425	4	smooth_e__ns
smoothers	14	20	604	4	smooth_e__rs
smoothes	13	21	854	4	smooth____es
smoothest	14	21	577	4	smooth_e_s_t
smoothies	14	5	613	4	smooth___ies
smudginesses	16	4	335	4	smudginesses
smugnesses	13	4	456	4	sm__ugnesses
snootiness	10	8	583	4	snootine_s_s
snowinesses	14	3	641	4	s_nowinesses
soapinesses	13	3	971	4	s_oapinesses
sobernesses	13	4	659	4	s_obernesses
sogginesses	13	4	677	4	s_ogginesses
solenesses	10	4	1270	4	s__olenesses
solidnesses	12	3	810	4	s_olidnesses
sombernesses	16	4	361	4	sombernesses
soothingnesses	18	10	209	4	s_ooth~~ing~~nesses
sootiness	9	9	983	4	s_ootine_s_s
soppinesses	15	6	684	4	s_oppinesses
sorenesses	10	13	1349	4	s__orenesses
sorrinesses	11	3	1009	4	s_orrinesses
sottishnesses	15	4	445	4	s_ottishnesses
soundnesses	12	4	752	4	s_oundnesses
sournesses	10	3	1001	4	s__ournesses
sponginesses	15	4	477	4	sponginesses
squatnesses	20	4	521	4	squat_nesses
stockinesses	18	4	450	4	stockinesses
stodginesses	14	4	394	4	stodginesses
stoninesses	11	3	825	4	s_toninesses
storminesses	14	4	503	4	storminesses
suchnesses	15	3	667	4	s__uchnesses
sultanesses	11	4	556	4	s_ultanesses
sveltenesses	15	4	523	4	sveltenesses
swarthinesses	19	4	345	4	swarthinesses
swartnesses	14	3	671	4	swart_nesses
sweatinesses	15	4	691	4	sweatinesses
sweetnesses	14	4	572	4	sweet_nesses
swiftnesses	17	4	450	4	swift_nesses
toughnesses	15	10	448	4	_toughnesses
uncouthnesses	18	6	281	4	uncouthnesses
woodinesses	15	12	746	4	_woodinesses
woolinesses	14	15	750	4	_woolinesses
woozinesses	23	17	563	4	_woozinesses
worthinesses	18	4	576	4	_worthinesses

Search took 7 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.393	454684.5
2	DLD Change Limit	124790	130	6.420	19437.7
3	Display Results	130	130	0.080	1625.0
	(SQL Overall)	178691	130	6.893	25923.5