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

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

467 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
rose	4	61	4890	(None)
arose	5	58	3208	1	arose
brose	7	52	2703	1	brose
dose	5	64	4243	1	dose
erose	5	57	2727	1	erose
hose	7	65	4724	1	hose
lose	4	51	4458	1	lose
nose	4	67	3936	1	nose
ose	3	81	4734	1	_ose
pose	6	64	4173	1	pose
prose	7	58	3512	1	prose
rase	4	61	4998	1	rase
rise	4	59	4523	1	rise
robe	6	53	3564	1	robe
rode	5	58	4430	1	rode
roe	3	68	6108	1	ro_e
roes	4	59	5414	1	roes
role	4	58	5182	1	role
roose	5	61	2709	1	roose
rope	6	55	4291	1	rope
rosed	6	59	3034	1	rosed
roses	5	64	4577	1	roses
roset	5	59	4524	1	roset
rosy	7	60	2487	1	rosy
rote	4	62	4902	1	rote
roue	4	59	4174	1	roue
rouse	5	66	3470	1	rouse
rove	7	51	3698	1	rove
ruse	4	59	3893	1	ruse
apse	6	77	2538	2	apse
ariose	6	48	1872	2	ariose
arise	5	64	3643	2	arise
arkose	10	49	1134	2	arkose
arouse	6	50	1998	2	arouse
arse	4	65	3927	2	arse
base	6	48	4702	2	base
bise	6	64	3710	2	bise
bode	7	58	3875	2	bode
bole	6	64	4869	2	bole
bone	6	59	4932	2	bone
bore	6	60	5133	2	bore
bos	5	79	6681	2	bos_
bosh	9	63	2897	2	bosh
bosk	10	58	2573	2	bosk
boss	6	59	3834	2	boss
bouse	7	59	3185	2	bouse
bowse	10	54	2063	2	bowse
broke	11	60	1978	2	broke
brome	9	44	2197	2	brome
bros	6	56	3566	2	bros_
broses	8	65	2440	2	broses
brosy	10	61	1538	2	brosy
browse	11	57	1385	2	browse
case	6	58	4808	2	case
chose	10	59	2540	2	chose
close	7	64	2522	2	close
code	7	73	4773	2	code
coke	10	70	3838	2	coke
cole	6	69	5611	2	cole
come	8	75	4770	2	come
cone	6	72	5696	2	cone
cope	8	68	4738	2	cope
copse	9	56	2392	2	copse
core	6	72	6311	2	core
corse	7	50	3618	2	corse
cos	5	102	7039	2	cos_
cosec	9	63	2018	2	cosec
coses	7	69	4949	2	coses
coset	7	57	4884	2	coset
cosey	10	62	2671	2	cosey
cosh	9	61	2762	2	cosh
cosie	7	47	2826	2	cosie
coss	6	61	4349	2	coss
cost	6	80	5794	2	cost
cosy	9	72	3270	2	cosy
cote	6	66	4873	2	cote
cove	9	58	3707	2	cove
crone	7	52	3133	2	crone
crore	7	49	2287	2	crore
cross	7	51	2450	2	cross
crosse	8	52	1630	2	crosse
crouse	8	46	1936	2	crouse
croze	16	47	1945	2	croze
cruse	7	57	2610	2	cruse
doe	4	73	6195	2	do_e
does	5	65	5447	2	does
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
dos	4	80	6231	2	dos_
dosed	7	66	2691	2	dosed
doser	6	62	2856	2	doser
doses	6	59	3850	2	doses
doss	5	62	3504	2	doss
dost	5	72	4835	2	dost
dote	5	54	4288	2	dote
douse	6	63	2972	2	douse
dove	8	51	3156	2	dove
dowse	9	60	2081	2	dowse
doze	14	58	2908	2	doze
drone	6	53	2498	2	drone
dross	6	54	1809	2	dross
drove	9	55	1806	2	drove
drowse	10	50	1055	2	drowse
druse	6	48	1766	2	druse
ease	4	50	4233	2	ease
else	4	59	2308	2	else
erase	5	49	2549	2	erase
erode	6	45	2099	2	erode
eros	4	52	3845	2	eros_
eroses	6	53	2705	2	eroses
foe	6	63	5081	2	fo_e
foes	7	65	4344	2	foes
fore	7	83	5147	2	fore
foss	7	64	3164	2	foss
fosse	8	61	1946	2	fosse
frise	8	53	2245	2	frise
froe	7	53	2999	2	fro_e
froes	8	61	2669	2	froes
frore	8	62	1880	2	frore
frosh	11	57	1340	2	frosh
frost	8	47	2783	2	frost
froze	17	45	1565	2	froze
fuse	7	64	2999	2	fuse
goes	5	56	4409	2	goes
gone	5	56	3904	2	gone
goose	6	59	2590	2	goose
gore	5	57	4496	2	gore
gorse	6	59	2681	2	gorse
gos	4	71	5513	2	gos_
gosh	8	61	2342	2	gosh
grope	8	48	2161	2	grope
gross	6	54	2169	2	gross
grosz	15	48	1409	2	grosz
grosze	16	45	773	2	grosze
grouse	7	43	1502	2	grouse
grove	9	52	1933	2	grove
gyrose	10	53	1025	2	gyrose
hoe	6	75	6272	2	ho_e
hoes	7	57	5573	2	hoes
hoise	8	52	2477	2	hoise
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
horse	8	61	3265	2	horse
hos	6	83	6419	2	hos_
hosed	9	58	3098	2	hosed
hosel	8	60	2481	2	hosel
hosen	8	56	2388	2	hosen
hoser	8	115	2976	2	hoser
hoses	8	54	4317	2	hoses
hosey	11	61	2702	2	hosey
host	7	78	5283	2	host
house	8	91	3142	2	house
hove	10	71	3222	2	hove
howe	10	67	3410	2	howe
irone	5	51	2636	2	irone
joe	10	66	4235	2	jo_e
joes	11	66	3589	2	joes
joke	15	59	2616	2	joke
jole	11	72	3382	2	jole
josh	14	51	1761	2	josh
joss	11	59	2559	2	joss
kore	8	58	3416	2	kore
kos	7	69	4482	2	kos_
koss	8	52	2481	2	koss
krone	9	40	1873	2	krone
lase	4	61	4851	2	lase
lobe	6	55	3536	2	lobe
lode	5	62	4011	2	lode
loge	5	68	3719	2	loge
lone	4	58	4913	2	lone
loose	5	66	2768	2	loose
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
losel	5	44	1942	2	losel
loser	5	47	2867	2	loser
loses	5	67	4201	2	loses
loss	4	53	3796	2	loss
lost	4	79	5149	2	lost
louse	5	61	3101	2	louse
love	7	52	3476	2	love
lowe	7	54	3531	2	lowe
lowse	8	72	1990	2	lowse
lyse	7	63	2059	2	lyse
mise	6	60	4358	2	mise
mode	7	58	4030	2	mode
moke	10	62	3422	2	moke
mole	6	62	5183	2	mole
mome	8	52	3935	2	mome
moose	7	63	2719	2	moose
mope	8	68	3804	2	mope
more	6	71	5452	2	more
morose	8	51	1624	2	morose
morse	7	60	3270	2	morse
mos	5	70	6712	2	mos_
mosey	10	59	2287	2	mosey
mosh	9	52	2760	2	mosh
mosk	10	56	2244	2	mosk
moss	6	76	4103	2	moss
most	6	65	5420	2	most
moste	7	59	2508	2	moste
mote	6	70	4808	2	mote
moue	6	58	3557	2	moue
mouse	7	71	3300	2	mouse
move	9	66	3072	2	move
muse	6	71	3603	2	muse
node	5	130	3688	2	node
noes	4	58	4539	2	noes
noise	5	57	2373	2	noise
nome	6	60	3842	2	nome
none	4	57	4317	2	none
noose	5	56	2406	2	noose
nope	6	59	3419	2	nope
nos	3	88	5932	2	nos_
nosed	6	55	2455	2	nosed
noses	5	54	3564	2	noses
nosey	8	56	1988	2	nosey
nosh	7	62	2354	2	nosh
nosy	7	63	2289	2	nosy
note	4	62	3996	2	note
obe	5	66	3864	2	_obe
ode	4	74	4658	2	_ode
oe	2	84	7306	2	_o_e
oes	3	58	6619	2	_oes
oke	7	58	3948	2	_oke
ole	3	71	5521	2	_ole
one	3	70	5091	2	_one
ooze	13	64	2060	2	ooze
ope	5	68	4524	2	_ope
ore	3	66	6183	2	_ore
ores	4	60	5668	2	ores
orle	4	56	3046	2	orle
ors	3	57	5011	2	ors_
os	2	113	5988	2	_os_
oses	4	66	4151	2	_oses
owe	6	70	4103	2	_owe
owse	7	63	2162	2	owse
pase	6	53	4686	2	pase
poise	7	51	2789	2	poise
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
porose	8	48	1874	2	porose
posed	8	58	2841	2	posed
poser	7	51	2877	2	poser
poses	7	46	4276	2	poses
posh	9	54	2732	2	posh
posse	7	47	2227	2	posse
post	6	79	5336	2	post
posy	9	60	2842	2	posy
prase	7	61	2875	2	prase
prese	7	52	2838	2	prese
prise	7	46	3261	2	prise
probe	9	43	2081	2	probe
prole	7	45	2779	2	prole
prone	7	53	3262	2	prone
pros	6	57	4278	2	pros_
prosed	9	49	2109	2	prosed
proser	8	42	2346	2	proser
proses	8	47	3347	2	proses
proso	7	72	2241	2	proso
pross	7	65	2940	2	pross
prost	7	54	3410	2	prost
prosy	10	63	1925	2	prosy
prove	10	48	2319	2	prove
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
ramose	8	3	1440	2	ramose
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
re	2	61	5374	2	r__e
rede	5	50	3767	2	rede
ree	3	79	7407	2	r_ee
rees	4	53	6419	2	rees
repose	8	41	2141	2	repose
rerose	6	33	2084	2	rerose
res	3	55	6504	2	res_
resee	5	43	3633	2	resee
reset	5	50	5186	2	reset
resew	8	45	1950	2	resew
resh	7	65	2345	2	resh
rest	4	64	5984	2	rest
rete	4	49	4413	2	rete
reuse	5	60	2536	2	reuse
rhos	7	63	1906	2	rhos_
ribose	8	3	989	2	ribose
rice	6	49	4291	2	rice
ride	5	59	4513	2	ride
rife	7	46	3232	2	rife
rile	4	56	5053	2	rile
rime	6	51	3888	2	rime
rimose	8	3	1059	2	rimose
rinse	5	48	2097	2	rinse
ripe	6	60	3892	2	ripe
risen	5	46	2188	2	risen
riser	5	54	3105	2	riser
rises	5	52	4404	2	rises
risk	8	57	2410	2	risk
rite	4	58	4945	2	rite
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
roast	5	62	3014	2	roast
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
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
roosed	7	56	2159	2	roosed
rooser	6	39	2188	2	rooser
rooses	6	55	2623	2	rooses
roost	5	57	3093	2	roost
root	4	56	5592	2	root
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
roscoe	8	3	976	2	roscoe
rosery	9	38	1328	2	rosery
rosets	6	58	1995	2	rosets
roshi	8	3	1075	2	roshi
rosier	6	42	2126	2	rosier
rosin	5	53	2531	2	rosin
roster	6	43	2908	2	roster
rot	3	72	8295	2	ro_t
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
rouen	5	49	2090	2	rouen
roues	5	60	3935	2	roues
rouge	6	54	2344	2	rouge
roup	6	66	2769	2	roup
roused	7	54	2644	2	roused
rouser	6	52	2408	2	rouser
rouses	6	54	3628	2	rouses
roust	5	55	3206	2	roust
rout	4	61	5328	2	rout
route	5	51	3207	2	route
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
rube	6	55	3201	2	rube
rude	5	56	3278	2	rude
rue	3	55	4926	2	r_ue
rues	4	60	4448	2	rues
rugose	7	3	728	2	rugose
rule	4	99	3842	2	rule
rune	4	52	3630	2	rune
ruses	5	61	3658	2	ruses
rush	7	66	2818	2	rush
rusk	8	58	2331	2	rusk
rust	4	55	4491	2	rust
rye	6	60	3254	2	r_ye
ryes	7	55	2935	2	ryes
ryke	11	56	1640	2	ryke
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
sos	3	77	6160	2	sos_
souse	5	65	3077	2	souse
those	8	52	1814	2	those
toe	3	101	6685	2	to_e
toes	4	69	5644	2	toes
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
torose	6	43	1769	2	torose
torse	5	58	3333	2	torse
tosh	7	48	2681	2	tosh
toss	4	56	3797	2	toss
tost	4	83	5192	2	tost
tote	4	66	4367	2	tote
touse	5	54	3067	2	touse
triose	6	47	1538	2	triose
trode	6	53	2285	2	trode
troke	9	48	2105	2	troke
trone	5	51	3186	2	trone
trope	7	57	2580	2	trope
trove	8	52	2192	2	trove
uprose	8	23	1148	2	uprose
urase	5	46	2469	2	urase
use	3	68	3516	2	_use
vase	7	56	2965	2	vase
vise	7	56	3267	2	vise
voe	6	77	3905	2	vo_e
voes	7	54	3282	2	voes
vole	7	52	3698	2	vole
vote	7	47	2862	2	vote
whose	11	49	1453	2	whose
wise	7	57	3734	2	wise
woe	6	66	5124	2	wo_e
woes	7	64	4066	2	woes
woke	11	55	2796	2	woke
wore	7	71	4467	2	wore
worse	8	65	2526	2	worse
wos	6	69	5353	2	wos_
wost	7	65	4436	2	wost
wove	10	56	2431	2	wove
wrote	8	47	1748	2	wrote
yoke	11	56	2639	2	yoke
yore	7	63	3594	2	yore
youse	8	53	2223	2	youse
yowe	10	67	2874	2	yowe
zone	13	52	3108	2	zone

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	29872	0.546	327272.9
2	DLD Change Limit	29872	467	1.953	15295.4
3	Display Results	467	467	0.233	2004.3
	(SQL Overall)	178691	467	2.732	65406.7