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

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

403 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
palapa	10	3	1067	(None)
palapas	11	3	1149	1	palapas
balata	8	6	1467	2	balata
halala	9	47	1509	2	halala
jalap	14	36	1247	2	jalap_
jalaps	15	29	918	2	jalaps
kalpa	11	45	1219	2	kal_pa
pajama	17	31	765	2	pajama
palabra	11	3	718	2	palabra
palace	10	45	1691	2	palace
palais	8	4	2042	2	palais
palatal	9	3	1015	2	palatal
palate	8	42	2678	2	palate
palea	7	50	2866	2	pal_ea
pallia	8	30	1559	2	pallia
palp	8	58	2857	2	pal_p_
palpal	10	41	1205	2	palpal
palpi	9	54	1455	2	pal_pi
palps	9	47	1956	2	pal_ps
pampa	11	49	1342	2	pa_mpa
panada	9	41	1305	2	panada
panama	10	42	1334	2	panama
papa	8	58	2714	2	p__apa
papaya	13	3	750	2	papaya
paraph	13	3	1126	2	paraph
pataca	10	3	1119	2	pataca
playa	10	58	1294	2	p_laya
plaza	16	43	1106	2	p_laza
salpa	7	50	1835	2	sal_pa
abaca	9	51	1804	3	_abaca
abaka	11	43	1382	3	_abaka
abaya	10	44	1317	3	_abaya
adapt	8	12	1855	3	_adapt
agama	8	58	1557	3	_agama
agapae	9	38	804	3	_agapae
agapai	9	45	684	3	_agapai
agape	8	56	1484	3	_agape
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
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
alate	5	53	4032	3	_alate
alba	6	83	2833	3	_al_ba
albata	8	3	933	3	_albata
aleph	10	3	1139	3	_aleph
alfa	7	76	2427	3	_al_fa
alga	5	79	2760	3	_al_ga
aliya	8	37	1348	3	_aliya
alma	6	63	3302	3	_al_ma
aloha	8	5	1361	3	_aloha
alp	5	66	4113	3	_al_p_
alpaca	10	4	738	3	_alpaca
alpha	10	4	965	3	_alpha
alps	6	55	2924	3	_al_ps
alula	5	3	1709	3	_alula
aplasia	9	25	1080	3	aplasia
arepa	7	56	1556	3	_arepa
asana	5	3	1548	3	_asana
atalaya	10	4	482	3	atalaya
atap	6	67	2245	3	_atap_
ataps	7	64	1483	3	_ataps
baklava	16	4	310	3	baklava
baklawa	16	4	340	3	baklawa
balas	7	69	3721	3	bala_s
balatas	9	3	1183	3	balatas
balboa	10	38	996	3	balboa
balsa	7	79	2041	3	bal_sa
banana	8	32	1341	3	banana
cabala	10	35	1691	3	cabala
cabana	10	39	1356	3	cabana
calamar	11	4	929	3	calamar
calami	10	3	1342	3	calami
calash	11	3	1243	3	calash
calesa	8	4	1247	3	calesa
caliph	13	3	1140	3	caliph
calla	7	48	2707	3	cal_la
calpac	12	32	1106	3	calpac
canape	10	9	1351	3	canape
carapax	18	3	579	3	carapax
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
catalpa	11	3	650	3	catalpa
chalaza	21	4	573	3	chalaza
chalupa	14	4	447	3	chalupa
clap	8	64	2904	3	_clap_
claps	9	56	2618	3	_claps
clapt	9	80	2717	3	_clapt
culpa	9	36	1096	3	cul_pa
dalapon	10	4	489	3	dalapon
dalasi	7	6	1062	3	dalasi
earlap	8	3	718	3	earlap_
earlaps	9	3	639	3	earlaps
falbala	12	3	587	3	falbala
flap	9	61	2870	3	_flap_
flaps	10	56	2138	3	_flaps
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
galatea	8	3	994	3	galatea
galax	13	53	1446	3	gala_x
galaxy	17	47	631	3	galaxy
galea	6	47	2293	3	gal_ea
galena	7	49	1109	3	galena
galop	8	47	1621	3	galop_
galops	9	47	1261	3	galops
gelada	8	3	762	3	gelada
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
halloa	9	49	1812	3	halloa
halma	10	82	1925	3	hal_ma
halva	11	54	1443	3	hal_va
hamada	12	3	991	3	hamada
hawala	12	36	891	3	hawala
jacana	15	3	793	3	jacana
jalapic	18	4	454	3	jalapic
jalapin	16	4	592	3	jalapin
jalop	14	42	1260	3	jalop_
jalops	15	32	959	3	jalops
jalopy	18	32	586	3	jalopy
kabaka	11	34	850	3	kabaka
kabala	12	40	1155	3	kabala
kabaya	15	38	712	3	kabaya
kakapo	11	4	385	3	kakapo
kalam	11	3	1511	3	kala_m
kalams	12	3	1060	3	kalams
kaliph	15	3	787	3	kaliph
kalmia	12	3	889	3	kalmia
kalpac	14	42	822	3	kalpac
kalpak	11	43	724	3	kalpak
kalpas	12	41	1294	3	kalpas
kamala	12	33	996	3	kamala
kanaka	9	35	752	3	kanaka
kapa	10	60	2129	3	__kapa
kappa	13	46	974	3	ka_ppa
labara	8	37	1289	3	labara
lama	6	66	3529	3	__lama
lap	5	85	6527	3	__lap_
laps	6	68	4887	3	__laps
lava	7	67	2542	3	__lava
lipa	6	84	2592	3	__lipa
llama	7	9	989	3	_llama
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
malate	8	46	2455	3	malate
maltha	11	3	750	3	maltha
manana	8	48	1607	3	manana
maraca	10	3	1415	3	maraca
masala	8	3	1181	3	masala
milpa	9	21	1140	3	mil_pa
nagana	7	4	894	3	nagana
nala	4	69	3039	3	nal__a
nalas	5	55	2836	3	nala_s
napa	6	69	2726	3	__napa
nappa	9	85	1186	3	na_ppa
paca	8	51	3224	3	p__aca
pacas	9	60	2940	3	paca_s
pacha	12	65	1806	3	pa_cha
padauk	13	3	564	3	padauk
paean	7	72	2272	3	paea_n
paeans	8	51	1826	3	paeans
paella	8	4	1091	3	paella
pagan	8	61	2116	3	paga_n
pagans	9	57	1792	3	pagans
pagoda	10	48	787	3	pagoda
pahlavi	15	4	264	3	pahlavi
paisa	7	60	2107	3	pa_isa
paisana	9	40	1022	3	paisana
pajamas	18	27	815	3	pajamas
pakeha	15	3	393	3	pakeha
pakora	12	4	728	3	pakora
pal	5	67	6167	3	pal___
palabras	12	6	735	3	palabras
palaced	12	41	1077	3	palaced
palaces	11	42	1645	3	palaces
paladin	10	10	1177	3	paladin
palatals	10	3	777	3	palatals
palates	9	36	2493	3	palates
palatial	10	4	1062	3	palatial
palaver	12	3	875	3	palaver
palazzi	17	4	299	3	palazzi
palazzo	17	4	308	3	palazzo
pale	6	60	5501	3	pal__e
paleae	8	48	2029	3	paleae
paleal	8	47	1667	3	paleal
paleate	9	41	2000	3	paleate
paled	8	55	3872	3	pal_ed
palely	11	3	1192	3	palely
paler	7	54	3693	3	pal_er
pales	7	57	5380	3	pal_es
palest	8	39	2622	3	palest
palet	7	46	5080	3	pal_et
palets	8	51	2231	3	palets
palier	8	50	2356	3	palier
palikar	13	3	545	3	palikar
paling	9	35	3013	3	paling
palish	11	47	1827	3	palish
pall	6	50	3934	3	pal__l
palladia	11	4	663	3	palladia
palled	9	46	2516	3	palled
pallet	8	42	3265	3	pallet
pallial	9	29	1125	3	pallial
pallid	9	39	1527	3	pallid
pallor	8	3	1367	3	pallor
palls	7	43	3256	3	pal_ls
pally	10	57	2712	3	pal_ly
palm	8	53	3136	3	pal__m
palmar	10	41	1346	3	palmar
palmary	14	33	855	3	palmary
palmate	11	32	1523	3	palmate
palmed	11	43	1464	3	palmed
palmer	10	58	1654	3	palmer
palms	9	49	2175	3	pal_ms
palmy	12	60	1673	3	pal_my
palmyra	14	4	414	3	palmyra
palooka	13	4	450	3	palooka
palpate	11	32	1392	3	palpate
palped	11	45	1364	3	palped
palpus	10	42	1028	3	palpus
pals	6	69	5135	3	pal__s
palsy	10	54	1746	3	pal_sy
palter	8	44	2326	3	palter
paltry	11	49	1040	3	paltry
paludal	10	3	568	3	paludal
paly	9	58	3553	3	pal__y
pampas	12	49	1399	3	pampas
panacea	11	3	778	3	panacea
panadas	10	33	1221	3	panadas
panamas	11	31	1275	3	panamas
panda	8	50	2261	3	pa_nda
panga	8	53	2353	3	pa_nga
pap	7	67	5840	3	p__ap_
papacy	15	4	749	3	papacy
papadam	14	8	691	3	papadam
papain	10	3	1379	3	papain
papal	9	58	2067	3	papa_l
papas	9	49	2749	3	papa_s
papaw	12	51	1249	3	papa_w
papaws	13	41	911	3	papaws
papayan	14	4	530	3	papayan
papayas	14	3	727	3	papayas
pappi	8	48	1089	3	pa_ppi
pappy	11	47	1380	3	pa_ppy
paps	8	64	4345	3	p__aps
papula	10	30	1111	3	papula
para	6	52	4217	3	p__ara
parade	9	47	2064	3	parade
parae	7	63	3570	3	para_e
paramo	10	26	1464	3	paramo
parang	9	37	1551	3	parang
parapet	11	3	1764	3	parapet
paraphs	14	3	931	3	paraphs
paras	7	61	4304	3	para_s
parka	11	51	2088	3	pa_rka
parlay	11	37	1399	3	parla_y
parlays	12	39	1045	3	parlays
parura	8	3	1058	3	parura
pasha	10	54	1718	3	pa_sha
pasta	7	66	2453	3	pa_sta
patacas	11	3	1100	3	patacas
patagia	10	6	878	3	patagia
patamar	11	4	709	3	patamar
patina	8	60	2219	3	patina
pavan	10	65	1847	3	pava_n
pavane	11	41	1344	3	pavane
pavans	11	57	1559	3	pavans
pavlova	15	4	211	3	pavlova
pawpaw	16	5	350	3	pawpaw
payola	11	20	811	3	payola
pazazz	15	5	402	3	pazazz
pelage	9	5	1536	3	pelage
pelota	8	6	1283	3	pelota
phalanx	19	4	520	3	phalanx
piasaba	11	4	419	3	piasaba
piasava	12	4	388	3	piasava
picara	10	3	1190	3	picara
pilaf	10	39	2348	3	pila_f
pilaff	14	39	1036	3	pilaff
pilafs	11	35	1102	3	pilafs
pilar	7	52	2150	3	pila_r
pilau	7	36	1852	3	pila_u
pilaus	8	41	1413	3	pilaus
pilaw	10	39	1374	3	pila_w
pilaws	11	39	943	3	pilaws
pilea	7	51	2395	3	pil_ea
pinata	8	38	1721	3	pinata
pirana	8	7	1326	3	pirana
piraya	11	6	771	3	piraya
pitapat	11	4	916	3	pitapat
pitaya	11	8	660	3	pitaya
place	9	48	2461	3	p_lace
plack	13	50	1784	3	p_lack
plagal	9	4	857	3	p_lagal
plage	8	45	2040	3	p_lage
plaid	8	51	1830	3	p_laid
plain	7	48	2330	3	p_lain
plait	7	56	3157	3	p_lait
plan	6	58	3394	3	p_la_n
planar	8	42	1271	3	p_lanar
plane	7	49	2914	3	p_lane
plank	11	52	2114	3	p_lank
plans	7	57	3127	3	p_lans
plant	7	54	3711	3	p_lant
plash	10	46	1656	3	p_lash
plasm	9	41	1463	3	p_lasm
plasma	10	38	1091	3	plasma
plat	6	60	4887	3	p_la_t
platan	8	39	1369	3	p_latan
plate	7	46	3511	3	p_late
plats	7	55	3137	3	p_lats
platy	10	50	2166	3	p_laty
play	9	59	2898	3	p_la_y
playas	11	46	1228	3	p_layas
plays	10	63	2077	3	p_lays
plazas	17	40	991	3	p_lazas
plea	6	68	3060	3	p_l_ea
plena	7	58	1639	3	p_lena
plica	9	6	1337	3	p_lica
plop	8	66	2574	3	p_lop_
plops	9	59	2033	3	p_lops
polar	7	56	2345	3	pola_r
polars	8	44	1935	3	polars
polka	11	3	1041	3	pol_ka
polyp	12	56	1153	3	polyp_
polypi	13	45	859	3	polypi
polyps	13	47	976	3	polyps
poppa	8	40	989	3	p_oppa
posada	9	3	716	3	posada
priapi	10	3	792	3	priapi
pula	6	51	2937	3	pul__a
pulp	8	48	2535	3	pul_p_
pulpal	10	40	845	3	pulpal
pulps	9	51	1648	3	pul_ps
pulpy	12	46	1236	3	pul_py
pupa	8	54	2281	3	p__upa
purana	8	7	1293	3	purana
pyjama	20	30	348	3	pyjama
qabala	17	39	919	3	qabala
ralph	10	7	874	3	ral_ph
ramada	9	3	1018	3	ramada
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
salep	7	70	2295	3	salep_
saleps	8	50	1490	3	saleps
salina	6	42	2112	3	salina
saliva	9	31	1074	3	saliva
salp	6	45	3409	3	sal_p_
salpae	8	46	1427	3	salpae
salpas	8	51	1692	3	salpas
salps	7	44	2324	3	sal_ps
salsa	5	67	1892	3	sal_sa
saltpan	9	3	530	3	saltpan
salvia	9	33	1075	3	salvia
samara	8	3	1385	3	samara
sarape	8	48	1757	3	sarape
satara	6	3	1553	3	satara
slap	6	64	3404	3	_slap_
slaps	7	60	2571	3	_slaps
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
tapa	6	51	2914	3	__tapa
tarama	8	4	1272	3	tarama
tilapia	9	4	554	3	tilapia
ulama	7	7	1147	3	_ulama
valuta	9	3	874	3	valuta
walla	8	53	2103	3	wal_la
watap	10	21	1167	3	watap_
watape	11	20	848	3	watape
wataps	11	24	868	3	wataps
zanana	15	38	1036	3	zanana

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.140	1276364.3
2	DLD Change Limit	112716	403	5.546	20323.8
3	Display Results	403	403	0.126	3198.4
	(SQL Overall)	178691	403	5.812	30745.2