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

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

334 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
mollah	11	31	945	(None)
mollahs	12	32	828	1	mollahs
moolah	11	40	919	1	moolah
mullah	11	37	1073	1	mullah
collar	8	38	1617	2	collar
dollar	7	41	1098	2	dollar
fellah	12	49	1077	2	fellah
hallah	12	41	1540	2	hallah
holla	8	49	1849	2	holla_
hollas	9	46	1690	2	hollas
mola	6	60	3563	2	mo_la_
molal	7	51	2034	2	mo_lal
molar	7	52	2309	2	mo_lar
molas	7	51	3209	2	mo_las
moll	6	67	3570	2	moll__
mollie	8	35	1710	2	mollie
molls	7	51	2978	2	moll_s
molly	10	52	2249	2	moll_y
moloch	13	5	648	2	moloch
moola	7	51	1703	2	moola_
moolahs	12	34	738	2	moolahs
moolas	8	36	1559	2	moolas
mulla	7	43	1711	2	mulla_
mullahs	12	38	873	2	mullahs
mullas	8	42	1593	2	mullas
nullah	9	38	814	2	nullah
olla	4	48	2117	2	_olla_
ollas	5	42	1828	2	_ollas
wallah	12	40	1199	2	wallah
zillah	18	3	656	2	zillah
abolla	8	4	1019	3	abolla_
abollae	9	3	694	3	abollae
allay	8	56	2039	3	_allay
almah	10	69	1725	3	_almah
ballad	9	43	1532	3	ballad
blah	9	86	2506	3	__blah
bola	6	60	3556	3	bo_la_
bolar	7	51	2347	3	bo_lar
bolas	7	47	3376	3	bo_las
boll	6	56	3475	3	boll__
bollard	10	32	1050	3	bollard
bolled	9	47	2265	3	bolled
bollix	15	3	805	3	bollix
bollox	15	4	874	3	bollox
bolls	7	55	3131	3	boll_s
boyla	10	29	1236	3	boyla_
boylas	11	30	1172	3	boylas
bulla	7	46	2056	3	bulla_
bullae	8	34	1616	3	bullae
calla	7	48	2707	3	calla_
callan	8	36	1960	3	callan
callas	8	45	2675	3	callas
cella	7	54	2031	3	cella_
cellae	8	49	1593	3	cellae
cellar	8	45	1498	3	cellar
chalah	14	35	1166	3	chalah
challah	15	45	832	3	challah
cholla	11	39	1102	3	cholla_
chollas	12	38	1135	3	chollas
coala	7	75	2112	3	coala_
coalas	8	74	1896	3	coalas
cola	6	65	4139	3	co_la_
colas	7	54	3677	3	co_las
colead	9	41	1464	3	colead
collage	10	28	1376	3	collage
collard	10	37	1292	3	collard
collars	9	38	1657	3	collars
collate	9	29	1968	3	collate
collet	8	40	3036	3	collet
collie	8	36	2199	3	collie
collop	10	73	1231	3	collop
colly	10	49	2677	3	coll_y
colza	16	51	1298	3	colza_
colzas	17	40	1051	3	colzas
coolth	11	3	951	3	coolth
coprah	13	37	1060	3	coprah
cullay	11	39	1017	3	cullay
dobla	8	49	1364	3	dobla_
doblas	9	38	1229	3	doblas
doll	5	66	3249	3	doll__
dollars	8	33	1102	3	dollars
dolled	8	35	1807	3	dolled
dollish	11	6	1009	3	dollish
dollop	9	25	936	3	dollop
dolls	6	61	2692	3	doll_s
dolly	9	61	2520	3	doll_y
dolma	8	62	1417	3	dolma_
dolman	9	53	1240	3	dolman
dolmas	9	52	1304	3	dolmas
doula	6	57	1777	3	doula_
doulas	7	51	1499	3	doulas
dourah	10	47	981	3	dourah
eolian	6	3	1259	3	eolian
eolith	9	30	1390	3	eolith
fallal	9	36	1269	3	fallal
fella	8	49	1865	3	fella_
fellahs	13	42	839	3	fellahs
fellas	9	51	1696	3	fellas
folia	8	36	1893	3	folia_
foliar	9	32	1097	3	foliar
folles	9	38	2047	3	folles
follis	9	31	1390	3	follis
follow	12	40	1035	3	follow
folly	11	50	2260	3	foll_y
fullam	11	3	836	3	fullam
galah	9	59	1763	3	_galah
goliath	11	4	593	3	goliath
golly	9	51	2110	3	goll_y
golosh	10	3	646	3	golosh
goulash	11	6	427	3	goulash
halalah	13	42	939	3	halalah
hallahs	13	39	1246	3	hallahs
hallal	9	44	1556	3	hallal
halvah	15	49	983	3	halvah
hollaed	11	35	985	3	hollaed
holland	11	34	947	3	holland
holler	9	35	2061	3	holler
hollo	8	48	2216	3	holl_o
holloa	9	49	1482	3	holloa
holloas	10	38	1494	3	holloas
holloo	9	44	1525	3	holloo
hollos	9	53	2063	3	hollos
hollow	12	42	1266	3	hollow
holly	11	48	2443	3	holl_y
hookah	16	48	824	3	hookah
hoorah	12	44	1111	3	hoorah
horah	11	79	2205	3	ho_rah
houdah	13	3	517	3	houdah
howdah	16	3	472	3	howdah
jolly	15	45	1751	3	joll_y
keblah	15	4	531	3	keblah
kiblah	15	3	558	3	kiblah
koala	9	51	1221	3	koala_
koalas	10	40	1166	3	koalas
kola	8	51	2496	3	ko_la_
kolas	9	48	2223	3	ko_las
lallan	6	34	1417	3	lallan
loll	4	61	2838	3	loll__
lolled	7	43	1582	3	lolled
loller	6	33	1528	3	loller
lollop	8	23	878	3	lollop
lolls	5	121	2173	3	loll_s
lolly	8	51	2066	3	loll_y
loofah	12	37	581	3	loofah
lotah	8	53	1585	3	lo_tah
malar	7	64	2444	3	m_alar
mall	6	46	3937	3	mall__
mallard	10	3	1027	3	mallard
malled	9	46	2611	3	malled
mallee	8	45	2559	3	mallee
mallei	8	44	1463	3	mallei
mallet	8	44	3305	3	mallet
mallow	11	40	1474	3	mallow
malls	7	62	3343	3	mall_s
maltha	11	3	750	3	maltha
matsah	11	3	823	3	matsah
matzah	20	3	596	3	matzah
medlar	9	30	1046	3	medlar
megillah	14	4	323	3	megillah
mell	6	49	3561	3	mell__
melled	9	50	2302	3	melled
mellow	11	41	1222	3	mellow
mells	7	50	3133	3	mell_s
mikvah	18	14	347	3	mikvah
milch	12	44	1337	3	m_ilch
milia	7	27	1957	3	milia_
mill	6	65	4148	3	mill__
millage	10	31	1275	3	millage
milldam	12	4	547	3	milldam
mille	7	50	2913	3	mill_e
milled	9	43	2617	3	milled
miller	8	46	2541	3	miller
milles	8	45	2656	3	milles
millet	8	40	3074	3	millet
mills	7	54	3505	3	mill_s
milpa	9	21	1140	3	milpa_
milpas	10	17	1027	3	milpas
mislay	11	35	1068	3	mislay
moa	5	72	4918	3	mo__a_
moan	6	58	3202	3	mo__an
moas	6	55	4534	3	mo__as
moat	6	63	5203	3	mo__at
mobcap	14	4	411	3	mobcap
mobled	11	32	1318	3	mobled
mocha	12	4	992	3	mocha_
mochas	13	3	1066	3	mochas
modal	8	59	1924	3	mo_dal
modals	9	39	1445	3	modals
modish	12	38	1354	3	modish
modular	10	8	736	3	modular
moil	6	55	3409	3	moil__
moiled	9	43	1886	3	moiled
moiler	8	40	1726	3	moiler
moils	7	61	2575	3	moil_s
moira	7	10	1202	3	moira_
moirai	8	8	691	3	moirai
mol	5	66	5459	3	mo_l__
molars	8	55	1732	3	molars
mold	7	60	3433	3	mo_l_d
molded	10	44	1408	3	molded
molder	9	38	1927	3	molder
molds	8	53	2483	3	mo_lds
moldy	11	50	1465	3	mo_ldy
mole	6	62	5183	3	mo_l_e
moles	7	47	4792	3	mo_les
molest	8	50	2274	3	molest
molies	8	44	2951	3	molies
moline	8	44	2203	3	moline
mollies	9	34	2023	3	mollies
mollify	15	5	550	3	mollify
mollusc	11	10	309	3	mollusc
mollusk	13	10	312	3	mollusk
molochs	14	3	522	3	molochs
mols	6	59	4857	3	mo_l_s
molt	6	63	5616	3	mo_l_t
molted	9	42	1747	3	molted
molten	8	33	1181	3	molten
molter	8	41	1942	3	molter
molto	7	56	1960	3	mo_lto
molts	7	60	3209	3	mo_lts
moly	9	60	3191	3	mo_l_y
momma	8	51	1105	3	momma_
mommas	9	41	1065	3	mommas
monad	8	55	1947	3	mo_nad
monas	7	47	3215	3	mo_nas
monish	11	42	1759	3	monish
month	10	48	1842	3	mo_nth
mooch	12	53	1361	3	mo_och
mool	6	75	3386	3	mool__
mooley	11	3	1163	3	mooley
mools	7	60	2717	3	mool_s
mopish	13	43	1159	3	mopish
mora	6	66	4127	3	mo_ra_
morae	7	58	3119	3	mo_rae
moral	7	55	3343	3	mo_ral
morale	8	52	2055	3	morale
morals	8	53	2463	3	morals
moras	7	64	3878	3	mo_ras
moray	10	54	2379	3	mo_ray
morgan	9	3	1137	3	morgan
morph	12	17	1251	3	mo_rph
mortal	8	46	1685	3	mortal
mortar	8	38	1204	3	mortar
morula	8	7	1047	3	morula_
morulae	9	5	896	3	morulae
morular	9	7	822	3	morular
morulas	9	5	971	3	morulas
mosh	9	52	2760	3	mo__sh
moshav	14	4	605	3	moshav
moth	9	67	3133	3	mo__th
motley	11	3	938	3	motley
mouch	12	47	1580	3	mo_uch
moulage	10	3	790	3	moulage
mould	8	60	1575	3	moul_d
moulds	9	49	1099	3	moulds
mouldy	12	43	741	3	mouldy
moulin	8	3	1328	3	moulin
moult	7	47	2872	3	moul_t
moults	8	47	1370	3	moults
mouth	10	54	2029	3	mo_uth
moxa	13	69	1774	3	mo_xa_
moxas	14	50	1439	3	mo_xas
mulch	12	40	1297	3	m_ulch
mulish	11	3	1190	3	mulish
mull	6	51	2880	3	mull__
mulled	9	47	2155	3	mulled
mullen	8	37	1476	3	mullen
muller	8	38	2035	3	muller
mullet	8	41	2682	3	mullet
mulley	11	40	1345	3	mulley
mulls	7	51	2415	3	mull_s
mylar	10	53	1153	3	m_ylar
mynah	13	56	956	3	m_ynah
nullahs	10	31	699	3	nullahs
obeah	10	3	899	3	_obeah
odah	8	70	1893	3	_o_dah
olea	4	65	3272	3	_olea_
onlay	8	42	1294	3	_onlay
oolith	9	38	1324	3	oolith
oompah	13	3	425	3	oompah
opah	9	62	1840	3	_o_pah
pillar	8	3	1402	3	pillar
polar	7	56	2345	3	po_lar
poleax	15	4	799	3	poleax
polish	11	49	1672	3	polish
polka	11	3	1041	3	polka_
polkas	12	3	910	3	polkas
poll	6	63	3213	3	poll__
pollack	15	6	733	3	pollack
pollard	10	35	1114	3	pollard
polled	9	40	2200	3	polled
pollee	8	36	2327	3	pollee
pollen	8	34	1645	3	pollen
poller	8	39	2185	3	poller
pollex	15	37	1116	3	pollex
polls	7	46	2772	3	poll_s
poplar	10	36	1111	3	poplar
potlach	14	10	636	3	potlach
roll	4	63	3165	3	roll__
rolled	7	42	2024	3	rolled
roller	6	39	1979	3	roller
rolls	5	53	2623	3	roll_s
rollway	13	4	465	3	rollway
selah	8	3	1961	3	_selah
sola	4	55	4186	3	so_la_
solan	5	53	2815	3	so_lan
solar	5	59	2734	3	so_lar
soldan	7	35	1185	3	soldan
tola	4	52	3633	3	to_la_
tolan	5	51	2401	3	to_lan
tolar	5	55	2411	3	to_lar
tolas	5	45	3277	3	to_las
toll	4	55	3526	3	toll__
tollage	8	26	1016	3	tollage
tollbar	9	4	545	3	tollbar
tolled	7	38	1903	3	tolled
toller	6	38	1944	3	toller
tollman	9	3	586	3	tollman
tolls	5	47	2843	3	toll_s
tollway	13	4	479	3	tollway
torah	8	71	2527	3	to_rah
villa	8	53	2123	3	villa_
villae	9	56	1538	3	villae
villas	9	61	1726	3	villas
voila	8	48	1394	3	voila_
volar	8	69	1741	3	vo_lar
volley	12	41	974	3	volley
volta	8	52	1562	3	volta_
volva	11	39	900	3	volva_
volvas	12	44	799	3	volvas
walla	8	53	2103	3	walla_
wallahs	13	40	947	3	wallahs
wallas	9	57	1939	3	wallas
zillahs	19	3	538	3	zillahs

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	334	5.360	21029.1
3	Display Results	334	334	0.093	3591.4
	(SQL Overall)	178691	334	5.843	30582.1