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

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

328 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
sawfly	15	3	513	(None)
barfly	14	33	965	2	barfly
dayfly	16	3	381	2	dayfly
gadfly	14	3	466	2	gadfly
mayfly	17	3	440	2	mayfly
rawly	11	51	1583	2	raw_ly
sadly	9	45	1912	2	sa_dly
safely	12	24	939	2	safely
sagely	10	28	1138	2	sagely
sally	8	51	2971	2	sa_lly
sandfly	14	3	564	2	sandfly
sanely	9	31	1461	2	sanely
sawney	12	38	760	2	sawney
shadfly	17	3	378	2	shadfly
waffly	18	30	543	2	waffly
ably	9	97	2513	3	_a_bly
agly	8	68	2180	3	_a_gly
ally	7	69	3564	3	_a_lly
amply	12	50	1291	3	_amply
apply	12	51	1139	3	_apply
aptly	10	51	1181	3	_aptly
away	10	80	2422	3	_aw_ay
awful	11	7	814	3	_awful
awfully	16	4	400	3	_awfully
awl	6	76	3530	3	_aw_l_
awls	7	59	2609	3	_aw_ls
awny	10	59	1930	3	_aw_ny
awol	7	56	2067	3	_awol_
awols	8	47	1352	3	_awols
awry	10	76	1968	3	_aw_ry
badly	11	49	1876	3	ba_dly
baffle	14	39	987	3	baffle
baffy	16	55	1192	3	ba_ffy
baldly	12	47	983	3	baldly
bally	10	55	3010	3	ba_lly
barely	11	47	1679	3	barely
basely	11	44	1231	3	basely
bassly	11	46	1007	3	bassly
bawdily	16	3	580	3	bawdily
bawdry	15	51	646	3	bawdry
bawdy	14	75	1328	3	baw_dy
bawl	9	53	2606	3	baw_l_
bawls	10	57	1932	3	baw_ls
bawty	13	56	1410	3	baw_ty
blowfly	18	4	324	3	blowfly
botfly	14	3	609	3	botfly
brawly	14	43	1235	3	braw_ly
cagily	12	4	1156	3	cagily
calmly	13	3	761	3	calmly
crawly	14	46	1076	3	craw_ly
daffily	17	3	513	3	daffily
daffy	15	55	1028	3	da_ffy
daftly	13	3	544	3	daftly
daily	9	59	2233	3	da_ily
dally	9	53	2474	3	da_lly
damply	14	33	789	3	damply
dangly	11	42	1226	3	dangly
dankly	14	41	946	3	dankly
darkly	14	54	1107	3	darkly
dawdle	11	39	950	3	dawdle
deafly	13	38	912	3	deafly
dewily	13	3	834	3	dewily
drawly	13	49	1072	3	draw_ly
early	8	53	2412	3	ea_rly
easily	9	3	1302	3	easily
fairly	12	56	1001	3	fairly
family	14	33	1170	3	family
fatly	11	57	1680	3	fa_tly
fawny	14	47	1171	3	faw_ny
fly	9	71	2495	3	___fly
gaily	9	50	2097	3	ga_ily
gainly	10	4	932	3	gainly
gallfly	14	3	352	3	gallfly
gally	9	50	2617	3	ga_lly
gamely	12	47	1191	3	gamely
gamily	12	37	1218	3	gamily
gangly	11	39	1158	3	gangly
gawkily	18	3	409	3	gawkily
gawky	16	56	999	3	gaw_ky
gawsy	12	45	909	3	gaw_sy
gayly	12	45	1309	3	ga_yly
glowfly	17	4	267	3	glowfly
hackly	18	29	873	3	hackly
haply	13	59	1506	3	ha_ply
hardly	13	51	1283	3	hardly
hawala	12	36	891	3	hawala
hawkey	19	50	763	3	hawkey
hazily	21	7	906	3	hazily
jangly	17	43	1060	3	jangly
jowly	18	64	1090	3	jow_ly
lacily	11	6	1276	3	lacily
lamely	11	40	1322	3	lamely
lanely	9	39	1448	3	lanely
lankly	13	43	962	3	lankly
lastly	9	33	1087	3	lastly
lately	9	34	1384	3	lately
lawful	12	3	549	3	lawful
lawfully	17	4	350	3	lawfully
lawny	11	59	1201	3	law_ny
laxly	15	6	1010	3	la_xly
lazily	18	5	971	3	lazily
lewdly	13	3	439	3	lewdly
liefly	12	6	636	3	liefly
lowly	11	41	1333	3	low_ly
madly	11	52	1813	3	ma_dly
mainly	11	4	1149	3	mainly
manly	10	50	2294	3	ma_nly
marbly	13	41	1193	3	marbly
marly	10	69	2561	3	ma_rly
mazily	20	6	1039	3	mazily
medfly	15	3	522	3	medfly
namely	11	37	1132	3	namely
newly	11	46	1020	3	new_ly
outfly	12	3	827	3	outfly
packly	17	22	833	3	packly
palely	11	3	1192	3	palely
pally	10	57	2712	3	pa_lly
paly	9	58	3553	3	pa__ly
panfry	14	45	641	3	panfry
partly	11	63	1547	3	partly
patly	10	50	2058	3	pa_tly
pawkily	19	3	420	3	pawkily
pawky	17	38	1015	3	paw_ky
pawl	9	51	2326	3	paw_l_
pawls	10	56	1766	3	paw_ls
racily	11	7	1517	3	racily
raffle	12	39	1070	3	raffle
rally	8	47	2590	3	ra_lly
rankly	13	39	1045	3	rankly
raptly	11	33	891	3	raptly
rarely	9	35	1365	3	rarely
rashly	12	34	1021	3	rashly
rattly	9	41	1154	3	rattly
refly	11	39	1456	3	_refly
ruffly	15	33	667	3	ruffly
sabal	7	54	2248	3	sabal_
sabals	8	46	1886	3	sabals
sable	7	47	3216	3	sa_ble
saddle	8	39	1549	3	saddle
safe	7	59	3095	3	sa_f_e
safer	8	47	2181	3	sa_fer
safes	8	52	2672	3	sa_fes
safety	12	20	691	3	safety
saggy	10	59	1746	3	sa_ggy
sagy	8	53	2708	3	sa__gy
sail	4	54	4716	3	sa_il_
sails	5	57	3810	3	sa_ils
saintly	10	3	934	3	saintly
sal	3	64	6288	3	sa__l_
salably	12	16	1074	3	salably
salal	5	54	2570	3	salal_
salals	6	51	2008	3	salals
salary	9	5	1521	3	salary
sale	4	49	5970	3	sa__le
salify	12	3	1137	3	salify
sall	4	45	4468	3	sa__ll
salol	5	52	2214	3	salol_
salols	6	40	1787	3	salols
salp	6	45	3409	3	sa__lp
sals	4	68	5167	3	sa__ls
salt	4	57	5852	3	sa__lt
saltily	10	3	1054	3	saltily
salty	8	55	2438	3	sa_lty
sample	10	42	1501	3	sample
sandy	9	42	2113	3	sa_ndy
sanity	9	3	1620	3	sanity
sappily	14	3	716	3	sappily
sappy	12	54	1347	3	sa_ppy
sarky	12	55	2178	3	sa_rky
sashay	12	3	836	3	sashay
sassily	10	3	872	3	sassily
sassy	8	58	1381	3	sa_ssy
satay	8	47	1846	3	sa_tay
satiny	9	38	1798	3	satiny
saucily	12	3	791	3	saucily
saucy	10	46	1516	3	sa_ucy
saughy	13	50	746	3	saughy
saul	4	58	3652	3	sa_ul_
sauls	5	51	2812	3	sa_uls
sault	5	58	3496	3	sa_ult
saury	8	43	1722	3	sa_ury
saveloy	13	3	466	3	saveloy
savory	12	43	1056	3	savory
savoy	11	47	1388	3	sa_voy
savvily	16	3	432	3	savvily
savvy	14	49	750	3	sa_vvy
saw	6	82	5535	3	saw___
sawbill	12	5	529	3	sawbill
sawed	9	56	2840	3	saw_ed
sawer	8	50	2621	3	saw_er
sawers	9	46	2016	3	sawers
sawfish	16	3	768	3	sawfish
sawflies	14	4	473	3	sawflies
sawing	10	43	2381	3	sawing
sawlog	10	3	579	3	sawlog
sawmill	12	4	407	3	sawmill
sawn	7	54	2816	3	saw__n
sawneys	13	27	464	3	sawneys
saws	7	58	3948	3	saw__s
sawyer	12	43	804	3	sawyer
saxony	16	3	623	3	saxony
say	6	72	6476	3	sa___y
scaly	10	47	1872	3	s_caly
scantly	12	41	955	3	scantly
scarily	12	3	1170	3	scarily
scrawly	15	19	718	3	scraw_ly
seawall	10	4	620	3	seawall
seaway	12	30	999	3	seaw_ay
seely	8	45	2263	3	s_eely
seemly	11	3	843	3	seemly
sexily	16	3	885	3	sexily
shadily	14	3	772	3	shadily
shakily	17	3	690	3	shakily
shaly	11	43	2286	3	s_haly
shapely	15	3	689	3	shapely
sharply	15	40	683	3	sharply
shawl	11	62	1757	3	shaw_l_
shawls	12	54	1197	3	shaw_ls
shelly	12	44	1446	3	shelly
shifty	15	40	925	3	shifty
shily	11	52	2201	3	s_hily
shoaly	12	40	1076	3	shoaly
shoofly	16	3	434	3	shoofly
showily	16	3	621	3	showily
shyly	14	48	1157	3	s_hyly
sickly	15	31	1048	3	sickly
silly	8	45	2761	3	s_illy
simply	13	30	1052	3	simply
singly	10	40	1585	3	singly
slackly	16	3	526	3	slackly
slantly	10	39	932	3	slantly
slily	8	58	2003	3	s_lily
slimly	11	40	890	3	slimly
slowly	12	3	715	3	slowly
sly	6	62	2856	3	s___ly
slyly	11	48	953	3	s_lyly
smartly	12	49	743	3	smartly
smelly	11	41	1035	3	smelly
smugly	12	7	483	3	smugly
snaffle	13	21	624	3	snaffle
snakily	14	3	691	3	snakily
snarly	9	38	1500	3	snarly
sniffly	16	26	564	3	sniffly
sniffy	15	33	719	3	sniffy
snowily	13	3	688	3	snowily
snuffly	16	30	519	3	snuffly
snuffy	15	35	624	3	snuffy
snugly	10	5	566	3	snugly
soapily	12	3	796	3	soapily
softly	12	45	776	3	softly
softy	11	54	1448	3	s_ofty
solely	9	37	1421	3	solely
sonly	8	57	1805	3	s_only
sorely	9	46	1800	3	sorely
sourly	9	36	1220	3	sourly
spangly	13	3	647	3	spangly
sparely	12	34	1066	3	sparely
sparkly	16	34	812	3	sparkly
spiffy	17	32	622	3	spiffy
sprawly	15	16	604	3	spraw_ly
spryly	14	3	551	3	spryly
stably	11	33	1412	3	stably
stagily	11	3	905	3	stagily
staidly	11	3	668	3	staidly
stalely	10	3	921	3	stalely
starkly	14	27	703	3	starkly
stately	10	3	1022	3	stately
steely	9	36	1257	3	steely
stiffly	16	23	517	3	stiffly
stifle	9	36	1190	3	stifle
stilly	9	37	1407	3	stilly
studly	10	39	769	3	studly
stuffy	15	31	708	3	stuffy
suably	11	28	1453	3	suably
suavely	13	7	648	3	suavely
subtly	11	24	926	3	subtly
sully	8	46	2289	3	s_ully
supply	13	4	689	3	supply
surely	9	38	1645	3	surely
surfy	11	53	1947	3	surf_y
surly	8	51	2442	3	s_urly
swabby	16	3	435	3	swabby
swail	8	62	1716	3	swail_
swails	9	49	1312	3	swails
swale	8	52	2159	3	s_wale
swampy	16	43	723	3	swampy
swamy	13	67	1440	3	s_wamy
swanky	16	44	797	3	swanky
swanny	12	33	682	3	swanny
swarty	12	58	1238	3	swarty
sway	10	71	2823	3	s_w_ay
swell	8	48	1598	3	s_well
swiftly	16	3	373	3	swiftly
swill	8	34	1737	3	s_will
swirly	12	43	924	3	swirly
taffy	14	51	1082	3	ta_ffy
tally	8	45	2686	3	ta_lly
tamely	11	37	1195	3	tamely
tangly	10	44	1391	3	tangly
tartly	9	60	1402	3	tartly
tautly	9	49	950	3	tautly
tawdry	13	39	525	3	tawdry
tawney	12	33	823	3	tawney
tawnily	13	3	544	3	tawnily
tawny	11	47	1365	3	taw_ny
usably	11	28	898	3	usa_bly
vainly	12	5	850	3	vainly
vastly	12	50	872	3	vastly
wabbly	16	34	836	3	wabbly
waddly	14	47	872	3	waddly
waffle	15	36	918	3	waffle
waggly	14	34	729	3	waggly
wally	11	46	2509	3	wa_lly
waly	10	58	3090	3	__waly
wambly	16	38	866	3	wambly
wanly	11	51	1802	3	wa_nly
warily	12	29	1509	3	warily
warmly	14	22	806	3	warmly
wavily	15	21	948	3	wavily
wawl	10	53	2194	3	waw_l_
wawls	11	54	1647	3	waw_ls
waxily	19	21	841	3	waxily
wily	10	64	2881	3	__wily
yarely	12	28	1030	3	yarely
yawey	14	45	827	3	yaw_ey
yawl	10	49	1897	3	yaw_l_
yawls	11	46	1360	3	yaw_ls
zanily	18	3	1018	3	zanily

Search took 7 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	328	6.313	17854.6
3	Display Results	328	328	0.093	3526.9
	(SQL Overall)	178691	328	6.546	27297.7