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

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

366 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
vases	8	46	2626	(None)
bases	7	56	4435	1	bases
cases	7	50	4838	1	cases
eases	5	60	4161	1	eases
gases	6	56	3399	1	gases
kvases	13	46	710	1	kvases
lases	5	49	4476	1	lases
oases	5	53	3098	1	oases
pases	7	53	4650	1	pases
rases	5	54	4721	1	rases
vales	8	54	3426	1	vales
valses	9	45	1461	1	valses
vanes	8	51	3097	1	vanes
vase	7	56	2965	1	vase_
vasts	8	64	2377	1	vasts
vises	8	44	2777	1	vises
abases	8	57	2077	2	abases
aces	6	76	4509	2	_aces
ages	5	58	4459	2	_ages
ales	4	70	6710	2	_ales
anes	4	52	5593	2	_anes
apes	6	60	4743	2	_apes
apses	7	68	2391	2	apses
ares	4	58	7102	2	_ares
arses	5	57	3387	2	arses
asea	4	63	2718	2	_asea
ashes	8	62	3061	2	_ashes
asks	8	57	2121	2	_asks
asps	6	56	2209	2	_asps
ass	3	78	4406	2	_as_s
asses	5	56	2928	2	asses
ates	4	50	4792	2	_ates
aves	7	61	4260	2	_aves
avgases	11	10	631	2	avgases
awes	7	60	3755	2	_awes
axes	11	73	3785	2	_axes
ayes	7	65	4351	2	_ayes
baases	8	52	1801	2	baases
babes	9	58	3411	2	babes
bakes	11	70	3537	2	bakes
bales	7	62	5008	2	bales
banes	7	49	4558	2	banes
bares	7	54	5713	2	bares
base	6	48	4702	2	base_
based	8	53	3158	2	based
baser	7	48	2892	2	baser
basest	8	47	2049	2	basest
bashes	11	56	3139	2	bashes
basis	7	54	2986	2	basis
basks	11	56	2176	2	basks
bass	6	61	4678	2	bas_s
basses	8	54	2830	2	basses
bastes	8	53	3038	2	bastes
basts	7	59	3693	2	basts
bates	7	58	4634	2	bates
beses	7	58	3072	2	beses
biases	8	46	1843	2	biases
bises	7	54	3562	2	bises
buses	7	59	3601	2	buses
cades	8	54	4073	2	cades
cafes	10	64	2692	2	cafes
cages	8	59	3601	2	cages
cakes	11	60	3767	2	cakes
cames	9	70	4731	2	cames
canes	7	53	5037	2	canes
capes	9	54	4192	2	capes
cares	7	73	6918	2	cares
carses	8	52	3365	2	carses
casas	7	53	2784	2	casas
case	6	58	4808	2	case_
cased	8	60	3241	2	cased
cashes	11	47	2988	2	cashes
casks	11	57	2006	2	casks
castes	8	56	3186	2	castes
casts	7	72	3779	2	casts
casus	7	64	1925	2	casus
cates	7	59	5187	2	cates
causes	8	80	2647	2	causes
caves	10	56	3970	2	caves
ceases	8	44	2707	2	ceases
chases	11	51	2823	2	chases
coses	7	69	4949	2	coses
crases	8	55	3231	2	crases
daces	8	50	3068	2	daces
daises	7	43	1898	2	daises
dales	6	64	3974	2	dales
dames	8	54	3585	2	dames
dares	6	61	4670	2	dares
dashes	10	61	2498	2	dashes
dates	6	56	3915	2	dates
dazes	15	50	2414	2	dazes
doses	6	59	3850	2	doses
ease	4	50	4233	2	ease_
eased	6	54	3040	2	eased
easel	5	45	2111	2	easel
easels	6	59	1455	2	easels
easies	6	41	2663	2	easies
easts	5	75	3032	2	easts
eaves	8	52	3199	2	eaves
erases	6	44	2540	2	erases
erses	5	58	2680	2	erses
eses	4	53	3610	2	_eses
esses	5	64	2297	2	esses
evades	10	3	902	2	evades
eyases	9	45	1368	2	eyases
faces	10	64	3943	2	faces
fades	9	49	3286	2	fades
fakes	12	60	3248	2	fakes
fames	10	57	3592	2	fames
fanes	8	46	3989	2	fanes
fares	8	58	5287	2	fares
fasces	11	49	1454	2	fasces
fashes	12	45	2402	2	fashes
fasts	8	64	2968	2	fasts
fates	8	51	3923	2	fates
faves	11	53	3142	2	faves
faxes	15	57	2665	2	faxes
fazes	17	55	2721	2	fazes
feases	9	54	2292	2	feases
fuses	8	56	2842	2	fuses
gaes	5	63	4803	2	ga_es
gages	7	45	2997	2	gages
gales	6	54	4248	2	gales
games	8	62	3855	2	games
gapes	8	60	3082	2	gapes
gashes	10	57	2515	2	gashes
gasps	8	54	1548	2	gasps
gasses	7	57	2478	2	gasses
gasts	6	66	2863	2	gasts
gates	6	59	3950	2	gates
gazes	15	54	2591	2	gazes
hades	9	60	3511	2	hades
haes	7	76	5102	2	ha_es
hajes	15	54	2094	2	hajes
hakes	12	60	3430	2	hakes
hales	8	54	4984	2	hales
hames	10	61	3870	2	hames
hanses	9	50	2263	2	hanses
hares	8	62	5554	2	hares
hashes	12	50	2480	2	hashes
hasps	10	51	1464	2	hasps
hastes	9	57	2707	2	hastes
hates	8	67	4257	2	hates
haves	11	60	3487	2	haves
hawses	12	51	1399	2	hawses
hazes	17	49	2832	2	hazes
hoses	8	54	4317	2	hoses
jades	13	52	2211	2	jades
jakes	16	50	2364	2	jakes
janes	12	49	2812	2	janes
japes	14	63	2282	2	japes
kaes	8	57	3406	2	ka_es
kales	9	57	3098	2	kales
kames	11	50	2469	2	kames
kanes	9	55	2937	2	kanes
kvass	12	50	727	2	kvas_s
kvasses	14	36	550	2	kvasses
laces	7	61	4176	2	laces
lades	6	51	4127	2	lades
lakes	9	57	3765	2	lakes
lames	7	54	4554	2	lames
lanes	5	49	4679	2	lanes
lapses	8	52	1769	2	lapses
lares	5	48	5263	2	lares
lase	4	61	4851	2	lase_
lased	6	51	3234	2	lased
laser	5	46	3332	2	laser
lasers	6	49	2570	2	lasers
lashes	9	48	3100	2	lashes
lass	4	74	4454	2	las_s
lasses	6	48	2759	2	lasses
lasts	5	77	3126	2	lasts
laves	8	60	3915	2	laves
laxes	12	54	3009	2	laxes
lazes	14	51	2957	2	lazes
leases	6	54	2811	2	leases
leses	5	49	3081	2	leses
loses	5	67	4201	2	loses
lyases	9	52	1187	2	lyases
lyses	8	45	1825	2	lyses
mabes	9	63	3153	2	mabes
maces	9	71	3996	2	maces
maes	6	69	4839	2	ma_es
mages	8	50	3602	2	mages
makes	11	53	3685	2	makes
males	7	50	4979	2	males
manes	7	66	4895	2	manes
manses	8	42	2551	2	manses
mares	7	64	5763	2	mares
marses	8	48	2711	2	marses
masas	7	56	3041	2	masas
maser	7	50	2997	2	maser
masers	8	46	2345	2	masers
mashes	11	50	3000	2	mashes
masks	11	53	2053	2	masks
mass	6	60	4493	2	mas_s
masse	7	51	2529	2	masse
masses	8	50	2871	2	masses
masts	7	70	3576	2	masts
mates	7	52	5136	2	mates
maxes	14	56	2953	2	maxes
mazes	16	56	3217	2	mazes
mises	7	47	4056	2	mises
muses	7	51	3430	2	muses
myases	11	37	1155	2	myases
nabes	7	54	2709	2	nabes
names	7	48	3336	2	names
napes	7	48	2846	2	napes
nares	5	55	4415	2	nares
nates	5	52	3833	2	nates
naves	8	70	3038	2	naves
noses	5	54	3564	2	noses
oasis	5	64	2255	2	oasis
oasts	5	65	2918	2	oasts
oaves	8	49	2561	2	oaves
oses	4	66	4151	2	_oses
paces	9	67	4111	2	paces
pages	8	52	3507	2	pages
pales	7	57	5380	2	pales
panes	7	61	4869	2	panes
pares	7	71	6448	2	pares
parses	8	55	3470	2	parses
pase	6	53	4686	2	pase_
paseo	7	70	2251	2	paseo
paseos	8	80	1581	2	paseos
pashes	11	58	2839	2	pashes
pass	6	52	3995	2	pas_s
passe	7	55	2569	2	passe
passes	8	60	3047	2	passes
pastes	8	52	3391	2	pastes
pasts	7	59	3650	2	pasts
pates	7	60	4789	2	pates
pauses	8	46	2147	2	pauses
paves	10	48	3392	2	paves
paxes	14	49	2842	2	paxes
peases	8	52	2947	2	peases
phases	11	46	1840	2	phases
poses	7	46	4276	2	poses
prases	8	44	2902	2	prases
puses	7	55	3220	2	puses
races	7	49	4324	2	races
rages	6	45	3944	2	rages
raises	6	48	2654	2	raises
rajes	12	50	2278	2	rajes
rakes	9	44	4035	2	rakes
rales	5	49	4749	2	rales
rapes	7	57	4072	2	rapes
rares	5	52	4744	2	rares
rase	4	61	4998	2	rase_
rased	6	50	3393	2	rased
raser	5	56	3341	2	raser
rasers	6	45	2678	2	rasers
rashes	9	53	3015	2	rashes
rasps	7	43	1666	2	rasps
rates	5	53	5201	2	rates
raves	8	54	4197	2	raves
raxes	12	47	2939	2	raxes
razes	14	50	3270	2	razes
rises	5	52	4404	2	rises
roses	5	64	4577	2	roses
ruses	5	61	3658	2	ruses
sabes	7	64	3746	2	sabes
sades	6	52	3989	2	sades
safes	8	52	2672	2	safes
sages	6	53	3906	2	sages
sakes	9	55	4075	2	sakes
sales	5	60	5559	2	sales
sanes	5	56	4907	2	sanes
sashes	9	47	2848	2	sashes
sass	4	50	3562	2	sas_s
sasses	6	41	2439	2	sasses
sates	5	49	4932	2	sates
saves	8	58	3863	2	saves
saxes	12	52	2934	2	saxes
sises	5	52	3383	2	sises
stases	6	42	2556	2	stases
tabes	7	60	3392	2	tabes
taces	7	62	3780	2	taces
tajes	12	49	2069	2	tajes
takes	9	44	3779	2	takes
tales	5	54	5137	2	tales
tames	7	52	4201	2	tames
tapes	7	58	3860	2	tapes
tares	5	74	5656	2	tares
tasks	9	49	1758	2	tasks
tass	4	56	4057	2	tas_s
tasse	5	48	2184	2	tasse
tasses	6	48	2676	2	tasses
tastes	6	41	2642	2	tastes
tates	5	54	4498	2	tates
tawses	9	49	1319	2	tawses
taxes	12	47	3082	2	taxes
teases	6	54	2627	2	teases
ukases	10	35	806	2	ukases
upases	8	41	1290	2	upases
urases	6	37	2356	2	urases
uses	4	49	3111	2	_uses
vacs	9	62	2620	2	va_cs
vagus	9	67	1381	2	vagus
vails	8	58	2593	2	vails
vairs	8	50	1913	2	vairs
vale	7	49	3734	2	vale_
valet	8	43	3787	2	valet
valets	9	37	1562	2	valets
valises	10	35	1626	2	valises
valse	8	51	1752	2	valse_
values	9	43	1494	2	values
valves	12	41	1378	2	valves
vamoses	12	3	914	2	vamoses
vamps	12	54	1548	2	vamps
vane	7	55	3468	2	vane_
vaned	9	46	2242	2	vaned
vangs	9	63	1958	2	vangs
vans	7	62	3672	2	va_ns
varas	8	60	2819	2	varas
varies	9	43	3087	2	varies
vars	7	57	4207	2	va_rs
varus	8	59	2118	2	varus
varuses	10	3	1062	2	varuses
varves	12	44	1478	2	varves
vas	6	77	5577	2	va__s
vasa	7	65	2297	2	vas_a
vasal	8	55	1629	2	vasal
vast	7	50	4512	2	vas_t
vaster	9	45	2102	2	vaster
vastest	10	29	1151	2	vastest
vasty	11	62	1592	2	vasty
vats	7	68	4174	2	va_ts
vatus	8	61	1464	2	vatus
vaus	7	59	2892	2	va_us
vavs	10	57	2043	2	va_vs
vaws	10	55	2732	2	va_ws
vees	7	54	3943	2	v_ees
veges	9	41	1886	2	veges
verses	9	42	2376	2	verses
vests	8	53	2598	2	vests
vexes	15	57	1912	2	vexes
vibes	10	47	1995	2	vibes
vices	10	57	2553	2	vices
vies	7	52	3862	2	v_ies
vines	8	51	3764	2	vines
vires	8	45	2968	2	vires
visas	8	43	1765	2	visas
vise	7	56	3267	2	vise_
vised	9	55	1876	2	vised
voces	10	59	1805	2	voces
voes	7	54	3282	2	v_oes
voles	8	62	3404	2	voles
votes	8	46	2708	2	votes
wades	9	56	3414	2	wades
waes	7	60	4860	2	wa_es
wages	9	53	3093	2	wages
wakes	12	66	3365	2	wakes
wales	8	61	4283	2	wales
wames	10	64	3280	2	wames
wanes	8	50	4088	2	wanes
wares	8	82	5058	2	wares
washes	12	44	2549	2	washes
wasps	10	67	1469	2	wasps
wastes	9	62	2488	2	wastes
wasts	8	74	3367	2	wasts
waves	11	56	3392	2	waves
waxes	15	58	2550	2	waxes
wises	8	56	3319	2	wises
yeses	8	51	1932	2	yeses
zaxes	21	51	1382	2	zaxes

Search took 3 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	366	1.860	28924.7
3	Display Results	366	366	0.106	3452.8
	(SQL Overall)	178691	366	2.059	86785.3