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

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

290 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
gory	8	61	2966	(None)
cory	9	69	4151	1	cory
dory	8	58	3623	1	dory
glory	9	64	1329	1	glory
goby	10	60	2108	1	goby
gor	4	78	4826	1	gor_
gore	5	57	4496	1	gore
gorm	7	55	2939	1	gorm
gorp	7	56	2590	1	gorp
gorsy	9	59	1578	1	gorsy
goy	7	78	4455	1	go_y
lory	7	59	3171	1	lory
tory	7	58	4054	1	tory
aery	7	72	3168	2	aery
agony	9	64	1565	2	agony
agora	6	9	1433	2	agora
airy	7	57	3415	2	airy
awry	10	76	1968	2	awry
body	10	74	2567	2	body
bogy	10	64	2619	2	bogy
bony	9	67	3208	2	bony
bora	6	61	4163	2	bora
bore	6	60	5133	2	bore
bork	10	69	3382	2	bork
born	6	73	3841	2	born
bort	6	59	6096	2	bort
borty	10	55	2283	2	borty
boxy	16	64	2073	2	boxy
boy	8	77	5356	2	bo_y
bury	9	56	3359	2	bury
coky	13	75	2682	2	coky
coly	9	69	4053	2	coly
cony	9	65	3783	2	cony
copy	11	62	2980	2	copy
cor	5	99	6094	2	cor_
corby	12	50	1853	2	corby
cord	7	67	4092	2	cord
core	6	72	6311	2	core
corf	9	59	4148	2	corf
cork	10	66	3569	2	cork
corky	14	52	2115	2	corky
corm	8	57	3537	2	corm
corn	6	99	4581	2	corn
corny	10	60	2327	2	corny
cors	6	66	5644	2	cors
cosy	9	72	3270	2	cosy
cowry	13	55	1248	2	cowry
cowy	12	64	2736	2	cowy
coy	8	105	5755	2	co_y
cozy	18	58	2380	2	cozy
cry	8	97	2624	2	_cry
doby	10	60	2216	2	doby
dogy	9	61	2649	2	dogy
dopy	10	62	2415	2	dopy
dor	4	72	5392	2	dor_
dore	5	63	5330	2	dore
dork	9	65	3146	2	dork
dorky	13	55	1874	2	dorky
dorm	7	68	3463	2	dorm
dormy	11	58	1747	2	dormy
dorp	7	60	2805	2	dorp
dorr	5	66	2772	2	dorr
dors	5	67	4760	2	dors
dorty	9	62	2081	2	dorty
doty	8	61	2822	2	doty
dowry	12	63	1248	2	dowry
doxy	15	64	1995	2	doxy
dozy	17	59	2032	2	dozy
dry	7	65	2603	2	_dry
eery	7	61	2962	2	eery
eyry	10	63	1588	2	eyry
fogy	11	59	2318	2	fogy
for	6	69	5207	2	for_
fora	7	59	3739	2	fora
foray	11	50	2397	2	foray
forb	9	71	3133	2	forb
forby	13	53	1767	2	forby
ford	8	68	3549	2	ford
fore	7	83	5147	2	fore
fork	11	59	3094	2	fork
forky	15	61	1964	2	forky
form	9	58	3687	2	form
fort	7	64	5644	2	fort
forty	11	48	2427	2	forty
foxy	17	65	1775	2	foxy
foy	9	60	4426	2	fo_y
fozy	19	70	1716	2	fozy
fry	9	62	2650	2	_fry
fury	10	77	2797	2	fury
gaby	10	71	2319	2	gaby
gamy	10	54	2753	2	gamy
gapy	10	63	2091	2	gapy
gar	4	72	5990	2	gar_
garb	7	53	3267	2	garb
gars	5	57	5074	2	gars
gay	7	68	5649	2	g_ay
germ	7	54	2896	2	germ
germy	11	51	1366	2	germy
gey	7	57	3830	2	g_ey
gird	6	54	2499	2	gird
girl	5	62	2655	2	girl
girly	9	44	1529	2	girly
girn	5	60	2686	2	girn
giro	5	58	2863	2	giro
girt	5	66	4642	2	girt
glary	9	60	1854	2	glary
gley	8	57	2465	2	gley
go	3	87	4874	2	go__
goa	4	73	4380	2	go_a
goad	6	68	3098	2	goad
goal	5	58	2930	2	goal
goas	5	52	3994	2	goas
goat	5	62	5083	2	goat
gob	6	89	5089	2	go_b
gobo	7	61	2690	2	gobo
gobs	7	69	3557	2	gobs
god	5	74	4979	2	go_d
godly	10	49	1329	2	godly
gods	6	54	3804	2	gods
goer	5	68	2710	2	goer
goers	6	55	2025	2	goers
goes	5	56	4409	2	goes
gogo	6	97	2283	2	gogo
gold	6	54	3016	2	gold
golf	8	57	3118	2	golf
golly	9	51	2110	2	golly
gone	5	56	3904	2	gone
gong	6	68	2719	2	gong
goo	4	77	5477	2	go_o
good	6	65	3180	2	good
goody	10	56	2039	2	goody
gooey	9	55	2286	2	gooey
goof	8	54	3687	2	goof
goofy	12	49	1562	2	goofy
gook	9	64	2960	2	gook
gooky	13	58	1803	2	gooky
goon	5	72	3617	2	goon
goony	9	55	1978	2	goony
goop	7	58	2948	2	goop
goopy	11	58	1662	2	goopy
goos	5	76	4491	2	goos
goosy	9	60	1888	2	goosy
goral	6	51	2575	2	goral
gored	7	52	2708	2	gored
gores	6	57	4037	2	gores
gorge	7	64	2389	2	gorge
gorily	10	6	1250	2	gorily
gorms	8	56	1959	2	gorms
gorps	8	53	1699	2	gorps
gorse	6	59	2681	2	gorse
gos	4	71	5513	2	go_s
gosh	8	61	2342	2	gosh
got	4	98	7044	2	go_t
goth	8	68	2508	2	goth
gourd	7	10	1190	2	gourd
gout	5	66	4600	2	gout
gouty	9	52	1736	2	gouty
gowd	9	65	1998	2	gowd
gowk	12	55	1647	2	gowk
gown	8	57	2407	2	gown
gox	11	71	3718	2	go_x
goys	8	63	2841	2	goys
gray	8	53	2989	2	gray
grey	8	56	2404	2	grey
grody	10	34	1206	2	grody
grog	6	59	2334	2	grog
grok	9	58	1968	2	grok
grot	5	59	4205	2	grot
grow	8	61	2730	2	grow
gurry	9	45	1541	2	gurry
guru	5	46	2391	2	guru
guy	7	57	2894	2	g_uy
gyre	8	47	2276	2	gyre
gyri	8	54	1515	2	gyri
gyro	8	52	1788	2	gyro
hoary	11	45	1676	2	hoary
holy	10	63	3343	2	holy
homy	12	66	2322	2	homy
hora	7	61	3656	2	hora
horn	7	67	3561	2	horn
horny	11	56	1962	2	horny
horsy	11	63	1839	2	horsy
hoy	9	74	4791	2	ho_y
ivory	11	3	737	2	ivory
joey	14	57	1933	2	joey
joky	18	62	1531	2	joky
joy	13	70	3636	2	jo_y
jury	14	67	1959	2	jury
kor	7	65	3889	2	kor_
kora	8	64	3155	2	kora
kore	8	58	3416	2	kore
kors	8	59	3301	2	kors
logy	8	70	2578	2	logy
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
lorn	4	64	3525	2	lorn
lorry	8	63	1567	2	lorry
loury	8	57	1675	2	loury
miry	9	63	2675	2	miry
moly	9	60	3191	2	moly
mony	9	68	3001	2	mony
moory	10	51	1579	2	moory
mopy	11	57	2197	2	mopy
mor	5	68	5500	2	mor_
mora	6	66	4127	2	mora
moray	10	54	2379	2	moray
more	6	71	5452	2	more
morn	6	62	3756	2	morn
mors	6	59	5006	2	mors
mort	6	67	5883	2	mort
nary	7	69	3122	2	nary
nor	3	80	4882	2	nor_
nori	4	71	3314	2	nori
norm	6	64	2981	2	norm
nosy	7	63	2289	2	nosy
ogre	5	63	2074	2	ogre
oozy	16	70	1813	2	oozy
or	2	73	5473	2	_or_
ora	3	72	5083	2	_ora
orb	5	57	3686	2	_orb
orby	9	75	1960	2	_orby
orc	5	70	3492	2	_orc
ore	3	66	6183	2	_ore
orgy	8	52	1800	2	_orgy
ors	3	57	5011	2	_ors
ort	3	94	6523	2	_ort
oryx	14	5	1021	2	_oryx
oxy	13	63	2098	2	_oxy
oy	5	89	5013	2	_o_y
pogy	10	56	2355	2	pogy
poky	13	59	2215	2	poky
poly	9	62	3515	2	poly
pony	9	64	3405	2	pony
pore	6	64	5126	2	pore
porgy	11	69	1612	2	porgy
pork	10	69	2968	2	pork
porky	14	50	1933	2	porky
porn	6	56	3602	2	porn
porny	10	60	2019	2	porny
port	6	60	5963	2	port
posy	9	60	2842	2	posy
poxy	16	68	2089	2	poxy
pry	8	57	2805	2	_pry
ropy	9	63	2341	2	ropy
rosy	7	60	2487	2	rosy
scry	9	60	1776	2	scry
sora	4	57	4691	2	sora
sorb	6	83	3304	2	sorb
sord	5	62	3720	2	sord
sore	4	70	5953	2	sore
sori	4	60	3984	2	sori
sorn	4	66	4106	2	sorn
sorry	8	46	1825	2	sorry
sort	4	62	6481	2	sort
soy	6	78	5145	2	so_y
spry	9	68	1912	2	spry
story	8	67	2303	2	story
toby	9	63	2229	2	toby
tody	8	63	2721	2	tody
tony	7	56	3515	2	tony
tor	3	92	6168	2	tor_
tora	4	75	4599	2	tora
torc	6	63	3335	2	torc
tore	4	73	5932	2	tore
tori	4	75	4215	2	tori
torn	4	60	4425	2	torn
toro	4	80	4568	2	toro
torr	4	56	3090	2	torr
tors	4	61	5738	2	tors
tort	4	69	6746	2	tort
towy	10	53	2547	2	towy
toy	6	96	5519	2	to_y
troy	7	74	2968	2	troy
try	6	65	2967	2	_try
vary	10	52	2606	2	vary
very	10	80	2564	2	very
wary	10	67	4001	2	wary
wiry	10	64	2283	2	wiry
word	8	98	3200	2	word
wordy	12	69	1616	2	wordy
wore	7	71	4467	2	wore
work	11	55	2884	2	work
worm	9	61	2948	2	worm
wormy	13	75	1425	2	wormy
worn	7	56	3175	2	worn
worry	11	61	1433	2	worry
wort	7	66	5475	2	wort
wry	9	65	2470	2	_wry
yore	7	63	3594	2	yore
zori	13	77	2292	2	zori

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.140	1276364.3
2	DLD Change Limit	29872	290	1.720	17367.4
3	Display Results	290	290	0.123	2357.7
	(SQL Overall)	178691	290	1.983	90111.4