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

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

296 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
vote	7	47	2862	(None)
cote	6	66	4873	1	cote
dote	5	54	4288	1	dote
mote	6	70	4808	1	mote
note	4	62	3996	1	note
rote	4	62	4902	1	rote
tote	4	66	4367	1	tote
voe	6	77	3905	1	vo_e
vole	7	52	3698	1	vole
volte	8	53	2130	1	volte
voted	9	39	1914	1	voted
voter	8	51	2105	1	voter
votes	8	46	2708	1	votes
ante	4	65	3890	2	ante
ate	3	70	5924	2	_ate
azote	14	44	1634	2	azote
bate	6	65	5242	2	bate
bite	6	65	4700	2	bite
bode	7	58	3875	2	bode
boite	7	44	2632	2	boite
bole	6	64	4869	2	bole
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
bot	5	96	8040	2	bot_
bota	6	62	3650	2	bota
botel	7	51	2186	2	botel
both	9	65	3343	2	both
bots	6	64	5395	2	bots
bott	6	65	4857	2	bott
bute	6	67	3967	2	bute
byte	9	65	2181	2	byte
cate	6	62	5460	2	cate
cete	6	49	3478	2	cete
cite	6	56	4034	2	cite
code	7	73	4773	2	code
coke	10	70	3838	2	coke
cole	6	69	5611	2	cole
come	8	75	4770	2	come
comte	9	61	2547	2	comte
cone	6	72	5696	2	cone
conte	7	66	3320	2	conte
cope	8	68	4738	2	cope
core	6	72	6311	2	core
cot	5	104	8322	2	cot_
coted	8	50	3385	2	coted
cotes	7	63	4784	2	cotes
cots	6	80	5484	2	cots
cove	9	58	3707	2	cove
cute	6	64	4045	2	cute
date	5	64	4332	2	date
devote	10	45	1378	2	devote
dite	5	55	4755	2	dite
doe	4	73	6195	2	do_e
doge	6	62	3380	2	doge
dole	5	65	5000	2	dole
dome	7	72	4073	2	dome
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dore	5	63	5330	2	dore
dose	5	64	4243	2	dose
dot	4	75	7318	2	dot_
doted	7	52	2707	2	doted
doter	6	54	2862	2	doter
dotes	6	58	3669	2	dotes
doth	8	62	2571	2	doth
dots	5	56	4766	2	dots
doty	8	61	2822	2	doty
dove	8	51	3156	2	dove
doze	14	58	2908	2	doze
emote	7	54	2119	2	emote
evite	8	53	1768	2	evite
evoke	12	47	885	2	evoke
fate	7	54	4428	2	fate
fete	7	57	3492	2	fete
foe	6	63	5081	2	fo_e
fore	7	83	5147	2	fore
forte	8	61	3146	2	forte
gate	5	57	4657	2	gate
gite	5	54	3861	2	gite
gone	5	56	3904	2	gone
gore	5	57	4496	2	gore
got	4	98	7044	2	got_
goth	8	68	2508	2	goth
hate	7	84	5017	2	hate
hoe	6	75	6272	2	ho_e
hoke	11	59	3593	2	hoke
hole	7	75	5339	2	hole
home	9	80	4244	2	home
hone	7	75	4932	2	hone
hope	9	66	3967	2	hope
hose	7	65	4724	2	hose
hot	6	77	7606	2	hot_
hotel	8	55	2075	2	hotel
hots	7	83	4933	2	hots
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
hyte	10	90	1894	2	hyte
iota	4	51	2783	2	iota
jete	11	59	2725	2	jete
joe	10	66	4235	2	jo_e
joke	15	59	2616	2	joke
jole	11	72	3382	2	jole
jot	10	82	5902	2	jot_
jota	11	64	2362	2	jota
jots	11	63	3614	2	jots
jute	11	53	2789	2	jute
kite	8	53	3824	2	kite
kore	8	58	3416	2	kore
koto	8	63	2347	2	koto
kyte	11	70	1776	2	kyte
late	4	75	6048	2	late
lite	4	70	5454	2	lite
lobe	6	55	3536	2	lobe
lode	5	62	4011	2	lode
loge	5	68	3719	2	loge
lone	4	58	4913	2	lone
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
lose	4	51	4458	2	lose
lot	3	81	7926	2	lot_
lota	4	72	3350	2	lota
loth	7	61	3213	2	loth
loti	4	64	3184	2	loti
lots	4	76	5209	2	lots
lotte	5	49	2385	2	lotte
love	7	52	3476	2	love
lowe	7	54	3531	2	lowe
lute	4	63	4101	2	lute
mate	6	51	5422	2	mate
mete	6	44	3813	2	mete
mite	6	62	4941	2	mite
mode	7	58	4030	2	mode
moke	10	62	3422	2	moke
mole	6	62	5183	2	mole
mome	8	52	3935	2	mome
monte	7	58	2977	2	monte
mope	8	68	3804	2	mope
more	6	71	5452	2	more
moste	7	59	2508	2	moste
mot	5	72	7942	2	mot_
motel	7	66	2324	2	motel
motes	7	59	4400	2	motes
motet	7	56	4119	2	motet
motey	10	59	2295	2	motey
moth	9	67	3133	2	moth
mots	6	68	5316	2	mots
mott	6	66	4844	2	mott
motte	7	55	2697	2	motte
moue	6	58	3557	2	moue
move	9	66	3072	2	move
mute	6	51	3687	2	mute
nite	4	59	4358	2	nite
node	5	130	3688	2	node
nome	6	60	3842	2	nome
none	4	57	4317	2	none
nope	6	59	3419	2	nope
nose	4	67	3936	2	nose
not	3	94	7466	2	not_
nota	4	68	3077	2	nota
noted	6	51	2384	2	noted
noter	5	50	2564	2	noter
notes	5	50	3458	2	notes
obe	5	66	3864	2	_obe
ode	4	74	4658	2	_ode
oe	2	84	7306	2	_o_e
oke	7	58	3948	2	_oke
ole	3	71	5521	2	_ole
one	3	70	5091	2	_one
oot	3	112	7469	2	oot_
oots	4	64	4644	2	oots
ooze	13	64	2060	2	ooze
ope	5	68	4524	2	_ope
ore	3	66	6183	2	_ore
ose	3	81	4734	2	_ose
ovate	8	42	1439	2	ovate
owe	6	70	4103	2	_owe
pate	6	53	5046	2	pate
poet	6	55	5290	2	poet
poke	10	53	3536	2	poke
pole	6	59	5130	2	pole
pome	8	56	3669	2	pome
pone	6	57	4753	2	pone
pope	8	55	3561	2	pope
pore	6	64	5126	2	pore
pose	6	64	4173	2	pose
pot	5	80	7843	2	pot_
pots	6	64	5236	2	pots
quote	14	37	1477	2	quote
rate	4	54	5876	2	rate
rete	4	49	4413	2	rete
revote	9	49	1745	2	revote
rite	4	58	4945	2	rite
robe	6	53	3564	2	robe
rode	5	58	4430	2	rode
roe	3	68	6108	2	ro_e
role	4	58	5182	2	role
rope	6	55	4291	2	rope
rose	4	61	4890	2	rose
rot	3	72	8295	2	rot_
rota	4	58	3434	2	rota
rotes	5	61	4390	2	rotes
roti	4	63	3293	2	roti
rotl	4	50	2968	2	rotl
roto	4	59	3505	2	roto
rots	4	64	5409	2	rots
rotte	5	46	2593	2	rotte
roue	4	59	4174	2	roue
route	5	51	3207	2	route
rove	7	51	3698	2	rove
sate	4	55	5610	2	sate
shote	8	55	2610	2	shote
site	4	70	5241	2	site
smote	7	58	2028	2	smote
soke	8	54	3626	2	soke
sole	4	60	5367	2	sole
some	6	60	4038	2	some
sone	4	66	4998	2	sone
sore	4	70	5953	2	sore
sot	3	103	8430	2	sot_
soth	7	59	3252	2	soth
sots	4	55	5245	2	sots
tate	4	47	4860	2	tate
toe	3	101	6685	2	to_e
toke	8	67	3849	2	toke
tole	4	60	5290	2	tole
tome	6	75	4319	2	tome
tone	4	69	5374	2	tone
tope	6	59	4638	2	tope
tore	4	73	5932	2	tore
torte	5	54	3170	2	torte
tot	3	88	8477	2	tot_
toted	6	49	2948	2	toted
totem	7	48	1937	2	totem
toter	5	59	3213	2	toter
totes	5	51	3968	2	totes
tots	4	66	5412	2	tots
ute	3	53	3588	2	_ute
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vat	6	78	6345	2	vat_
vats	7	68	4174	2	vats
vatu	7	65	2433	2	vatu
vee	6	57	5018	2	v_ee
vet	6	59	5852	2	vet_
veto	7	66	2299	2	veto
vets	7	68	3509	2	vets
vibe	9	51	2450	2	vibe
vice	9	57	3285	2	vice
vide	8	54	3276	2	vide
vie	6	54	4763	2	v_ie
vile	7	61	3980	2	vile
vine	7	56	4368	2	vine
vise	7	56	3267	2	vise
vita	7	58	2852	2	vita
vitae	8	42	1763	2	vitae
vive	10	54	2662	2	vive
voces	10	59	1805	2	voces
voes	7	54	3282	2	voes
vogie	9	51	1666	2	vogie
vogue	9	56	1304	2	vogue
voice	10	49	1532	2	voice
void	8	62	2056	2	void
voile	8	47	1972	2	voile
voled	9	53	2372	2	voled
voles	8	62	3404	2	voles
volt	7	64	3953	2	volt
volta	8	52	1562	2	volta
voltes	9	49	1558	2	voltes
volti	8	49	1596	2	volti
volts	8	54	2129	2	volts
volute	9	39	1276	2	volute
vomer	10	55	1738	2	vomer
vortex	16	3	592	2	vortex
voters	9	50	1744	2	voters
votive	12	34	893	2	votive
vow	9	61	3631	2	vo_w
vowed	12	44	2457	2	vowed
vowel	11	55	1501	2	vowel
vower	11	52	2079	2	vower
vows	10	66	2694	2	vows
vox	13	66	2815	2	vo_x
wite	7	54	4327	2	wite
woe	6	66	5124	2	wo_e
woke	11	55	2796	2	woke
wore	7	71	4467	2	wore
wot	6	104	6748	2	wot_
wots	7	63	4289	2	wots
wove	10	56	2431	2	wove
wrote	8	47	1748	2	wrote
wyte	10	60	1864	2	wyte
yoke	11	56	2639	2	yoke
yore	7	63	3594	2	yore
yowe	10	67	2874	2	yowe
zlote	14	39	1294	2	zlote
zone	13	52	3108	2	zone

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.280	638182.1
2	DLD Change Limit	29872	296	0.750	39829.3
3	Display Results	296	296	0.080	3700.0
	(SQL Overall)	178691	296	1.110	160982.9