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

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

271 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
grandly	12	3	874	(None)
blandly	13	3	604	2	blandly
brandy	12	47	1206	2	brand_y
crankly	16	35	812	2	crankly
frankly	17	31	563	2	frankly
gangly	11	39	1158	2	g_angly
gladly	11	49	793	2	gla_dly
granary	11	5	779	2	granary
grand	7	51	2269	2	grand__
grandad	10	3	845	2	grandad
grandam	11	3	939	2	grandam
grandee	9	31	1551	2	grandee
grander	9	33	1587	2	grander
grandma	11	3	691	2	grandma
grandpa	11	3	541	2	grandpa
grands	8	42	1824	2	grand_s
granny	10	43	1116	2	gran_ny
granola	8	3	791	2	granola
granule	8	3	947	2	granule
gravely	14	46	906	2	gravely
gravidly	16	5	374	2	gravidly
grayly	13	28	796	2	gra_yly
randy	9	50	2208	2	_rand_y
rankly	13	39	1045	2	_rankly
aridly	10	55	1370	3	ar_idly
arrantly	11	5	610	3	arrantly
badly	11	49	1876	3	_ba_dly
baldly	12	47	983	3	_baldly
bandy	11	48	2418	3	_band_y
blankly	16	3	426	3	blankly
blindly	13	3	574	3	blindly
brainily	13	3	731	3	brainily
brambly	16	29	625	3	brambly
branchy	17	35	791	3	branchy
brand	8	51	2449	3	brand__
branded	11	44	1410	3	branded
brander	10	39	1582	3	brander
brands	9	51	1894	3	brand_s
branny	11	51	1183	3	bran_ny
brashly	15	42	761	3	brashly
bravely	15	42	823	3	bravely
brawly	14	43	1235	3	bra_wly
brawnily	16	4	408	3	brawnily
brindle	10	42	1010	3	brindle
broadly	13	3	715	3	broadly
candle	9	43	2148	3	_candle
candy	11	51	1982	3	_cand_y
crackly	18	39	770	3	crackly
cradle	9	33	1316	3	cra_dle
crankily	17	5	562	3	crankily
crankle	13	36	1006	3	crankle
cranky	15	39	1063	3	cran_ky
cranny	11	42	1027	3	cran_ny
crassly	12	7	665	3	crassly
crawly	14	46	1076	3	cra_wly
crazily	21	3	692	3	crazily
crinkly	16	38	752	3	crinkly
dandily	12	27	963	3	_dandily
dandle	8	42	1809	3	_dandle
dandy	10	44	1670	3	_dand_y
dangly	11	42	1226	3	_dangly
dankly	14	41	946	3	_dankly
deadly	11	38	1147	3	dea_dly
drably	12	35	1161	3	dra_bly
drawly	13	49	1072	3	dra_wly
errantly	11	7	579	3	errantly
fondly	13	29	904	3	_fondly
frailly	13	3	731	3	frailly
friendly	15	4	438	3	friendly
gadfly	14	3	466	3	g_adfly
gaily	9	50	2097	3	g_a_ily
gainly	10	4	932	3	g_ainly
gally	9	50	2617	3	g_a_lly
gamely	12	47	1191	3	g_amely
gamily	12	37	1218	3	g_amily
gander	8	43	2276	3	g_ander
gantry	10	38	1011	3	g_antry
gaudily	12	3	652	3	g_audily
gaudy	10	66	1146	3	g_aud_y
gauntly	11	3	533	3	gauntly
gayly	12	45	1309	3	g_a_yly
gelidly	12	3	475	3	gelidly
gently	10	37	1091	3	g_ently
germanely	15	4	399	3	germanely
ghastly	14	35	456	3	ghastly
girandola	11	5	254	3	girandola
girandole	11	4	354	3	girandole
glady	10	54	1394	3	gla_d_y
gland	7	52	1771	3	gland__
glandes	9	54	1383	3	glandes
glands	8	53	1440	3	gland_s
glandule	10	4	385	3	glandule
glazily	20	3	538	3	glazily
gnarly	10	46	1038	3	gna_rly
godly	10	49	1329	3	g__odly
goodly	11	41	930	3	g_oodly
gorgedly	14	4	400	3	gorgedly
graal	6	43	1650	3	gra_al_
graals	7	41	1291	3	gra_als
grabble	12	33	964	3	grabble
grabby	14	33	618	3	gra_bby
gracile	10	25	1260	3	gracile
grackle	14	33	889	3	grackle
grad	6	68	2986	3	gra_d__
grade	7	51	2609	3	gra_d_e
graded	9	49	1955	3	gra_ded
grader	8	49	1969	3	gra_der
grades	8	49	2631	3	gra_des
gradin	8	35	1748	3	gra_din
grads	7	56	2575	3	gra_d_s
gradus	8	44	1122	3	gra_dus
grail	6	46	2287	3	gra_il_
grails	7	75	1878	3	gra_ils
grainy	10	39	1421	3	gra_iny
gramary	13	5	590	3	gramary
gran	5	63	3501	3	gran___
grana	6	57	2209	3	gran__a
grandaddy	16	5	211	3	grandaddy
grandads	11	3	655	3	grandads
grandame	12	4	711	3	grandame
grandams	12	3	712	3	grandams
grandbaby	18	5	173	3	grandbaby
granddad	12	4	425	3	granddad
granddam	13	4	469	3	granddam
grandees	10	32	1128	3	grandees
grandest	10	3	1157	3	grandest
grandeur	10	30	567	3	grandeur
grandkid	15	4	364	3	grandkid
grandmas	12	3	692	3	grandmas
grandpas	12	3	600	3	grandpas
grandsir	10	4	431	3	grandsir
grandson	10	5	541	3	grandson
grange	8	37	1620	3	gran_ge
granger	9	35	1421	3	granger
granges	9	35	1652	3	granges
granita	8	21	1130	3	granita
granite	8	20	1708	3	granite
grannie	8	3	1035	3	grannie
granolas	9	3	805	3	granolas
grans	6	48	3254	3	gran__s
grant	6	48	4002	3	gran__t
granted	9	47	1510	3	granted
grantee	8	32	1713	3	grantee
granter	8	41	1713	3	granter
grantor	8	40	1093	3	grantor
grants	7	37	2247	3	gran_ts
granular	9	4	689	3	granular
granules	9	3	993	3	granules
granum	9	3	1091	3	gran_um
grapery	13	45	795	3	grapery
grapey	12	60	1230	3	gra_pey
grapnel	10	3	560	3	grapnel_
grapnels	11	3	439	3	grapnels
grapple	12	37	800	3	grapple
grapy	11	54	1643	3	gra__py
grassily	12	3	643	3	grassily
grassy	10	61	909	3	gra_ssy
gratify	14	3	611	3	gratify
gratingly	14	3	740	3	gratingly
gravel	10	53	1382	3	gravel_
gravelly	15	38	577	3	gravelly
gravels	11	36	1114	3	gravels
gravity	14	3	718	3	gravity
gravy	12	55	1211	3	gra__vy
gray	8	53	2989	3	gra___y
grazingly	23	4	494	3	grazingly
greasily	12	3	623	3	greasily
greatly	11	3	761	3	greatly
greedily	13	4	518	3	greedily
greedy	11	51	885	3	greed_y
greenfly	15	5	408	3	greenfly
greenly	11	40	819	3	greenly
greyly	13	31	654	3	gr_eyly
griddle	10	3	550	3	griddle
grimily	13	3	652	3	grimily
grimly	12	45	993	3	gr_imly
grind	7	59	1756	3	grind__
grinded	10	42	1063	3	grinded
grinder	9	33	1239	3	grinder
grindery	13	25	551	3	grindery
grinds	8	45	1184	3	grind_s
grisly	10	43	1058	3	gr_isly
gristly	11	18	733	3	gristly
grizzly	19	35	447	3	grizzly
grody	10	34	1206	3	gr_od_y
grossly	11	7	598	3	grossly
growly	13	49	917	3	gr_owly
gruffly	17	41	389	3	gruffly
grumbly	15	35	540	3	grumbly
grungy	11	34	597	3	grun_gy
gruntle	8	25	705	3	gruntle
guanay	10	3	791	3	guan_ay
gynandry	16	6	174	3	gynandry
gyrally	14	3	558	3	gyra_lly
handily	14	36	1087	3	_handily
handle	10	42	1929	3	_handle
handy	12	55	2087	3	_hand_y
hardly	13	51	1283	3	_hardly
inanely	10	3	794	3	inanely
irately	10	4	768	3	irately
jangly	17	43	1060	3	_jangly
kindly	14	35	884	3	_kindly
lanely	9	39	1448	3	_lanely
lankly	13	43	962	3	_lankly
leanly	9	38	1150	3	lean_ly
madly	11	52	1813	3	_ma_dly
manly	10	50	2295	3	_man_ly
meanly	11	54	1204	3	mean_ly
orally	9	31	1359	3	ora_lly
orangey	11	38	883	3	orangey
orangy	10	51	1123	3	oran_gy
organdy	12	5	457	3	organd_y
pandy	11	50	2117	3	_pand_y
pronely	12	3	1025	3	pronely
proudly	13	3	633	3	proudly
rabidly	13	3	625	3	_rabidly
racily	11	7	1517	3	_racily
raddle	8	48	1617	3	_raddle
rainily	10	3	1043	3	_rainily
rally	8	47	2590	3	_ra_lly
rancidly	14	4	443	3	_rancidly
rand	5	58	3957	3	_rand__
randan	7	3	1525	3	_randan
random	9	25	1355	3	_random
randomly	14	4	379	3	_randomly
rands	6	59	3045	3	_rand_s
rangy	9	53	2038	3	_ran_gy
rankle	10	34	1488	3	_rankle
ranula	6	3	1181	3	_ranula
rapidly	13	3	652	3	_rapidly
raptly	11	33	891	3	_raptly
rarely	9	35	1365	3	_rarely
rashly	12	34	1021	3	_rashly
rattly	9	41	1154	3	_rattly
rawly	11	51	1583	3	_ra_wly
redly	9	42	1720	3	_r_edly
repandly	14	4	502	3	repandly
riantly	10	3	761	3	riantly
rindy	9	57	1739	3	_rind_y
roundly	11	3	672	3	roundly
rundle	7	32	1423	3	_rundle
sadly	9	45	1912	3	_sa_dly
sandfly	14	3	564	3	_sandfly
sandy	9	42	2113	3	_sand_y
sanely	9	31	1461	3	_sanely
scantly	12	41	955	3	scantly
shandy	13	47	1003	3	shand_y
slantly	10	39	932	3	slantly
soundly	11	3	668	3	soundly
spangly	13	3	647	3	spangly
spindly	13	25	738	3	spindly
staidly	11	3	668	3	staidly
standby	13	3	442	3	standby
tangly	10	44	1391	3	_tangly
tranny	9	42	1086	3	tran_ny
trendily	12	5	644	3	trendily
trendy	10	46	960	3	trend_y
trindle	8	33	1136	3	trindle
truantly	11	4	464	3	truantly
trundle	8	30	787	3	trundle
uranyl	9	3	629	3	uranyl_
uranyls	10	3	445	3	uranyls
urbanely	13	4	369	3	urbanely
vagrantly	16	4	321	3	vagrantly
waddly	14	47	872	3	_waddly
wandle	10	53	1666	3	_wandle
wanly	11	51	1802	3	_wan_ly
wrangle	11	3	738	3	wrangle
wrinkly	17	29	575	3	wrinkly
wrongly	14	3	455	3	wrongly
zanily	18	3	1018	3	_zanily

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.406	440125.6
2	DLD Change Limit	134027	271	6.470	20715.1
3	Display Results	271	271	0.093	2914.0
	(SQL Overall)	178691	271	6.969	25640.8