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

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

493 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
balata	8	6	1467	(None)
balatas	9	3	1183	1	balatas
ablate	8	22	1921	2	ablate
alate	5	53	4032	2	_alate
albata	8	3	933	2	_albata
baklava	16	4	310	2	baklava
baklawa	16	4	340	2	baklawa
balas	7	69	3721	2	bala_s
balboa	10	38	996	2	balboa
balsa	7	79	2041	2	bal_sa
banana	8	32	1341	2	banana
baryta	11	43	1029	2	baryta
bemata	10	4	1169	2	bemata
blat	6	65	5095	2	b_lat_
blate	7	59	3378	2	b_late
blats	7	51	3250	2	b_lats
galatea	8	3	994	2	galatea
halala	9	47	1509	2	halala
malate	8	46	2455	2	malate
palapa	10	3	1067	2	palapa
palatal	9	3	1015	2	palatal
palate	8	42	2678	2	palate
valuta	9	3	874	2	valuta
abaca	9	51	1804	3	_abaca
abaka	11	43	1382	3	_abaka
abate	7	66	2784	3	_abate
abaya	10	44	1317	3	_abaya
ablated	10	25	1344	3	ablated
ablates	9	24	1690	3	ablates
ablator	9	3	984	3	ablator
ablaut	8	3	1326	3	ablaut
ablauts	9	3	608	3	ablauts
ablaze	17	23	983	3	ablaze
abwatt	11	4	1067	3	abwatt
aceta	7	40	1735	3	_aceta
acta	6	95	2480	3	_a_cta
adyta	9	3	685	3	_adyta
agama	8	58	1557	3	_agama
agate	6	65	2514	3	_agate
agita	6	3	1542	3	_agita
ala	3	124	6360	3	_al__a
alack	11	48	2006	3	_alack
alae	4	56	4375	3	_ala_e
alamo	7	4	1814	3	_alamo
alan	4	68	4408	3	_ala_n
aland	6	55	2641	3	_aland
alane	5	61	3561	3	_alane
alang	6	60	2351	3	_alang
alans	5	56	3617	3	_alans
alant	5	57	4229	3	_alant
alants	6	77	2202	3	_alants
alar	4	63	4007	3	_ala_r
alarm	7	66	2142	3	_alarm
alary	8	61	2344	3	_alary
alas	4	63	5812	3	_ala_s
alaska	10	3	671	3	_alaska
alated	7	56	2514	3	_alated
alates	6	48	3396	3	_alates
alba	6	83	2833	3	_al_ba
albatas	9	3	837	3	_albatas
alfa	7	76	2427	3	_al_fa
alga	5	79	2760	3	_al_ga
alit	4	61	5569	3	_alit_
aliya	8	37	1348	3	_aliya
alma	6	63	3302	3	_al_ma
aloha	8	5	1361	3	_aloha
alpaca	10	4	738	3	_alpaca
alpha	10	4	965	3	_alpha
alt	3	64	6796	3	_al_t_
altar	5	55	2064	3	_altar
alto	4	78	3126	3	_al_to
alts	4	66	3990	3	_al_ts
alula	5	3	1709	3	_alula
anta	4	68	3958	3	_a_nta
aorta	5	59	2257	3	_aorta
asana	5	3	1548	3	_asana
atalaya	10	4	482	3	atalaya
atlatl	6	3	787	3	atlatl
avatar	9	3	752	3	_avatar
baa	5	106	5042	3	b__a_a
baaed	8	52	1816	3	ba_aed
baal	6	70	3311	3	ba_a_l
baalim	10	3	847	3	baalim
baals	7	61	2270	3	ba_als
baas	6	68	4467	3	ba_a_s
baba	8	88	2834	3	b__aba
babas	9	63	2573	3	baba_s
babka	13	78	1291	3	ba_bka
bacalao	11	4	661	3	bacalao
bacca	11	10	1218	3	ba_cca
baccara	13	4	714	3	baccara
baccate	13	10	1126	3	baccate
bacula	10	31	1267	3	bacula
badass	9	4	929	3	badass
badland	11	4	765	3	badland
bagass	9	3	893	3	bagass
baht	9	67	4001	3	ba_ht_
bahts	10	56	1780	3	ba_hts
bait	6	65	5600	3	ba_it_
baith	10	80	2313	3	ba_ith
baits	7	66	3058	3	ba_its
baiza	16	48	1322	3	ba_iza
baklavas	17	4	278	3	baklavas
baklawas	17	4	321	3	baklawas
bal	5	66	6272	3	bal___
balance	11	5	1026	3	balance
balases	9	38	1543	3	balases
balboas	11	37	1007	3	balboas
bald	7	64	3290	3	bal__d
balded	10	54	1751	3	balded
balder	9	53	1886	3	balder
baldly	12	47	983	3	baldly
baldpate	13	4	548	3	baldpate
balds	8	55	2464	3	bal_ds
baldy	11	55	1893	3	bal_dy
bale	6	63	5384	3	bal__e
baled	8	54	3644	3	bal_ed
baleen	8	6	1305	3	baleen
baler	7	56	3527	3	bal_er
balers	8	56	2693	3	balers
bales	7	62	5008	3	bal_es
baling	9	48	2969	3	baling
balk	10	51	3222	3	bal__k
balked	13	52	1941	3	balked
balker	12	45	1916	3	balker
balks	11	49	2629	3	bal_ks
balky	14	54	1824	3	bal_ky
ball	6	60	4332	3	bal__l
ballad	9	43	1532	3	ballad
ballade	10	40	1256	3	ballade
ballads	10	42	1291	3	ballads
ballast	9	3	1399	3	ballast
ballasts	10	3	793	3	ballasts
balled	9	49	2689	3	balled
baller	8	38	2520	3	baller
ballet	8	47	3397	3	ballet
ballets	9	37	1951	3	ballets
ballista	10	4	580	3	ballista
ballon	8	41	1749	3	ballon
ballot	8	46	2409	3	ballot
ballots	9	41	1603	3	ballots
balls	7	62	3641	3	bal_ls
ballsy	11	50	887	3	ballsy
ballute	9	3	854	3	ballute
bally	10	55	3010	3	bal_ly
balm	8	55	3420	3	bal__m
balms	9	57	2392	3	bal_ms
balmy	12	52	1747	3	bal_my
balneal	9	3	657	3	balneal
bals	6	63	5404	3	bal__s
balsam	10	56	1223	3	balsam
balsams	11	57	901	3	balsams
balsas	8	64	1752	3	balsas
banal	7	59	2599	3	bana_l
bananas	9	33	1222	3	bananas
banda	8	52	2310	3	ba_nda
bandana	10	17	946	3	bandana
bantam	10	3	1406	3	bantam
banty	10	66	2400	3	ba_nty
barathea	13	4	527	3	barathea
barbate	11	3	1454	3	barbate
barca	9	13	1943	3	ba_rca
barista	9	3	1081	3	barista
barite	8	42	2481	3	barite
barytas	12	37	828	3	barytas
baryte	11	53	1288	3	baryte
basal	7	57	2228	3	basa_l
basalt	8	35	1958	3	basalt
basalts	9	35	896	3	basalts
basmati	11	4	823	3	basmati
bast	6	63	6241	3	ba_st_
baste	7	48	2998	3	ba_ste
basts	7	59	3693	3	ba_sts
bat	5	109	8895	3	b__at_
bate	6	65	5242	3	b__ate
bath	9	59	4008	3	b__ath
bats	6	69	6233	3	b__ats
batt	6	50	5387	3	b__att
batts	7	67	2756	3	ba_tts
battu	7	52	1661	3	ba_ttu
batty	10	54	2224	3	ba_tty
bawty	13	56	1410	3	ba_wty
bayamo	13	3	560	3	bayamo
bayard	12	44	1166	3	bayard
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	baza_r
bazars	17	46	1311	3	bazars
beat	6	61	6830	3	b_eat_
beats	7	60	4224	3	b_eats
begat	8	66	2972	3	begat_
belady	12	48	993	3	belady
belated	10	35	2001	3	belated
belaud	9	3	913	3	belaud
belay	10	50	2152	3	bela_y
belays	11	43	1385	3	belays
belga	8	3	1323	3	bel_ga
belt	6	57	5403	3	bel_t_
belts	7	59	3116	3	bel_ts
beluga	9	3	623	3	beluga
berate	8	47	2902	3	berate
beta	6	62	3413	3	b__eta
betta	7	49	1684	3	b_etta
bhakta	15	3	365	3	bhakta
bilboa	10	36	784	3	bilboa
binate	8	4	1977	3	binate
biota	7	45	1682	3	b_iota
blab	8	66	2913	3	b_la_b
blabs	9	56	1963	3	b_labs
black	13	47	1907	3	b_lack
blade	8	59	2333	3	b_lade
blae	6	61	3464	3	b_la_e
blaff	13	52	1648	3	b_laff
blah	9	86	2506	3	b_la_h
blahs	10	56	1651	3	b_lahs
blain	7	54	2179	3	b_lain
blam	8	61	3170	3	b_la_m
blame	9	56	2549	3	b_lame
blams	9	50	2385	3	b_lams
bland	8	53	2045	3	b_land
blank	11	54	1855	3	b_lank
blare	7	58	2623	3	b_lare
blase	7	55	2423	3	b_lase
blast	7	65	3257	3	b_last
blasts	8	51	1677	3	blasts
blasty	11	56	1105	3	blasty
blatant	9	3	1067	3	b_latant
blaw	9	70	2672	3	b_la_w
blawn	10	68	1370	3	b_lawn
blaws	10	56	2046	3	b_laws
blaze	16	55	2083	3	b_laze
bleat	7	57	3700	3	bleat_
bleats	8	55	1861	3	bleats
blet	6	62	4767	3	b_let_
blets	7	53	2494	3	b_lets
blite	7	62	2535	3	b_lite
blitz	16	53	1813	3	b_litz
bloat	7	52	2992	3	bloat_
bloats	8	52	1576	3	bloats
blot	6	58	4232	3	b_lot_
blots	7	56	2617	3	b_lots
boat	6	63	6031	3	b_oat_
boats	7	56	3515	3	b_oats
bola	6	60	3556	3	bol__a
bolar	7	51	2347	3	bola_r
bolas	7	47	3376	3	bola_s
bolete	8	5	1961	3	bolete
boleti	8	4	1340	3	boleti
bolt	6	62	5417	3	bol_t_
bolts	7	62	3211	3	bol_ts
bonita	8	3	1294	3	bonita
borate	8	50	2615	3	borate
bota	6	62	3650	3	b__ota
brat	6	60	5554	3	b_rat_
brats	7	53	3601	3	b_rats
brava	10	64	1479	3	b_rava
braza	16	52	1425	3	b_raza
breath	11	39	1626	3	breath
bulla	7	46	2056	3	bul_la
bullate	9	34	1507	3	bullate
bwana	10	3	1024	3	b_wana
bylaw	13	40	860	3	byla_w
bylaws	14	41	583	3	bylaws
bypath	16	4	535	3	bypath
cabala	10	35	1691	3	cabala
cabana	10	39	1356	3	cabana
calamar	11	4	929	3	calamar
calamata	12	4	755	3	calamata
calami	10	3	1342	3	calami
calash	11	3	1243	3	calash
calathi	12	4	757	3	calathi
calesa	8	4	1247	3	calesa
calla	7	48	2707	3	cal_la
canasta	9	3	836	3	canasta
cantata	9	38	1181	3	cantata
capita	10	29	1377	3	capita
carat	7	50	4879	3	carat_
carate	8	47	3400	3	carate
carats	8	59	2902	3	carats
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
casita	8	29	1370	3	casita
cassata	9	3	814	3	cassata
chalaza	21	4	573	3	chalaza
dalasi	7	6	1062	3	dalasi
daleth	10	3	863	3	daleth
data	5	60	2665	3	__data
dealate	8	36	1784	3	dealate
delate	7	38	2775	3	delate
delta	6	61	1777	3	del_ta
dilate	7	32	2069	3	dilate
eclat	7	5	2360	3	eclat_
eclats	8	3	1303	3	eclats
elate	5	53	3588	3	_elate
errata	6	3	901	3	errata
fajita	16	3	592	3	fajita
falbala	12	3	587	3	falbala
falcate	12	3	1161	3	falcate
flat	7	71	4782	3	_flat_
flats	8	64	2974	3	_flats
flauta	9	3	782	3	flauta
flota	8	53	1564	3	_flota
folate	9	33	2039	3	folate
gala	5	56	3516	3	gal__a
galabia	10	3	831	3	galabia
galago	8	3	890	3	galago
galah	9	59	1762	3	gala_h
galahs	10	55	1267	3	galahs
galanga	9	3	601	3	galanga
galas	6	57	3164	3	gala_s
galateas	9	3	712	3	galateas
galax	13	53	1446	3	gala_x
galaxy	17	47	631	3	galaxy
galea	6	47	2293	3	gal_ea
galeate	8	39	1678	3	galeate
galena	7	49	1109	3	galena
gallate	8	34	1712	3	gallate
galleta	8	39	964	3	galleta
gelada	8	3	762	3	gelada
gelate	7	34	2125	3	gelate
gelati	7	38	1453	3	gelati
gelato	7	38	1295	3	gelato
halacha	15	38	800	3	halacha
halakah	17	51	795	3	halakah
halakha	17	41	658	3	halakha
halal	8	56	2359	3	hala_l
halalah	13	42	938	3	halalah
halalas	10	42	1408	3	halalas
halals	9	50	1831	3	halals
halavah	16	44	701	3	halavah
halite	9	36	2423	3	halite
halloa	9	49	1812	3	halloa
halma	10	82	1925	3	hal_ma
halt	7	60	5630	3	hal_t_
halts	8	52	3010	3	hal_ts
halutz	18	6	885	3	halutz
halva	11	54	1443	3	hal_va
hamada	12	3	991	3	hamada
hamate	11	33	1982	3	hamate
hawala	12	36	891	3	hawala
jacana	15	3	793	3	jacana
jalap	14	36	1247	3	jala_p
jalaps	15	29	918	3	jalaps
kabaka	11	34	850	3	kabaka
kabala	12	40	1155	3	kabala
kabaya	15	38	712	3	kabaya
kalam	11	3	1511	3	kala_m
kalamata	14	4	527	3	kalamata
kalams	12	3	1060	3	kalams
kalmia	12	3	889	3	kalmia
kalpa	11	45	1219	3	kal_pa
kamala	12	33	996	3	kamala
kanaka	9	35	752	3	kanaka
karat	9	68	3759	3	karat_
karate	10	53	2092	3	karate
karats	10	64	2049	3	karats
kata	8	56	2602	3	__kata
labara	8	37	1289	3	labara
lama	6	66	3529	3	__lama
lanate	6	4	2126	3	lanate
lat	3	75	9340	3	__lat_
late	4	75	6048	3	__late
lath	7	66	4038	3	__lath
lati	4	64	3827	3	__lati
lats	4	59	6270	3	__lats
latu	4	79	3418	3	__latu
lava	7	67	2542	3	__lava
llama	7	9	989	3	_llama
lota	4	72	3350	3	__lota
magmata	12	3	746	3	magmata
mahatma	14	4	378	3	mahatma
makuta	12	3	639	3	makuta
malacca	13	4	495	3	malacca
malady	12	3	786	3	malady
malanga	10	3	666	3	malanga
malar	7	64	2444	3	mala_r
malaria	9	3	1369	3	malaria
malars	8	50	2068	3	malars
malates	9	35	2260	3	malates
maleate	9	41	1754	3	maleate
maloti	8	3	1319	3	maloti
malt	6	62	5480	3	mal_t_
maltha	11	3	750	3	maltha
malts	7	63	3175	3	mal_ts
malty	10	67	2170	3	mal_ty
manana	8	48	1607	3	manana
manat	7	60	3998	3	manat_
manats	8	46	2346	3	manats
manta	7	56	2990	3	ma_nta
maraca	10	3	1415	3	maraca
maranta	9	3	1169	3	maranta
masala	8	3	1181	3	masala
muleta	8	3	923	3	muleta
nagana	7	4	894	3	nagana
nala	4	69	3039	3	nal__a
nalas	5	55	2836	3	nala_s
oblate	8	22	1474	3	oblate
oxalate	14	5	762	3	oxalate
pajama	17	31	765	3	pajama
palabra	11	3	718	3	palabra
palace	10	45	1691	3	palace
palais	8	4	2042	3	palais
palapas	11	3	1149	3	palapas
palatals	10	3	777	3	palatals
palates	9	36	2493	3	palates
palatial	10	4	1062	3	palatial
palea	7	50	2866	3	pal_ea
paleate	9	41	2000	3	paleate
palet	7	46	5080	3	palet_
palets	8	51	2231	3	palets
pallia	8	30	1559	3	pallia
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
panada	9	41	1305	3	panada
panama	10	42	1334	3	panama
papaya	13	3	750	3	papaya
pasta	7	66	2453	3	pa_sta
pataca	10	3	1119	3	pataca
pelota	8	6	1283	3	pelota
pinata	8	38	1721	3	pinata
plat	6	60	4887	3	_plat_
platan	8	39	1369	3	_platan
plate	7	46	3511	3	_plate
plats	7	55	3137	3	_plats
platy	10	50	2166	3	_platy
playa	10	58	1294	3	_playa
plaza	16	43	1106	3	_plaza
qabala	17	39	919	3	qabala
qanat	14	44	2684	3	qanat_
qanats	15	41	1281	3	qanats
rabat	7	28	3222	3	rabat_
rabato	8	34	1326	3	rabato
rabats	8	31	1622	3	rabats
raita	5	46	2307	3	ra_ita
ramada	9	3	1018	3	ramada
ramate	8	39	2168	3	ramate
ratatat	7	4	1226	3	ratatat
reata	5	42	2539	3	_reata
relate	6	40	3363	3	relate
riata	5	46	1802	3	_riata
salaam	8	7	1101	3	salaam
salad	6	53	2183	3	sala_d
salads	7	53	1696	3	salads
salal	5	54	2570	3	sala_l
salals	6	51	2008	3	salals
salami	8	3	1310	3	salami
salary	9	5	1521	3	salary
salina	6	42	2112	3	salina
saliva	9	31	1074	3	saliva
salpa	7	50	1835	3	sal_pa
salsa	5	67	1892	3	sal_sa
salt	4	57	5852	3	sal_t_
salts	5	54	3188	3	sal_ts
salty	8	55	2438	3	sal_ty
salute	6	44	1802	3	salute
salvia	9	33	1075	3	salvia
samara	8	3	1385	3	samara
sancta	8	3	983	3	sancta
sapota	8	3	1020	3	sapota
satara	6	3	1553	3	satara
savate	9	3	1378	3	savate
slat	4	69	5902	3	_slat_
slate	5	54	3828	3	_slate
slats	5	54	3690	3	_slats
slaty	8	65	2315	3	_slaty
solate	6	45	2607	3	solate
solatia	7	3	1224	3	solatia
somata	8	3	1238	3	somata
sonata	6	3	1322	3	sonata
splat	7	61	2934	3	splat_
splats	8	48	1730	3	splats
strata	6	36	1628	3	strata
tala	4	59	3805	3	tal__a
talar	5	62	2538	3	tala_r
talaria	7	4	1250	3	talaria
talars	6	60	2168	3	talars
talas	5	59	3589	3	tala_s
taluka	10	42	677	3	taluka
tapeta	8	3	1069	3	tapeta
tarama	8	4	1272	3	tarama
tarlatan	8	4	506	3	tarlatan
ulama	7	7	1147	3	_ulama
vacate	11	3	1455	3	vacate
valet	8	43	3787	3	valet_
valets	9	37	1562	3	valets
vallate	10	30	1656	3	vallate
valuate	10	25	1273	3	valuate
valutas	10	3	653	3	valutas
valvate	13	37	1081	3	valvate
velate	9	37	2014	3	velate
volta	8	52	1562	3	vol_ta
walla	8	53	2103	3	wal_la
waltz	17	6	1547	3	wal_tz
zanana	15	38	1036	3	zanana

Search took 8 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.123	1452772.4
2	DLD Change Limit	112716	493	6.830	16503.1
3	Display Results	493	493	0.170	2900.0
	(SQL Overall)	178691	493	7.123	25086.5