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

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

438 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
rote	4	62	4902	(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
rate	4	54	5876	1	rate
rete	4	49	4413	1	rete
rite	4	58	4945	1	rite
robe	6	53	3564	1	robe
rode	5	58	4430	1	rode
roe	3	68	6107	1	ro_e
role	4	58	5182	1	role
rope	6	55	4291	1	rope
rose	4	61	4890	1	rose
rot	3	72	8295	1	rot_
rota	4	58	3434	1	rota
rotes	5	61	4390	1	rotes
roti	4	63	3292	1	roti
rotl	4	50	2968	1	rotl
roto	4	59	3505	1	roto
rots	4	64	5409	1	rots
rotte	5	46	2593	1	rotte
roue	4	59	4174	1	roue
route	5	51	3207	1	route
rove	7	51	3698	1	rove
tote	4	66	4367	1	tote
vote	7	47	2862	1	vote
wrote	8	47	1748	1	wrote
ante	4	65	3890	2	ante
arete	5	60	3135	2	arete
arose	5	58	3208	2	arose
ate	3	70	5924	2	_ate
azote	14	44	1634	2	azote
bate	6	65	5242	2	bate
bite	6	65	4699	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
broke	11	60	1978	2	broke
brome	9	44	2197	2	brome
brose	7	52	2703	2	brose
broth	10	65	2109	2	broth
brute	7	53	2178	2	brute
bute	6	67	3967	2	bute
byte	9	65	2181	2	byte
cate	6	62	5459	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
crate	7	65	3740	2	crate
crone	7	52	3133	2	crone
crore	7	49	2286	2	crore
croute	8	46	1727	2	croute
croze	16	47	1945	2	croze
cute	6	64	4045	2	cute
date	5	64	4332	2	date
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
drone	6	53	2498	2	drone
drove	9	55	1806	2	drove
emote	7	54	2119	2	emote
erode	6	45	2099	2	erode
erose	5	57	2727	2	erose
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
froe	7	53	2999	2	fro_e
frore	8	62	1880	2	frore
froth	11	59	1928	2	froth
froze	17	45	1565	2	froze
garote	7	7	1794	2	garote
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
grate	6	49	3288	2	grate
grope	8	48	2161	2	grope
grot	5	59	4205	2	grot_
grots	6	50	2585	2	grots
grove	9	52	1933	2	grove
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	7605	2	hot_
hotel	8	55	2074	2	hotel
hots	7	83	4932	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
irate	5	56	2798	2	irate
irone	5	51	2636	2	irone
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	3823	2	kite
kore	8	58	3416	2	kore
koto	8	63	2346	2	koto
krone	9	40	1873	2	krone
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	3183	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	5421	2	mate
mete	6	44	3813	2	mete
mite	6	62	4940	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
orate	5	51	3330	2	orate
ore	3	66	6183	2	_ore
orle	4	56	3046	2	orle
ort	3	94	6523	2	ort_
orts	4	65	3833	2	orts
ose	3	81	4734	2	_ose
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
prate	7	51	3598	2	prate
probe	9	43	2081	2	probe
prole	7	45	2779	2	prole
prone	7	53	3262	2	prone
prose	7	58	3512	2	prose
protea	8	22	1476	2	protea
protei	8	26	1530	2	protei
prove	10	48	2319	2	prove
quote	14	37	1477	2	quote
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rat	3	78	9274	2	rat_
rated	6	54	4138	2	rated
ratel	5	42	2488	2	ratel
rater	5	49	4328	2	rater
rates	5	53	5201	2	rates
rath	7	60	3766	2	rath
rathe	8	58	2192	2	rathe
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
re	2	61	5374	2	r__e
rede	5	50	3766	2	rede
ree	3	79	7407	2	r_ee
remote	8	42	2260	2	remote
rente	5	47	3378	2	rente
ret	3	59	8283	2	ret_
retem	7	42	2195	2	retem
retie	5	57	3530	2	retie
rets	4	53	5256	2	rets
revote	9	49	1745	2	revote
rice	6	49	4291	2	rice
ride	5	59	4512	2	ride
rife	7	46	3232	2	rife
rile	4	56	5053	2	rile
rime	6	51	3888	2	rime
riot	4	59	4721	2	riot_
rioted	7	34	1637	2	rioted
rioter	6	48	1728	2	rioter
riots	5	49	2201	2	riots
ripe	6	60	3892	2	ripe
rise	4	59	4523	2	rise
rites	5	44	4255	2	rites
ritz	13	51	2998	2	ritz
rive	7	55	3772	2	rive
road	5	63	3211	2	road
roam	6	71	3241	2	roam
roan	4	72	3420	2	roan
roar	4	63	2857	2	roar
rob	5	67	5430	2	ro_b
robed	8	53	2373	2	robed
robes	7	51	3330	2	robes
roble	7	52	2302	2	roble
robs	6	58	3787	2	robs
roc	5	202	4325	2	ro_c
rock	10	57	3518	2	rock
rocs	6	55	3366	2	rocs
rod	4	79	5389	2	ro_d
rodeo	6	59	2109	2	rodeo
rodes	6	140	3908	2	rodes
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
roger	6	45	2141	2	roger
rogue	6	64	1753	2	rogue
roil	4	62	3529	2	roil
roles	5	67	4798	2	roles
rolf	7	51	3487	2	rolf
roll	4	63	3165	2	roll
rom	5	98	5563	2	ro_m
romeo	7	37	1970	2	romeo
romp	8	59	2657	2	romp
roms	6	70	3896	2	roms
rood	5	67	3300	2	rood
roof	7	57	3883	2	roof
rook	8	55	3203	2	rook
room	6	62	3508	2	room
roose	5	61	2709	2	roose
root	4	56	5592	2	root
rooted	7	54	2400	2	rooted
rooter	6	49	2603	2	rooter
rootle	6	32	1445	2	rootle
roots	5	59	3367	2	roots
rooty	8	64	2302	2	rooty
roped	8	46	3080	2	roped
roper	7	54	3191	2	roper
ropes	7	59	4006	2	ropes
ropey	10	60	2187	2	ropey
ropy	9	63	2341	2	ropy
roque	14	48	1213	2	roque
rosed	6	59	3034	2	rosed
roses	5	64	4577	2	roses
roset	5	59	4524	2	roset
roster	6	43	2908	2	roster
rosy	7	60	2487	2	rosy
rotas	5	48	2772	2	rotas
rotate	6	33	2034	2	rotate
rotch	10	58	1593	2	rotch
rotche	11	43	1198	2	rotche
rotis	5	63	2705	2	rotis
rotls	5	56	2016	2	rotls
rotor	5	55	1973	2	rotor
rotos	5	60	2788	2	rotos
rotted	7	45	2443	2	rotted
rotten	6	41	1543	2	rotten
rotter	6	43	2546	2	rotter
rottes	6	45	2483	2	rottes
rouen	5	49	2090	2	rouen
roues	5	60	3935	2	roues
rouge	6	54	2344	2	rouge
roup	6	66	2769	2	roup
rouse	5	66	3470	2	rouse
rout	4	61	5328	2	rout
routed	7	56	2433	2	routed
router	6	50	2584	2	router
routes	6	61	2931	2	routes
routh	8	64	2307	2	routh
routs	5	71	3341	2	routs
roux	11	74	1936	2	roux
roved	9	53	2355	2	roved
roven	8	55	2197	2	roven
rover	8	55	2737	2	rover
roves	8	48	3448	2	roves
row	6	74	5367	2	ro_w
rowed	9	40	3432	2	rowed
rowel	8	47	2141	2	rowel
rowen	8	49	2115	2	rowen
rower	8	54	3049	2	rower
rows	7	59	4175	2	rows
rowth	11	57	1323	2	rowth
rube	6	55	3201	2	rube
rude	5	56	3278	2	rude
rue	3	55	4926	2	r_ue
rule	4	99	3842	2	rule
rune	4	52	3629	2	rune
ruse	4	59	3893	2	ruse
rut	3	55	6052	2	rut_
ruth	7	68	2599	2	ruth
ruts	4	45	4149	2	ruts
rye	6	60	3254	2	r_ye
ryke	11	56	1640	2	ryke
ryot	7	55	2856	2	ryot_
ryots	8	53	1378	2	ryots
sate	4	55	5610	2	sate
shote	8	55	2608	2	shote
site	4	70	5241	2	site
smote	7	58	2027	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	8429	2	sot_
soth	7	59	3251	2	soth
sots	4	55	5244	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	1936	2	totem
toter	5	59	3213	2	toter
totes	5	51	3968	2	totes
tots	4	66	5412	2	tots
trite	5	47	3003	2	trite
trode	6	53	2285	2	trode
troke	9	48	2105	2	troke
trone	5	51	3186	2	trone
trope	7	57	2580	2	trope
trot	4	63	5131	2	trot_
troth	8	56	2220	2	troth
trots	5	66	2994	2	trots
trove	8	52	2192	2	trove
urate	5	54	3216	2	urate
ute	3	53	3588	2	_ute
voe	6	77	3905	2	vo_e
vole	7	52	3698	2	vole
volte	8	53	2130	2	volte
voted	9	39	1914	2	voted
voter	8	51	2105	2	voter
votes	8	46	2708	2	votes
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
write	8	55	2283	2	write
wroth	11	68	1588	2	wroth
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.080	2233637.5
2	DLD Change Limit	29872	438	0.873	34217.6
3	Display Results	438	438	0.110	3981.8
	(SQL Overall)	178691	438	1.063	168100.7