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

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

361 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
valval	12	39	886	(None)
valvar	12	38	865	1	valvar
vulval	12	41	766	1	vulval
algal	6	65	1822	2	_algal
arval	8	60	1701	2	_arval
fallal	9	36	1269	2	fallal
halal	8	56	2359	2	hal_al
hallal	9	44	1556	2	hallal
halva	11	54	1443	2	halva_
halvah	15	49	983	2	halvah
halvas	12	47	1417	2	halvas
larval	9	4	850	2	larval
naval	8	53	1583	2	na_val
paleal	8	47	1667	2	paleal
palpal	10	41	1205	2	palpal
salal	5	54	2570	2	sal_al
vagal	9	46	1363	2	va_gal
valvate	13	37	1081	2	valvate
valve	11	45	1593	2	valv_e
valved	13	67	1104	2	valved
valves	12	41	1378	2	valves
valvula	13	4	325	2	valvula
valvule	13	4	366	2	valvule
vandal	10	37	1383	2	vandal
vasal	8	55	1629	2	va_sal
vassal	9	7	924	2	vassal
volva	11	39	900	2	volva_
volvas	12	44	799	2	volvas
vulva	11	44	880	2	vulva_
vulvae	12	43	803	2	vulvae
vulvar	12	42	796	2	vulvar
vulvas	12	38	884	2	vulvas
aal	3	90	5867	3	_a__al
ala	3	124	6360	3	_al_a_
alae	4	56	4375	3	_al_ae
alan	4	68	4408	3	_al_an
alar	4	63	4007	3	_al_ar
alas	4	63	5812	3	_al_as
alba	6	83	2833	3	_alba_
albas	7	59	2539	3	_albas
aldol	6	12	1233	3	_aldol
alfa	7	76	2427	3	_alfa_
alfas	8	72	1904	3	_alfas
alga	5	79	2760	3	_alga_
algae	6	53	1962	3	_algae
algas	6	56	2493	3	_algas
alias	5	58	3460	3	_alias
alkali	10	12	756	3	_alkali
alkyl	12	51	804	3	_alkyl
all	3	61	4823	3	_al__l
allay	8	56	2039	3	_allay
allyl	8	53	1054	3	_allyl
alma	6	63	3302	3	_alma_
almah	10	69	1725	3	_almah
almas	7	66	2977	3	_almas
altar	5	55	2064	3	_altar
alula	5	3	1709	3	_alula
alway	11	61	1392	3	_alway
anal	4	80	3752	3	_a_nal
annal	5	65	2076	3	_annal
anvil	8	27	1260	3	_anvil
appal	9	53	1522	3	_appal
areal	5	59	2873	3	_areal
argal	6	50	2339	3	_argal
artal	5	55	2547	3	_artal
aural	5	44	2896	3	_aural
ava	6	101	3932	3	_a_va_
avail	8	3	1388	3	_a_vail
avowal	12	4	632	3	avowal
axal	11	65	2049	3	_a_xal
axial	12	45	1519	3	_axial
baal	6	70	3311	3	ba__al
balas	7	69	3721	3	bal_as
ball	6	60	4332	3	bal__l
ballad	9	43	1532	3	ballad
balneal	9	3	657	3	balneal
balsa	7	79	2041	3	balsa_
balsam	10	56	1223	3	balsam
balsas	8	64	1752	3	balsas
banal	7	59	2599	3	ba_nal
barbal	10	40	1666	3	barbal
basal	7	57	2228	3	ba_sal
cabal	9	52	2215	3	ca_bal
caecal	10	37	1373	3	caecal
calcar	10	3	1275	3	calcar
call	6	68	3867	3	cal__l
calla	7	48	2707	3	calla_
callan	8	36	1960	3	callan
callas	8	45	2675	3	callas
calpac	12	32	1106	3	calpac
calvary	15	3	718	3	calvary
calve	10	59	1992	3	calv_e
calved	12	52	1545	3	calved
calves	11	51	1928	3	calves
canal	7	54	2804	3	ca_nal
cantal	8	41	2203	3	cantal
canvas	11	38	1333	3	canvas
carnal	8	39	1921	3	carnal
carpal	10	37	1625	3	carpal
carvel	11	48	1757	3	carvel
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
coaeval	12	4	518	3	coaeval
coeval	11	3	889	3	coeval
daedal	8	4	908	3	daedal
datival	11	3	558	3	datival
facial	11	36	1563	3	facial
faecal	11	35	981	3	faecal
falbala	12	3	587	3	falbala
fall	7	55	3531	3	fal__l
fallals	10	33	1019	3	fallals
farfal	12	34	1018	3	farfal
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
filial	9	30	1325	3	filial
gala	5	56	3516	3	gal_a_
galah	9	59	1764	3	gal_ah
galas	6	57	3164	3	gal_as
galax	13	53	1446	3	gal_ax
galea	6	47	2294	3	galea_
galeae	7	47	1745	3	galeae
galeas	7	46	1851	3	galeas
gall	5	63	3599	3	gal__l
galyac	12	3	597	3	galyac
galyak	14	4	533	3	galyak
gavel	9	58	1518	3	ga_vel
gavial	10	3	1008	3	gavial
gayal	9	3	1271	3	ga_yal
glial	6	67	1543	3	_glial
hadal	9	55	1812	3	ha_dal
haemal	11	38	1164	3	haemal
halala	9	47	1509	3	hal_ala
halals	9	50	1831	3	hal_als
halavah	16	44	702	3	halavah
hall	7	57	4116	3	hal__l
hallah	12	41	1540	3	hallah
hallel	9	35	1409	3	hallel
halma	10	82	1925	3	halma_
halmas	11	70	1789	3	halmas
halvahs	16	41	753	3	halvahs
halve	11	48	1892	3	halv_e
halved	13	48	1390	3	halved
halves	12	47	1709	3	halves
hamal	10	46	2311	3	ha_mal
hammal	13	45	1206	3	hammal
hartal	9	4	1547	3	hartal
ileal	5	61	1808	3	_ileal
ilial	5	53	1784	3	_ilial
jacal	14	3	1370	3	ja_cal
jackal	19	3	761	3	jackal
jalap	14	36	1247	3	jal_ap
java	14	73	1664	3	ja_va_
javas	15	59	1542	3	ja_vas
kalam	11	3	1511	3	kal_am
kalian	10	3	1216	3	kalian
kalpa	11	45	1219	3	kalpa_
kalpac	14	42	822	3	kalpac
kalpak	11	43	724	3	kalpak
kalpas	12	41	1294	3	kalpas
kava	11	58	1970	3	ka_va_
kavas	12	59	1995	3	ka_vas
labial	8	47	1434	3	labial
laical	8	3	1232	3	laical
lall	4	55	3131	3	lal__l
lallan	6	34	1417	3	lallan
larva	8	3	1248	3	larva_
larvae	9	3	884	3	larvae
larvas	9	3	1023	3	larvas
lava	7	67	2542	3	la_va_
lavas	8	54	2222	3	la_vas
leal	4	60	4327	3	__leal
malar	7	64	2444	3	mal_ar
mall	6	46	3937	3	mal__l
maltol	8	3	1084	3	maltol
mammal	9	51	1275	3	mammal
manual	8	3	1346	3	manual
marvel	11	37	1200	3	marvel
molal	7	51	2034	3	mol_al
nala	4	69	3039	3	nal_a_
nalas	5	55	2836	3	nal_as
narial	6	3	1795	3	narial
narwal	9	3	894	3	narwal
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
ogival	10	3	587	3	ogival
oval	7	71	1952	3	__oval
ovarial	10	3	761	3	ovarial
palatal	9	3	1015	3	palatal
palea	7	50	2866	3	palea_
paleae	8	48	2029	3	paleae
pall	6	50	3934	3	pal__l
pallial	9	29	1125	3	pallial
palmar	10	41	1346	3	palmar
paludal	10	3	568	3	paludal
papal	9	58	2067	3	pa_pal
parral	8	55	1753	3	parral
pascal	10	8	1237	3	pascal
pausal	8	15	1196	3	pausal
pavan	10	65	1847	3	pa_van
plagal	9	4	857	3	plagal
pulpal	10	40	845	3	pulpal
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
rival	8	52	1650	3	_rival
sabal	7	54	2248	3	sa_bal
sacral	8	34	1441	3	sacral
salaam	8	7	1101	3	salaam
salad	6	53	2183	3	sal_ad
salals	6	51	2008	3	sal_als
saliva	9	31	1074	3	saliva_
salivas	10	30	960	3	salivas
sall	4	45	4468	3	sal__l
salol	5	52	2214	3	sal_ol
salpa	7	50	1835	3	salpa_
salpae	8	46	1427	3	salpae
salpas	8	51	1692	3	salpas
salsa	5	67	1892	3	salsa_
salsas	6	53	1613	3	salsas
salvable	13	3	840	3	salvable
salvably	16	4	544	3	salvably
salvage	11	3	819	3	salvage
salve	8	50	2213	3	salv_e
salved	10	39	1642	3	salved
salver	9	46	1775	3	salver
salves	9	42	2176	3	salves
salvia	9	33	1075	3	salvia
salvias	10	27	993	3	salvias
salvo	8	44	1564	3	salv_o
salvor	9	47	1109	3	salvor
salvos	9	46	1338	3	salvos
sambal	10	52	1518	3	sambal
sandal	7	33	1728	3	sandal
selva	8	30	1427	3	selva_
selvas	9	38	1291	3	selvas
serval	9	39	1341	3	serval
silva	8	27	1402	3	silva_
silvae	9	28	1109	3	silvae
silvan	9	28	1015	3	silvan
silvas	9	29	1218	3	silvas
sulcal	8	3	1127	3	sulcal
sylva	11	26	844	3	sylva_
sylvae	12	23	686	3	sylvae
sylvan	12	25	736	3	sylvan
sylvas	12	28	817	3	sylvas
tala	4	59	3805	3	tal_a_
talar	5	62	2538	3	tal_ar
talas	5	59	3589	3	tal_as
tall	4	72	4021	3	tal__l
tallol	6	36	1222	3	tallol
tamal	7	35	2262	3	ta_mal
tarnal	6	37	1650	3	tarnal
tarsal	6	33	1527	3	tarsal
telial	6	58	1536	3	telial
ulva	7	54	1269	3	_ulva_
ulvas	8	45	1150	3	_ulvas
vacua	10	5	1046	3	vacua_
vaginal	11	28	840	3	vaginal
vail	7	54	3255	3	va__il
vakeel	13	3	519	3	vakeel
vakil	12	5	979	3	va_kil
vale	7	49	3734	3	val__e
vales	8	54	3426	3	val_es
valet	8	43	3787	3	val_et
valets	9	37	1562	3	valets
valgus	10	4	710	3	valgus
valiant	10	3	1462	3	valiant
valid	9	46	1839	3	val_id
validly	14	3	557	3	validly
valine	9	46	2309	3	valine
valise	9	29	1764	3	valise
valkyr	16	3	240	3	valkyr
vallate	10	30	1656	3	vallate
valley	12	43	1160	3	valley
valor	8	36	1489	3	val_or
valors	9	34	1377	3	valors
valour	9	30	1037	3	valour
valse	8	51	1752	3	val_se
valses	9	45	1461	3	valses
valuable	13	3	686	3	valuable
valuably	16	4	471	3	valuably
valuate	10	25	1273	3	valuate
value	8	57	1909	3	val_ue
valued	10	40	1115	3	valued
valuer	9	39	1144	3	valuer
values	9	43	1494	3	values
valuta	9	3	874	3	valuta
valutas	10	3	653	3	valutas
valvelet	14	4	534	3	valvelet
valving	14	36	855	3	valving
valvulae	14	4	272	3	valvulae
valvular	14	4	346	3	valvular
valvules	14	4	347	3	valvules
vanda	9	45	1592	3	vanda_
vandals	11	32	1166	3	vandals
vandas	10	39	1599	3	vandas
vanload	11	4	470	3	vanload
vanman	11	3	979	3	vanman
vara	7	55	3088	3	va_ra_
varas	8	60	2819	3	va_ras
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
vasa	7	65	2297	3	va_sa_
vassals	10	5	795	3	vassals
vatful	12	10	708	3	vatful
vatical	12	3	998	3	vatical
vav	9	58	2943	3	va_v__
vavs	10	57	2043	3	va_v_s
veal	7	69	3681	3	v__eal
veinal	9	38	1296	3	veinal
vela	7	57	2554	3	vel_a_
velar	8	58	1763	3	vel_ar
velvet	12	36	1375	3	velvet
venal	8	55	2321	3	v_enal
venial	9	42	1828	3	venial
verbal	11	25	1366	3	verbal
vernal	9	35	1421	3	vernal
versal	9	30	1375	3	versal
vestal	9	46	1557	3	vestal
vial	7	67	3109	3	v__ial
vill	7	52	3507	3	vil__l
villa	8	53	2123	3	villa_
villae	9	56	1538	3	villae
villas	9	61	1726	3	villas
vinal	8	57	2581	3	v_inal
vineal	9	48	1474	3	vineal
viral	8	64	1959	3	v_iral
visual	9	3	880	3	visual
vital	8	48	1967	3	v_ital
viva	10	61	1909	3	v_iva_
vivas	11	48	1502	3	v_ivas
vocal	10	47	1564	3	v_ocal
volar	8	69	1741	3	vol_ar
volta	8	52	1562	3	volta_
volvate	13	31	799	3	volvate
volvox	19	3	336	3	volvox
volvuli	13	5	208	3	volvuli
vulgar	10	42	682	3	vulgar
vulvate	13	38	832	3	vulvate
wadmal	12	3	728	3	wadmal
wall	7	62	3610	3	wal__l
walla	8	53	2103	3	walla_
wallah	12	40	1199	3	wallah
wallas	9	57	1939	3	wallas

Search took 7 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.406	440125.6
2	DLD Change Limit	112716	361	5.766	19548.4
3	Display Results	361	361	0.106	3405.7
	(SQL Overall)	178691	361	6.278	28463.0