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

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

45 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
sniffishnesses	22	7	220	(None)
sniffinesses	18	4	369	2	sniffi__nesses
sniffishness	21	5	219	2	sniffishne_s_s
offishnesses	21	4	381	3	__offishnesses
raffishnesses	22	4	322	3	_raffishnesses
selfishnesses	18	4	404	3	s_elfishnesses
sickishnesses	21	4	366	3	s_ickishnesses
skittishnesses	20	5	239	3	skittishnesses
snappishnesses	20	5	226	3	snappishnesses
snobbishnesses	20	5	177	3	snobbishnesses
spiffinesses	20	4	301	3	spiffi__nesses
swinishnesses	18	4	365	3	swi_nishnesses
blimpishnesses	23	8	214	4	blimpishnesses
childishnesses	23	5	256	4	childishnesses
cliquishnesses	28	5	211	4	cliquishnesses
diffusenesses	20	5	282	4	_diffusenesses
dwarfishnesses	24	9	213	4	dwarfishnesses
faintishnesses	20	5	330	4	faintishnesses
girlishnesses	17	4	403	4	_girlishnesses
iffinesses	16	3	558	4	__iffi__nesses
impishnesses	19	4	429	4	__impishnesses
miffinesses	19	4	436	4	_miffi__nesses
niftinesses	14	3	724	4	_nifti__nesses
oafishnesses	18	4	477	4	__oafishnesses
piggishnesses	20	4	328	4	_piggishnesses
pinkishnesses	22	4	398	4	_pinkishnesses
priggishnesses	21	5	237	4	priggishnesses
sheepishnesses	21	5	301	4	sheepishnesses
shiftinesses	18	10	524	4	shifti__nesses
shrewishnesses	22	6	224	4	shrewishnesses
slavishnesses	18	4	368	4	s_lavishnesses
sluggishnesses	18	5	214	4	sluggishnesses
sluttishnesses	16	5	268	4	sluttishnesses
sniffiness	16	4	376	4	sniffi__ne_s_s
sottishnesses	15	4	445	4	s_ottishnesses
squarishnesses	25	5	244	4	squarishnesses
stiffnesses	17	4	359	4	stiff___nesses
stuffinesses	18	4	329	4	stuffi__nesses
stylishnesses	18	4	340	4	s_tylishnesses
swainishnesses	19	5	232	4	swainishnesses
thievishnesses	23	6	219	4	thievishnesses
trickishnesses	23	5	250	4	trickishnesses
unselfishnesses	20	6	151	4	unselfishnesses
wimpishnesses	23	4	358	4	_wimpishnesses
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.093	1921408.6
2	DLD Change Limit	65874	45	3.580	18400.6
3	Display Results	45	45	0.030	1500.0
	(SQL Overall)	178691	45	3.703	48255.7