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

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

358 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
clammy	15	35	633	(None)
chammy	18	48	895	1	chammy
calmly	13	3	761	2	calmly
campy	14	51	1618	2	c_ampy
champy	18	50	961	2	champy
chasmy	16	46	854	2	chasmy
chummy	18	38	589	2	chummy
claim	9	56	1691	2	claim_
claims	10	52	1157	2	claims
clam	8	63	3229	2	cla_m_
clammed	14	36	996	2	clammed
clammer	13	42	1179	2	clammer
clammily	17	4	363	2	clammily
clamor	10	4	945	2	clamor
clamp	11	55	1765	2	cla_mp
clamps	12	45	1508	2	clamps
clams	9	51	2767	2	cla_ms
clanky	15	46	907	2	clanky
clary	10	57	1961	2	cla_ry
classy	11	37	904	2	classy
clay	9	59	2741	2	cla__y
clayey	14	40	766	2	clayey
clumpy	15	40	957	2	clumpy
clumsy	13	32	619	2	clumsy
commy	14	47	1264	2	c_ommy
crampy	15	47	1099	2	crampy
crummy	15	36	589	2	crummy
flamy	13	52	1747	2	fla_my
gammy	13	55	1489	2	_gammy
hammy	15	51	1343	2	_hammy
jammy	19	48	1019	2	_jammy
lamby	12	51	1484	2	_lamby
mammy	11	52	1516	2	_mammy
plummy	15	37	566	2	plummy
rammy	12	43	1249	2	_rammy
shammy	16	38	850	2	shammy
slummy	13	32	586	2	slummy
tammy	12	40	1322	2	_tammy
whammy	19	37	529	2	whammy
alamo	7	4	1814	3	ala_mo
alamos	8	4	1500	3	alamos
alarm	7	66	2142	3	alarm_
alarms	8	59	1305	3	alarms
alary	8	61	2344	3	ala_ry
ammo	8	55	2013	3	__ammo
army	9	66	2418	3	__army
balmy	12	52	1747	3	_balmy
barmy	12	52	1876	3	_barmy
beamy	12	62	1857	3	bea_my
blabby	12	3	481	3	blabby
blam	8	61	3170	3	bla_m_
blame	9	56	2549	3	bla_me
blamed	11	60	1795	3	blamed
blamer	10	44	1714	3	blamer
blames	10	51	2186	3	blames
blams	9	50	2385	3	bla_ms
blasty	11	56	1105	3	blasty
blimey	13	46	845	3	blimey
blimy	12	52	1282	3	bl_imy
bloomy	13	45	1011	3	bloomy
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
cakey	14	55	1727	3	c_akey
caky	13	62	2244	3	c_a_ky
calamar	11	4	929	3	calamar
calamary	15	4	546	3	calamary
calami	10	3	1342	3	calami
calamity	15	4	775	3	calamity
calamus	11	3	924	3	calamus
calm	8	50	3236	3	c_alm_
calmed	11	48	1638	3	calmed
calmer	10	52	1693	3	calmer
calms	9	52	2235	3	c_alms
calory	11	3	1284	3	calory
calumny	14	4	386	3	calumny
cam	7	80	5898	3	c_a_m_
camas	9	63	3352	3	c_amas
came	8	76	4875	3	c_a_me
camel	9	68	2280	3	c_amel
cameo	9	59	2499	3	c_ameo
cames	9	70	4731	3	c_ames
cammie	12	46	1529	3	c_ammie
camo	8	57	3175	3	c_a_mo
camos	9	59	2761	3	c_amos
camp	10	63	3645	3	c_a_mp
campi	11	62	1778	3	c_ampi
campo	11	52	1976	3	c_ampo
camps	11	63	3026	3	c_amps
cams	8	70	4728	3	c_a_ms
candy	11	51	1982	3	c_andy
canny	10	58	1769	3	c_anny
canty	10	52	2680	3	c_anty
carny	10	58	2292	3	c_arny
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
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	1884	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
chlamys	17	3	378	3	chlamys
chromy	16	30	990	3	chromy
clach	12	46	1782	3	cla_ch
clachs	13	35	1132	3	clachs
clack	13	47	2017	3	cla_ck
clacks	14	45	1634	3	clacks
clad	7	62	2582	3	cla__d
clade	8	58	2101	3	cla_de
clades	9	49	2046	3	clades
clads	8	57	2273	3	cla_ds
clag	7	59	2457	3	cla__g
clags	8	56	2112	3	cla_gs
claimed	12	29	883	3	claimed
claimer	11	27	988	3	claimer
clamant	11	3	1243	3	clamant
clamber	13	33	1174	3	clamber
clammers	14	35	1069	3	clammers
clammier	14	3	584	3	clammier
clamming	15	32	937	3	clamming
clamors	11	7	1009	3	clamors
clamour	11	9	633	3	clamour
clamped	14	40	1204	3	clamped
clamper	13	40	1299	3	clamper
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
clap	8	64	2904	3	cla__p
claps	9	56	2618	3	cla_ps
clapt	9	80	2717	3	cla_pt
claque	17	33	856	3	claque
claret	8	40	2657	3	claret
clarify	15	3	609	3	clarify
clarity	12	3	1091	3	clarity
claro	7	50	1869	3	cla_ro
claros	8	40	1511	3	claros
clash	10	62	1903	3	cla_sh
clasp	9	55	1719	3	cla_sp
clasps	10	45	1209	3	clasps
claspt	10	45	1341	3	claspt
class	7	55	2548	3	cla_ss
clast	7	60	3058	3	cla_st
clasts	8	48	1729	3	clasts
clause	8	43	1150	3	clause
clave	10	54	2015	3	cla_ve
claver	11	38	1697	3	claver
claves	11	50	2006	3	claves
clavi	10	49	1292	3	cla_vi
clavus	11	34	735	3	clavus
claw	9	56	2434	3	cla__w
clawed	12	51	1507	3	clawed
clawer	11	45	1278	3	clawer
claws	10	60	2083	3	cla_ws
claxon	15	3	658	3	claxon
clayed	12	50	1304	3	clayed
clays	10	55	2133	3	cla_ys
cleanly	12	3	632	3	cleanly
clearly	12	3	666	3	clearly
cleome	10	3	908	3	cleome
clergy	12	3	499	3	clergy
cliffy	17	43	524	3	cliffy
climax	17	3	565	3	climax
climb	11	54	1359	3	cl_imb
climbs	12	49	872	3	climbs
clime	9	57	2089	3	cl_ime
climes	10	47	2000	3	climes
clingy	12	65	906	3	clingy
cliquy	20	32	471	3	cliquy
cloddy	13	40	523	3	cloddy
cloggy	13	4	487	3	cloggy
clomb	11	57	1470	3	cl_omb
clomp	11	56	1570	3	cl_omp
clomps	12	52	1223	3	clomps
clotty	11	20	826	3	clotty
cloudy	12	51	780	3	cloudy
cloy	9	66	2383	3	cl__oy
clubby	15	3	468	3	clubby
clump	11	55	1745	3	cl_ump
clumps	12	153	1464	3	clumps
clunky	15	44	789	3	clunky
coaly	10	55	2159	3	coa_ly
comfy	15	37	1021	3	c_omfy
comma	11	45	1479	3	c_omma
crabby	15	34	675	3	crabby
cracky	17	50	1022	3	cracky
crafty	14	47	891	3	crafty
craggy	13	39	660	3	craggy
cram	8	56	3549	3	cra_m_
crambe	12	3	907	3	crambe
crambo	12	3	804	3	crambo
crammed	14	37	1012	3	crammed
crammer	13	40	1096	3	crammer
cramp	11	51	2069	3	cra_mp
cramps	12	56	1556	3	cramps
crams	9	62	2915	3	cra_ms
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
crappy	15	44	680	3	crappy
crawly	14	46	1076	3	crawly
crazy	19	55	1122	3	cra_zy
creamy	13	48	1136	3	creamy
crimpy	15	48	939	3	crimpy
crumby	15	40	811	3	crumby
dummy	13	47	1278	3	_dummy
elmy	9	56	1679	3	el__my
emmy	11	60	1324	3	__emmy
flabby	16	3	457	3	flabby
flaggy	14	41	592	3	flaggy
flakey	16	44	1051	3	flakey
flaky	15	57	1558	3	fla_ky
flam	9	63	3329	3	fla_m_
flambe	13	48	915	3	flambe
flame	10	51	2444	3	fla_me
flamed	12	46	1897	3	flamed
flamen	11	52	1599	3	flamen
flamer	11	49	1912	3	flamer
flames	11	47	2369	3	flames
flammed	15	37	741	3	flammed
flams	10	51	2501	3	fla_ms
flappy	16	5	448	3	flappy
flashy	15	49	817	3	flashy
flatly	12	31	1021	3	flatly
flawy	14	59	1338	3	fla_wy
flaxy	18	90	1229	3	fla_xy
flay	10	63	3280	3	fla__y
flimsy	14	34	556	3	flimsy
foamy	13	53	1320	3	foa_my
gamay	11	64	1911	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
gladly	11	49	793	3	gladly
glady	10	54	1394	3	gla_dy
glairy	10	44	827	3	glairy
glam	7	65	2934	3	gla_m_
glamor	9	5	819	3	glamor
glams	8	58	2293	3	gla_ms
glary	9	60	1854	3	gla_ry
glassy	10	52	775	3	glassy
glazy	18	74	1098	3	gla_zy
gleamy	12	39	811	3	gleamy
gloomy	12	52	876	3	gloomy
glumly	12	35	662	3	glumly
glumpy	14	52	719	3	glumpy
gramma	11	49	980	3	gramma
gramme	11	42	1033	3	gramme
gremmy	14	5	447	3	gremmy
gummy	13	54	1365	3	_gummy
immy	11	46	1183	3	__immy
jemmy	19	49	855	3	_jemmy
jimmy	19	53	850	3	_jimmy
lacey	10	58	2091	3	_lacey
lacy	9	58	2963	3	_la_cy
lady	8	65	2715	3	_la_dy
laity	8	53	1890	3	_laity
laky	11	67	2582	3	_la_ky
lam	5	76	6671	3	_la_m_
lama	6	66	3529	3	_la_ma
lamas	7	55	3279	3	_lamas
lamb	8	68	3214	3	_la_mb
lambs	9	59	2141	3	_lambs
lame	6	68	4929	3	_la_me
lamed	8	52	3529	3	_lamed
lamely	11	40	1322	3	_lamely
lamer	7	52	3370	3	_lamer
lames	7	54	4554	3	_lames
lamia	7	53	2432	3	_lamia
lammed	11	39	1562	3	_lammed
lamp	8	62	3382	3	_la_mp
lamps	9	56	2483	3	_lamps
lams	6	65	5226	3	_la_ms
lanky	12	55	1748	3	_lanky
lardy	9	61	1927	3	_lardy
larky	12	52	1887	3	_larky
lathy	11	52	1506	3	_lathy
lawny	11	59	1201	3	_lawny
laxly	15	6	1010	3	_laxly
lay	6	88	6535	3	_la__y
lazy	16	64	2307	3	_la_zy
lemma	9	48	1103	3	_lemma
limby	12	57	1407	3	_limby
limey	10	47	2104	3	_limey
limy	9	57	2771	3	_l_imy
llama	7	9	989	3	lla_ma
llamas	8	8	897	3	llamas
loamy	10	59	1334	3	_loamy
lumpy	12	66	1591	3	_lumpy
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
plaguy	12	38	641	3	plaguy
plashy	14	44	887	3	plashy
plasm	9	41	1463	3	plasm_
plasma	10	38	1091	3	plasma
plasms	10	37	1133	3	plasms
platy	10	50	2166	3	pla_ty
play	9	59	2898	3	pla__y
plumy	12	42	1323	3	pl_umy
pommy	14	44	986	3	_pommy
qualmy	20	28	580	3	qualmy
rummy	12	42	1241	3	_rummy
scummy	15	26	522	3	scummy
seamy	10	59	2127	3	sea_my
shamoy	14	37	991	3	shamoy
shimmy	16	30	641	3	shimmy
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	sl_imy
smarmy	13	62	935	3	smarmy
stemmy	13	41	703	3	stemmy
swampy	16	43	723	3	swampy
swamy	13	67	1440	3	swa_my
swimmy	16	23	435	3	swimmy
tommy	12	47	1223	3	_tommy
trampy	13	49	925	3	trampy
tummy	12	47	1199	3	_tummy
ulama	7	7	1147	3	ula_ma
ulamas	8	9	1045	3	ulamas
vampy	15	53	940	3	_vampy
whammo	16	40	519	3	whammo
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.373	479064.3
2	DLD Change Limit	112716	358	5.283	21335.6
3	Display Results	358	358	0.123	2910.6
	(SQL Overall)	178691	358	5.779	30920.7