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

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

489 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
cranny	11	42	1027	(None)
branny	11	51	1183	1	branny
canny	10	58	1769	1	c_anny
cranky	15	39	1063	1	cranky
granny	10	43	1116	1	granny
tranny	9	42	1086	1	tranny
brainy	11	48	1564	2	brainy
brandy	12	47	1206	2	brandy
brawny	14	47	1060	2	brawny
candy	11	51	1982	2	c_andy
canna	7	59	1933	2	c_anna
canty	10	52	2680	2	c_anty
carney	11	53	1570	2	carney
carny	10	58	2292	2	c_arny
chancy	16	40	1086	2	chancy
chanty	14	52	1582	2	chanty
clanky	15	46	907	2	clanky
crabby	15	34	675	2	crabby
cracky	17	50	1022	2	cracky
crafty	14	47	891	2	crafty
craggy	13	39	660	2	craggy
crampy	15	47	1099	2	crampy
cranch	13	36	1353	2	cranch
crane	7	53	3160	2	cra_ne
craned	9	61	2165	2	craned
cranes	8	43	3075	2	cranes
crania	8	24	1843	2	crania
craning	10	36	2030	2	craning
crank	11	48	1961	2	cra_nk
crankly	16	35	812	2	crankly
cranks	12	50	1531	2	cranks
crannog	10	4	424	2	crannog
crappy	15	44	680	2	crappy
crawly	14	46	1076	2	crawly
crazy	19	55	1122	2	cra_zy
crony	10	59	1867	2	cr_ony
fanny	11	48	1604	2	_fanny
grainy	10	39	1421	2	grainy
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
scrawny	15	21	394	2	scrawny
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	4049	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
cabby	14	53	1456	3	c_abby
caddy	12	54	1402	3	c_addy
cadgy	12	52	1078	3	c_adgy
cagey	11	59	1782	3	c_agey
cagy	10	63	2199	3	c_a_gy
cain	6	56	4391	3	c_ain_
cains	7	53	3430	3	c_ains
cairny	11	55	782	3	cairny
cakey	14	55	1727	3	c_akey
caky	13	62	2244	3	c_a_ky
campy	14	51	1618	3	c_ampy
can	5	77	6014	3	c_a_n_
canal	7	54	2804	3	c_anal
canary	11	3	1469	3	c_anary
cane	6	66	5312	3	c_a_ne
caned	8	58	3809	3	c_aned
caner	7	53	3477	3	c_aner
canes	7	53	5037	3	c_anes
canid	8	55	2634	3	c_anid
canine	8	38	2670	3	c_anine
caning	9	41	2862	3	c_aning
cannas	8	45	1840	3	c_annas
canned	9	50	2206	3	c_anned
cannel	8	42	1640	3	c_annel
canner	8	46	2598	3	c_anner
cannery	12	36	1001	3	c_annery
cannie	8	38	1936	3	c_annie
cannily	12	3	926	3	c_annily
cannon	8	45	1444	3	c_annon
cannot	8	36	1677	3	c_annot
canoe	7	56	2725	3	c_anoe
canon	7	47	2530	3	c_anon
canonry	12	3	592	3	c_anonry
canons	8	55	2206	3	c_anons
canopy	13	3	772	3	c_anopy
cans	6	50	5085	3	c_a_ns
canso	7	50	1940	3	c_anso
canst	7	49	3221	3	c_anst
cant	6	63	6203	3	c_a_nt
canto	7	49	3101	3	c_anto
cants	7	70	3694	3	c_ants
caraway	15	3	813	3	caraway
carboy	13	49	1418	3	carboy
carina	8	43	2533	3	carina
caring	9	51	3799	3	caring
carn	6	62	4543	3	c_arn_
carnal	8	39	1921	3	carnal
carnet	8	47	3287	3	carnet
carneys	12	43	1054	3	carneys
carnie	8	44	2109	3	carnie
carnify	15	5	588	3	carnify
carns	7	59	3756	3	c_arns
carry	10	58	2378	3	c_arry
casky	14	45	1268	3	c_asky
catty	10	45	2041	3	c_atty
cavy	12	59	2000	3	c_a_vy
cay	8	71	5598	3	c_a__y
chaffy	20	45	647	3	chaffy
chain	10	57	2367	3	chain_
chaine	11	51	1922	3	chaine
chains	11	48	1970	3	chains
chalky	18	46	877	3	chalky
chally	14	43	1429	3	chally
chammy	18	48	895	3	chammy
champy	18	50	961	3	champy
chance	13	46	1709	3	chance
chang	11	54	1856	3	cha_ng
change	12	41	1675	3	change
changs	12	52	1537	3	changs
channel	12	39	1048	3	channel
chanoyu	15	4	448	3	chanoyu
chant	10	59	3269	3	cha_nt
chantey	15	41	1254	3	chantey
chantry	15	38	822	3	chantry
chants	11	50	2039	3	chants
charry	14	50	1211	3	charry
chary	13	50	2313	3	cha_ry
chasmy	16	46	854	3	chasmy
chatty	14	41	936	3	chatty
chaunt	11	6	1349	3	chaunt
chay	12	49	2487	3	cha__y
chinky	18	56	1054	3	chinky
chunky	18	46	827	3	chunky
clammy	15	35	633	3	clammy
clan	6	56	3392	3	cla_n_
clang	8	60	1931	3	cla_ng
clangs	9	51	1361	3	clangs
clank	11	47	1952	3	cla_nk
clanks	12	46	1518	3	clanks
clans	7	50	3101	3	cla_ns
clary	10	57	1961	3	cla_ry
classy	11	37	904	3	classy
clay	9	59	2741	3	cla__y
clayey	14	40	766	3	clayey
cleanly	12	3	632	3	cleanly
clingy	12	65	906	3	clingy
clunky	15	44	789	3	clunky
coaly	10	55	2159	3	coa_ly
coannex	16	3	551	3	coannex
colony	11	54	1727	3	colony
coney	10	59	3288	3	c_oney
conky	14	58	1874	3	c_onky
conn	6	62	2913	3	c_onn_
conns	7	50	2423	3	c_onns
cony	9	65	3783	3	c__ony
coranto	9	3	1189	3	coranto
corny	10	60	2327	3	c_orny
county	11	43	1332	3	county
craal	7	41	1775	3	cra_al
craals	8	41	1330	3	craals
crab	8	57	2767	3	cra__b
crabs	9	54	2139	3	cra_bs
crack	13	41	2053	3	cra_ck
crackly	18	39	770	3	crackly
cracks	14	48	1700	3	cracks
cradle	9	33	1316	3	cradle
craft	10	53	2766	3	cra_ft
crafts	11	53	1274	3	crafts
crag	7	56	2530	3	cra__g
crags	8	56	2257	3	cra_gs
crake	11	48	2352	3	cra_ke
crakes	12	49	2181	3	crakes
cram	8	56	3549	3	cra__m
crambe	12	3	907	3	crambe
crambo	12	3	804	3	crambo
cramp	11	51	2069	3	cra_mp
cramps	12	56	1556	3	cramps
crams	9	62	2915	3	cra_ms
cranial	9	21	1468	3	cranial
cranium	11	9	1110	3	cranium
cranked	14	38	1284	3	cranked
cranker	13	36	1279	3	cranker
crankily	17	5	562	3	crankily
cranking	15	46	1307	3	cranking
crankle	13	36	1006	3	crankle
crannied	11	3	789	3	crannied
crannies	10	3	1301	3	crannies
crannoge	11	4	426	3	crannoge
crannogs	11	4	378	3	crannogs
crap	8	57	3184	3	cra__p
crape	9	61	2844	3	cra_pe
craped	11	61	2052	3	craped
crapes	10	47	2769	3	crapes
craping	12	40	1871	3	craping
craps	9	53	2864	3	cra_ps
crases	8	55	3231	3	crases
crash	10	91	2001	3	cra_sh
crasis	8	50	2047	3	crasis
crass	7	63	2804	3	cra_ss
crassly	12	7	665	3	crassly
cratch	13	41	1079	3	cratch
crate	7	65	3740	3	cra_te
crated	9	48	2777	3	crated
crater	8	50	2664	3	crater
crates	8	57	3606	3	crates
crating	10	37	2520	3	crating
craton	8	45	1719	3	craton
cratons	9	43	1603	3	cratons
craunch	14	6	444	3	craunch
cravat	11	3	1444	3	cravat
crave	10	56	2631	3	cra_ve
craved	12	54	1777	3	craved
craven	11	41	1393	3	craven
cravenly	16	4	466	3	cravenly
cravens	12	40	1012	3	cravens
craver	11	46	1847	3	craver
craves	11	58	2539	3	craves
craving	13	40	1573	3	craving
craw	9	77	2526	3	cra__w
crawl	10	49	1671	3	cra_wl
crawls	11	47	1208	3	crawls
craws	10	57	2312	3	cra_ws
crayon	11	41	1000	3	crayon
crayons	12	43	923	3	crayons
craze	16	52	2146	3	cra_ze
crazed	18	47	1445	3	crazed
crazes	17	47	2013	3	crazes
crazily	21	3	692	3	crazily
crazing	19	39	1458	3	crazing
creaky	15	49	1155	3	creaky
creamy	13	48	1136	3	creamy
creasy	11	46	1230	3	creasy
creepy	13	41	880	3	creepy
crenel	8	42	1306	3	crenel
crepey	13	51	1093	3	crepey
crepy	12	48	1270	3	cr_epy
cressy	11	43	911	3	cressy
crikey	15	31	778	3	crikey
criminy	14	26	845	3	criminy
crimpy	15	48	939	3	crimpy
cringe	9	35	1548	3	cringe
crinkly	16	38	752	3	crinkly
crinum	10	3	933	3	crinum
crispy	13	47	856	3	crispy
croaky	15	52	848	3	croaky
crone	7	52	3133	3	cr_one
crones	8	47	2924	3	crones
croon	7	55	2278	3	croon_
croons	8	54	1842	3	croons
croupy	13	45	873	3	croupy
crowdy	15	46	717	3	crowdy
crown	10	56	2008	3	crown_
crowns	11	56	1511	3	crowns
cruddy	13	3	419	3	cruddy
crumby	15	40	811	3	crumby
crummy	15	36	589	3	crummy
crunch	13	34	950	3	crunch
crunchy	17	32	476	3	crunchy
crusty	11	49	1134	3	crusty
cry	8	97	2624	3	cr___y
crying	12	36	1228	3	crying
curably	14	20	1077	3	curably
curacy	13	3	959	3	cura_cy
cyan	9	64	1962	3	cya_n_
cyanic	13	31	1077	3	cyanic
cyanid	12	39	1204	3	cyanid
cyanin	11	39	1145	3	cyanin
cyanine	12	29	1151	3	cyanine
cyanins	12	29	1001	3	cyanins
cyano	10	55	1249	3	cya_no
cyans	10	57	1481	3	cya_ns
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
ginny	9	53	1457	3	_ginny
goanna	7	3	665	3	goanna
grabby	14	33	618	3	grabby
grain	6	51	2625	3	grain_
grains	7	42	2309	3	grains
gran	5	63	3501	3	gra_n_
grana	6	57	2209	3	gra_na
granary	11	5	779	3	granary
grand	7	51	2269	3	gra_nd
grandly	12	3	874	3	grandly
grands	8	42	1824	3	grands
grange	8	37	1620	3	grange
grannie	8	3	1035	3	grannie
grans	6	48	3254	3	gra_ns
grant	6	48	4002	3	gra_nt
grants	7	37	2247	3	grants
granum	9	3	1091	3	granum
grapey	12	60	1230	3	grapey
grapy	11	54	1643	3	gra_py
grassy	10	61	909	3	grassy
gravy	12	55	1211	3	gra_vy
gray	8	53	2989	3	gra__y
grayly	13	28	796	3	grayly
greeny	10	48	1145	3	greeny
grungy	11	34	597	3	grungy
guanay	10	3	791	3	guanay
gunny	9	44	1366	3	_gunny
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	2124	3	_mangy
manly	10	50	2295	3	_manly
manna	7	55	2254	3	_manna
many	9	57	3186	3	_ma_ny
meanly	11	54	1204	3	meanly
meany	10	46	2048	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	6662	3	_ra_n_
rance	7	50	2851	3	_rance
ranch	10	50	1979	3	_ranch
rand	5	58	3957	3	_ra_nd
rands	6	59	3045	3	_rands
ranee	5	54	3810	3	_ranee
rang	5	69	3916	3	_ra_ng
range	6	47	2841	3	_range
rani	4	66	4011	3	_ra_ni
ranid	6	64	2933	3	_ranid
ranis	5	52	3583	3	_ranis
rank	8	51	3553	3	_ra_nk
rankly	13	39	1045	3	_rankly
ranks	9	52	2573	3	_ranks
rant	4	58	6468	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
scraggy	14	30	458	3	scraggy
scrannel	10	4	403	3	scrannel
scrappy	16	23	447	3	scrappy
scrawly	15	19	719	3	scrawly
shandy	13	47	1003	3	shandy
shanty	12	47	1512	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
waney	11	51	2032	3	_waney
wanly	11	51	1802	3	_wanly
wany	10	64	3236	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	1699	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.390	458182.1
2	DLD Change Limit	112716	489	5.860	19234.8
3	Display Results	489	489	0.156	3134.6
	(SQL Overall)	178691	489	6.406	27894.3