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

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

404 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
shammy	16	38	850	(None)
chammy	18	48	895	1	chammy
hammy	15	51	1343	1	_hammy
shamoy	14	37	991	1	shamoy
shimmy	16	30	641	1	shimmy
whammy	19	37	529	1	whammy
champy	18	50	961	2	champy
chasmy	16	46	854	2	chasmy
chummy	18	38	589	2	chummy
clammy	15	35	633	2	clammy
gammy	13	55	1489	2	_gammy
jammy	19	48	1019	2	_jammy
mammy	11	52	1516	2	_mammy
rammy	12	43	1249	2	_rammy
scummy	15	26	522	2	scummy
seamy	10	59	2127	2	sea_my
shabby	16	3	580	2	shabby
shady	12	54	1651	2	sha_dy
shaggy	14	47	804	2	shaggy
shaky	15	46	1684	2	sha_ky
shaley	12	37	1499	2	shaley
shaly	11	43	2286	2	sha_ly
sham	9	64	3635	2	sha_m_
shaman	11	33	1427	2	shaman
shamas	11	37	1793	2	shamas
shame	10	57	2670	2	sha_me
shamed	12	51	2021	2	shamed
shames	11	47	2622	2	shames
shammas	14	35	871	2	shammas
shammed	15	39	1142	2	shammed
shammer	14	46	1314	2	shammer
shammes	14	43	1283	2	shammes
shammos	14	30	720	2	shammos
shamos	11	42	1698	2	shamos
shamoys	15	36	728	2	shamoys
shams	10	58	2941	2	sha_ms
shamus	11	41	1281	2	shamus
shandy	13	47	1003	2	shandy
shanny	12	41	1009	2	shanny
shanty	12	47	1511	2	shanty
sharny	12	47	1183	2	sharny
sharpy	14	52	1103	2	sharpy
shawm	13	53	1614	2	shawm_
shawms	14	57	956	2	shawms
shay	10	71	3334	2	sha__y
slummy	13	32	586	2	slummy
smarmy	13	62	935	2	smarmy
stemmy	13	41	703	2	stemmy
swampy	16	43	723	2	swampy
swamy	13	67	1440	2	swa_my
swimmy	16	23	435	2	swimmy
tammy	12	40	1322	2	_tammy
whammo	16	40	519	2	whammo
ammo	8	55	2013	3	__ammo
army	9	66	2418	3	__army
ashamed	13	3	624	3	ashamed
balmy	12	52	1747	3	_balmy
barmy	12	52	1876	3	_barmy
beamy	12	62	1857	3	bea_my
campy	14	51	1618	3	_campy
chacma	15	3	790	3	chacma
chaffy	20	45	647	3	chaffy
chalky	18	46	877	3	chalky
chally	14	43	1429	3	chally
cham	11	55	3231	3	cha_m_
champ	14	50	1796	3	cha_mp
champs	15	49	1568	3	champs
chams	12	60	2850	3	cha_ms
chancy	16	40	1086	3	chancy
chanty	14	52	1582	3	chanty
charm	12	61	2466	3	charm_
charms	13	52	1883	3	charms
charry	14	50	1211	3	charry
chary	13	50	2313	3	cha_ry
chasm	12	55	1879	3	chasm_
chasms	13	55	1314	3	chasms
chatty	14	41	936	3	chatty
chay	12	49	2487	3	cha__y
chromy	16	30	990	3	chromy
commy	14	47	1264	3	_commy
crampy	15	47	1099	3	crampy
crummy	15	36	589	3	crummy
dharma	12	7	610	3	dharma
dummy	13	47	1278	3	_dummy
emmy	11	60	1324	3	__emmy
flamy	13	52	1747	3	fla_my
foamy	13	53	1320	3	foa_my
gamay	11	64	1910	3	_gamay
gamey	11	53	2055	3	_gamey
gamma	10	61	1610	3	_gamma
gamy	10	54	2753	3	_ga_my
gemmy	13	52	1105	3	_gemmy
gharry	13	54	627	3	gharry
gramma	11	49	980	3	gramma
gramme	11	42	1033	3	gramme
gremmy	14	5	447	3	gremmy
gummy	13	54	1365	3	_gummy
haem	9	57	3098	3	_haem_
haems	10	55	1701	3	_haems
hairy	11	53	1683	3	_hairy
halm	9	58	3497	3	_halm_
halma	10	82	1925	3	_halma
halms	10	52	2521	3	_halms
ham	8	63	6328	3	_ha_m_
hamal	10	46	2310	3	_hamal
hame	9	70	4313	3	_ha_me
hames	10	61	3870	3	_hames
hammal	13	45	1206	3	_hammal
hammam	12	41	933	3	_hammam
hammed	14	41	1697	3	_hammed
hammer	13	81	2003	3	_hammer
hammily	17	3	606	3	_hammily
hams	9	64	4613	3	_ha_ms
hamza	19	13	977	3	_hamza
handy	12	55	2087	3	_handy
hanky	15	54	1829	3	_hanky
haply	13	59	1506	3	_haply
happy	15	58	1353	3	_happy
hardy	12	56	2206	3	_hardy
harm	9	56	3779	3	_harm_
harms	10	68	2901	3	_harms
harpy	13	64	1820	3	_harpy
harry	11	53	2295	3	_harry
hasty	11	57	1876	3	_hasty
haulmy	14	45	555	3	_haulmy
hay	9	73	5877	3	_ha__y
hayey	14	48	1253	3	_hayey
hazy	19	181	1919	3	_ha_zy
hempy	15	49	1276	3	_hempy
hmm	10	62	1899	3	_h_mm_
homey	13	59	2484	3	_homey
homy	12	66	2322	3	_h_omy
humpy	15	51	1567	3	_humpy
immy	11	46	1182	3	__immy
jemmy	19	49	855	3	_jemmy
jimmy	19	53	850	3	_jimmy
lamby	12	51	1484	3	_lamby
loamy	10	59	1334	3	loa_my
malmy	12	48	1634	3	_malmy
mamey	12	54	1883	3	_mamey
mamma	8	63	1791	3	_mamma
mammey	12	43	1089	3	_mammey
mommy	11	40	1075	3	_mommy
mummy	11	49	1362	3	_mummy
palmy	12	60	1673	3	_palmy
plummy	15	37	566	3	plummy
pommy	14	44	986	3	_pommy
qualmy	20	28	580	3	qualmy
rheumy	14	3	335	3	rheumy
rummy	12	42	1241	3	_rummy
sadly	9	45	1912	3	s_adly
saggy	10	59	1746	3	s_aggy
sagy	8	53	2708	3	s_a_gy
sally	8	51	2971	3	s_ally
salmi	7	8	1586	3	s_almi
salty	8	55	2438	3	s_alty
samba	9	56	1877	3	s_amba
sambo	9	51	1801	3	s_ambo
same	6	52	4564	3	s_a_me
samek	11	49	1527	3	s_amek
samp	8	57	3359	3	s_a_mp
samps	9	61	2467	3	s_amps
sandy	9	42	2113	3	s_andy
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
saucy	10	46	1516	3	s_aucy
saury	8	43	1722	3	s_aury
savoy	11	47	1388	3	s_avoy
savvy	14	49	750	3	s_avvy
say	6	72	6476	3	s_a__y
scabby	15	3	550	3	scabby
scaly	10	47	1872	3	sca_ly
scam	8	59	3235	3	sca_m_
scammed	14	47	954	3	scammed
scammer	13	36	1197	3	scammer
scammony	17	4	302	3	scammony
scamp	11	57	1731	3	sca_mp
scampi	12	46	910	3	scampi
scamps	12	50	1417	3	scamps
scams	9	44	2397	3	sca_ms
scanty	11	40	1466	3	scanty
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
seam	6	66	4597	3	sea_m_
seaman	8	40	1590	3	seaman
seamed	9	48	2388	3	seamed
seamen	8	45	1856	3	seamen
seamer	8	42	2361	3	seamer
seams	7	57	3166	3	sea_ms
seaway	12	30	999	3	seaway
seemly	11	3	843	3	seemly
sha	6	98	3778	3	sha___
shack	14	53	2175	3	sha_ck
shacko	15	38	1011	3	shacko
shacks	15	48	1756	3	shacks
shad	8	62	3091	3	sha__d
shade	9	51	2558	3	sha_de
shaded	11	45	1887	3	shaded
shader	10	42	1876	3	shader
shades	10	59	2453	3	shades
shadfly	17	3	378	3	shadfly
shadily	14	3	772	3	shadily
shadow	13	3	725	3	shadow
shadowy	17	4	472	3	shadowy
shads	9	51	2448	3	sha_ds
shaduf	13	3	706	3	shaduf
shaft	11	57	2525	3	sha_ft
shafts	12	54	1143	3	shafts
shag	8	64	3056	3	sha__g
shags	9	51	2386	3	sha_gs
shah	10	56	2778	3	sha__h
shahs	11	59	1951	3	sha_hs
shaird	10	28	870	3	shaird
shairn	9	26	906	3	shairn
shake	12	47	2640	3	sha_ke
shaken	13	41	1361	3	shaken
shaker	13	43	1946	3	shaker
shakes	13	50	2459	3	shakes
shakily	17	3	690	3	shakily
shako	12	55	1608	3	sha_ko
shakos	13	49	1218	3	shakos
shale	8	53	3283	3	sha_le
shaled	10	50	2395	3	shaled
shales	9	47	3125	3	shales
shall	8	50	2405	3	sha_ll
shalom	11	8	1091	3	shalom
shaloms	12	8	898	3	shaloms
shalt	8	55	3448	3	sha_lt
shamably	18	16	579	3	shamably
shamans	12	36	1089	3	shamans
shamble	14	14	926	3	shamble
shaming	13	30	1674	3	shaming
shammash	18	29	374	3	shammash
shammers	15	37	1083	3	shammers
shammied	16	26	554	3	shammied
shammies	15	25	967	3	shammies
shamming	16	28	941	3	shamming
shammying	20	4	295	3	shammy~~ing~~
shamois	12	32	1040	3	shamois
shamoyed	17	4	404	3	shamoyed
shampoo	14	3	537	3	shampoo
shank	12	54	2219	3	sha_nk
shanks	13	53	1558	3	shanks
shantey	13	42	1003	3	shantey
shanti	9	40	1407	3	shanti
shape	10	51	2511	3	sha_pe
shaped	12	50	2010	3	shaped
shapely	15	3	689	3	shapely
shapen	11	44	1465	3	shapen
shaper	11	41	1993	3	shaper
shapes	11	51	2494	3	shapes
shard	9	61	2596	3	sha_rd
shards	10	43	1917	3	shards
share	8	64	3708	3	sha_re
shared	10	58	2906	3	shared
sharer	9	50	2548	3	sharer
shares	9	52	3641	3	shares
sharia	9	31	1672	3	sharia
sharif	12	29	1711	3	sharif
shark	12	62	2502	3	sha_rk
sharks	13	50	1972	3	sharks
sharn	8	48	2370	3	sha_rn
sharns	9	55	1698	3	sharns
sharp	10	49	2253	3	sha_rp
sharply	15	40	683	3	sharply
sharps	11	55	1608	3	sharps
shat	7	64	5659	3	sha__t
shaugh	13	28	743	3	shaugh
shaul	8	54	1810	3	sha_ul
shauls	9	49	1311	3	shauls
shave	11	44	2589	3	sha_ve
shaved	13	51	1838	3	shaved
shaven	12	42	1330	3	shaven
shaver	12	37	1891	3	shaver
shaves	12	52	2493	3	shaves
shavie	12	43	1241	3	shavie
shaw	10	81	3255	3	sha__w
shawed	13	48	1723	3	shawed
shawl	11	62	1757	3	sha_wl
shawls	12	54	1197	3	shawls
shawn	11	64	1761	3	sha_wn
shaws	11	62	2626	3	sha_ws
shays	11	60	2143	3	sha_ys
shazam	20	4	660	3	shazam
sheeny	12	49	1219	3	sheeny
shelly	12	44	1446	3	shelly
shelty	12	40	1154	3	shelty
shelvy	15	37	786	3	shelvy
sherry	12	45	1041	3	sherry
shifty	15	40	925	3	shifty
shily	11	52	2201	3	sh_ily
shim	9	58	2784	3	sh_im_
shimmed	15	33	858	3	shimmed
shimmer	14	33	1087	3	shimmer
shimmery	18	26	525	3	shimmery
shims	10	44	2254	3	sh_ims
shindy	13	44	932	3	shindy
shinny	12	48	1078	3	shinny
shiny	11	51	2214	3	sh_iny
shirty	12	43	1255	3	shirty
shitty	12	41	1005	3	shitty
shlump	13	4	571	3	shlump
shlumpy	17	4	286	3	shlumpy
shmo	9	53	1809	3	sh__mo
shoaly	12	40	1076	3	shoaly
shoddy	14	3	453	3	shoddy
shorty	12	43	1319	3	shorty
showy	14	57	1400	3	sh_owy
shrimp	13	47	876	3	shrimp
shrimpy	17	41	540	3	shrimpy
shy	9	67	2819	3	sh___y
shyly	14	48	1157	3	sh_yly
skanky	12	47	696	3	skanky
skimpy	17	47	572	3	skimpy
slaggy	11	43	879	3	slaggy
slam	6	77	3797	3	sla_m_
slammed	12	35	1110	3	slammed
slammer	11	39	1303	3	slammer
slams	7	49	2790	3	sla_ms
slangy	10	54	1139	3	slangy
slanty	9	51	1484	3	slanty
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
slimly	11	40	890	3	slimly
slimsy	11	40	772	3	slimsy
slimy	10	54	1742	3	s_limy
smarm	9	55	1760	3	smarm_
smarms	10	57	1253	3	smarms
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
sodomy	12	7	667	3	sodomy
spacey	13	62	1253	3	spacey
spacy	12	54	1562	3	spa_cy
spam	8	59	3004	3	spa_m_
spammed	14	34	852	3	spammed
spammer	13	34	1043	3	spammer
spams	9	49	2219	3	spa_ms
sparky	15	45	1152	3	sparky
sparry	11	51	1130	3	sparry
spasm	9	45	1417	3	spasm_
spasms	10	41	897	3	spasms
spay	9	66	3166	3	spa__y
spumy	12	46	1036	3	s_pumy
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
stalky	13	49	930	3	stalky
stamen	8	41	1594	3	stamen
stammel	11	60	753	3	stammel
stammer	11	60	1334	3	stammer
stamp	9	52	1736	3	sta_mp
stamps	10	56	1402	3	stamps
starry	9	49	1167	3	starry
stay	7	83	3372	3	sta__y
steamy	11	51	1237	3	steamy
stemma	10	32	813	3	stemma
stimy	10	51	1473	3	s_timy
stormy	11	55	1072	3	stormy
stumpy	13	45	813	3	stumpy
stymy	13	35	829	3	s_tymy
suably	11	28	1453	3	suably
summa	9	47	1331	3	s_umma
swabby	16	3	435	3	swabby
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
swanky	16	44	797	3	swanky
swanny	12	33	682	3	swanny
swarm	10	62	1883	3	swarm_
swarms	11	61	1216	3	swarms
swarty	12	58	1238	3	swarty
sway	10	71	2823	3	swa__y
tharm	10	59	1664	3	tharm_
tharms	11	57	1224	3	tharms
thrummy	17	4	217	3	thrummy
thymey	17	42	631	3	thymey
thymy	16	43	792	3	th_ymy
tommy	12	47	1223	3	_tommy
trampy	13	49	925	3	trampy
tummy	12	47	1199	3	_tummy
vampy	15	53	940	3	_vampy
whacky	21	55	649	3	whacky
wham	12	53	2169	3	wha_m_
whammed	18	34	513	3	whammed
whamo	13	55	1126	3	wha_mo
whams	13	55	1564	3	wha_ms
whimsy	17	37	522	3	whimsy
yummy	15	42	915	3	_yummy

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.140	1276364.3
2	DLD Change Limit	112716	404	5.313	21215.1
3	Display Results	404	404	0.123	3284.6
	(SQL Overall)	178691	404	5.576	32046.4