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

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

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.

70 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
hookiest	15	27	1210	(None)
hokiest	14	41	1424	1	h_okiest
hoodiest	12	24	1317	1	hoodiest
hookies	14	40	1744	1	hookies_
hootiest	11	31	1564	1	hootiest
kookiest	11	26	813	1	kookiest
rookiest	12	29	1217	1	rookiest
bookies	13	38	1940	2	bookies_
bookrest	14	3	649	2	bookrest
boomiest	12	27	1184	2	boomiest
booziest	19	37	926	2	booziest
boskiest	14	28	973	2	boskiest
chokiest	17	3	872	2	chokiest
choosiest	14	3	732	2	choosiest
cockiest	16	30	1329	2	cockiest
cookies	13	37	1927	2	cookies_
corkiest	14	31	1479	2	corkiest
doomiest	11	29	1045	2	doomiest
dorkiest	13	31	1125	2	dorkiest
folkiest	15	31	950	2	folkiest
footiest	11	35	1491	2	footiest
forkiest	15	38	1230	2	forkiest
goofiest	12	28	939	2	goofiest
gooiest	8	28	1388	2	goo_iest
gooniest	9	32	1300	2	gooniest
goopiest	11	27	1055	2	goopiest
goosiest	9	29	1182	2	goosiest
hinkiest	15	33	1175	2	hinkiest
hoariest	11	3	1288	2	hoariest
holiest	10	43	1962	2	h_oliest
homiest	12	41	1663	2	h_omiest
honkies	14	30	1514	2	honkies_
hoodies	11	34	1983	2	hoodies_
hookier	14	38	1167	2	hookie_r
hookless	15	123	836	2	hookless
hooklet	14	25	1081	2	hookle_t
hooklets	15	21	720	2	hooklets
hoppiest	15	26	1073	2	hoppiest
horniest	11	28	1404	2	horniest
horsiest	11	25	1326	2	horsiest
hulkiest	15	32	971	2	hulkiest
hunkiest	15	38	1233	2	hunkiest
huskiest	15	32	1041	2	huskiest
jokiest	18	37	919	2	_jokiest
lookist	11	3	956	2	looki_st
looniest	8	33	1325	2	looniest
loopiest	10	30	1132	2	loopiest
moodiest	11	27	1218	2	moodiest
mooniest	10	30	1417	2	mooniest
mooriest	10	28	1272	2	mooriest
nookies	11	34	1496	2	nookies_
oakiest	11	29	1392	2	_oakiest
ooziest	16	34	1152	2	_ooziest
pockiest	16	34	1205	2	pockiest
pokiest	13	33	1491	2	_pokiest
porkiest	14	35	1371	2	porkiest
rockiest	14	29	1222	2	rockiest
rookies	11	39	1710	2	rookies_
roomiest	10	26	1199	2	roomiest
rootiest	8	31	1559	2	rootiest
smokiest	14	3	788	2	smokiest
sootiest	8	40	1675	2	sootiest
spookiest	15	15	640	2	spookiest
wonkiest	15	3	894	2	wonkiest
woodiest	12	31	1207	2	woodiest
wooliest	11	30	1164	2	wooliest
wooziest	20	32	790	2	wooziest
yolkiest	15	28	669	2	yolkiest
zooiest	16	19	992	2	zoo_iest
zootiest	17	33	1121	2	zootiest

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	70	3.830	31608.1
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	4.250	42044.9