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

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

378 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
labara	8	37	1289	(None)
labra	7	54	1546	1	lab_ra
abaca	9	51	1804	2	_abaca
abaka	11	43	1382	2	_abaka
abaya	10	44	1317	2	_abaya
albata	8	3	933	2	albata
cabala	10	35	1691	2	cabala
cabana	10	39	1356	2	cabana
kabaka	11	34	850	2	kabaka
kabala	12	40	1155	2	kabala
kabar	11	48	1555	2	kabar_
kabars	12	45	1395	2	kabars
kabaya	15	38	712	2	kabaya
laari	5	44	1571	2	la_ari
labarum	11	6	601	2	labarum
labia	7	52	1901	2	lab_ia
labor	7	51	1731	2	labor_
labors	8	40	1641	2	labors
lahar	8	31	1426	2	lahar_
lahars	9	40	1316	2	lahars
lambada	12	4	564	2	lambada
laura	5	41	1620	2	la_ura
lazar	14	41	1364	2	lazar_
lazars	15	38	1239	2	lazars
libra	7	47	1242	2	lib_ra
lobar	7	3	1301	2	lobar_
qabala	17	39	919	2	qabala
sabra	7	53	1785	2	sab_ra
samara	8	3	1385	2	samara
satara	6	3	1553	2	satara
tabard	9	3	1333	2	tabard
aba	5	128	5095	3	_ab__a
abacas	10	44	1472	3	_abacas
abaci	9	47	1884	3	_abaci
aback	13	48	1617	3	_aback
abaft	10	3	1806	3	_abaft
abakas	12	39	1174	3	_abakas
abamp	11	3	1060	3	_abamp
abas	6	86	4208	3	_aba_s
abase	7	60	2348	3	_abase
abash	10	60	1651	3	_abash
abasia	8	7	1295	3	_abasia
abate	7	66	2784	3	_abate
abayas	11	40	1170	3	_abayas
abba	8	105	2265	3	_ab_ba
abfarad	13	4	422	3	_abfarad
aboard	9	3	1261	3	_aboard
aboma	9	11	1460	3	_aboma
aboral	8	3	1437	3	_aboral
abort	7	61	3358	3	_abort
abri	6	55	2221	3	_ab_ri
acari	7	50	2028	3	_acari
afar	7	67	2078	3	_afar_
afars	8	57	1651	3	_afars
agama	8	58	1558	3	_agama
agar	5	87	2641	3	_agar_
agars	6	61	2064	3	_agars
agora	6	9	1433	3	_agora
ajar	11	62	1770	3	_ajar_
alar	4	63	4007	3	_alar_
alarm	7	66	2142	3	_alarm
alary	8	61	2344	3	_alary
alba	6	83	2833	3	alb__a
albas	7	59	2539	3	alba_s
albatas	9	3	837	3	albatas
alpaca	10	4	738	3	alpaca
altar	5	55	2064	3	altar_
altars	6	45	1815	3	altars
amarna	8	3	979	3	_amarna
ambari	10	30	1217	3	ambari
ambary	13	40	1054	3	ambary
antra	5	65	2192	3	_antra
apart	7	43	3067	3	_apart
asana	5	3	1548	3	_asana
aura	4	58	3625	3	_a_ura
award	9	71	1804	3	_award
aware	8	64	2002	3	_aware
baa	5	106	5042	3	__ba_a
baba	8	88	2835	3	__baba
babas	9	63	2573	3	baba_s
babka	13	78	1291	3	bab_ka
baccara	13	4	714	3	baccara
balata	8	6	1468	3	balata
banana	8	32	1341	3	banana
bar	5	80	7055	3	__bar_
barb	8	52	4006	3	__barb
barca	9	13	1943	3	__barca
bard	7	56	4886	3	__bard
bare	6	54	6052	3	__bare
barf	9	58	4441	3	__barf
bark	10	62	4215	3	__bark
barm	8	67	3960	3	__barm
barn	6	64	4464	3	__barn
bars	6	65	6409	3	__bars
bayard	12	44	1166	3	bayard
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	bazar_
bazars	17	46	1311	3	bazars
bora	6	61	4163	3	__bora
bra	5	63	3946	3	__b_ra
bura	6	61	3953	3	__bura
cabal	9	52	2215	3	caba_l
cabalas	11	35	1600	3	cabalas
cabals	10	40	2015	3	cabals
cabanas	11	24	1303	3	cabanas
cabaret	11	25	1904	3	cabaret
cabbala	13	6	718	3	cabbala
caber	9	51	2683	3	caber_
cabers	10	50	2392	3	cabers
calabaza	21	4	346	3	calabaza
camera	10	3	1369	3	camera
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
capybara	17	4	278	3	capybara
carbarn	11	3	945	3	carbarn
carbora	11	3	1070	3	carbora
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
cascara	11	3	831	3	cascara
cobra	9	52	1440	3	cob_ra
curara	8	37	1220	3	curara
damar	8	41	1774	3	damar_
damars	9	38	1500	3	damars
darbar	9	5	995	3	darbar_
darbars	10	5	1009	3	darbars
datary	10	3	1024	3	datary
datura	7	3	803	3	datura
debar	8	55	1786	3	debar_
debark	13	42	1094	3	debark
debars	9	42	1804	3	debars
dobra	8	50	1310	3	dob_ra
embar	9	40	1160	3	embar_
embark	14	45	852	3	embark
embars	10	38	1288	3	embars
falbala	12	3	587	3	falbala
fubar	10	3	992	3	fubar_
gabbard	13	3	655	3	gabbard
gabbart	12	4	888	3	gabbart
gabbro	11	11	495	3	gabbro
gazar	15	46	1298	3	gazar_
gazars	16	48	1155	3	gazars
haar	7	73	2349	3	ha_ar_
haars	8	56	2047	3	ha_ars
habanera	13	4	327	3	habanera
haftara	13	13	609	3	haftara
halala	9	47	1509	3	halala
hamada	12	3	992	3	hamada
hawala	12	36	891	3	hawala
hazard	19	3	840	3	hazard
imbark	14	34	786	3	imbark
jabiru	15	12	551	3	jabiru
jacana	15	3	793	3	jacana
jagra	13	3	817	3	ja_gra
kabab	13	48	1444	3	kaba_b
kababs	14	40	977	3	kababs
kabakas	12	36	740	3	kabakas
kabalas	13	39	1106	3	kabalas
kabayas	16	31	680	3	kabayas
kabbala	15	8	461	3	kabbala
kamala	12	33	996	3	kamala
kanaka	9	35	752	3	kanaka
kbar	10	65	1465	3	_kbar_
kbars	11	46	1260	3	_kbars
kebar	11	51	1353	3	kebar_
kebars	12	41	1249	3	kebars
kinara	10	3	1037	3	kinara
lab	5	88	6478	3	lab___
labarums	12	5	450	3	labarums
label	7	50	1938	3	lab_el
labella	9	8	894	3	labella
labels	8	45	1568	3	labels
labial	8	47	1434	3	labial
labials	9	29	987	3	labials
labiate	9	13	1357	3	labiate
labile	8	3	1522	3	labile
labium	10	4	1024	3	labium
labored	10	28	1025	3	labored
laborer	9	24	951	3	laborer
labour	8	42	1093	3	labour
labours	9	34	989	3	labours
labret	8	3	2022	3	labret
labrum	10	5	742	3	labrum
labs	6	71	4512	3	lab__s
lacer	7	58	3375	3	lacer_
lacers	8	52	2525	3	lacers
lactary	12	3	785	3	lactary
lacuna	8	11	812	3	lacuna
lader	6	56	3372	3	lader_
laders	7	49	2776	3	laders
lagan	6	65	2034	3	laga_n
lagans	7	57	1778	3	lagans
lager	6	51	3286	3	lager_
lagers	7	48	2614	3	lagers
laggard	10	34	762	3	laggard
laguna	7	12	722	3	laguna
lair	4	59	3415	3	la_ir_
laird	6	54	1779	3	la_ird
lairs	5	54	2587	3	la_irs
laker	9	54	3287	3	laker_
lakers	10	52	2515	3	lakers
lama	6	66	3529	3	l__ama
lamas	7	55	3279	3	lama_s
lambadas	13	5	487	3	lambadas
lambast	11	12	989	3	lambast
lambda	11	4	611	3	lambda
lamber	10	44	1849	3	lamber_
lambers	11	38	1711	3	lambers
lambert	11	36	1711	3	lambert
lamer	7	52	3370	3	lamer_
lamia	7	53	2432	3	la_mia
lamina	8	49	2044	3	lamina
lanai	5	3	1957	3	lana_i
lanais	6	3	1679	3	lanais
lanate	6	4	2126	3	lanate
laniard	8	6	852	3	laniard
laniary	10	6	801	3	laniary
lantana	7	3	960	3	lantana
lanyard	11	6	729	3	lanyard
lapboard	13	5	578	3	lapboard
lar	3	79	6753	3	l__ar_
larboard	11	5	766	3	larboard
lard	5	67	4200	3	l__ard
lari	4	58	3915	3	l__ari
lark	8	57	3386	3	l__ark
lars	4	69	5657	3	l__ars
larva	8	3	1248	3	la_rva
lasagna	8	4	354	3	lasagna
lascar	8	6	857	3	lascar_
lascars	9	7	901	3	lascars
laser	5	46	3332	3	laser_
lasers	6	49	2570	3	lasers
latakia	11	4	609	3	latakia
later	5	48	4392	3	later_
laterad	8	3	1084	3	laterad
lateral	7	3	1357	3	lateral
latina	6	56	2114	3	latina
latria	6	23	1360	3	latria
lauan	5	52	1679	3	laua_n
lauans	6	51	1353	3	lauans
laurae	6	40	1166	3	laurae
lauras	6	34	1433	3	lauras
lava	7	67	2542	3	l__ava
lavabo	11	3	527	3	lavabo
lavage	10	3	826	3	lavage
lavas	8	54	2222	3	lava_s
lavash	12	59	737	3	lavash
laver	8	50	3179	3	laver_
lavers	9	45	2636	3	lavers
laxer	12	54	2033	3	laxer_
layaway	16	4	393	3	layaway
layer	8	46	2647	3	layer_
layers	9	39	2118	3	layers
lazaret	16	4	1178	3	lazaret
lear	4	70	4595	3	l_ear_
learn	5	53	2266	3	l_earn
lears	5	59	3873	3	l_ears
leary	8	59	2738	3	l_eary
liana	5	39	1589	3	l_iana
liar	4	72	2968	3	l_iar_
liard	6	54	1859	3	l_iard
liars	5	47	2316	3	l_iars
liber	7	47	2362	3	liber_
liberal	9	3	1019	3	liberal
libers	8	47	2144	3	libers
librae	8	43	1017	3	librae
library	12	4	532	3	library
libras	8	37	1170	3	libras
libri	7	46	1011	3	lib_ri
lidar	6	3	1272	3	lidar_
lidars	7	3	1078	3	lidars
lira	4	69	2868	3	l__ira
lizard	16	36	923	3	lizard
llama	7	9	989	3	l_lama
lobate	8	29	1524	3	lobate
lumbar	10	36	1059	3	lumbar_
lumbars	11	28	976	3	lumbars
lunar	5	70	1731	3	lunar_
lunars	6	50	1281	3	lunars
lustra	6	35	889	3	lustra
lyard	9	51	1321	3	l_yard
lyart	8	51	2188	3	l_yart
lycra	10	31	797	3	l_ycra
maar	6	60	2506	3	ma_ar_
maars	7	46	2163	3	ma_ars
makar	11	56	1497	3	makar_
makars	12	46	1263	3	makars
malar	7	64	2444	3	malar_
malaria	9	3	1370	3	malaria
malars	8	50	2068	3	malars
manana	8	48	1607	3	manana
mantra	8	41	1609	3	mantra
mara	6	74	4457	3	__mara
maraca	10	3	1415	3	maraca
masala	8	3	1181	3	masala
mascara	11	3	802	3	mascara
mazard	18	3	876	3	mazard
mbira	9	7	797	3	_mbira
megara	9	3	1009	3	megara
nagana	7	4	894	3	nagana
naira	5	3	1474	3	na_ira
navar	8	39	1273	3	navar_
navars	9	28	1057	3	navars
pajama	17	31	765	3	pajama
pakora	12	4	728	3	pakora
palabra	11	3	719	3	palabra
palapa	10	3	1067	3	palapa
panada	9	41	1305	3	panada
panama	10	42	1335	3	panama
papaya	13	3	750	3	papaya
para	6	52	4217	3	__para
parura	8	3	1058	3	parura
pataca	10	3	1119	3	pataca
picara	10	3	1190	3	picara
placard	12	3	678	3	placard
planar	8	42	1271	3	planar_
planaria	10	4	735	3	planaria
qabalah	21	28	503	3	qabalah
qabalas	18	28	950	3	qabalas
rabat	7	28	3222	3	raba_t
rabato	8	34	1326	3	rabato
rabats	8	31	1622	3	rabats
radar	6	13	1672	3	radar_
radars	7	13	1467	3	radars
ramada	9	3	1018	3	ramada
rasbora	9	4	594	3	rasbora
rebar	7	54	2019	3	rebar_
rebars	8	40	1983	3	rebars
sabal	7	54	2248	3	saba_l
sabals	8	46	1886	3	sabals
saber	7	53	3024	3	saber_
sabers	8	52	2473	3	sabers
sabir	7	59	1700	3	sabir_
sabirs	8	54	1463	3	sabirs
sabras	8	51	1636	3	sabras
sabre	7	48	2150	3	sab_re
sacra	7	45	1699	3	sa_cra
safari	9	11	1022	3	safari
salary	9	5	1521	3	salary
samaras	9	3	1291	3	samaras
sambar	10	39	1416	3	sambar_
sambars	11	51	1384	3	sambars
samsara	9	3	691	3	samsara
sataras	7	3	1506	3	sataras
subarea	9	3	940	3	subarea
tabards	10	3	1038	3	tabards
tabaret	9	27	1731	3	tabaret
taber	7	38	2582	3	taber_
tabers	8	46	2157	3	tabers
tabla	7	33	1836	3	tab_la
tabor	7	55	1839	3	tabor_
tabors	8	45	1711	3	tabors
talar	5	62	2538	3	talar_
talaria	7	4	1252	3	talaria
talars	6	60	2168	3	talars
tamarao	9	7	759	3	tamarao
tamarau	9	10	706	3	tamarau
tamari	8	3	1341	3	tamari
tambala	11	3	802	3	tambala
tambura	11	32	646	3	tambura
tanbark	13	3	737	3	tanbark
tantara	7	24	1082	3	tantara
tantra	6	37	1335	3	tantra
tarama	8	4	1273	3	tarama
tatar	5	61	2206	3	tatar_
tatars	6	46	1979	3	tatars
tiara	5	3	1591	3	_tiara
tuatara	7	4	551	3	tuatara
uakari	10	4	686	3	uakari
umbra	9	4	851	3	umb_ra
unbar	7	19	1361	3	unbar_
unbars	8	21	1303	3	unbars
vagary	13	3	733	3	vagary
vara	7	55	3088	3	__vara
vaward	13	49	872	3	vaward
yantra	9	44	962	3	yantra
zamarra	18	4	379	3	zamarra
zanana	15	38	1036	3	zanana
zebra	16	3	788	3	zeb_ra

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.373	479064.3
2	DLD Change Limit	112716	378	5.330	21147.5
3	Display Results	378	378	0.110	3436.4
	(SQL Overall)	178691	378	5.813	30739.9