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

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

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.

77 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
helpfulness	19	5	348	(None)
heedfulness	18	10	407	2	heedfulness
helpfulnesses	21	5	354	2	helpfulnesses
balefulness	16	4	501	3	balefulness
cheerfulness	20	5	358	3	cheerfulness
dolefulness	15	4	488	3	dolefulness
fearfulness	17	4	522	3	fearfulness
gleefulness	15	5	406	3	gleefulness
harmfulness	19	8	429	3	harmfulness
hatefulness	17	4	596	3	hatefulness
healthfulness	22	5	290	3	healthfulness
helpless	13	3	506	3	help__l_ess
hopefulness	19	5	487	3	hopefulness
hurtfulness	17	5	501	3	hurtfulness
needfulness	15	9	399	3	needfulness
restfulness	14	4	723	3	restfulness
tearfulness	14	4	548	3	tearfulness
willfulness	17	5	351	3	willfulness
zestfulness	23	4	531	3	zestfulness
artfulness	13	4	642	4	_artfulness
awfulness	15	4	441	4	__awfulness
bashfulness	19	5	422	4	bashfulness
carefulness	16	4	596	4	carefulness
colorfulness	17	5	382	4	colorfulness
dreadfulness	17	6	388	4	dreadfulness
dreamfulness	18	5	359	4	dreamfulness
dutifulness	15	5	508	4	dutifulness
eventfulness	18	5	464	4	eventfulness
fatefulness	17	4	601	4	fatefulness
fellness	11	3	591	4	fel___lness
fitfulness	16	4	573	4	_fitfulness
fretfulness	17	7	622	4	fretfulness
fulness	10	24	896	4	____fulness
gainfulness	15	4	462	4	gainfulness
guilefulness	16	5	372	4	guilefulness
halfness	14	3	556	4	hal_f__ness
heedfulnesses	20	12	410	4	heedfulnesses
heftiness	15	3	631	4	he__ftiness
heinousness	14	5	558	4	heinousness
hellishness	17	4	411	4	hellishness
helmless	13	3	427	4	hel__ml_ess
helpful	15	4	396	4	helpful____
helpfully	20	5	270	4	helpful__ly
helplessness	17	5	447	4	helplessness
joyfulness	23	4	320	4	_joyfulness
lawfulness	16	4	385	4	_lawfulness
lustfulness	14	4	531	4	lustfulness
manfulness	15	4	565	4	_manfulness
mercifulness	19	6	442	4	mercifulness
mindfulness	17	5	406	4	mindfulness
painfulness	16	4	509	4	painfulness
peacefulness	19	5	499	4	peacefulness
pitifulness	16	6	549	4	pitifulness
playfulness	19	5	362	4	playfulness
pushfulness	19	5	414	4	pushfulness
ruefulness	13	4	610	4	_ruefulness
ruthfulness	17	5	498	4	ruthfulness
selfless	11	3	501	4	sel_f_l_ess
selfness	11	3	515	4	sel_f__ness
shamefulness	20	7	415	4	shamefulness
sinfulness	13	4	585	4	_sinfulness
skillfulness	19	5	244	4	skillfulness
songfulness	15	5	458	4	songfulness
soulfulness	14	4	448	4	soulfulness
tactfulness	16	4	522	4	tactfulness
thankfulness	22	5	339	4	thankfulness
tunefulness	14	5	524	4	tunefulness
unlawfulness	18	5	259	4	unlawfulness
usefulness	13	4	572	4	_usefulness
vengefulness	19	5	387	4	vengefulness
wakefulness	21	5	458	4	wakefulness
wearifulness	18	5	481	4	wearifulness
wellness	11	3	579	4	wel___lness
whelpless	17	4	205	4	whelp__l_ess
wishfulness	20	5	434	4	wishfulness
wistfulness	17	4	527	4	wistfulness
woefulness	16	4	526	4	_woefulness

Search took 10 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	77	9.343	15928.4
3	Display Results	77	77	0.046	1673.9
	(SQL Overall)	178691	77	9.812	18211.5