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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

154 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
shoofly	16	3	435	(None)
aloofly	13	4	362	2	aloofly
dhooly	13	45	714	2	dhoo_ly
hooly	11	50	2222	2	_hoo_ly
shadfly	17	3	378	2	shadfly
shoaly	12	40	1077	2	sh_oaly
shool	8	45	2315	2	shoo_l_
shools	9	49	1901	2	shoo_ls
shortly	13	38	757	2	shortly
showily	16	3	622	2	showily
spoofy	14	49	855	2	spoof_y
blowfly	18	4	324	3	blowfly
botfly	14	3	609	3	_botfly
chiefly	18	3	410	3	chiefly
choosey	15	45	923	3	choosey
choosy	14	45	910	3	choo_sy
coolly	11	48	1139	3	_coolly
cooly	10	55	2542	3	_coo_ly
dooly	9	48	2180	3	_doo_ly
drooly	10	49	1107	3	droo_ly
ghostly	14	35	510	3	ghostly
glowfly	17	4	267	3	glowfly
goodly	11	41	930	3	_goodly
goofily	14	10	535	3	_goofily
goofy	12	49	1562	3	_goof_y
googly	11	41	788	3	_googly
hokily	16	40	909	3	_hokily
holily	12	36	1295	3	_holily
holly	11	48	2443	3	_h_olly
holy	10	63	3343	3	_h_o_ly
homely	14	53	1317	3	_homely
homily	14	47	1233	3	_homily
hoody	12	49	1972	3	_hoo_dy
hooey	11	49	2660	3	_hoo_ey
hoof	10	60	3658	3	_hoof__
hoofed	13	46	1489	3	_hoofed
hoofer	12	40	1495	3	_hoofer
hoofs	11	57	2104	3	_hoof_s
hookey	16	47	1393	3	_hookey
hooky	15	52	2026	3	_hoo_ky
hoopla	11	4	763	3	_hoopla
hooray	12	30	1137	3	_hooray
hooty	11	50	2244	3	_hoo_ty
hostly	12	42	1086	3	_hostly
hotly	11	58	1548	3	_h_otly
hourly	12	36	962	3	_hourly
phonily	15	3	710	3	phonily
phooey	14	37	923	3	phoo_ey
poofy	13	62	1327	3	_poof_y
poorly	11	3	789	3	_poorly
sandfly	14	3	564	3	sandfly
sawfly	15	3	513	3	s_awfly
school	11	4	1072	3	schoo_l_
schools	12	4	911	3	schoo_ls
shadily	14	3	772	3	shadily
shakily	17	3	690	3	shakily
shaly	11	43	2286	3	sh__aly
shapely	15	3	689	3	shapely
sharply	15	40	683	3	sharply
sheerly	13	33	770	3	sheerly
shelly	12	44	1447	3	sh_elly
sheol	8	43	1837	3	sheo_l_
sheols	9	46	1416	3	sheo_ls
shifty	15	40	926	3	sh_ifty
shily	11	52	2201	3	sh__ily
shingly	14	32	1081	3	shingly
shinily	13	26	893	3	shinily
shlocky	19	31	450	3	shlocky
shoal	8	39	2027	3	sh_oal_
shoals	9	42	1579	3	sh_oals
shoddily	16	4	357	3	shoddily
shoddy	14	3	454	3	sh_oddy
shofar	12	3	631	3	sh_ofar
shoo	7	59	2989	3	shoo___
shooed	10	39	1608	3	shoo_ed
shooflies	15	4	414	3	shooflies
shooing	11	21	1291	3	shooing
shook	12	49	2016	3	shoo__k
shooks	13	45	1563	3	shoo_ks
shooled	11	52	1266	3	shooled
shoon	8	40	2201	3	shoo__n
shoos	8	42	2636	3	shoo__s
shoot	8	42	3591	3	shoo__t
shooter	10	30	1399	3	shooter
shoots	9	46	1936	3	shoo_ts
shopboy	17	4	380	3	shopboy
shorl	8	47	2025	3	sh_orl_
shorls	9	45	1620	3	sh_orls
shorty	12	43	1320	3	sh_orty
should	10	3	803	3	sh_ould
shovel	12	46	1132	3	shovel_
shovels	13	37	839	3	shovels
showery	16	43	724	3	showery
showoff	19	4	389	3	showof_f
showoffs	20	4	245	3	showoffs
showy	14	57	1401	3	sh_o_wy
shrilly	13	31	856	3	shrilly
shroff	15	3	850	3	shrof_f
shroffs	16	3	436	3	shroffs
shuffle	16	27	692	3	shuffle
shyly	14	48	1157	3	sh__yly
slowly	12	3	715	3	s_lowly
smokily	16	3	537	3	smokily
smoochy	17	22	386	3	smoochy
smoothly	16	20	364	3	smoothly
smoothy	15	20	508	3	smoothy
sniffly	16	26	564	3	sniffly
snool	5	51	1864	3	snoo_l_
snools	6	57	1588	3	snoo_ls
snoopily	13	4	555	3	snoopily
snoopy	11	44	947	3	snoo_py
snootily	11	3	625	3	snootily
snooty	9	42	1151	3	snoo_ty
snoozle	16	30	591	3	snoozle
snoozy	18	51	723	3	snoo_zy
snowily	13	3	688	3	snowily
snuffly	16	30	520	3	snuffly
softly	12	45	776	3	s_oftly
softy	11	54	1448	3	s__ofty
solely	9	37	1421	3	s_olely
sonly	8	57	1805	3	s__only
sooey	8	45	2243	3	s_oo_ey
soothly	13	18	692	3	soothly
sootily	10	18	1052	3	sootily
sooty	8	49	2484	3	s_oo_ty
sorely	9	46	1801	3	s_orely
sourly	9	36	1221	3	s_ourly
spoof	10	50	1901	3	spoof__
spoofed	13	39	910	3	spoofed
spoofer	12	36	872	3	spoofer
spoofery	16	35	431	3	spoofery
spoofs	11	40	1181	3	spoof_s
spookily	17	4	417	3	spookily
spooky	15	41	809	3	spoo_ky
spool	7	52	1904	3	spoo_l_
spools	8	51	1591	3	spoo_ls
spooney	12	41	824	3	spooney
spoonily	13	3	523	3	spoonily
spoony	11	41	1179	3	spoo_ny
stiffly	16	23	517	3	stiffly
stonefly	14	4	347	3	stonefly
stonily	10	4	943	3	stonily
stool	5	56	1989	3	stoo_l_
stools	6	51	1702	3	stoo_ls
stoutly	10	3	583	3	stoutly
swoony	12	40	826	3	swoo_ny
swoopy	14	48	728	3	swoo_py
wholly	15	36	657	3	wh_olly
whoof	14	46	1269	3	whoof__
whoofed	17	37	451	3	whoofed
whoofs	15	45	724	3	whoof_s
whoopla	15	4	263	3	whoopla
woolly	12	40	851	3	_woolly
wooly	11	44	1767	3	_woo_ly

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	134027	0.390	458182.1
2	DLD Change Limit	134027	154	6.643	20175.7
3	Display Results	154	154	0.046	3347.8
	(SQL Overall)	178691	154	7.079	25242.4