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

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

40 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
colorfulnesses	19	9	383	(None)
colorfulness	17	5	382	2	colorfulne_s_s
cheerfulnesses	22	5	338	3	cheerfulnesses
colonialnesses	16	5	305	3	colonialnesses
colorfastnesses	20	6	130	3	colorfastnesses
dolefulnesses	17	7	484	3	dol_efulnesses
dolorousnesses	15	5	578	3	dolorousnesses
balefulnesses	18	4	485	4	bal_efulnesses
boastfulnesses	19	5	403	4	boastfulnesses
canorousnesses	16	12	706	4	canorousnesses
carefulnesses	18	4	569	4	c_arefulnesses
colorlessnesses	16	6	509	4	colorlessnesses
coolnesses	12	3	719	4	co_o___lnesses
corporealnesses	19	6	188	4	corporealnesses
doubtfulnesses	20	5	370	4	doubtfulnesses
effortfulnesses	20	11	218	4	effortfulnesses
fearfulnesses	19	4	531	4	_fearfulnesses
forcefulnesses	22	5	417	4	forcefulnesses
gleefulnesses	17	6	425	4	_gleefulnesses
helpfulnesses	21	5	354	4	hel_pfulnesses
hopefulnesses	21	8	459	4	ho_pefulnesses
joyfulnesses	25	5	350	4	__joyfulnesses
lawfulnesses	18	4	414	4	__lawfulnesses
mournfulnesses	19	6	342	4	mournfulnesses
odorousnesses	14	5	673	4	_odorousnesses
playfulnesses	21	5	364	4	_playfulnesses
scornfulnesses	19	5	320	4	sco_rnfulnesses
slothfulnesses	20	5	346	4	slothfulnesses
songfulnesses	17	5	467	4	so_ngfulnesses
sonorousnesses	13	5	651	4	sonorousnesses
sorrowfulnesses	21	6	196	4	sorrowfulnesses
soulfulnesses	16	5	455	4	so_ulfulnesses
sportfulnesses	19	6	417	4	_sportfulnesses
tearfulnesses	16	4	553	4	_tearfulnesses
unlawfulnesses	20	5	298	4	unlawfulnesses
voicefulnesses	22	5	357	4	voicefulnesses
willfulnesses	19	5	388	4	wil_lfulnesses
woefulnesses	18	4	534	4	__woefulnesses
wonderfulnesses	22	6	267	4	wonderfulnesses
youthfulnesses	23	5	373	4	youthfulnesses

Search took 4 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	65874	0.326	548131.9
2	DLD Change Limit	65874	40	3.440	19149.4
3	Display Results	40	40	0.030	1333.3
	(SQL Overall)	178691	40	3.796	47073.5