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

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

411 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
larval	9	4	850	(None)
arval	8	60	1701	1	_arval
larva	8	3	1248	1	larva_
larvae	9	3	884	1	larvae
larvas	9	3	1023	1	larvas
areal	5	59	2873	2	_areal
argal	6	50	2338	2	_argal
artal	5	55	2547	2	_artal
barbal	10	40	1666	2	barbal
carnal	8	39	1920	2	carnal
carpal	10	37	1625	2	carpal
carvel	11	48	1757	2	carvel
farfal	12	34	1018	2	farfal
hartal	9	4	1547	2	hartal
labial	8	47	1433	2	labial
laical	8	3	1232	2	laical
lariat	6	6	2904	2	lariat
lava	7	67	2542	2	la_va_
lavas	8	54	2222	2	la_vas
loral	5	59	2782	2	lor_al
loreal	6	38	1431	2	loreal
marvel	11	37	1200	2	marvel
narial	6	3	1795	2	narial
narwal	9	3	894	2	narwal
naval	8	53	1583	2	na_val
parral	8	55	1753	2	parral
serval	9	39	1341	2	serval
tarnal	6	37	1650	2	tarnal
tarsal	6	33	1527	2	tarsal
valval	12	39	886	2	valval
aal	3	90	5867	3	_a__al
aerial	6	46	2571	3	aerial
algal	6	65	1821	3	_algal
anal	4	80	3752	3	_a_nal
annal	5	65	2076	3	_annal
anvil	8	27	1260	3	_anvil
aortal	6	52	1751	3	aortal
appal	9	53	1522	3	_appal
arak	8	69	2957	3	_ar_ak
area	4	58	4339	3	_area_
areae	5	52	2974	3	_areae
areas	5	59	3577	3	_areas
argala	7	47	1266	3	_argala
argali	7	50	1374	3	_argali
argals	7	55	1770	3	_argals
argil	6	51	1688	3	_argil
argol	6	53	1726	3	_argol
arhat	8	3	2709	3	_arhat
aria	4	62	4542	3	_aria_
arias	5	54	3802	3	_arias
ariel	5	52	2897	3	_ariel
aril	4	58	4302	3	_ar_il
arras	5	56	2613	3	_arras
array	8	63	1714	3	_array
arrival	10	3	756	3	arrival
artel	5	61	2274	3	_artel
arvo	7	60	2343	3	_arv_o
arvos	8	60	1566	3	_arvos
aryl	7	59	2234	3	_ar_yl
atrial	6	54	1894	3	atrial
aural	5	44	2896	3	_aural
ava	6	101	3932	3	_a_va_
avail	8	3	1388	3	_a_vail
axal	11	65	2049	3	_a_xal
axial	12	45	1519	3	_axial
baal	6	70	3311	3	ba__al
banal	7	59	2599	3	ba_nal
barbel	10	43	1707	3	barbel
barca	9	13	1943	3	barca_
barcas	10	10	1660	3	barcas
barman	10	35	1970	3	barman
barrel	8	45	1787	3	barrel
basal	7	57	2228	3	ba_sal
bharal	11	3	889	3	bhar_al
boral	7	58	3170	3	bor_al
boreal	8	48	1721	3	boreal
brava	10	64	1479	3	brava_
bravas	11	49	1332	3	bravas
burial	8	41	1762	3	burial
bursal	8	44	1482	3	bursal
cabal	9	52	2215	3	ca_bal
caecal	10	37	1373	3	caecal
canal	7	54	2804	3	ca_nal
cantal	8	41	2203	3	cantal
canvas	11	38	1333	3	canvas
caracal	11	3	1251	3	caracal
carat	7	50	4879	3	car_at
caravan	12	3	922	3	caravan
caravel	12	3	820	3	caravel
carcel	10	50	1867	3	carcel
carful	11	6	1097	3	carful
carinal	9	43	1822	3	carinal
carl	6	51	4478	3	car__l
carman	10	39	2074	3	carman
carnival	13	4	561	3	carnival
carol	7	51	2861	3	car_ol
carpale	11	34	1435	3	carpale
carpals	11	34	1462	3	carpals
carpel	10	54	1847	3	carpel
carrel	8	47	1863	3	carrel
cartel	8	50	2253	3	cartel
carve	10	62	2775	3	carv_e
carved	12	43	2085	3	carved
carvels	12	49	1459	3	carvels
carven	11	47	1666	3	carven
carver	11	44	2014	3	carver
carves	11	51	2845	3	carves
casual	8	11	1286	3	casual
caudal	9	16	1148	3	caudal
causal	8	14	1320	3	causal
cavil	10	38	1649	3	ca_vil
cercal	10	3	1412	3	cercal
cereal	8	3	1583	3	cereal
clausal	9	3	627	3	clausal
coaeval	12	4	518	3	coaeval
coeval	11	3	889	3	coeval
coral	7	60	3345	3	cor_al
corral	8	36	1625	3	corral
craal	7	41	1775	3	_craal
cravat	11	3	1444	3	cravat
curial	8	40	1915	3	curial
curtal	8	39	1454	3	curtal
daedal	8	4	908	3	daedal
darbar	9	5	995	3	darbar
darnel	7	43	1218	3	darnel
datival	11	3	558	3	datival
dermal	9	36	1434	3	dermal
dorsal	7	46	1394	3	dorsal
dural	6	49	2389	3	dur_al
earful	9	5	896	3	earful
earl	4	58	3814	3	ear__l
earlap	8	3	718	3	earlap
earwax	16	6	473	3	earwax
ervil	8	3	1030	3	_ervil
facial	11	36	1563	3	facial
faecal	11	35	981	3	faecal
fallal	9	36	1269	3	fallal
farad	9	57	2067	3	far_ad
fardel	10	47	1259	3	fardel
farfals	13	26	850	3	farfals
farfel	12	43	1043	3	farfel
farl	7	63	3855	3	far__l
fatal	8	48	1937	3	fa_tal
faucal	11	33	996	3	faucal
faunal	9	47	1159	3	faunal
fava	10	68	2026	3	fa_va_
favas	11	56	1859	3	fa_vas
feral	8	54	2465	3	fer_al
ferial	9	46	2125	3	ferial
filarial	11	4	786	3	filarial
floral	9	43	1381	3	flor_al
formal	11	32	1520	3	formal
garda	7	3	1676	3	garda_
gardai	8	3	966	3	gardai
garvey	13	12	787	3	garvey
gavel	9	58	1518	3	ga_vel
gavial	10	3	1008	3	gavial
gayal	9	3	1271	3	ga_yal
gharial	11	3	734	3	gharial
glacial	10	3	814	3	glacial
goral	6	51	2575	3	gor_al
graal	6	43	1650	3	_graal
gravel	10	53	1382	3	gravel
gyral	9	44	1278	3	gyr_al
hadal	9	55	1812	3	ha_dal
haemal	11	38	1164	3	haemal
halal	8	56	2359	3	ha_lal
hallal	9	44	1556	3	hallal
halva	11	54	1443	3	halva_
halvah	15	49	983	3	halvah
halvas	12	47	1417	3	halvas
hamal	10	46	2310	3	ha_mal
hammal	13	45	1206	3	hammal
harl	7	57	4000	3	har__l
hartals	10	3	1302	3	hartals
herbal	11	25	1349	3	herbal
horal	8	63	2867	3	hor_al
irreal	6	5	782	3	irreal
jacal	14	3	1370	3	ja_cal
jackal	19	3	761	3	jackal
jarful	16	4	668	3	jarful
jarl	11	58	2813	3	jar__l
jarrah	16	3	668	3	jarrah
jarvey	19	13	540	3	jarvey
java	14	73	1664	3	ja_va_
javas	15	59	1542	3	ja_vas
jural	12	51	2048	3	jur_al
karat	9	68	3759	3	kar_at
karma	11	34	1500	3	karma_
karmas	12	30	1373	3	karmas
kava	11	58	1970	3	ka_va_
kavas	12	59	1995	3	ka_vas
kraal	9	45	1182	3	_kraal
label	7	50	1938	3	la_bel
labia	7	52	1900	3	labia_
labials	9	29	987	3	labials
labra	7	54	1546	3	labra_
lacrimal	12	4	444	3	lacrimal
lactam	10	3	1094	3	lactam
lacteal	9	6	681	3	lacteal
lacunal	9	13	655	3	lacunal
laevo	8	4	936	3	laev_o
lagan	6	65	2034	3	la_gan
lahar	8	31	1426	3	la_har
lall	4	55	3131	3	la__ll
lallan	6	34	1417	3	lallan
lama	6	66	3529	3	la_ma_
lamas	7	55	3279	3	la_mas
lamia	7	53	2432	3	lamia_
lamiae	8	48	1745	3	lamiae
lamias	8	50	2061	3	lamias
laminal	9	41	1363	3	laminal
lampad	11	45	1003	3	lampad
lampas	10	66	1595	3	lampas
lanai	5	3	1957	3	la_nai
landau	7	3	1061	3	landau
lanital	7	3	1091	3	lanital
laogai	7	3	598	3	laogai
lapel	7	37	1668	3	la_pel
lapful	11	5	648	3	lapful
lar	3	79	6753	3	lar___
larch	10	59	1979	3	lar_ch
lard	5	67	4200	3	lar__d
larded	8	43	1909	3	larded
larder	7	37	2097	3	larder
lardon	7	44	1506	3	lardon
lards	6	53	3186	3	lar_ds
lardy	9	61	1927	3	lar_dy
laree	5	60	3629	3	lar_ee
larees	6	53	2311	3	larees
lares	5	48	5263	3	lar_es
large	6	53	2546	3	lar_ge
largely	11	3	670	3	largely
larger	7	44	1751	3	larger
larges	7	48	2423	3	larges
largo	6	53	1978	3	lar_go
largos	7	48	1506	3	largos
lari	4	58	3915	3	lar__i
lariats	7	6	1505	3	lariats
larine	6	39	2704	3	larine
laris	5	47	3746	3	lar_is
lark	8	57	3386	3	lar__k
larked	11	45	1947	3	larked
larker	10	45	1924	3	larker
larks	9	52	2781	3	lar_ks
larky	12	52	1887	3	lar_ky
larrup	8	3	571	3	larrup
lars	4	69	5657	3	lar__s
larum	7	43	1797	3	lar_um
larums	8	36	1053	3	larums
laryngal	12	4	276	3	laryngal
larynx	16	3	285	3	larynx
lascar	8	6	857	3	lascar
lateral	7	3	1356	3	lateral
latria	6	23	1358	3	latria_
latrias	7	19	1321	3	latrias
lauan	5	52	1679	3	la_uan
laura	5	41	1620	3	laura_
laurae	6	40	1166	3	laurae
lauras	6	34	1433	3	lauras
laurel	6	4	903	3	laurel
lav	6	68	4734	3	la_v__
lavabo	11	3	527	3	la_vabo
lavage	10	3	826	3	la_vage
lavash	12	59	737	3	la_vash
lave	7	56	4214	3	la_v_e
laved	9	50	2859	3	la_ved
laver	8	50	3179	3	la_ver
laves	8	60	3915	3	la_ves
lavs	7	67	3415	3	la_v_s
lawful	12	3	549	3	lawful
lawman	11	28	905	3	lawman
layman	11	35	1130	3	layman
lazar	14	41	1364	3	la_zar
leal	4	60	4327	3	l__eal
legal	6	57	1594	3	l_egal
lekvar	13	3	304	3	lekvar
lethal	9	3	980	3	lethal
leva	7	70	2071	3	l_eva_
level	8	41	1655	3	l_evel
lienal	6	39	1278	3	lienal
lineal	6	56	1602	3	lineal
lira	4	69	2868	3	lir_a_
liras	5	60	2198	3	lir_as
local	7	48	2027	3	l_ocal
loran	5	59	2509	3	lor_an
lovat	8	3	2104	3	l_ovat
loyal	8	45	1348	3	l_oyal
lurdan	7	3	836	3	lurdan
luteal	6	44	1148	3	luteal
lyrical	12	3	649	3	lyrical
malarial	10	4	1061	3	malarial
mammal	9	51	1275	3	mammal
manual	8	3	1346	3	manual
mara	6	74	4456	3	mar_a_
maras	7	54	4328	3	mar_as
marcel	10	37	1485	3	marcel
margay	12	3	1059	3	margay
maria	7	50	3288	3	maria_
marital	9	23	1418	3	marital
marka	11	46	2079	3	marka_
markas	12	47	1700	3	markas
marl	6	63	4161	3	mar__l
marram	10	3	1388	3	marram
marsala	9	3	958	3	marsala
marshal	12	3	897	3	marshal
martial	9	24	1541	3	martial
marvels	12	38	1009	3	marvels
marvy	13	50	1403	3	marv_y
moral	7	55	3343	3	mor_al
mortal	8	46	1685	3	mortal
mural	7	52	2510	3	mur_al
narwals	10	3	698	3	narwals
narwhal	13	4	433	3	narwhal
nasal	5	62	1759	3	na_sal
nasial	6	4	1328	3	nasial
natal	5	39	2149	3	na_tal
navar	8	39	1273	3	na_var
navel	8	70	1657	3	na_vel
nival	8	49	1577	3	_nival
normal	8	32	1353	3	normal
ogival	10	3	587	3	ogival
oral	4	76	3812	3	_or_al
oval	7	71	1952	3	__oval
ovarial	10	3	761	3	ovarial
paleal	8	47	1667	3	paleal
palpal	10	41	1205	3	palpal
papal	9	58	2067	3	pa_pal
para	6	52	4217	3	par_a_
parae	7	63	3570	3	par_ae
paras	7	61	4304	3	par_as
parcel	10	39	1547	3	parcel
pardah	12	34	1282	3	pardah
pariah	11	43	2058	3	pariah
parian	8	32	2396	3	parian
parka	11	51	2088	3	parka_
parkas	12	50	1802	3	parkas
parlay	11	37	1399	3	parlay
parol	7	48	2627	3	par_ol
parrals	9	44	1457	3	parrals
parrel	8	45	1598	3	parrel
partan	8	38	2056	3	partan
partial	9	26	1626	3	partial
parve	10	98	2485	3	parv_e
parvis	11	61	1480	3	parvis
parvo	10	77	1918	3	parv_o
parvos	11	66	1475	3	parvos
pascal	10	8	1237	3	pascal
pausal	8	15	1196	3	pausal
pavan	10	65	1847	3	pa_van
plagal	9	4	857	3	pla_gal
plural	8	3	982	3	plur_al
portal	8	42	1846	3	portal
racial	8	34	1924	3	racial
radial	7	40	2039	3	radial
ramal	7	46	2224	3	ra_mal
rascal	8	5	1112	3	rascal
ratal	5	50	2511	3	ra_tal
ravel	8	46	2151	3	ra_vel
real	4	57	5029	3	__real
rial	4	59	3809	3	__rial
rival	8	52	1650	3	_rival
rural	5	58	2117	3	rur_al
sabal	7	54	2248	3	sa_bal
sacral	8	34	1441	3	sacral
salal	5	54	2570	3	sa_lal
sambal	10	52	1518	3	sambal
sandal	7	33	1728	3	sandal
saran	5	37	3030	3	sar_an
sardar	7	30	1317	3	sardar
sarsar	6	30	1184	3	sarsar
seral	5	63	3638	3	ser_al
serial	6	46	2585	3	serial
servals	10	34	1074	3	servals
sural	5	59	3126	3	sur_al
tamal	7	35	2261	3	ta_mal
tarmac	10	3	1033	3	tarmac
tarpan	8	28	1429	3	tarpan
tarsals	7	25	1260	3	tarsals
tartan	6	42	1751	3	tartan
tartar	6	32	1475	3	tartar
tarzan	15	29	1075	3	tarzan
tergal	7	29	1283	3	tergal
travail	10	3	654	3	travail
travel	9	41	1298	3	travel
trial	5	49	2635	3	_trial
unreal	6	44	1445	3	unreal
ureal	5	67	2268	3	_ureal
urial	5	48	2302	3	_urial
vagal	9	46	1363	3	va_gal
valvar	12	38	865	3	valvar
vandal	10	37	1383	3	vandal
vara	7	55	3088	3	var_a_
varas	8	60	2819	3	var_as
varia	8	58	2420	3	varia_
varias	9	50	1990	3	varias
varna	8	45	1617	3	varna_
varnas	9	42	1282	3	varnas
varve	11	57	1685	3	varv_e
varved	13	41	1060	3	varved
varves	12	44	1478	3	varves
vasal	8	55	1629	3	va_sal
vassal	9	7	924	3	vassal
verbal	11	25	1366	3	verbal
vernal	9	35	1421	3	vernal
versal	9	30	1375	3	versal
viral	8	64	1959	3	vir_al
vulval	12	41	766	3	vulval
wadmal	12	3	728	3	wadmal
warsaw	12	3	619	3	warsaw
zoarial	16	4	692	3	zoarial

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.140	1276364.3
2	DLD Change Limit	112716	411	6.876	16392.7
3	Display Results	411	411	0.140	2935.7
	(SQL Overall)	178691	411	7.156	24970.8