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

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

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.

78 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
stiffish	17	4	524	(None)
sniffish	17	4	451	1	sniffish
sailfish	14	4	605	2	sailfish
starfish	14	3	808	2	starfish
stiffest	14	3	568	2	stiffest
stiffie	13	24	577	2	stiffi_e
stiffies	14	25	838	2	stiffies
stiffing	15	24	870	2	stiffing
stiffs	12	38	996	2	stiff_s_
studfish	15	4	452	2	studfish
surffish	17	4	478	2	surffish
baitfish	16	4	548	3	baitfish
draffish	18	4	455	3	draffish
finfish	16	26	819	3	_finfish
gruffish	18	4	394	3	gruffish
huffish	19	3	571	3	_huffish
offish	15	13	727	3	__offish
pigfish	16	21	717	3	_pigfish
pinfish	15	31	930	3	_pinfish
raffish	16	5	884	3	_raffish
sandfish	15	5	668	3	sandfish
sawfish	16	3	768	3	s_awfish
selfish	13	8	851	3	s_elfish
serfish	13	4	897	3	s_erfish
sickish	16	3	842	3	s_ickish
skiffs	16	32	701	3	skiff_s_
skirmish	17	4	326	3	skirmish
skittish	15	4	450	3	skittish
sniffier	14	35	664	3	sniffier
sniffiest	15	23	600	3	sniffiest
sniffily	17	15	403	3	sniffily
sniffing	15	22	745	3	sniffing
sniffishly	22	5	187	3	sniffishly
sniffs	12	37	884	3	sniff_s_
softish	13	12	781	3	s_oftish
spiffied	17	23	482	3	spiffied
spiffier	16	25	588	3	spiffier
spiffies	16	27	799	3	spiffies
spiffiest	17	23	566	3	spiffiest
spiffily	19	15	348	3	spiffily
spiffing	17	23	708	3	spiffing
spiffs	14	32	847	3	spiff_s_
stablish	13	4	834	3	stablish
staffing	15	24	749	3	staffing
staffs	12	34	975	3	staff_s_
standish	12	3	854	3	standish
steepish	13	7	582	3	steepish
stiff	11	42	1924	3	stiff___
stiffed	14	35	958	3	stiff_ed
stiffen	13	28	602	3	stiff_en
stiffens	14	24	411	3	stiffens
stiffer	13	31	939	3	stiff_er
stiffly	16	23	517	3	stiff_ly
stiffness	15	4	355	3	stiffness
stifles	10	30	1339	3	stifles_
stifling	12	21	1091	3	stifling
stockfish	21	4	285	3	stockfish
stockish	17	18	604	3	stockish
stonefish	15	4	406	3	stonefish
stonish	10	4	1065	3	st_onish
stoutish	11	4	590	3	stoutish
stuffier	14	33	662	3	stuffier
stuffiest	15	23	595	3	stuffiest
stuffily	17	12	416	3	stuffily
stuffing	15	24	784	3	stuffing
stuffs	12	38	1022	3	stuff_s_
stylish	13	19	744	3	st_ylish
suckfish	20	4	389	3	suckfish
sunfish	13	3	888	3	s_unfish
swinish	13	4	720	3	swi_nish
tiffin	12	32	793	3	_tiffi_n
tiffing	14	33	938	3	_tiffing
tiffins	13	32	798	3	_tiffins
tiffs	11	44	1488	3	_tiff_s_
tigrish	11	3	757	3	_tigrish
tilefish	14	4	545	3	_tilefish
waifish	16	3	770	3	wai_fish
wolffish	20	4	333	3	wolffish

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	78	7.390	19778.3
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.826	22833.0