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

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

314 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
rye	6	60	3254	(None)
aye	6	71	5176	1	aye
bye	8	61	3459	1	bye
dye	7	53	3484	1	dye
eye	6	55	3977	1	eye
kye	10	73	2727	1	kye
lye	6	65	3341	1	lye
pye	8	64	3250	1	pye
re	2	61	5374	1	r_e
ree	3	79	7407	1	ree
roe	3	68	6108	1	roe
rue	3	55	4926	1	rue
rya	6	76	2201	1	rya
ryes	7	55	2935	1	ryes
ryke	11	56	1640	1	ryke
tye	6	58	3744	1	tye
wye	9	63	3197	1	wye
ye	5	76	5006	1	_ye
abye	9	79	2100	2	abye
ace	5	96	5683	2	ace
ae	2	125	9029	2	_ae
age	4	71	5433	2	age
ale	3	65	7234	2	ale
ane	3	78	6695	2	ane
ape	5	72	5118	2	ape
are	3	78	7457	2	are
arse	4	65	3927	2	arse
aryl	7	59	2234	2	aryl
ate	3	70	5924	2	ate
ave	6	77	4870	2	ave
awe	6	77	4662	2	awe
axe	10	82	3949	2	axe
ay	5	117	7389	2	ay_
ayes	7	65	4351	2	ayes
ays	6	70	5029	2	ays
barye	10	50	2149	2	barye
be	4	79	4894	2	_be
bee	5	62	6240	2	bee
bey	8	66	4542	2	bey
brae	6	56	3911	2	brae
bree	6	72	4126	2	bree
brie	6	58	3790	2	brie
by	7	75	2923	2	by_
byes	9	52	3053	2	byes
byre	9	50	2385	2	byre
bys	8	52	2946	2	bys
byte	9	65	2181	2	byte
cee	5	59	5270	2	cee
cry	8	97	2624	2	cry_
cue	5	75	4418	2	cue
cyme	11	94	2037	2	cyme
de	3	70	4954	2	_de
dee	4	76	6582	2	dee
dey	7	72	4337	2	dey
die	4	67	5965	2	die
doe	4	73	6195	2	doe
dree	5	66	3832	2	dree
dry	7	65	2603	2	dry_
dryer	9	51	1146	2	dryer
drys	8	63	1480	2	drys
due	4	52	4986	2	due
dyed	9	67	2076	2	dyed
dyer	8	55	2211	2	dyer
dyes	8	53	3189	2	dyes
dyke	12	64	1818	2	dyke
dyne	8	53	2093	2	dyne
eke	7	56	3009	2	eke
eme	5	58	3718	2	eme
ere	3	63	5277	2	ere
erne	4	67	2742	2	erne
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
eyed	8	66	2323	2	eyed
eyen	7	62	2366	2	eyen
eyer	7	61	2728	2	eyer
eyes	7	58	3788	2	eyes
eyne	7	63	2246	2	eyne
eyre	7	55	2525	2	eyre
fe	5	79	4474	2	_fe
fee	6	68	6201	2	fee
fey	9	59	4088	2	fey
fie	6	71	5244	2	fie
foe	6	63	5081	2	foe
frae	7	53	3047	2	frae
free	7	59	4018	2	free
froe	7	53	2999	2	froe
fry	9	62	2650	2	fry_
fryer	11	59	1343	2	fryer
fyce	12	63	1683	2	fyce
fyke	14	59	1529	2	fyke
gae	4	64	5770	2	gae
gee	4	53	5920	2	gee
gey	7	57	3830	2	gey
gie	4	71	4954	2	gie
gree	5	66	4156	2	gree
grey	8	56	2404	2	grey
grue	5	58	2571	2	grue
gybe	10	59	1624	2	gybe
gym	9	57	1906	2	gym
gyp	9	83	1901	2	gyp
gyre	8	47	2276	2	gyre
gyve	11	62	1508	2	gyve
hae	6	73	6400	2	hae
he	5	81	5195	2	_he
hey	9	67	4106	2	hey
hie	6	76	5270	2	hie
hoe	6	75	6272	2	hoe
hue	6	66	4230	2	hue
hyp	11	78	2246	2	hyp
hype	12	55	1981	2	hype
hyte	10	90	1894	2	hyte
ice	5	67	3724	2	ice
ire	3	69	4317	2	ire
jee	10	66	4864	2	jee
joe	10	66	4235	2	joe
kae	7	67	4454	2	kae
key	10	58	3333	2	key
kue	7	66	3186	2	kue
kyes	11	51	2493	2	kyes
kyte	11	70	1776	2	kyte
lee	3	60	6814	2	lee
ley	6	62	4681	2	ley
lie	3	82	6452	2	lie
lyes	7	55	3083	2	lyes
lyre	7	56	2379	2	lyre
lyse	7	63	2059	2	lyse
mae	5	76	5911	2	mae
me	4	77	4833	2	_me
my	7	81	2565	2	my_
myc	10	65	1950	2	myc
nae	3	59	5274	2	nae
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
obe	5	66	3864	2	obe
ode	4	74	4658	2	ode
oe	2	84	7306	2	_oe
oke	7	58	3948	2	oke
ole	3	71	5521	2	ole
one	3	70	5091	2	one
ope	5	68	4524	2	ope
ore	3	66	6183	2	ore
orle	4	56	3046	2	orle
oryx	14	5	1021	2	oryx
ose	3	81	4734	2	ose
owe	6	70	4103	2	owe
oy	5	89	5013	2	oy_
oyer	7	59	2765	2	oyer
oyes	7	49	4013	2	oyes
oyez	16	60	2035	2	oyez
pe	4	76	4903	2	_pe
pee	5	60	6651	2	pee
pie	5	54	5740	2	pie
pree	6	70	4473	2	pree
prey	9	62	2848	2	prey
pry	8	57	2805	2	pry_
pryer	10	44	1531	2	pryer
pya	8	70	2375	2	pya
pyes	9	55	2899	2	pyes
pyre	9	49	2555	2	pyre
pyx	15	78	1701	2	pyx
race	6	67	4626	2	race
rad	4	76	6200	2	rad
rag	4	57	6132	2	rag
rage	5	57	4235	2	rage
rah	6	80	5240	2	rah
rai	3	76	5822	2	rai
raj	10	57	4022	2	raj
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
ram	5	68	6727	2	ram
ran	3	82	6662	2	ran
rap	5	62	6196	2	rap
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
ras	3	75	7539	2	ras
rase	4	61	4998	2	rase
rat	3	78	9274	2	rat
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raw	6	72	5225	2	raw
rax	10	84	4572	2	rax
ray	6	63	6199	2	ray
raya	7	52	2482	2	raya
rayed	9	51	2750	2	rayed
rays	7	76	4235	2	rays
raze	13	52	3543	2	raze
reb	5	58	4496	2	reb
rec	5	56	4546	2	rec
red	4	67	5580	2	red
rede	5	50	3767	2	rede
redye	9	44	1347	2	redye
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
ref	6	60	5329	2	ref
reg	4	61	4649	2	reg
rei	3	56	4725	2	rei
rem	5	61	5004	2	rem
rep	5	58	4780	2	rep
res	3	55	6504	2	res
ret	3	59	8283	2	ret
rete	4	49	4413	2	rete
rev	6	53	3662	2	rev
rex	10	57	4099	2	rex
rhea	7	50	1743	2	rhea
rho	6	59	2483	2	rho
rhyme	13	47	955	2	rhyme
ria	3	67	4550	2	ria
rib	5	68	4803	2	rib
rice	6	49	4291	2	rice
rid	4	67	5462	2	rid
ride	5	59	4512	2	ride
riel	4	64	3238	2	riel
rif	6	59	5156	2	rif
rife	7	46	3232	2	rife
rig	4	67	4812	2	rig
rile	4	56	5053	2	rile
rim	5	60	5227	2	rim
rime	6	51	3888	2	rime
rin	3	66	6318	2	rin
rip	5	68	5130	2	rip
ripe	6	60	3892	2	ripe
rise	4	59	4523	2	rise
rite	4	58	4945	2	rite
rive	7	55	3772	2	rive
rob	5	67	5430	2	rob
robe	6	53	3564	2	robe
roc	5	202	4325	2	roc
rod	4	79	5389	2	rod
rode	5	58	4430	2	rode
roes	4	59	5414	2	roes
role	4	58	5182	2	role
rom	5	98	5563	2	rom
rope	6	55	4291	2	rope
rose	4	61	4890	2	rose
rot	3	72	8295	2	rot
rote	4	62	4902	2	rote
roue	4	59	4174	2	roue
rove	7	51	3698	2	rove
row	6	74	5367	2	row
rub	5	63	4282	2	rub
rube	6	55	3201	2	rube
rude	5	56	3278	2	rude
rued	5	57	2979	2	rued
ruer	4	61	2756	2	ruer
rues	4	60	4448	2	rues
rug	4	60	3915	2	rug
rule	4	99	3842	2	rule
rum	5	66	4464	2	rum
run	3	62	4498	2	run
rune	4	52	3629	2	rune
ruse	4	59	3893	2	ruse
rut	3	55	6052	2	rut
ryas	7	72	2461	2	ryas
ryked	13	66	951	2	ryked
rykes	12	55	1303	2	rykes
rynd	8	64	1410	2	rynd
ryot	7	55	2856	2	ryot
sae	3	83	6518	2	sae
see	3	57	7226	2	see
she	6	68	3769	2	she
snye	7	71	1549	2	snye
stye	7	62	1897	2	stye
sue	3	56	5146	2	sue
syce	9	58	2028	2	syce
syke	11	54	2056	2	syke
syn	6	70	2412	2	syn
syne	7	57	2576	2	syne
tae	3	82	6705	2	tae
tee	3	83	6687	2	tee
the	6	74	3605	2	the
tie	3	65	5753	2	tie
toe	3	101	6685	2	toe
tree	4	77	4581	2	tree
trey	7	72	2879	2	trey
true	4	67	2585	2	true
try	6	65	2967	2	try_
tyee	7	51	3142	2	tyee
tyer	7	53	2339	2	tyer
tyes	7	64	3337	2	tyes
tyke	11	57	2050	2	tyke
tyne	7	63	2505	2	tyne
type	9	62	2374	2	type
tyre	7	54	2825	2	tyre
uke	7	57	2729	2	uke
urge	5	47	2241	2	urge
use	3	68	3516	2	use
ute	3	53	3588	2	ute
vee	6	57	5018	2	vee
vie	6	54	4763	2	vie
voe	6	77	3905	2	voe
wae	6	75	5695	2	wae
we	5	70	4345	2	_we
wee	6	67	6081	2	wee
woe	6	66	5124	2	woe
wry	9	65	2470	2	wry_
wryer	11	48	930	2	wryer
wyes	10	57	2750	2	wyes
wyle	10	55	1938	2	wyle
wyn	9	59	2144	2	wyn
wyte	10	60	1864	2	wyte
ya	5	102	5150	2	_ya
yea	6	64	4575	2	_yea
yeh	9	71	3577	2	_yeh
yen	6	68	4738	2	_yen
yep	8	66	3896	2	_yep
yes	6	62	5061	2	_yes
yet	6	69	6069	2	_yet
yew	9	64	3629	2	_yew
yo	5	97	4855	2	_yo
zee	12	61	4323	2	zee
zyme	18	191	1494	2	zyme

Search took 1 second 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	14084	0.250	714764.0
2	DLD Change Limit	14084	314	0.343	41061.2
3	Display Results	314	314	0.080	3925.0
	(SQL Overall)	178691	314	0.673	265514.1