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

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

327 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
vacant	11	4	1513	(None)
alant	5	57	4229	2	_alant
avant	8	62	2466	2	_avant
cant	6	63	6203	2	__cant
decant	9	35	2422	2	decant
evacuant	13	4	441	2	evacuant
incant	8	24	1851	2	incant
jacana	15	3	793	2	jacana
natant	6	3	1873	2	natant
recant	8	32	2868	2	recant
savant	9	4	1604	2	savant
scant	7	97	3507	2	_scant
secant	8	40	2329	2	secant
vacancy	17	4	444	2	vacancy
vacantly	16	4	407	2	vacantly
vacate	11	3	1455	2	vacate
vagrant	11	4	1066	2	vagrant
valiant	10	3	1462	2	valiant
variant	10	3	1680	2	variant
vaunt	8	59	2531	2	va_unt
volant	9	3	1632	2	volant
abaft	10	3	1806	3	_abaft
acantha	12	5	466	3	_acantha
acanthi	12	4	466	3	_acanthi
acari	7	50	2028	3	_acari
accent	10	51	1626	3	accent
acing	8	74	2915	3	_acing
acini	7	57	1898	3	_acini
acne	6	66	2587	3	_ac_ne
act	5	95	5784	3	_ac__t
adamant	10	11	1044	3	adamant
adapt	8	12	1855	3	_adapt
agent	6	58	2964	3	_agent
alan	4	68	4408	3	_alan_
aland	6	55	2641	3	_aland
alane	5	61	3561	3	_alane
alang	6	60	2351	3	_alang
alans	5	56	3617	3	_alans
alants	6	77	2202	3	_alants
ament	7	60	3654	3	_ament
anent	5	49	3184	3	_anent
ant	3	72	7079	3	___ant
apart	7	43	3067	3	_apart
arcana	8	9	1258	3	arcana
arcane	8	12	1674	3	arcane
arrant	6	6	2325	3	arrant
asana	5	3	1548	3	_asana
ascent	8	45	1965	3	ascent
askant	10	4	1271	3	askant
aslant	6	3	1775	3	aslant
aunt	4	65	5365	3	_a_unt
avast	8	55	1936	3	_avast
avaunt	9	5	960	3	avaunt
avian	8	46	1605	3	avian_
avians	9	37	1156	3	avians
await	8	55	2449	3	_await
azan	13	65	2178	3	_azan_
azans	14	65	1688	3	_azans
bacchant	17	4	780	3	bacchant
bacon	9	56	2059	3	bacon_
bacons	10	49	1758	3	bacons
banana	8	32	1341	3	banana
basalt	8	35	1958	3	basalt
bezant	17	8	1454	3	bezant
blatant	9	3	1067	3	blatant
brant	7	47	4217	3	_brant
byzant	20	9	681	3	byzant
cabana	10	39	1356	3	cabana
caca	8	55	2808	3	caca__
cacao	9	54	2000	3	caca_o
cacaos	10	46	1618	3	cacaos
cacas	9	56	2798	3	caca_s
cachet	13	45	2641	3	cachet
cadent	9	41	2036	3	cadent
callant	9	41	2122	3	callant
can	5	77	6014	3	__can_
cancan	10	3	1410	3	cancan_
cancans	11	3	1187	3	cancans
cane	6	66	5312	3	__cane
cans	6	50	5085	3	__cans
canst	7	49	3221	3	__canst
canto	7	49	3101	3	__canto
cants	7	70	3694	3	__cants
canty	10	52	2680	3	__canty
carat	7	50	4879	3	cara_t
carcanet	12	3	1635	3	carcanet
cart	6	65	7034	3	__cart
cast	6	71	5990	3	__cast
cat	5	82	8234	3	__ca_t
cent	6	74	5101	3	__cent
chant	10	59	3269	3	_chant
clamant	11	3	1243	3	clamant
cunt	6	62	4367	3	__cunt
dacoit	9	4	1545	3	dacoit
daman	8	48	2116	3	daman_
damans	9	47	1598	3	damans
daunt	6	59	2908	3	da_unt
decane	9	38	1887	3	decane
decants	10	35	1444	3	decants
decent	9	40	2370	3	decent
descant	10	43	1559	3	descant
dicast	9	3	1557	3	dicast
discant	10	30	1726	3	discant
docent	9	29	1868	3	docent
dopant	9	3	1613	3	dopant
ducat	8	62	2590	3	duca_t
eluant	6	3	1509	3	eluant
emanant	9	4	1109	3	emanant
enchant	12	3	1312	3	enchant
errant	6	6	1873	3	errant
etchant	12	4	982	3	etchant
evacuants	14	4	295	3	evacuants
extant	13	27	1475	3	extant
facade	12	3	880	3	facade
facet	10	60	3852	3	fac_et
facing	12	53	2157	3	facing
fact	9	71	4254	3	fac__t
faint	8	58	3706	3	fa_int
gallant	8	35	1711	3	gallant
gardant	9	3	1446	3	gardant
gaunt	6	54	3040	3	ga_unt
gelant	7	28	2167	3	gelant
giant	6	54	3059	3	_giant
grant	6	48	4002	3	_grant
haint	8	54	3632	3	ha_int
hant	7	54	6159	3	__hant
haunt	8	52	2913	3	ha_unt
hazan	17	38	1361	3	hazan_
hazans	18	34	1165	3	hazans
incants	9	20	1280	3	incants
incent	8	33	2072	3	incent
infant	9	23	1513	3	infant
jacal	14	3	1370	3	jaca_l
jacals	15	3	987	3	jacals
jacanas	16	3	826	3	jacanas
jacinth	19	5	460	3	jacinth
jacket	19	47	2067	3	jacket
jaconet	16	3	1148	3	jaconet
japan	14	4	1123	3	japan_
japans	15	3	982	3	japans
jaunt	12	50	2527	3	ja_unt
jawan	15	7	1038	3	jawan_
jawans	16	5	784	3	jawans
jurant	13	42	1655	3	jurant
karat	9	68	3759	3	kara_t
lacing	9	46	2623	3	lacing
lacuna	8	11	812	3	lacuna
lacune	8	16	967	3	lacune
lagan	6	65	2034	3	lagan_
lagans	7	57	1778	3	lagans
lament	8	50	2494	3	lament
latent	6	41	2430	3	latent
lauan	5	52	1679	3	lauan_
lauans	6	51	1353	3	lauans
leant	5	67	3778	3	_leant
levant	9	3	1449	3	levant
lucent	8	3	1382	3	lucent
macaco	12	4	785	3	macaco
macaw	12	3	1176	3	maca_w
macaws	13	3	702	3	macaws
macing	11	42	2155	3	macing
macon	9	45	1995	3	macon_
macons	10	40	1724	3	macons
manana	8	48	1607	3	manana
manat	7	60	3999	3	mana_t
maranta	9	3	1169	3	maranta
mayan	10	56	1690	3	mayan_
meant	7	65	3721	3	_meant
mutant	8	3	1769	3	mutant
naan	4	76	2193	3	na_an_
naans	5	58	1525	3	na_ans
nagana	7	4	894	3	nagana
nascent	9	6	1052	3	nascent
nocent	8	32	1741	3	nocent
nonvacant	14	4	504	3	~~non~~vacant
nutant	6	3	1638	3	nutant
octant	8	12	1655	3	octant
oxcart	15	3	952	3	oxcart
paca	8	51	3224	3	paca__
pacas	9	60	2940	3	paca_s
pacing	11	45	2275	3	pacing
packet	14	47	2650	3	packet
pact	8	66	4872	3	pac__t
paean	7	72	2272	3	paean_
paeans	8	51	1826	3	paeans
pagan	8	61	2116	3	pagan_
pagans	9	57	1792	3	pagans
pageant	10	3	1278	3	pageant
paint	7	54	4369	3	pa_int
pant	6	60	6126	3	__pant
parang	9	37	1551	3	parang
parent	8	32	3042	3	parent
passant	9	8	1394	3	passant
patent	8	45	2492	3	patent
pavan	10	65	1847	3	pavan_
pavane	11	41	1344	3	pavane
pavans	11	57	1559	3	pavans
peasant	9	3	1492	3	peasant
pecan	9	19	1903	3	pecan_
pecans	10	15	1583	3	pecans
peccant	13	3	1173	3	peccant
pedant	9	3	1949	3	pedant
picante	11	3	1052	3	picante
plant	7	54	3711	3	_plant
pliant	8	39	1882	3	pliant
qanat	14	44	2684	3	qana_t
quant	14	36	2481	3	_quant
rabat	7	28	3222	3	raba_t
rachet	11	50	2897	3	rachet
racing	9	50	3053	3	racing
racist	8	28	2279	3	racist
racket	12	52	2942	3	racket
racon	7	54	2214	3	racon_
racons	8	43	1934	3	racons
radiant	8	28	1713	3	radiant
rampant	11	3	1217	3	rampant
rant	4	58	6468	3	__rant
ratan	5	37	2266	3	ratan_
ratans	6	38	1937	3	ratans
ratany	9	34	1187	3	ratany
reactant	10	3	1143	3	reactant
recane	8	30	2287	3	recane
recants	9	32	1709	3	recants
recast	8	34	2277	3	recast
recent	8	36	3085	3	recent
riant	5	58	3315	3	_riant
sacbut	10	8	1194	3	sacbut
sachet	11	47	2577	3	sachet
saint	5	51	4707	3	sa_int
saltant	7	3	1677	3	saltant
saran	5	37	3030	3	saran_
sarans	6	42	2443	3	sarans
satang	7	57	1156	3	satang
savants	10	3	865	3	savants
scan	6	55	3045	3	_scan_
scans	7	46	2510	3	_scans
scants	8	52	1972	3	_scants
scanty	11	40	1466	3	_scanty
scart	7	61	3977	3	_scart
scat	6	58	4837	3	_sca_t
scatt	7	60	3009	3	_scatt
scent	7	58	3162	3	_scent
sealant	7	31	1830	3	sealant
seawant	10	36	1341	3	seawant
secants	9	34	1389	3	secants
sejant	13	31	1448	3	sejant
slant	5	52	3870	3	_slant
sonant	6	6	2195	3	sonant
statant	7	3	1312	3	statant
tacet	7	58	4002	3	tac_et
tacit	7	63	3367	3	tac_it
tacket	12	46	2749	3	tacket
tact	6	73	4903	3	tac__t
taggant	9	3	1022	3	taggant
taint	5	55	4228	3	ta_int
talent	6	3	2332	3	talent
taunt	5	55	3228	3	ta_unt
teacart	9	11	1319	3	teacart
tenant	6	3	2247	3	tenant
truant	6	3	1578	3	truant
tyrant	9	3	1533	3	tyrant
uncast	8	42	1571	3	uncast
upcast	10	27	1009	3	upcast
vac	8	65	3714	3	vac___
vacated	13	4	935	3	vacated
vacates	12	3	1283	3	vacates
vacating	14	3	1036	3	vacating
vaccina	14	3	530	3	vaccina
vaccine	14	3	732	3	vaccine
vacillant	14	4	473	3	vac~~ill~~ant
vacs	9	62	2620	3	vac__s
vacua	10	5	1046	3	vac_ua
vacuity	15	4	576	3	vacuity
vacuum	13	3	483	3	vacuum
vagal	9	46	1363	3	vaga_l
vagary	13	3	733	3	vagary
vagina	10	27	1093	3	vagina
vagrants	12	4	614	3	vagrants
vahine	12	36	1211	3	vahine
vain	7	52	3300	3	va_in_
valance	12	6	925	3	valance
valet	8	43	3787	3	va_let
valiants	11	3	779	3	valiants
valine	9	46	2309	3	valine
van	6	62	4633	3	v__an_
vane	7	55	3469	3	v__ane
vang	8	49	2604	3	v__ang
vanman	11	3	979	3	vanman_
vans	7	62	3673	3	v__ans
vara	7	55	3088	3	vara__
varas	8	60	2819	3	vara_s
variants	11	3	920	3	variants
varlet	9	4	2350	3	varlet
varment	12	3	1324	3	varment
varmint	12	3	1168	3	varmint
varna	8	45	1617	3	va_rna
varnas	9	42	1282	3	varnas
vasa	7	65	2297	3	vasa__
vasal	8	55	1629	3	vasa_l
vast	7	50	4512	3	v__ast
vat	6	78	6345	3	v__a_t
vault	8	58	2376	3	va_ult
vaunts	9	52	1262	3	va_unts
vaunty	12	40	906	3	va_unty
vaward	13	49	872	3	vaward
vegan	9	51	1415	3	vegan_
vegans	10	39	1085	3	vegans
vent	7	60	4905	3	v__ent
verdant	11	3	1329	3	verdant
versant	10	3	1383	3	versant
vesicant	13	4	750	3	vesicant
viand	9	5	1107	3	v_iand
vibrant	12	4	1039	3	vibrant
vicar	10	5	1386	3	vica_r
vicars	11	7	1226	3	vicars
vicing	12	40	1424	3	vicing
vicuna	11	11	590	3	vicuna
vocab	12	40	997	3	voca_b
vocabs	13	33	631	3	vocabs
vocal	10	47	1564	3	voca_l
vocals	11	38	1158	3	vocals
volante	10	3	851	3	volante
volcano	12	4	461	3	volcano
want	7	61	5617	3	__want
warrant	10	6	1424	3	warrant
yacht	13	4	1739	3	yac_ht
zanana	15	38	1036	3	zanana

Search took 6 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.376	475242.0
2	DLD Change Limit	112716	327	5.376	20966.5
3	Display Results	327	327	0.106	3084.9
	(SQL Overall)	178691	327	5.858	30503.8