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

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

422 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
swanny	12	33	682	(None)
shanny	12	41	1009	1	shanny
swanky	16	44	797	1	swanky
branny	11	51	1183	2	branny
canny	10	58	1769	2	_canny
cranny	11	42	1027	2	cranny
fanny	11	48	1604	2	_fanny
granny	10	43	1116	2	granny
nanny	8	48	1381	2	_nanny
sandy	9	42	2113	2	s_andy
sawney	12	38	760	2	sawney
scanty	11	40	1466	2	scanty
shandy	13	47	1003	2	shandy
shanty	12	47	1512	2	shanty
sharny	12	47	1183	2	sharny
shinny	12	48	1078	2	shinny
skanky	12	47	696	2	skanky
skinny	13	45	661	2	skinny
slangy	10	54	1139	2	slangy
slanty	9	51	1484	2	slanty
sonny	8	50	1610	2	s_onny
spinny	11	45	1018	2	spinny
sunny	8	49	1774	2	s_unny
swabby	16	3	435	2	swabby
swain	8	49	1905	2	swain_
swains	9	45	1395	2	swains
swampy	16	43	723	2	swampy
swamy	13	67	1440	2	swa_my
swan	7	66	3131	2	swa_n_
swang	9	55	1972	2	swa_ng
swank	12	53	1823	2	swa_nk
swanks	13	48	1156	2	swanks
swanned	11	35	817	2	swanned
swannery	14	3	355	2	swannery
swans	8	46	2501	2	swa_ns
swarty	12	58	1238	2	swarty
sway	10	71	2823	2	swa__y
sweeny	12	35	884	2	sweeny
swingy	13	48	987	2	swingy
swinney	13	36	597	2	swinney
swoony	12	40	826	2	swoony
tranny	9	42	1086	2	tranny
twangy	13	38	699	2	twangy
twanky	16	44	577	2	twanky
waney	11	51	2032	2	_waney
wanly	11	51	1802	2	_wanly
wany	10	64	3236	2	_wa_ny
wenny	11	44	1246	2	_wenny
anna	4	55	2901	3	__anna
annoy	8	6	971	3	__annoy
any	6	84	4049	3	__a_ny
away	10	80	2422	3	awa__y
awny	10	59	1930	3	__awny
bandy	11	48	2419	3	_bandy
banns	7	53	2123	3	_banns
banty	10	66	2400	3	_banty
barny	10	58	2173	3	_barny
benny	10	52	1736	3	_benny
blenny	11	5	620	3	blenny
bonny	10	58	1662	3	_bonny
brainy	11	48	1564	3	brainy
brandy	12	47	1206	3	brandy
brawny	14	47	1060	3	brawny
bunny	10	47	1580	3	_bunny
bwana	10	3	1024	3	bwa_na
bwanas	11	5	744	3	bwanas
candy	11	51	1982	3	_candy
canna	7	59	1933	3	_canna
canty	10	52	2680	3	_canty
carny	10	58	2292	3	_carny
chancy	16	40	1086	3	chancy
chanty	14	52	1582	3	chanty
clanky	15	46	907	3	clanky
cranky	15	39	1063	3	cranky
dandy	10	44	1670	3	_dandy
djinny	17	3	287	3	djinny
fancy	13	46	1548	3	_fancy
fawny	14	47	1171	3	_fawny
fenny	11	51	1513	3	_fenny
finny	11	47	1675	3	_finny
funny	11	46	1483	3	_funny
ginny	9	53	1457	3	_ginny
goanna	7	3	665	3	goanna
gowany	13	45	749	3	gowa_ny
grainy	10	39	1421	3	grainy
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
hwan	10	57	1689	3	hwa_n_
janty	15	68	1696	3	_janty
jenny	15	38	1162	3	_jenny
johnny	19	3	219	3	johnny
kwanza	22	3	247	3	kwanza
lanky	12	55	1748	3	_lanky
lawny	11	59	1201	3	_lawny
leanly	9	38	1150	3	leanly
mangy	11	50	2125	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
orangy	10	51	1123	3	orangy
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
punny	10	42	1771	3	_punny
rainy	8	59	2108	3	_rainy
randy	9	50	2208	3	_randy
rangy	9	53	2039	3	_rangy
runny	8	46	1348	3	_runny
sadly	9	45	1912	3	s_adly
saggy	10	59	1746	3	s_aggy
sagy	8	53	2708	3	s_a_gy
sain	4	55	5129	3	s_ain_
sains	5	56	3997	3	s_ains
saint	5	51	4707	3	s_aint
sally	8	51	2971	3	s_ally
salty	8	55	2438	3	s_alty
sand	5	53	3847	3	s_a_nd
sands	6	52	2858	3	s_ands
sane	4	59	5434	3	s_a_ne
saned	6	56	3627	3	s_aned
sanely	9	31	1461	3	s_anely
saner	5	43	3432	3	s_aner
sanes	5	56	4907	3	s_anes
sang	5	54	4124	3	s_a_ng
sanga	6	60	2380	3	s_anga
sangh	9	55	1746	3	s_angh
saning	7	51	2764	3	s_aning
sanity	9	3	1620	3	s_anity
sank	8	52	3683	3	s_a_nk
sannop	8	3	737	3	s_annop
sannup	8	3	656	3	s_annup
sans	4	51	5336	3	s_a_ns
santo	5	62	2728	3	s_anto
sappy	12	54	1347	3	s_appy
sarky	12	55	2178	3	s_arky
sassy	8	58	1381	3	s_assy
satay	8	47	1846	3	s_atay
satiny	9	38	1798	3	satiny
saucy	10	46	1516	3	s_aucy
sauna	5	41	1755	3	s_auna
saury	8	43	1722	3	s_aury
savanna	10	4	371	3	savanna
savoy	11	47	1388	3	s_avoy
savvy	14	49	750	3	s_avvy
sawfly	15	3	513	3	sawfly
sawing	10	43	2381	3	sawing
sawn	7	54	2816	3	s_awn_
sawneys	13	27	464	3	sawneys
saxony	16	3	623	3	saxony
say	6	72	6476	3	s_a__y
scabby	15	3	550	3	scabby
scaly	10	47	1872	3	sca_ly
scan	6	55	3045	3	sca_n_
scanned	10	41	1089	3	scanned
scanner	9	44	1181	3	scanner
scans	7	46	2510	3	sca_ns
scant	7	97	3507	3	sca_nt
scantly	12	41	955	3	scantly
scants	8	52	1972	3	scants
scarey	11	50	1698	3	scarey
scarry	11	63	1118	3	scarry
scary	10	52	2259	3	sca_ry
scatty	11	53	1065	3	scatty
scrawny	15	21	394	3	scrawny
seamy	10	59	2127	3	sea_my
seance	8	37	1669	3	seance
seaway	12	30	999	3	seaway
senary	9	37	1607	3	senary
senna	5	46	1798	3	s_enna
sewan	8	59	2129	3	sewa_n_
sewans	9	52	1590	3	sewa_ns
shabby	16	3	580	3	shabby
shady	12	54	1651	3	sha_dy
shaggy	14	47	804	3	shaggy
shaky	15	46	1684	3	sha_ky
shaley	12	37	1499	3	shaley
shaly	11	43	2286	3	sha_ly
shammy	16	38	850	3	shammy
shamoy	14	37	991	3	shamoy
shank	12	54	2219	3	sha_nk
shanks	13	53	1558	3	shanks
shantey	13	42	1004	3	shantey
shanti	9	40	1409	3	shanti
sharn	8	48	2370	3	sharn_
sharns	9	55	1698	3	sharns
sharpy	14	52	1103	3	sharpy
shawn	11	64	1761	3	shawn_
shay	10	71	3334	3	sha__y
sheeny	12	49	1219	3	sheeny
shindy	13	44	932	3	shindy
shinney	13	36	830	3	shinney
shiny	11	51	2214	3	s_hiny
sienna	6	4	719	3	sienna
simony	11	3	790	3	simony
skank	8	44	1558	3	ska_nk
skanks	9	47	1083	3	skanks
skunky	12	43	616	3	skunky
slaggy	11	43	879	3	slaggy
slain	5	49	2357	3	slain_
slang	6	63	2402	3	sla_ng
slangs	7	56	1534	3	slangs
slank	9	58	2277	3	sla_nk
slant	5	52	3870	3	sla_nt
slantly	10	39	932	3	slantly
slants	6	48	1908	3	slants
slatey	9	54	1706	3	slatey
slaty	8	65	2315	3	sla_ty
slavey	12	40	1180	3	slavey
slay	7	64	3638	3	sla__y
slinky	13	39	910	3	slinky
smarmy	13	62	935	3	smarmy
smarty	11	50	1379	3	smarty
snaggy	11	48	805	3	snaggy
snakey	13	50	1127	3	snakey
snaky	12	51	1391	3	sna_ky
snappy	13	6	610	3	snappy
snarky	13	42	1084	3	snarky
snarly	9	38	1500	3	snarly
snazzy	17	3	401	3	snazzy
soapy	10	61	1478	3	soa_py
sonant	6	6	2195	3	sonant
sonly	8	57	1805	3	s_only
sonsy	8	64	1637	3	s_onsy
sowans	9	42	1589	3	sowa_ns
spacey	13	62	1253	3	spacey
spacy	12	54	1562	3	spa_cy
span	6	52	3466	3	spa_n_
spang	8	49	1973	3	spa_ng
spangly	13	3	647	3	spangly
spank	11	59	1957	3	spa_nk
spanks	12	45	1412	3	spanks
spanned	10	41	1122	3	spanned
spanner	9	43	1256	3	spanner
spans	7	45	2873	3	spa_ns
sparky	15	45	1152	3	sparky
sparry	11	51	1130	3	sparry
spawn	10	78	1171	3	spawn_
spawns	11	57	792	3	spawns
spay	9	66	3166	3	spa__y
spendy	12	49	1114	3	spendy
spinney	12	43	892	3	spinney
spiny	10	49	2130	3	s_piny
spongy	12	3	674	3	spongy
spoony	11	41	1179	3	spoony
spunky	15	42	716	3	spunky
squinny	19	27	422	3	squinny
stably	11	33	1412	3	stably
stagey	10	59	1558	3	stagey
staggy	11	55	1039	3	staggy
stagy	9	66	1889	3	sta_gy
stain	5	57	2794	3	stain_
stains	6	49	2365	3	stains
stalky	13	49	930	3	stalky
stance	8	43	1691	3	stance
stanch	11	38	1237	3	stanch
stand	6	59	2328	3	sta_nd
standby	13	3	442	3	standby
stands	7	51	1805	3	stands
stane	5	59	3300	3	sta_ne
staned	7	48	2464	3	staned
stanes	6	49	3340	3	stanes
stang	6	64	2469	3	sta_ng
stangs	7	50	1817	3	stangs
stanine	7	34	1707	3	stanine
staning	8	39	2224	3	staning
stank	9	58	2330	3	sta_nk
stanks	10	49	1770	3	stanks
stannary	11	4	461	3	stannary
stannic	9	3	666	3	stannic
stannum	9	4	464	3	stannum
stanol	6	3	1072	3	stanol
stanza	15	3	707	3	stanza
starry	9	49	1167	3	starry
stay	7	83	3372	3	sta__y
stingy	10	52	1320	3	stingy
stinky	13	46	1107	3	stinky
stoney	9	62	1735	3	stoney
stony	8	58	1864	3	s_tony
suably	11	28	1453	3	suably
sunn	4	54	2359	3	s_unn_
sunna	5	50	1606	3	s_unna
sunns	5	50	1735	3	s_unns
swab	9	68	2531	3	swa__b
swabs	10	58	1727	3	swa_bs
swag	8	75	2673	3	swa__g
swage	9	49	1956	3	swa_ge
swaged	11	42	1225	3	swaged
swager	10	40	1361	3	swager
swages	10	44	1707	3	swages
swaging	12	42	1063	3	swaging
swags	9	49	2125	3	swa_gs
swail	8	62	1716	3	swa_il
swails	9	49	1312	3	swails
swale	8	52	2159	3	swa_le
swales	9	39	2076	3	swales
swam	9	63	2998	3	swa__m
swami	10	56	1452	3	swa_mi
swamis	11	42	1229	3	swamis
swamp	12	50	1532	3	swa_mp
swamps	13	59	1026	3	swamps
swanked	15	35	954	3	swanked
swanker	14	36	948	3	swanker
swankily	18	3	383	3	swankily
swanking	16	39	996	3	swanking
swanning	12	33	881	3	swanning
swanpan	12	4	369	3	swanpan
swanpans	13	4	342	3	swanpans
swap	9	59	2543	3	swa__p
swaps	10	48	1920	3	swa_ps
swaraj	16	3	602	3	swaraj
sward	9	42	2146	3	swa_rd
swards	10	54	1513	3	swards
sware	8	58	2821	3	swa_re
swarf	11	53	2465	3	swa_rf
swarfs	12	56	1206	3	swarfs
swarm	10	62	1884	3	swa_rm
swarms	11	61	1217	3	swarms
swart	8	62	3464	3	swa_rt
swarth	12	60	1208	3	swarth
swarthy	16	46	637	3	swarthy
swash	11	63	1675	3	swa_sh
swat	7	72	4444	3	swa__t
swatch	14	54	928	3	swatch
swath	11	59	2038	3	swa_th
swathe	12	55	1411	3	swathe
swaths	12	53	1264	3	swaths
swats	8	57	2686	3	swa_ts
swayed	13	35	1026	3	swayed
swayer	12	52	1097	3	swayer
swaying	14	36	1064	3	swaying
sways	11	55	1846	3	swa_ys
sweaty	12	37	1005	3	sweaty
sweeney	13	38	700	3	sweeney
sweepy	14	44	745	3	sweepy
swimmy	16	23	435	3	swimmy
swine	8	56	2530	3	sw_ine
swing	9	61	2484	3	sw_ing
swingby	16	34	389	3	swingby
swinge	10	56	1438	3	swinge
swings	10	47	1445	3	swings
swink	12	51	1635	3	sw_ink
swinks	13	46	1065	3	swinks
swinneys	14	26	420	3	swinneys
swirly	12	43	925	3	swirly
swishy	15	36	584	3	swishy
swoon	8	50	1478	3	swoon_
swoons	9	45	1114	3	swoons
swoopy	14	48	728	3	swoopy
sworn	8	61	1531	3	sworn_
swoun	8	48	1149	3	swoun_
swound	10	37	763	3	swound
swouns	9	35	824	3	swouns
swung	9	56	1056	3	sw_ung
tangy	9	45	1995	3	_tangy
tannoy	9	5	836	3	_tannoy
tansy	8	45	1494	3	_tansy
tawney	12	33	823	3	tawney
tawny	11	47	1365	3	_tawny
tinny	8	53	1765	3	_tinny
tunny	8	65	1503	3	_tunny
twain	8	63	1362	3	twain_
twains	9	58	1118	3	twains
twang	9	45	1186	3	twa_ng
twangs	10	35	810	3	twangs
tweeny	12	47	700	3	tweeny
twenty	12	3	622	3	twenty
twiny	11	60	1281	3	tw_iny
tyranny	13	4	306	3	tyranny
uncanny	12	4	511	3	uncanny
wacky	17	47	1493	3	_wacky
waddy	13	53	1299	3	_waddy
wady	11	53	2499	3	_wa_dy
wain	7	58	4020	3	_wain_
wains	8	69	3087	3	_wains
wally	11	46	2509	3	_wally
waly	10	58	3090	3	_wa_ly
wan	6	67	6194	3	_wa_n_
wand	8	58	3388	3	_wa_nd
wands	9	64	2548	3	_wands
wane	7	63	4472	3	_wa_ne
waned	9	58	3178	3	_waned
wanes	8	50	4088	3	_wanes
waning	10	36	2380	3	_waning
wank	11	56	3251	3	_wa_nk
wanks	12	61	2448	3	_wanks
wanned	10	43	1801	3	_wanned
wanner	9	40	1962	3	_wanner
wans	7	64	5227	3	_wa_ns
want	7	61	5617	3	_wa_nt
wants	8	79	3221	3	_wants
warn	7	52	3932	3	_warn_
warns	8	72	3100	3	_warns
warty	11	93	2382	3	_warty
wary	10	67	4001	3	_wa_ry
washy	14	59	1184	3	_washy
waspy	13	54	1099	3	_waspy
wavey	14	51	1554	3	_wavey
wavy	13	66	2047	3	_wa_vy
waxy	17	59	1820	3	_wa_xy
way	9	67	5766	3	_wa__y
weeny	11	53	1616	3	_weeny
whinny	15	58	749	3	whinny
whiny	14	49	1557	3	_whiny
windy	12	61	1810	3	_windy
winey	11	53	2543	3	_winey
wingy	12	65	2103	3	_wingy
winy	10	70	3432	3	_w_iny
wonky	15	40	1177	3	_wonky
wynn	10	58	1129	3	_wynn_
wynns	11	51	747	3	_wynns
zany	16	73	1699	3	_za_ny

Search took 6 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	422	5.173	21789.3
3	Display Results	422	422	0.123	3430.9
	(SQL Overall)	178691	422	5.686	31426.5