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

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

54 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
ghoulishnesses	21	5	228	(None)
ghoulishness	19	5	234	2	ghoulishne_s_s
churlishnesses	22	5	254	3	churlishnesses
dollishnesses	17	4	437	3	_dollishnesses
foolishnesses	19	4	446	3	_foolishnesses
girlishnesses	17	4	403	3	g_irlishnesses
hellishnesses	19	7	435	3	_hellishnesses
hoggishnesses	21	14	365	3	_hoggishnesses
loutishnesses	16	4	499	3	_loutishnesses
mulishnesses	17	5	509	3	__mulishnesses
owlishnesses	18	4	464	3	__owlishnesses
bluishnesses	17	6	526	4	_blu_ishnesses
bookishnesses	22	6	368	4	_bookishnesses
boorishnesses	18	6	431	4	_boorishnesses
boyishnesses	20	4	403	4	_bo_yishnesses
brutishnesses	18	4	409	4	_brutishnesses
bullishnesses	18	4	404	4	_bullishnesses
childishnesses	23	5	256	4	childishnesses
cloddishnesses	21	5	262	4	cloddishnesses
clownishnesses	22	6	227	4	clownishnesses
coltishnesses	18	4	522	4	_coltishnesses
cultishnesses	18	4	456	4	__cultishnesses
devilishnesses	21	5	269	4	devilishnesses
doggishnesses	19	14	368	4	_doggishnesses
doltishnesses	17	4	461	4	_doltishnesses
donnishnesses	17	8	411	4	_donnishnesses
dovishnesses	19	4	446	4	_do_vishnesses
folkishnesses	23	4	392	4	_folkishnesses
foppishnesses	23	4	339	4	_foppishnesses
garishnesses	16	4	588	4	g__arishnesses
gawkishnesses	24	4	303	4	g_awkishnesses
ghostlinesses	17	4	249	4	ghostli__nesses
godlessnesses	14	4	658	4	g_odlessnesses
godlikenesses	19	6	266	4	g_odlikenesses
godlinesses	13	3	712	4	g_odli__nesses
goutinesses	12	3	997	4	g_outi__nesses
greenishnesses	18	8	296	4	greenishnesses
growlinesses	16	4	472	4	growli__nesses
hawkishnesses	26	4	325	4	_hawkishnesses
holinesses	13	5	1149	4	_ho_li__nesses
modishnesses	18	4	473	4	_mo_dishnesses
oafishnesses	18	4	477	4	__oafishnesses
offishnesses	21	4	381	4	__offishnesses
prudishnesses	19	4	367	4	_prudishnesses
roguishnesses	17	6	397	4	_roguishnesses
sheepishnesses	21	5	301	4	sheepishnesses
shrewishnesses	22	6	224	4	shrewishnesses
snobbishnesses	20	5	177	4	snobbishnesses
sottishnesses	15	4	445	4	_sottishnesses
stylishnesses	18	4	340	4	_stylishnesses
thievishnesses	23	6	219	4	thievishnesses
ticklishnesses	23	5	238	4	ticklishnesses
voguishnesses	20	6	349	4	_voguishnesses
wolfishnesses	22	4	373	4	_wolfishnesses

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	54	3.533	18645.3
3	Display Results	54	54	0.046	1173.9
	(SQL Overall)	178691	54	3.905	45759.5