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

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

360 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
vase	7	56	2965	(None)
base	6	48	4702	1	base
case	6	58	4808	1	case
ease	4	50	4233	1	ease
lase	4	61	4851	1	lase
pase	6	53	4686	1	pase
rase	4	61	4998	1	rase
vale	7	49	3734	1	vale
valse	8	51	1752	1	valse
vane	7	55	3469	1	vane
vas	6	77	5577	1	vas_
vasa	7	65	2297	1	vasa
vases	8	46	2626	1	vases
vast	7	50	4512	1	vast
vise	7	56	3267	1	vise
aas	3	109	7539	2	aas_
abase	7	60	2348	2	abase
ace	5	96	5683	2	_ace
ae	2	125	9029	2	_a_e
age	4	71	5433	2	_age
ale	3	65	7234	2	_ale
ane	3	78	6695	2	_ane
ape	5	72	5118	2	_ape
apse	6	77	2538	2	apse
are	3	78	7457	2	_are
arse	4	65	3927	2	arse
as	2	110	8307	2	_as_
asea	4	63	2718	2	_asea
ash	6	79	4460	2	_ash
ask	7	71	3070	2	_ask
asp	5	72	3534	2	_asp
ass	3	78	4406	2	_ass
ate	3	70	5924	2	_ate
avast	8	55	1936	2	avast
ave	6	77	4870	2	_ave
aves	7	61	4260	2	aves
awe	6	77	4662	2	_awe
axe	10	82	3949	2	_axe
aye	6	71	5176	2	_aye
babe	8	68	3582	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
bas	5	86	8175	2	bas_
based	8	53	3158	2	based
baser	7	48	2892	2	baser
bases	7	56	4435	2	bases
bash	9	152	4016	2	bash
bask	10	51	3142	2	bask
bass	6	61	4678	2	bass
bast	6	63	6241	2	bast
baste	7	48	2998	2	baste
bate	6	65	5242	2	bate
bise	6	64	3710	2	bise
blase	7	55	2423	2	blase
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
came	8	76	4875	2	came
cane	6	66	5312	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
carse	7	49	3433	2	carse
casa	6	56	3086	2	casa
cased	8	60	3241	2	cased
cases	7	50	4838	2	cases
cash	9	66	3628	2	cash
cask	10	56	2643	2	cask
cast	6	71	5990	2	cast
caste	7	59	3236	2	caste
cate	6	62	5460	2	cate
cause	7	52	2535	2	cause
cave	9	59	4126	2	cave
cease	7	52	2765	2	cease
chase	10	51	2712	2	chase
dace	7	69	3492	2	dace
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dare	5	58	4886	2	dare
dash	8	70	3163	2	dash
date	5	64	4332	2	date
daze	14	73	2723	2	daze
dose	5	64	4243	2	dose
eased	6	54	3040	2	eased
easel	5	45	2111	2	easel
eases	5	60	4161	2	eases
east	4	66	5910	2	east
easy	7	62	2449	2	easy
eave	7	57	3358	2	eave
else	4	59	2308	2	else
erase	5	49	2549	2	erase
evade	9	3	818	2	evade
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
false	8	48	1812	2	false
fame	9	56	3939	2	fame
fane	7	53	4357	2	fane
fare	7	63	5446	2	fare
fas	6	82	6293	2	fas_
fash	10	72	3229	2	fash
fast	7	70	5231	2	fast
fate	7	54	4428	2	fate
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fease	8	48	2487	2	fease
fuse	7	64	2999	2	fuse
gae	4	64	5770	2	ga_e
gaes	5	63	4803	2	gaes
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
game	7	66	4432	2	game
gane	5	51	4530	2	gane
gape	7	51	3451	2	gape
gas	4	88	7025	2	gas_
gases	6	56	3399	2	gases
gash	8	68	3302	2	gash
gasp	7	62	2733	2	gasp
gast	5	60	5256	2	gast
gate	5	57	4657	2	gate
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
haes	7	76	5102	2	haes
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hanse	8	57	2279	2	hanse
hare	7	62	5573	2	hare
has	6	73	7265	2	has_
hash	10	69	3650	2	hash
hasp	9	66	2729	2	hasp
hast	7	62	5948	2	hast
haste	8	59	2786	2	haste
hate	7	84	5017	2	hate
have	10	61	3707	2	have
hawse	11	60	1512	2	hawse
haze	16	48	3339	2	haze
hose	7	65	4724	2	hose
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
kae	7	67	4454	2	ka_e
kaes	8	57	3406	2	kaes
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3397	2	kane
kas	7	70	5858	2	kas_
kvas	11	70	1594	2	kvas_
kvases	13	46	710	2	kvases
kvass	12	50	727	2	kvass
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5333	2	lane
lapse	7	49	1768	2	lapse
las	3	72	8147	2	las_
lased	6	51	3234	2	lased
laser	5	46	3332	2	laser
lases	5	49	4476	2	lases
lash	7	65	3965	2	lash
lass	4	74	4454	2	lass
last	4	62	6032	2	last
late	4	75	6048	2	late
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
lease	5	52	3026	2	lease
lose	4	51	4458	2	lose
lyase	8	55	1241	2	lyase
lyse	7	63	2059	2	lyse
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
made	7	54	4024	2	made
mae	5	76	5911	2	ma_e
maes	6	69	4840	2	maes
mage	7	57	3913	2	mage
make	10	55	3789	2	make
male	6	60	5230	2	male
mane	6	50	5203	2	mane
manse	7	55	2823	2	manse
mare	6	47	5933	2	mare
marse	7	62	3115	2	marse
mas	5	81	7582	2	mas_
masa	6	50	3472	2	masa
maser	7	50	2997	2	maser
mash	9	60	3940	2	mash
mask	10	52	2736	2	mask
mass	6	60	4494	2	mass
masse	7	51	2529	2	masse
mast	6	59	5996	2	mast
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
mise	6	60	4358	2	mise
muse	6	71	3603	2	muse
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nose	4	67	3936	2	nose
oases	5	53	3098	2	oases
oast	4	71	5632	2	oast
ose	3	81	4734	2	_ose
ovate	8	42	1439	2	ovate
owse	7	63	2162	2	owse
pace	8	63	4577	2	pace
page	7	60	3610	2	page
paise	7	50	2833	2	paise
pale	6	60	5501	2	pale
pane	6	49	5029	2	pane
pare	6	67	6084	2	pare
parse	7	52	3699	2	parse
pas	5	87	7574	2	pas_
paseo	7	70	2251	2	paseo
pases	7	53	4650	2	pases
pash	9	56	3813	2	pash
pass	6	52	3995	2	pass
passe	7	55	2569	2	passe
past	6	59	5901	2	past
paste	7	49	3295	2	paste
pate	6	53	5046	2	pate
pause	7	50	2183	2	pause
pave	9	61	3389	2	pave
pease	7	52	3111	2	pease
phase	10	46	1721	2	phase
pose	6	64	4173	2	pose
prase	7	61	2875	2	prase
race	6	67	4626	2	race
rage	5	57	4235	2	rage
raise	5	48	2805	2	raise
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
ras	3	75	7539	2	ras_
rased	6	50	3393	2	rased
raser	5	56	3341	2	raser
rases	5	54	4721	2	rases
rash	7	60	3993	2	rash
rasp	6	60	2916	2	rasp
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
rise	4	59	4523	2	rise
rose	4	61	4890	2	rose
ruse	4	59	3893	2	ruse
sabe	6	61	4057	2	sabe
sade	5	55	4447	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sash	7	72	3530	2	sash
sass	4	50	3562	2	sass
sate	4	55	5610	2	sate
save	7	57	4136	2	save
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
tas	3	84	7710	2	tas_
task	8	53	2665	2	task
tass	4	56	4057	2	tass
tasse	5	48	2184	2	tasse
taste	5	51	2723	2	taste
tate	4	47	4860	2	tate
tawse	8	56	1650	2	tawse
tease	5	54	2871	2	tease
ukase	9	42	849	2	ukase
urase	5	46	2468	2	urase
use	3	68	3516	2	_use
vac	8	65	3714	2	va_c
vacs	9	62	2620	2	vacs
vadose	10	3	796	2	vadose
vagi	8	67	1936	2	vagi
vague	9	65	1311	2	vague
vail	7	54	3255	2	vail
vain	7	52	3300	2	vain
vair	7	56	2414	2	vair
vales	8	54	3426	2	vales
valet	8	43	3787	2	valet
valise	9	29	1764	2	valise
valses	9	45	1461	2	valses
value	8	57	1909	2	value
valve	11	45	1593	2	valve
vamose	11	5	928	2	vamose
vamp	11	55	2154	2	vamp
van	6	62	4633	2	va_n
vaned	9	46	2242	2	vaned
vanes	8	51	3097	2	vanes
vang	8	49	2604	2	vang
vans	7	62	3673	2	vans
var	6	61	4833	2	va_r
vara	7	55	3088	2	vara
vars	7	57	4207	2	vars
varve	11	57	1685	2	varve
vary	10	52	2606	2	vary
vasal	8	55	1629	2	vasal
vaster	9	45	2102	2	vaster
vasts	8	64	2377	2	vasts
vasty	11	62	1592	2	vasty
vat	6	78	6345	2	va_t
vats	7	68	4174	2	vats
vatu	7	65	2433	2	vatu
vau	6	68	4087	2	va_u
vaus	7	59	2892	2	vaus
vav	9	58	2943	2	va_v
vavs	10	57	2043	2	vavs
vaw	9	59	3746	2	va_w
vaws	10	55	2732	2	vaws
vee	6	57	5018	2	v_ee
vees	7	54	3943	2	vees
verse	8	47	2358	2	verse
vest	7	57	4360	2	vest
vibe	9	51	2450	2	vibe
vice	9	57	3285	2	vice
vide	8	54	3275	2	vide
vie	6	54	4763	2	v_ie
vies	7	52	3862	2	vies
vile	7	61	3980	2	vile
vine	7	56	4368	2	vine
vis	6	67	4761	2	vis_
visa	7	63	2387	2	visa
vised	9	55	1876	2	vised
vises	8	44	2777	2	vises
vive	10	54	2662	2	vive
voe	6	77	3905	2	v_oe
voes	7	54	3282	2	voes
vole	7	52	3698	2	vole
vote	7	47	2862	2	vote
wade	8	52	3706	2	wade
wae	6	75	5695	2	wa_e
waes	7	60	4860	2	waes
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
was	6	87	6756	2	was_
wash	10	60	3381	2	wash
wasp	9	56	2685	2	wasp
wast	7	56	5585	2	wast
waste	8	61	2505	2	waste
wave	10	52	3473	2	wave
wise	7	57	3734	2	wise
yare	7	56	3694	2	yare
zas	12	69	4683	2	zas_

Search took 2 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	29872	0.063	2836365.1
2	DLD Change Limit	29872	360	0.860	34734.9
3	Display Results	360	360	0.076	4736.8
	(SQL Overall)	178691	360	0.999	178869.9