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

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

398 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
hammal	13	45	1206	(None)
haemal	11	38	1164	1	haemal
hamal	10	46	2311	1	ha_mal
hammals	14	40	922	1	hammals
hammam	12	41	933	1	hammam
mammal	9	51	1275	1	mammal
chasmal	14	15	821	2	chasmal
dammar	11	43	890	2	dammar
gamma	10	61	1610	2	gamma_
gammas	11	57	1469	2	gammas
gimmal	11	24	751	2	gimmal
hadal	9	55	1812	2	ha_dal
halal	8	56	2359	2	ha_lal
hallal	9	44	1556	2	hallal
halma	10	82	1925	2	halma_
halmas	11	70	1789	2	halmas
hamals	11	48	1682	2	ha_mals
hamaul	11	42	1087	2	hamaul
hammada	15	4	509	2	hammada
hammams	13	38	644	2	hammams
hammed	14	41	1697	2	hammed
hammer	13	81	2003	2	hammer
hammily	17	3	606	2	hammily
hammy	15	51	1343	2	hamm_y
hamza	19	13	977	2	hamza_
hamzah	23	13	556	2	hamzah
hamzas	20	11	901	2	hamzas
hartal	9	4	1547	2	hartal
hazmat	20	3	1226	2	hazmat
hemal	10	44	1980	2	h_emal
hiemal	11	33	950	2	hiemal
hymnal	14	3	491	2	hymnal
mamma	8	63	1791	2	mamma_
mammae	9	46	1321	2	mammae
mammals	10	38	927	2	mammals
mammas	9	46	1640	2	mammas
ramal	7	46	2224	2	ra_mal
sambal	10	52	1518	2	sambal
shammas	14	35	872	2	shammas
tamal	7	35	2262	2	ta_mal
wadmal	12	3	728	2	wadmal
aal	3	90	5867	3	_a__al
adman	8	45	1790	3	_adman
agma	7	76	2326	3	_agma_
agmas	8	59	1987	3	_agmas
algal	6	65	1822	3	_algal
alma	6	63	3302	3	_alma_
almah	10	69	1725	3	_almah
almas	7	66	2977	3	_almas
ama	5	108	5330	3	_a_ma_
amah	9	89	2749	3	_a_mah
amas	6	77	4629	3	_a_mas
amia	6	68	3690	3	_amia_
amias	7	58	3147	3	_amias
ammo	8	55	2013	3	_amm_o
ammonal	11	3	702	3	_ammonal
ammos	9	48	1582	3	_ammos
amoral	8	3	1463	3	_amoral
ampul	9	11	1085	3	_ampul
amyl	9	55	1510	3	_a_myl
anal	4	80	3752	3	_a_nal
animal	8	50	1625	3	animal
annal	5	65	2076	3	_annal
appal	9	53	1522	3	_appal
areal	5	59	2873	3	_areal
argal	6	50	2339	3	_argal
artal	5	55	2547	3	_artal
arval	8	60	1701	3	_arval
atma	6	81	2177	3	_atma_
atman	7	55	2014	3	_atman
atmas	7	57	2101	3	_atmas
aural	5	44	2896	3	_aural
axal	11	65	2049	3	_a_xal
axial	12	45	1519	3	_axial
axman	14	48	1318	3	_axman
baal	6	70	3311	3	ba__al
badman	11	38	1384	3	badman
bagman	11	46	1381	3	bagman
bammed	13	39	1324	3	bammed
banal	7	59	2599	3	ba_nal
barbal	10	40	1666	3	barbal
barman	10	35	1970	3	barman
basal	7	57	2228	3	ba_sal
batman	10	52	1406	3	batman
bayman	13	37	1270	3	bayman
bharal	11	3	889	3	bha_ral
bromal	10	3	1365	3	bromal
brumal	10	4	950	3	brumal
bummalo	13	5	379	3	bummalo
cabal	9	52	2215	3	ca_bal
cabman	12	38	1250	3	cabman
caecal	10	37	1373	3	caecal
caiman	10	36	1566	3	caiman
camail	10	3	1483	3	camail
camas	9	63	3352	3	ca_mas
cambial	13	40	1076	3	cambial
camel	9	68	2280	3	ca_mel
cameral	11	3	1128	3	cameral
cammie	12	46	1529	3	cammie
canal	7	54	2804	3	ca_nal
cantal	8	41	2203	3	cantal
carman	10	39	2074	3	carman
carnal	8	39	1921	3	carnal
carpal	10	37	1625	3	carpal
casual	8	11	1286	3	casual
caudal	9	16	1148	3	caudal
causal	8	14	1320	3	causal
cayman	13	36	1321	3	cayman
chacma	15	3	790	3	chacma_
chacmas	16	3	800	3	chacmas
chaetal	12	3	828	3	chaetal
chammy	18	48	895	3	chamm_y
champac	18	3	495	3	champac
champak	20	3	449	3	champak
chapman	16	3	789	3	chapman
chiasmal	15	28	503	3	chiasmal
comal	9	51	2513	3	_comal
comma	11	45	1479	3	comma_
commas	12	48	1457	3	commas
cymbal	15	23	691	3	cymbal
daedal	8	4	908	3	daedal
daman	8	48	2116	3	da_man
damar	8	41	1774	3	da_mar
dammars	12	30	819	3	dammars
dammed	12	42	1479	3	dammed
dammer	11	43	1793	3	dammer
dammit	11	3	1113	3	dammit
damsel	9	14	803	3	damsel
dermal	9	36	1434	3	dermal
dharma	12	7	610	3	dharma_
dharmas	13	5	651	3	dharmas
dismal	9	24	1224	3	dismal
domal	8	56	1920	3	_domal
facial	11	36	1563	3	facial
faecal	11	35	981	3	faecal
fallal	9	36	1269	3	fallal
farfal	12	34	1018	3	farfal
fatal	8	48	1937	3	fa_tal
faucal	11	33	996	3	faucal
faunal	9	47	1159	3	faunal
formal	11	32	1520	3	formal
gagman	10	38	1124	3	gagman
gama	7	70	3552	3	ga_ma_
gamas	8	54	3136	3	ga_mas
gamay	11	64	1911	3	ga_may
gamba	10	60	1851	3	gamba_
gambas	11	58	1751	3	gambas
gambol	11	3	822	3	gambol
gametal	10	3	760	3	gametal
gammed	12	42	1616	3	gammed
gammer	11	123	1833	3	gammer
gammon	11	3	890	3	gammon
gammy	13	55	1489	3	gamm_y
gasman	9	29	1174	3	gasman
gavial	10	3	1008	3	gavial
gayal	9	3	1271	3	ga_yal
gemma	10	63	1177	3	gemma_
gemmae	11	50	779	3	gemmae
gharial	11	3	734	3	gharial
gimbal	11	22	881	3	gimbal
gimmals	12	22	582	3	gimmals
gramma	11	49	980	3	gramma_
grammar	12	40	689	3	grammar
grammas	12	49	977	3	grammas
gumma	10	53	1310	3	gumma_
gummas	11	48	1051	3	gummas
haaf	10	62	2773	3	ha__af
haar	7	73	2349	3	ha__ar
hackman	18	3	643	3	hackman
haem	9	57	3098	3	haem__
haematal	13	4	514	3	haematal
haemic	13	32	1008	3	haemic
haemin	11	34	1266	3	haemin
haems	10	55	1701	3	haem_s
haha	10	78	2106	3	ha_ha_
hahas	11	71	1844	3	ha_has
haika	12	53	1379	3	haika_
hail	7	48	3906	3	ha__il
halala	9	47	1509	3	ha_lala
halals	9	50	1831	3	ha_lals
hall	7	57	4116	3	ha__ll
hallah	12	41	1540	3	hallah
hallel	9	35	1409	3	hallel
halm	9	58	3497	3	halm__
halms	10	52	2521	3	halm_s
halva	11	54	1443	3	halva_
halvah	15	49	983	3	halvah
halvas	12	47	1417	3	halvas
ham	8	63	6328	3	ha_m__
hamada	12	3	992	3	hamada
hamadas	13	3	967	3	hamadas
hamate	11	33	1983	3	hamate
hamauls	12	38	781	3	hamauls
hame	9	70	4313	3	ha_m_e
hames	10	61	3870	3	ha_mes
hamlet	11	37	2279	3	hamlet
hammadas	16	4	479	3	hammadas
hammers	14	42	1606	3	hammers
hammier	14	35	1065	3	hammier
hamming	15	30	1409	3	hamming
hammock	20	6	463	3	hammock
hamper	13	45	1865	3	hamper
hams	9	64	4613	3	ha_m_s
hamular	12	3	697	3	hamular
hamuli	11	3	706	3	hamuli
hamzahs	24	13	437	3	hamzahs
handax	17	4	958	3	handax
hangar	10	41	1451	3	hangar
hangman	13	3	781	3	hangman
hangul	10	4	921	3	hangul
hansa	8	54	1678	3	hansa_
hansas	9	46	1604	3	hansas
hansel	9	52	1437	3	hansel
hanuman	12	3	713	3	hanuman
hapax	17	3	932	3	ha_pax
harl	7	57	4000	3	ha__rl
harm	9	56	3779	3	harm__
harmed	12	52	1883	3	harmed
harmer	11	47	1955	3	harmer
harmful	15	3	576	3	harmful
harmin	11	31	1739	3	harmin
harms	10	68	2901	3	harm_s
hartals	10	3	1302	3	hartals
hassel	9	56	1421	3	hassel
hatful	12	10	874	3	hatful
haul	7	55	3045	3	ha__ul
hawala	12	36	891	3	ha_wala
haymow	17	7	368	3	haymow
hazan	17	38	1361	3	ha_zan
hazel	17	64	1481	3	ha_zel
hazmats	21	3	660	3	hazmats
hazzan	17	23	680	3	hazzan
headman	13	22	963	3	headman
heal	7	56	4569	3	h__eal
hematal	12	3	895	3	hematal
hemmed	14	42	1146	3	hemmed
hemmer	13	41	1264	3	hemmer
herbal	11	25	1349	3	herbal
herma	10	53	1888	3	herma_
hermae	11	53	1447	3	hermae
hermai	11	89	1286	3	hermai
hetman	11	25	1060	3	hetman
hiatal	9	3	1020	3	hiatal
hitman	11	27	1022	3	hitman
hmm	10	62	1899	3	h_mm__
hommos	13	12	850	3	hommos
horal	8	63	2868	3	h_oral
human	10	27	1603	3	h_uman
humeral	12	3	856	3	humeral
hummable	17	4	458	3	hummable
hummed	14	48	1267	3	hummed
hummer	13	36	1527	3	hummer
hummus	13	3	624	3	hummus
humoral	12	3	797	3	humoral
hyetal	12	3	654	3	hyetal
hymenal	15	4	518	3	hymenal
hymnals	15	4	352	3	hymnals
hyphal	17	3	641	3	hyphal
jacal	14	3	1370	3	ja_cal
jackal	19	3	761	3	jackal
jammable	21	4	451	3	jammable
jammed	18	38	1150	3	jammed
jammer	17	40	1413	3	jammer
jammy	19	48	1019	3	jamm_y
jumbal	17	5	846	3	jumbal
kamala	12	33	996	3	ka_mala
karma	11	34	1500	3	karma_
karmas	12	30	1373	3	karmas
kummel	14	26	617	3	kummel
labial	8	47	1434	3	labial
laical	8	3	1232	3	laical
lama	6	66	3529	3	la_ma_
lamas	7	55	3279	3	la_mas
lamia	7	53	2432	3	lamia_
lamiae	8	48	1745	3	lamiae
lamias	8	50	2061	3	lamias
laminal	9	41	1363	3	laminal
lammed	11	39	1562	3	lammed
lampad	11	45	1003	3	lampad
lampas	10	66	1595	3	lampas
larval	9	4	850	3	larval
lawman	11	28	905	3	lawman
layman	11	35	1130	3	layman
lemma	9	48	1103	3	lemma_
lemmas	10	34	916	3	lemmas
madman	11	37	1238	3	madman
magma	10	45	1357	3	magma_
magmas	11	55	1250	3	magmas
mama	8	62	3159	3	ma_ma_
mamas	9	59	3077	3	ma_mas
mamba	11	63	1752	3	mamba_
mambas	12	57	1624	3	mambas
mammary	13	3	599	3	mammary
mammate	10	44	1127	3	mammate
mammati	10	39	837	3	mammati
mammee	9	44	1785	3	mammee
mammer	9	42	1886	3	mammer
mammet	9	43	1925	3	mammet
mammey	12	43	1089	3	mammey
mammie	9	43	1378	3	mammie
mammon	9	3	964	3	mammon
mammy	11	52	1516	3	mamm_y
manual	8	3	1346	3	manual
maximal	18	34	709	3	maximal
meal	6	56	4317	3	__meal
miasmal	11	7	674	3	miasmal
momma	8	51	1105	3	momma_
mommas	9	41	1065	3	mommas
narial	6	3	1795	3	narial
narwal	9	3	894	3	narwal
nasal	5	62	1759	3	na_sal
nasial	6	4	1328	3	nasial
natal	5	39	2149	3	na_tal
naval	8	53	1583	3	na_val
normal	8	32	1353	3	normal
oatmeal	9	4	497	3	oatmeal
paleal	8	47	1667	3	paleal
palmar	10	41	1346	3	palmar
palpal	10	41	1205	3	palpal
pampa	11	49	1342	3	pampa_
pampas	12	49	1399	3	pampas
papal	9	58	2067	3	pa_pal
parral	8	55	1753	3	parral
pascal	10	8	1237	3	pascal
pausal	8	15	1196	3	pausal
phaseal	12	4	567	3	phaseal
pommel	12	27	745	3	pommel
primal	10	40	1462	3	primal
pummel	12	27	804	3	pummel
racial	8	34	1924	3	racial
radial	7	40	2039	3	radial
ragman	9	40	1371	3	ragman
rambla	10	35	1093	3	rambla
rammed	11	31	1730	3	rammed
rammer	10	35	1965	3	rammer
rammy	12	43	1249	3	ramm_y
ramtil	8	3	1103	3	ramtil
rascal	8	5	1112	3	rascal
ratal	5	50	2511	3	ra_tal
sabal	7	54	2248	3	sa_bal
sacral	8	34	1441	3	sacral
salal	5	54	2570	3	sa_lal
samba	9	56	1877	3	samba_
sambals	11	52	1348	3	sambals
sambar	10	39	1416	3	sambar
sambas	10	42	1926	3	sambas
samiel	8	3	1333	3	samiel
sampan	10	25	1189	3	sampan
sandal	7	33	1728	3	sandal
shaman	11	33	1428	3	sha_man
shamas	11	37	1794	3	sha_mas
shammash	18	29	375	3	shammash
shammed	15	39	1142	3	shammed
shammer	14	46	1314	3	shammer
shammes	14	43	1283	3	shammes
shammos	14	30	720	3	shammos
shammy	16	38	850	3	shamm_y
stammel	11	60	753	3	stammel
stomal	8	52	1331	3	stomal
summa	9	47	1331	3	summa_
summae	10	39	1101	3	summae
summas	10	43	1316	3	summas
tamale	8	37	1740	3	ta_male
tamals	8	41	1663	3	ta_mals
tambac	12	22	1024	3	tambac
tambak	14	24	926	3	tambak
tambala	11	3	802	3	tambala
tammie	10	42	1269	3	tammie
tammy	12	40	1322	3	tamm_y
tampala	11	3	661	3	tampala
tampan	10	25	1232	3	tampan
tarmac	10	3	1033	3	tarmac
tarnal	6	37	1650	3	tarnal
tarsal	6	33	1527	3	tarsal
taxman	15	32	861	3	taxman
thermal	12	50	1097	3	thermal
timbal	10	25	1075	3	timbal
tombal	10	23	1102	3	tombal
trammel	11	35	766	3	trammel
tymbal	13	23	682	3	tymbal
vagal	9	46	1363	3	va_gal
valval	12	39	886	3	valval
vandal	10	37	1383	3	vandal
vanman	11	3	979	3	vanman
vasal	8	55	1629	3	va_sal
vassal	9	7	924	3	vassal
wadmaal	13	4	320	3	wadmaal
wadmals	13	3	551	3	wadmals
wadmel	12	3	552	3	wadmel
wadmol	12	3	405	3	wadmol
wammus	13	42	673	3	wammus
whammed	18	34	513	3	whammed
whammo	16	40	519	3	whamm_o
whammy	19	37	529	3	whamm_y
yammer	13	37	1318	3	yammer
yasmak	15	3	459	3	yasmak
zamia	16	51	1521	3	zamia_
zamias	17	42	1292	3	zamias

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	398	5.690	19809.5
3	Display Results	398	398	0.140	2842.9
	(SQL Overall)	178691	398	6.220	28728.5