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

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

316 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
kamala	12	33	996	(None)
kabala	12	40	1155	1	kabala
kamalas	13	33	912	1	kamalas
cabala	10	35	1691	2	cabala
halala	9	47	1509	2	halala
hamada	12	3	992	2	hamada
hamal	10	46	2311	2	hamal_
hamals	11	48	1683	2	hamals
hawala	12	36	891	2	hawala
kabaka	11	34	850	2	kabaka
kabalas	13	39	1106	2	kabalas
kabaya	15	38	712	2	kabaya
kabbala	15	8	461	2	kabbala
kanaka	9	35	752	2	kanaka
koala	9	51	1221	2	k_oala
masala	8	3	1181	2	masala
qabala	17	39	919	2	qabala
ramada	9	3	1018	2	ramada
ramal	7	46	2224	2	ramal_
rambla	10	35	1093	2	rambla
samara	8	3	1385	2	samara
tamal	7	35	2262	2	tamal_
tamale	8	37	1740	2	tamale
tamals	8	41	1663	2	tamals
tambala	11	3	802	2	tambala
tampala	11	3	661	2	tampala
yamalka	16	5	296	2	yamalka
aal	3	90	5867	3	_a_al_
aals	4	99	4114	3	_a_als
abaca	9	51	1804	3	_abaca
abaka	11	43	1382	3	_abaka
abaya	10	44	1317	3	_abaya
agama	8	58	1558	3	_agama
akela	9	3	1134	3	_akela
ala	3	124	6360	3	___ala
alula	5	3	1709	3	_alula
ama	5	108	5330	3	_am__a
amah	9	89	2749	3	_ama_h
amahs	10	78	1906	3	_amahs
amain	7	49	2291	3	_amain
amalgam	12	4	492	3	_amalgam
amarna	8	3	979	3	_amarna
amas	6	77	4629	3	_ama_s
amass	7	71	1968	3	_amass
amaze	16	60	1660	3	_amaze
amble	9	59	2464	3	_amble
ameba	9	3	1238	3	_ameba
amia	6	68	3690	3	_am_ia
amiga	8	55	1481	3	_amiga
amnia	7	59	1864	3	_amnia
amole	7	57	2459	3	_amole
ample	9	47	2030	3	_ample
amply	12	50	1291	3	_amply
amyl	9	55	1510	3	_amyl_
amyls	10	45	1269	3	_amyls
anal	4	80	3752	3	_anal_
argala	7	47	1267	3	argala
armada	9	3	878	3	armada
asana	5	3	1548	3	_asana
asyla	8	3	933	3	_asyla
axal	11	65	2049	3	_axal_
azalea	15	3	700	3	_azalea
baal	6	70	3311	3	ba_al_
baals	7	61	2270	3	ba_als
bacalao	11	4	661	3	bacalao
bacula	10	31	1268	3	bacula
balata	8	6	1468	3	balata
banal	7	59	2599	3	banal_
banana	8	32	1341	3	banana
basal	7	57	2228	3	basal_
basalt	8	35	1958	3	basalt
bemata	10	4	1169	3	bemata
cabal	9	52	2215	3	cabal_
cabalas	11	35	1600	3	cabalas
cabals	10	40	2015	3	cabals
cabana	10	39	1356	3	cabana
cabbala	13	6	718	3	cabbala
calla	7	48	2707	3	ca_lla
camail	10	3	1483	3	camail
camails	11	3	1175	3	camails
camas	9	63	3352	3	cama_s
camass	10	41	1418	3	camass
cambia	12	49	1315	3	cambia
camel	9	68	2280	3	camel_
camelia	11	5	1044	3	camelia
camels	10	52	1708	3	camels
camera	10	3	1369	3	camera
camisa	10	31	1432	3	camisa
canal	7	54	2804	3	canal_
canals	8	44	2167	3	canals
canola	8	3	1362	3	canola
cantala	9	41	1467	3	cantala
canula	8	3	1296	3	canula
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
catalo	8	3	1485	3	catalo
catalpa	11	3	650	3	catalpa
cavalla	12	5	788	3	cavalla
cicala	10	3	1006	3	cicala
coala	7	75	2112	3	_coala
comal	9	51	2513	3	comal_
damage	10	4	1078	3	damage
daman	8	48	2116	3	dama_n
damans	9	47	1598	3	damans
damar	8	41	1774	3	dama_r
damars	9	38	1500	3	damars
damask	13	3	584	3	damask
damiana	10	4	656	3	damiana
damply	14	33	789	3	damply
domal	8	56	1920	3	domal_
facula	11	29	1223	3	facula
falbala	12	3	587	3	falbala
family	14	33	1170	3	family
famuli	11	3	676	3	famuli
fatal	8	48	1937	3	fatal_
favela	12	3	703	3	favela
female	11	3	1055	3	female
gala	5	56	3516	3	__gala
gama	7	70	3552	3	gam__a
gamas	8	54	3136	3	gama_s
gamay	11	64	1911	3	gama_y
gamays	12	63	1091	3	gamays
gamba	10	60	1851	3	gam_ba
gambia	11	59	1225	3	gambia
gamble	11	54	1718	3	gamble
gamelan	10	10	665	3	gamelan
gamely	12	47	1191	3	gamely
gamily	12	37	1218	3	gamily
gamma	10	61	1610	3	gam_ma
gayal	9	3	1271	3	gayal_
gayals	10	3	951	3	gayals
hadal	9	55	1812	3	hadal_
haemal	11	38	1164	3	haemal_
halal	8	56	2359	3	halal_
halalah	13	42	939	3	halalah
halalas	10	42	1408	3	halalas
halals	9	50	1831	3	halals
hamadas	13	3	967	3	hamadas
hamate	11	33	1983	3	hamate
hamaul	11	42	1087	3	hamaul
hamauls	12	38	782	3	hamauls
hammada	15	4	509	3	hammada
hammal	13	45	1206	3	hammal_
hammals	14	40	923	3	hammals
hamular	12	3	697	3	hamular
hamuli	11	3	706	3	hamuli
hamza	19	13	977	3	ham_za
hawalas	13	34	835	3	hawalas
hemal	10	44	1980	3	hemal_
impala	10	25	694	3	impala
jacal	14	3	1370	3	jacal_
jacals	15	3	987	3	jacals
jacana	15	3	793	3	jacana
kaas	8	65	3184	3	ka_a_s
kabab	13	48	1444	3	kaba_b
kababs	14	40	977	3	kababs
kabakas	12	36	740	3	kabakas
kabar	11	48	1555	3	kaba_r
kabars	12	45	1395	3	kabars
kabayas	16	31	680	3	kabayas
kabbalah	19	6	243	3	kabbalah
kabbalas	16	7	435	3	kabbalas
kahuna	13	9	410	3	kahuna
kaiak	8	3	1035	3	kaia_k
kaiaks	9	3	704	3	kaiaks
kail	8	51	3149	3	ka_il_
kails	9	55	2521	3	ka_ils
kaka	7	65	1868	3	k__aka
kakapo	11	4	385	3	kakapo
kakas	8	51	1734	3	kaka_s
kalam	11	3	1511	3	kala_m
kalamata	14	4	527	3	kalamata
kalams	12	3	1060	3	kalams
kale	8	65	3375	3	k__ale
kalmia	12	3	889	3	kalmia
kalpa	11	45	1219	3	ka_lpa
kamaaina	14	4	327	3	kamaaina
kame	10	57	2823	3	kam__e
kames	11	50	2469	3	kam_es
kami	10	58	2364	3	kam__i
kamik	10	50	1155	3	kam_ik
kamiks	11	38	791	3	kamiks
kamsin	12	3	832	3	kamsin
kana	8	59	2853	3	k__ana
kanakas	10	32	721	3	kanakas
kanas	9	53	2691	3	kana_s
kapa	10	60	2129	3	k__apa
kapas	11	60	2173	3	kapa_s
kappa	13	46	974	3	ka_ppa
karat	9	68	3759	3	kara_t
karate	10	53	2092	3	karate
karats	10	64	2049	3	karats
karma	11	34	1501	3	ka_rma
karmas	12	30	1374	3	karma_s
kasha	12	47	1072	3	ka_sha
kata	8	56	2602	3	k__ata
katas	9	59	2209	3	kata_s
kava	11	58	1970	3	k__ava
kavas	12	59	1995	3	kava_s
kavass	13	51	730	3	kavass
kayak	11	3	836	3	kaya_k
kayaks	12	3	633	3	kayaks
kibla	11	3	983	3	k_ibla
kinara	10	3	1037	3	kinara
koalas	10	40	1166	3	k_oalas
kola	8	51	2496	3	k__ola
kraal	9	45	1182	3	kraal_
kraals	10	37	843	3	kraals
labara	8	37	1289	3	labara
lama	6	66	3529	3	lam__a
lamas	7	55	3279	3	lama_s
lambada	12	4	564	3	lambada
lambda	11	4	611	3	lambda
lamella	9	8	862	3	lamella
lamely	11	40	1322	3	lamely
lamia	7	53	2432	3	lam_ia
lamina	8	49	2044	3	lamina
macula	10	30	1367	3	macula
magmata	12	3	746	3	magmata
malar	7	64	2444	3	__malar
male	6	60	5230	3	__male
mall	6	46	3937	3	__mall
malm	8	51	2998	3	__malm
malt	6	62	5481	3	__malt
mama	8	62	3159	3	__mama
mamaliga	13	4	413	3	mamaliga
mamas	9	59	3077	3	mama_s
mamba	11	63	1752	3	mam_ba
mamma	8	63	1791	3	mam_ma
mammal	9	51	1275	3	mammal_
mammals	10	38	927	3	mammals
mana	6	53	4196	3	__mana
manana	8	48	1607	3	manana
mandala	10	3	1021	3	mandala
manila	8	45	1830	3	manila
mara	6	74	4457	3	__mara
maraca	10	3	1415	3	maraca
marsala	9	3	958	3	marsala
masa	6	50	3472	3	__masa
masalas	9	3	1206	3	masalas
maya	9	58	2459	3	__maya
mola	6	60	3563	3	__mola
nagana	7	4	894	3	nagana
nala	4	69	3039	3	__nala
namable	11	3	1234	3	namable
namely	11	37	1132	3	namely
napalm	10	4	726	3	napalm
nasal	5	62	1759	3	nasal_
nasals	6	33	1246	3	nasals
natal	5	39	2149	3	natal_
naval	8	53	1583	3	naval_
nyala	8	3	682	3	_nyala
omasa	7	4	948	3	_omasa
paella	8	4	1091	3	paella
pajama	17	31	765	3	pajama
palapa	10	3	1067	3	palapa
pampa	11	49	1342	3	pam_pa
panada	9	41	1305	3	panada
panama	10	42	1335	3	panama
papal	9	58	2067	3	papal_
papaya	13	3	750	3	papaya
papula	10	30	1111	3	papula
pataca	10	3	1119	3	pataca
payola	11	20	811	3	payola
qabalah	21	28	503	3	qabalah
qabalas	18	28	950	3	qabalas
radula	7	4	931	3	radula
ramadas	10	3	930	3	ramadas
ramate	8	39	2169	3	ramate
ramblas	11	27	1026	3	ramblas
ramble	10	45	1997	3	ramble
ramona	8	4	1241	3	ramona
ranula	6	3	1181	3	ranula
ratal	5	50	2511	3	ratal_
ratals	6	42	1958	3	ratals
sabal	7	54	2248	3	sabal_
sabals	8	46	1886	3	sabals
salal	5	54	2570	3	salal_
salals	6	51	2008	3	salals
samaras	9	3	1291	3	samaras
samba	9	56	1877	3	sam_ba
sambal	10	52	1518	3	sambal_
sambals	11	52	1348	3	sambals
samosa	8	5	1020	3	samosa
sample	10	42	1501	3	sample
samsara	9	3	691	3	samsara
satara	6	3	1553	3	satara
small	7	40	1626	3	_small
smalt	7	47	2933	3	_smalt
somata	8	3	1238	3	somata
tabla	7	33	1836	3	ta_bla
tala	4	59	3805	3	__tala
tamable	11	3	1285	3	tamable
tamales	9	32	1615	3	tamales
tamarao	9	7	759	3	tamarao
tamarau	9	10	706	3	tamarau
tamari	8	3	1341	3	tamari
tamasha	12	12	543	3	tamasha
tambalas	12	3	703	3	tambalas
tamely	11	37	1195	3	tamely
tampalas	12	4	547	3	tampalas
tapalo	8	3	979	3	tapalo
tarama	8	4	1273	3	tarama
vagal	9	46	1363	3	vagal_
vasal	8	55	1629	3	vasal_
wadmaal	13	4	320	3	wadmaal
wadmal	12	3	728	3	wadmal_
wadmals	13	3	551	3	wadmals
walla	8	53	2103	3	wa_lla
wamble	13	44	1575	3	wamble
wambly	16	38	866	3	wambly
yamalkas	17	4	310	3	yamalkas
yamulka	16	5	177	3	yamulka
zamarra	18	4	379	3	zamarra
zamia	16	51	1521	3	zam_ia
zanana	15	38	1036	3	zanana

Search took 9 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.733	243780.4
2	DLD Change Limit	112716	316	7.846	14366.0
3	Display Results	316	316	0.093	3397.8
	(SQL Overall)	178691	316	8.672	20605.5