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

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

483 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
granny	10	43	1116	(None)
branny	11	51	1183	1	branny
cranny	11	42	1027	1	cranny
grainy	10	39	1421	1	grainy
tranny	9	42	1086	1	tranny
brainy	11	48	1564	2	brainy
brandy	12	47	1206	2	brandy
brawny	14	47	1060	2	brawny
canny	10	58	1769	2	_canny
cranky	15	39	1063	2	cranky
fanny	11	48	1604	2	_fanny
ginny	9	53	1457	2	g_inny
goanna	7	3	665	2	goanna
grabby	14	33	618	2	grabby
grain	6	51	2625	2	grain_
grains	7	42	2309	2	grains
gran	5	63	3501	2	gra_n_
grana	6	57	2209	2	gra_na
granary	11	5	779	2	granary
grand	7	51	2269	2	gra_nd
grandly	12	3	874	2	grandly
grands	8	42	1824	2	grands
grange	8	37	1620	2	grange
grannie	8	3	1035	2	grannie
grans	6	48	3254	2	gra_ns
grant	6	48	4002	2	gra_nt
grants	7	37	2247	2	grants
granum	9	3	1091	2	granum
grapey	12	60	1230	2	grapey
grapy	11	54	1643	2	gra_py
grassy	10	61	909	2	grassy
gravy	12	55	1211	2	gra_vy
gray	8	53	2989	2	gra__y
grayly	13	28	796	2	grayly
greeny	10	48	1145	2	greeny
grungy	11	34	597	2	grungy
guanay	10	3	791	2	guanay
gunny	9	44	1366	2	g_unny
nanny	8	48	1381	2	_nanny
orangy	10	51	1123	2	orangy
rainy	8	59	2108	2	_rainy
randy	9	50	2208	2	_randy
rangy	9	53	2038	2	_rangy
runny	8	46	1348	2	_runny
shanny	12	41	1009	2	shanny
swanny	12	33	682	2	swanny
tyranny	13	4	306	2	tyranny
anna	4	55	2901	3	__anna
annoy	8	6	971	3	__annoy
any	6	84	4048	3	__a_ny
awny	10	59	1930	3	__awny
bandy	11	48	2418	3	_bandy
banns	7	53	2123	3	_banns
banty	10	66	2400	3	_banty
barney	11	53	1445	3	barney
barny	10	58	2173	3	_barny
barony	11	59	1530	3	barony
benny	10	52	1736	3	_benny
blenny	11	5	620	3	blenny
bonny	10	58	1662	3	_bonny
braggy	13	33	717	3	braggy
brain	7	62	2938	3	brain_
brains	8	51	2547	3	brains
braky	14	50	1581	3	bra_ky
bran	6	57	4038	3	bra_n_
branch	13	40	1477	3	branch
branchy	17	35	791	3	branchy
brand	8	51	2449	3	bra_nd
brands	9	51	1894	3	brands
brank	11	52	2228	3	bra_nk
branks	12	48	1738	3	branks
branned	10	43	1169	3	branned
branner	9	42	1237	3	branner
brans	7	54	3743	3	bra_ns
brant	7	47	4217	3	bra_nt
brants	8	57	2305	3	brants
brashy	14	52	1059	3	brashy
brassy	11	50	923	3	brassy
bratty	11	5	968	3	bratty
brawly	14	43	1235	3	brawly
brawn	10	60	1856	3	brawn_
brawns	11	56	1408	3	brawns
braxy	17	54	1089	3	bra_xy
bray	9	52	3290	3	bra__y
briny	10	47	1966	3	br_iny
briony	11	4	904	3	briony
bronzy	20	30	671	3	bronzy
browny	14	45	1004	3	browny
bryony	14	3	583	3	bryony
bunny	10	47	1580	3	_bunny
candy	11	51	1982	3	_candy
canna	7	59	1933	3	_canna
canty	10	52	2680	3	_canty
carney	11	53	1570	3	carney
carny	10	58	2292	3	_carny
chancy	16	40	1086	3	chancy
chanty	14	52	1582	3	chanty
clanky	15	46	907	3	clanky
crabby	15	34	675	3	crabby
cracky	17	50	1022	3	cracky
crafty	14	47	891	3	crafty
craggy	13	39	660	3	craggy
crampy	15	47	1099	3	crampy
cranch	13	36	1353	3	cranch
crane	7	53	3160	3	cra_ne
craned	9	61	2165	3	craned
cranes	8	43	3075	3	cranes
crania	8	24	1843	3	crania
craning	10	36	2030	3	craning
crank	11	48	1961	3	cra_nk
crankly	16	35	812	3	crankly
cranks	12	50	1531	3	cranks
crannog	10	4	424	3	crannog
crappy	15	44	680	3	crappy
crawly	14	46	1076	3	crawly
crazy	19	55	1122	3	cra_zy
crony	10	59	1867	3	cr_ony
dandy	10	44	1670	3	_dandy
djinny	17	3	287	3	djinny
drably	12	35	1161	3	drably
draffy	16	48	663	3	draffy
drafty	13	63	893	3	drafty
draggy	12	34	682	3	draggy
drain	6	52	2289	3	drain_
drains	7	37	1940	3	drains
drank	10	48	1620	3	dra_nk
drapey	12	50	1058	3	drapey
drawly	13	49	1072	3	drawly
drawn	9	56	1424	3	drawn_
dray	8	54	2809	3	dra__y
errancy	12	5	636	3	errancy
fancy	13	46	1548	3	_fancy
fawny	14	47	1171	3	_fawny
fenny	11	51	1513	3	_fenny
finny	11	47	1675	3	_finny
fraena	9	3	806	3	fraena
franc	10	46	1541	3	fra_nc
francs	11	41	1219	3	francs
frank	12	44	1751	3	fra_nk
frankly	17	31	563	3	frankly
franks	13	49	1273	3	franks
fray	10	54	2890	3	fra__y
frenzy	21	3	588	3	frenzy
fringy	13	30	926	3	fringy
funny	11	46	1483	3	_funny
gabby	13	55	1295	3	g_abby
gaby	10	71	2319	3	g_a_by
gaen	5	73	2960	3	g_aen_
gaily	9	50	2097	3	g_aily
gain	5	60	4216	3	g_ain_
gainly	10	4	932	3	gainly
gains	6	57	2951	3	g_ains
gally	9	50	2617	3	g_ally
gamay	11	64	1910	3	g_amay
gamey	11	53	2055	3	g_amey
gammy	13	55	1489	3	g_ammy
gamy	10	54	2753	3	g_a_my
gan	4	80	6012	3	g_a_n_
gane	5	51	4529	3	g_a_ne
ganef	9	63	2246	3	g_anef
ganev	9	55	1386	3	g_anev
gang	6	60	3196	3	g_a_ng
gangly	11	39	1158	3	g_angly
gangs	7	62	2257	3	g_angs
ganja	13	14	1000	3	g_anja
gannet	7	43	2185	3	g_annet
ganof	9	54	2036	3	g_anof
gantry	10	38	1011	3	g_antry
gappy	13	62	1203	3	g_appy
gapy	10	63	2091	3	g_a_py
garganey	13	4	488	3	garganey
garner	7	39	1700	3	garner
garnet	7	39	2841	3	garnet
garni	6	3	1570	3	g_arni
garvey	13	12	787	3	garvey
gassy	9	55	1402	3	g_assy
gaudy	10	66	1146	3	g_audy
gaun	5	64	2771	3	g_aun_
gaunt	6	54	3040	3	g_aunt
gauzy	18	48	921	3	g_auzy
gawky	16	56	999	3	g_awky
gawsy	12	45	909	3	g_awsy
gay	7	68	5649	3	g_a__y
gayly	12	45	1309	3	g_ayly
gharry	13	54	627	3	gharry
giant	6	54	3059	3	gia_nt
giants	7	47	1350	3	giants
gladly	11	49	793	3	gladly
glady	10	54	1394	3	gla_dy
glairy	10	44	827	3	glairy
glance	9	43	1231	3	glance
gland	7	52	1771	3	gla_nd
glands	8	53	1440	3	glands
glans	6	51	2583	3	gla_ns
glary	9	60	1854	3	gla_ry
glassy	10	52	775	3	glassy
glazy	18	74	1098	3	gla_zy
glinty	10	69	1069	3	glinty
gnarly	10	46	1038	3	gnarly
gnatty	10	33	648	3	gnatty
gnawn	9	51	778	3	gnawn_
goannas	8	3	622	3	goannas
gobony	12	3	691	3	gobony
gooney	10	66	1231	3	gooney
goony	9	55	1978	3	g_oony
gowany	13	45	749	3	gowany
graal	6	43	1650	3	gra_al
graals	7	41	1291	3	graals
grab	7	54	2761	3	gra__b
graben	9	41	972	3	graben
grabens	10	36	700	3	grabens
grabs	8	57	1969	3	gra_bs
grace	8	51	2454	3	gra_ce
graced	10	52	1790	3	graced
graces	9	45	2349	3	graces
gracing	11	32	1644	3	gracing
grad	6	68	2986	3	gra__d
grade	7	51	2609	3	gra_de
graded	9	49	1955	3	graded
grader	8	49	1969	3	grader
grades	8	49	2631	3	grades
gradin	8	35	1748	3	gradin
gradine	9	33	1703	3	gradine
grading	10	39	1871	3	grading
gradins	9	34	1623	3	gradins
grads	7	56	2575	3	gra_ds
gradus	8	44	1121	3	gradus
graft	9	53	2720	3	gra_ft
grafts	10	50	1325	3	grafts
graham	12	3	785	3	graham
grail	6	46	2287	3	gra_il
grails	7	75	1878	3	grails
grained	9	38	1427	3	grained
grainer	8	37	1406	3	grainer
graining	10	28	1318	3	graining
gram	7	70	3458	3	gra__m
grama	8	56	2028	3	gra_ma
gramary	13	5	590	3	gramary
gramas	9	43	1720	3	gramas
gramma	11	49	980	3	gramma
gramme	11	42	1033	3	gramme
gramp	10	62	1832	3	gra_mp
grampa	11	50	1017	3	grampa
gramps	11	41	1427	3	gramps
grams	8	53	2731	3	gra_ms
grandad	10	3	845	3	grandad
grandam	11	3	939	3	grandam
grandee	9	31	1551	3	grandee
grander	9	33	1587	3	grander
grandma	11	3	691	3	grandma
grandpa	11	3	541	3	grandpa
granger	9	35	1421	3	granger
granges	9	35	1652	3	granges
granita	8	21	1130	3	granita
granite	8	20	1708	3	granite
grannies	9	3	1261	3	grannies
granola	8	3	791	3	granola
granted	9	47	1510	3	granted
grantee	8	32	1713	3	grantee
granter	8	41	1713	3	granter
granting	10	35	1452	3	granting
grantor	8	40	1093	3	grantor
granule	8	3	947	3	granule
grape	8	48	2466	3	gra_pe
grapery	13	45	795	3	grapery
grapes	9	51	2312	3	grapes
graph	11	53	1561	3	gra_ph
graphs	12	45	1015	3	graphs
grapnel	10	3	560	3	grapnel
grappa	11	39	644	3	grappa
grasp	8	48	1448	3	gra_sp
grasps	9	48	925	3	grasps
grass	6	61	2520	3	gra_ss
grat	5	56	5128	3	gra__t
grate	6	49	3288	3	gra_te
grated	8	45	2392	3	grated
grater	7	46	2543	3	grater
grates	7	54	2988	3	grates
gratify	14	3	611	3	gratify
gratin	7	45	2058	3	gratin
gratine	8	47	1919	3	gratine
grating	9	39	2318	3	grating
gratins	8	41	1918	3	gratins
gratis	7	48	1924	3	gratis
grave	9	46	2487	3	gra_ve
graved	11	48	1881	3	graved
gravel	10	53	1382	3	gravel
gravely	14	46	906	3	gravely
graven	10	45	1352	3	graven
graver	10	50	1859	3	graver
graves	10	46	2400	3	graves
gravid	11	37	1097	3	gravid
graving	12	31	1456	3	graving
gravity	14	3	718	3	gravity
grayed	11	54	1564	3	grayed
grayer	10	60	1454	3	grayer
graying	12	41	1588	3	graying
grays	9	56	2133	3	gra_ys
graze	15	58	2005	3	gra_ze
grazed	17	41	1591	3	grazed
grazer	16	48	1576	3	grazer
grazes	16	45	1964	3	grazes
grazing	18	35	1455	3	grazing
greasy	10	41	946	3	greasy
greatly	11	3	761	3	greatly
greedy	11	51	884	3	greedy
green	6	55	2214	3	green_
greenly	11	40	818	3	greenly
greens	7	57	1687	3	greens
gremmy	14	5	447	3	gremmy
grey	8	56	2404	3	gr__ey
greyly	13	31	654	3	greyly
grimly	12	45	993	3	grimly
grimy	11	43	1260	3	gr_imy
grin	5	57	3372	3	gr_in_
grinch	12	3	847	3	grinch
grind	7	59	1756	3	gr_ind
grinds	8	45	1184	3	grinds
gringa	8	3	854	3	gringa
gringo	8	3	864	3	gringo
grinned	9	37	855	3	grinned
grinner	8	32	923	3	grinner
grins	6	54	2722	3	gr_ins
gripey	12	41	1120	3	gripey
grippy	14	44	776	3	grippy
gripy	11	51	1525	3	gr_ipy
grisly	10	43	1058	3	grisly
gritty	10	33	840	3	gritty
groan	6	56	1842	3	groan_
groaned	9	25	997	3	groaned
groaner	8	25	1013	3	groaner
groaning	10	24	1028	3	groaning
groans	7	48	1506	3	groans
grody	10	34	1206	3	gr_ody
groggy	12	3	480	3	groggy
groin	6	55	2108	3	groin_
groins	7	39	1720	3	groins
groovy	13	37	540	3	groovy
groszy	19	39	570	3	groszy
grotty	10	38	983	3	grotty
ground	8	23	1027	3	ground
grouty	10	47	1098	3	grouty
growly	13	49	917	3	growly
grown	9	53	1735	3	grown_
groyne	10	3	721	3	groyne
grubby	14	32	450	3	grubby
gruffy	16	39	601	3	gruffy
grumpy	14	49	815	3	grumpy
grunge	8	35	958	3	grunge
grunt	6	55	2354	3	gr_unt
grunts	7	55	1185	3	grunts
guan	5	53	2558	3	gua_n_
guanays	11	3	495	3	guanays
guanin	7	6	1080	3	guanin
guanine	8	8	1054	3	guanine
guanins	8	8	1001	3	guanins
guano	6	92	1398	3	gua_no
guanos	7	38	1199	3	guanos
guans	6	44	1944	3	gua_ns
guaranty	12	4	415	3	guaranty
gunky	13	55	1411	3	g_unky
gurney	10	42	941	3	gurney
gyrally	14	3	558	3	gyrally
handy	12	55	2087	3	_handy
hanky	15	54	1829	3	_hanky
hinny	11	56	1667	3	_hinny
irony	8	50	1590	3	ir_ony
janty	15	68	1696	3	_janty
jenny	15	38	1162	3	_jenny
johnny	19	3	219	3	johnny
lanky	12	55	1748	3	_lanky
lawny	11	59	1201	3	_lawny
leanly	9	38	1150	3	leanly
mangy	11	50	2123	3	_mangy
manly	10	50	2294	3	_manly
manna	7	55	2253	3	_manna
many	9	57	3184	3	_ma_ny
meanly	11	54	1204	3	meanly
meany	10	46	2047	3	mea_ny
minny	10	45	1866	3	_minny
nancy	10	52	1492	3	_nancy
ninny	8	45	1493	3	_ninny
orally	9	31	1359	3	orally
orang	6	51	1994	3	ora_ng
orange	7	40	1632	3	orange
orangey	11	38	883	3	orangey
orangs	7	41	1603	3	orangs
organdy	12	5	457	3	organdy
pandy	11	50	2117	3	_pandy
panne	7	66	2365	3	_panne
pansy	10	57	1797	3	_pansy
panty	10	59	2930	3	_panty
penny	10	51	1945	3	_penny
pinny	10	52	2206	3	_pinny
prajna	15	3	507	3	prajna
prance	10	43	1857	3	prance
prang	8	48	2032	3	pra_ng
prangs	9	48	1623	3	prangs
prank	11	50	1945	3	pra_nk
pranks	12	48	1472	3	pranks
prawn	10	53	1243	3	prawn_
prawns	11	50	902	3	prawns
pray	9	63	3153	3	pra__y
punny	10	42	1771	3	_punny
racy	9	58	2568	3	_ra_cy
raggy	10	61	1657	3	_raggy
rain	4	62	5173	3	_rain_
rains	5	51	4023	3	_rains
rally	8	47	2590	3	_rally
rammy	12	43	1249	3	_rammy
ran	3	82	6661	3	_ra_n_
rance	7	50	2851	3	_rance
ranch	10	50	1979	3	_ranch
rand	5	58	3956	3	_ra_nd
rands	6	59	3045	3	_rands
ranee	5	54	3810	3	_ranee
rang	5	69	3915	3	_ra_ng
range	6	47	2841	3	_range
rani	4	66	4010	3	_ra_ni
ranid	6	64	2933	3	_ranid
ranis	5	52	3583	3	_ranis
rank	8	51	3552	3	_ra_nk
rankly	13	39	1045	3	_rankly
ranks	9	52	2573	3	_ranks
rant	4	58	6467	3	_ra_nt
rants	5	59	3534	3	_rants
raspy	10	65	1170	3	_raspy
ratany	9	34	1187	3	_ratany
ratty	8	48	1959	3	_ratty
rawly	11	51	1583	3	_rawly
ray	6	63	6199	3	_ra__y
rindy	9	57	1739	3	_rindy
runty	8	61	1904	3	_runty
sandy	9	42	2113	3	_sandy
scanty	11	40	1466	3	scanty
scrawny	15	21	393	3	scrawny
shandy	13	47	1003	3	shandy
shanty	12	47	1511	3	shanty
sharny	12	47	1183	3	sharny
shinny	12	48	1078	3	shinny
skanky	12	47	696	3	skanky
skinny	13	45	661	3	skinny
slangy	10	54	1139	3	slangy
slanty	9	51	1484	3	slanty
sonny	8	50	1610	3	_sonny
spinny	11	45	1018	3	spinny
sunny	8	49	1774	3	_sunny
swanky	16	44	797	3	swanky
tangy	9	45	1993	3	_tangy
tannoy	9	5	835	3	_tannoy
tansy	8	45	1493	3	_tansy
tawny	11	47	1365	3	_tawny
tinny	8	53	1765	3	_tinny
train	5	65	2911	3	train_
trains	6	47	2534	3	trains
trampy	13	49	925	3	trampy
trance	8	47	1876	3	trance
trank	9	62	2242	3	tra_nk
tranks	10	40	1776	3	tranks
tranq	14	54	1689	3	tra_nq
tranqs	15	52	1031	3	tranqs
trans	5	49	3304	3	tra_ns
trashy	12	50	905	3	trashy
tray	7	76	3259	3	tra__y
trendy	10	46	960	3	trendy
truancy	12	4	499	3	truancy
tunny	8	65	1503	3	_tunny
twangy	13	38	698	3	twangy
twanky	16	44	577	3	twanky
uncanny	12	4	511	3	uncanny
urania	6	25	1612	3	urania
uranic	8	23	1518	3	uranic
uranyl	9	3	629	3	uranyl
vagrancy	17	4	345	3	vagrancy
waney	11	51	2032	3	_waney
wanly	11	51	1802	3	_wanly
wany	10	64	3235	3	_wa_ny
wenny	11	44	1246	3	_wenny
whinny	15	58	749	3	whinny
wrang	9	47	1611	3	wra_ng
wrangs	10	46	1191	3	wrangs
wrathy	15	37	785	3	wrathy
zany	16	73	1698	3	_za_ny

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.126	1418182.5
2	DLD Change Limit	112716	483	6.576	17140.5
3	Display Results	483	483	0.156	3096.2
	(SQL Overall)	178691	483	6.858	26055.8