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

Here are the results of your fuzzy-string dictionary search for “vavs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

300 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
vavs	10	57	2043	(None)
lavs	7	67	3415	1	lavs
tavs	7	56	3097	1	tavs
vacs	9	62	2620	1	vacs
vans	7	62	3672	1	vans
vars	7	57	4207	1	vars
vas	6	77	5577	1	va_s
vats	7	68	4174	1	vats
vaus	7	59	2892	1	vaus
vav	9	58	2943	1	vav_
vaws	10	55	2732	1	vaws
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
ads	4	97	5573	2	_ads
ags	4	75	5166	2	_ags
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
als	3	66	6302	2	_als
ars	3	76	7093	2	_ars
as	2	110	8307	2	_a_s
ass	3	78	4406	2	_ass
ava	6	101	3932	2	_ava
ave	6	77	4870	2	_ave
aves	7	61	4260	2	aves
avo	6	89	3623	2	_avo
avos	7	72	2701	2	avos
ays	6	70	5029	2	_ays
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
bags	7	66	4550	2	bags
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
bans	6	65	5513	2	bans
baps	8	60	4084	2	baps
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bays	9	71	4391	2	bays
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
cams	8	70	4728	2	cams
cans	6	50	5084	2	cans
caps	8	71	4789	2	caps
cars	6	73	6476	2	cars
cats	6	63	5634	2	cats
cave	9	59	4126	2	cave
caves	10	56	3970	2	caves
cavy	12	59	2000	2	cavy
caws	9	60	3610	2	caws
cays	9	54	3767	2	cays
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dags	6	66	4259	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dams	7	74	4437	2	dams
dans	5	67	4814	2	dans
daps	7	72	3916	2	daps
davy	11	60	1552	2	davy
daws	8	66	3824	2	daws
days	8	76	3713	2	days
devs	8	64	2403	2	devs
ears	4	63	5659	2	ears
eats	4	70	5487	2	eats
eave	7	57	3358	2	eave
eaves	8	52	3199	2	eaves
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fans	7	62	4736	2	fans
fas	6	82	6293	2	fa_s
fats	7	62	5250	2	fats
fava	10	68	2026	2	fava
favas	11	56	1859	2	favas
fave	10	55	3296	2	fave
faves	11	53	3142	2	faves
favus	11	43	1173	2	favus
fays	10	85	3536	2	fays
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	ga_s
gats	5	67	5344	2	gats
gave	8	46	3405	2	gave
gays	8	73	3802	2	gays
guvs	8	58	1681	2	guvs
haes	7	76	5102	2	haes
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
hams	9	64	4613	2	hams
haps	9	64	4346	2	haps
has	6	73	7265	2	ha_s
hats	7	68	5825	2	hats
have	10	61	3707	2	have
haves	11	60	3487	2	haves
haws	10	64	3944	2	haws
hays	10	61	3807	2	hays
jabs	13	58	3009	2	jabs
jags	12	61	3279	2	jags
jams	13	52	3107	2	jams
jars	11	73	3835	2	jars
java	14	73	1664	2	java
javas	15	59	1542	2	javas
jaws	14	50	2729	2	jaws
jays	14	63	2834	2	jays
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kava	11	58	1970	2	kava
kavas	12	59	1995	2	kavas
kays	11	60	3219	2	kays
kvas	11	70	1594	2	kva_s
kvass	12	50	727	2	kvass
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lav	6	68	4734	2	lav_
lava	7	67	2542	2	lava
lavas	8	54	2222	2	lavas
lave	7	56	4214	2	lave
laves	8	60	3915	2	laves
laws	7	64	4168	2	laws
lays	7	60	4325	2	lays
luvs	7	58	1850	2	luvs
macs	8	67	4250	2	macs
mads	7	68	4536	2	mads
maes	6	69	4839	2	maes
mags	7	54	4452	2	mags
mans	6	63	5453	2	mans
maps	8	61	4104	2	maps
mars	6	62	6186	2	mars
mas	5	81	7581	2	ma_s
mass	6	60	4493	2	mass
mats	6	54	6028	2	mats
mavis	10	56	2272	2	mavis
maws	9	64	3713	2	maws
mays	9	69	4002	2	mays
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nans	4	61	3939	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nave	7	57	3231	2	nave
naves	8	70	3038	2	naves
navy	10	75	1863	2	navy
nays	7	59	3159	2	nays
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
oaves	8	49	2561	2	oaves
ovals	8	54	1339	2	ovals
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pans	6	58	5572	2	pans
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	pa_s
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
pave	9	61	3389	2	pave
paves	10	48	3392	2	paves
pavis	10	64	2273	2	pavis
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
qats	13	53	3134	2	qats
rads	5	60	4660	2	rads
rags	5	54	4837	2	rags
rais	4	52	5262	2	rais
rams	6	59	5077	2	rams
raps	6	62	4773	2	raps
ras	3	75	7539	2	ra_s
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raves	8	54	4197	2	raves
raws	7	52	3821	2	raws
rays	7	76	4235	2	rays
revs	7	50	2705	2	revs
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
sals	4	68	5167	2	sals
sans	4	51	5335	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
save	7	57	4136	2	save
saves	8	58	3863	2	saves
saws	7	58	3948	2	saws
says	7	59	4210	2	says
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
tams	6	72	4793	2	tams
tans	4	61	5481	2	tans
taos	4	55	4100	2	taos
taps	6	60	5067	2	taps
tars	4	67	6395	2	tars
tas	3	84	7710	2	ta_s
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taus	4	63	4273	2	taus
tav	6	60	4321	2	tav_
taws	7	56	4159	2	taws
vac	8	65	3714	2	va_c
vagi	8	67	1936	2	vagi
vagus	9	67	1381	2	vagus
vail	7	54	3255	2	vail
vails	8	58	2593	2	vails
vain	7	52	3300	2	vain
vair	7	56	2414	2	vair
vairs	8	50	1913	2	vairs
vale	7	49	3734	2	vale
vales	8	54	3426	2	vales
valse	8	51	1752	2	valse
valve	11	45	1593	2	valve
valves	12	41	1378	2	valves
vamp	11	55	2154	2	vamp
vamps	12	54	1548	2	vamps
van	6	62	4632	2	va_n
vane	7	55	3468	2	vane
vanes	8	51	3097	2	vanes
vang	8	49	2603	2	vang
vangs	9	63	1958	2	vangs
var	6	61	4833	2	va_r
vara	7	55	3088	2	vara
varas	8	60	2819	2	varas
varus	8	59	2118	2	varus
varve	11	57	1685	2	varve
varves	12	44	1478	2	varves
vary	10	52	2606	2	vary
vasa	7	65	2297	2	vasa
vase	7	56	2965	2	vase
vases	8	46	2626	2	vases
vast	7	50	4512	2	vast
vasts	8	64	2377	2	vasts
vat	6	78	6345	2	va_t
vatu	7	65	2433	2	vatu
vatus	8	61	1464	2	vatus
vau	6	68	4087	2	va_u
vaw	9	59	3746	2	va_w
veals	8	49	2619	2	veals
vees	7	54	3943	2	vees
vets	7	68	3509	2	vets
vials	8	58	2238	2	vials
vids	8	56	2753	2	vids
vies	7	52	3862	2	vies
vigs	8	54	2727	2	vigs
vims	9	54	2331	2	vims
vis	6	67	4761	2	v_is
viva	10	61	1909	2	viva
vivas	11	48	1502	2	vivas
vive	10	54	2662	2	vive
voes	7	54	3282	2	voes
vows	10	66	2694	2	vows
vugs	8	70	2287	2	vugs
wabs	9	73	3723	2	wabs
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wags	8	61	4055	2	wags
wans	7	64	5226	2	wans
waps	9	66	4208	2	waps
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wats	7	75	5588	2	wats
wave	10	52	3473	2	wave
waves	11	56	3392	2	waves
wavy	13	66	2047	2	wavy
waws	10	68	3490	2	waws
ways	10	77	3795	2	ways
yags	8	66	3229	2	yags
yaks	11	60	2520	2	yaks
yams	9	53	3073	2	yams
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yays	10	57	2891	2	yays
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	za_s

Search took 1 second 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	29872	0.080	2233637.5
2	DLD Change Limit	29872	300	0.826	36164.6
3	Display Results	300	300	0.063	4761.9
	(SQL Overall)	178691	300	0.969	184407.6