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

Here are the results of your fuzzy-string dictionary search for “gobony” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

327 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
gobony	12	3	691	(None)
goony	9	55	1978	1	go_ony
bony	9	67	3208	2	__bony
colony	11	54	1727	2	colony
ebony	10	45	1151	2	_ebony
goban	8	44	1407	2	goban_
gobang	10	37	670	2	gobang
gobans	9	44	1204	2	gobans
gobo	7	61	2690	2	gobo__
goboes	9	59	1444	2	goboes
gobonee	10	7	778	2	gobonee
gobos	8	62	1938	2	gobo_s
goby	10	60	2108	2	gob__y
goody	10	56	2039	2	go_ody
gooey	9	55	2286	2	go_oey
goofy	12	49	1562	2	go_ofy
gooky	13	58	1803	2	go_oky
goon	5	72	3617	2	go_on_
gooney	10	66	1231	2	go_oney
goons	6	53	2677	2	go_ons
goopy	11	58	1662	2	go_opy
goosy	9	60	1888	2	go_osy
gowany	13	45	749	2	gowany
loony	8	69	1896	2	lo_ony
moony	10	48	1827	2	mo_ony
nobody	12	3	574	2	nobody
poboy	12	16	1222	2	pobo_y
aboon	7	49	1870	3	aboon_
agony	9	64	1565	3	_agony
astony	9	5	1052	3	astony
atony	8	72	1885	3	_atony
barony	11	59	1530	3	barony
betony	11	42	1158	3	betony
bobby	11	48	1466	3	bob_by
body	10	74	2567	3	__body
bogy	10	64	2619	3	__bogy
boloney	12	4	776	3	boloney
bonbon	10	3	1007	3	bonbon_
bonbons	11	3	933	3	bonbons
bond	7	53	3436	3	__bond
bone	6	59	4932	3	__bone
boney	10	52	2731	3	__boney
bong	7	56	3341	3	__bong
bonk	10	55	3171	3	__bonk
bonny	10	58	1662	3	bo_nny
booby	12	53	1951	3	bo_oby
boody	11	54	2040	3	bo_ody
boogy	11	45	1832	3	bo_ogy
boomy	12	54	2182	3	bo_omy
boon	6	71	4217	3	bo_on_
boons	7	50	3191	3	bo_ons
booty	10	61	2591	3	bo_oty
boozy	19	49	1706	3	bo_ozy
boron	7	67	2714	3	boron_
borons	8	55	2054	3	borons
bosomy	13	50	903	3	bosomy
boson	7	60	1973	3	boson_
bosons	8	50	1665	3	bosons
botany	11	3	926	3	botany
boxy	16	64	2073	3	__boxy
boy	8	77	5356	3	__bo_y
briony	11	4	904	3	briony
bryony	14	3	583	3	bryony
cobby	14	55	1641	3	cob_by
codon	8	65	2285	3	codon_
codons	9	61	1946	3	codons
cogon	8	91	2090	3	cogon_
cogons	9	68	1811	3	cogons
colon	7	86	3019	3	colon_
colone	8	54	2500	3	colone
coloni	8	56	1920	3	coloni
colons	8	60	2868	3	colons
compony	16	130	1191	3	compony
cony	9	65	3783	3	__cony
cooey	10	58	2822	3	co_oey
cooky	14	53	2136	3	co_oky
cooly	10	55	2542	3	co_oly
coon	6	72	4894	3	co_on_
coons	7	67	3728	3	co_ons
corny	10	60	2327	3	co_rny
corody	12	14	970	3	corody
corona	8	38	1740	3	corona
cottony	12	3	725	3	cottony
cowboy	16	3	706	3	cowbo_y
crony	10	59	1867	3	_crony
debone	9	37	1478	3	debone
dobby	13	60	1363	3	dob_by
doblon	9	3	801	3	doblon_
doblons	10	3	704	3	doblons
dobson	9	3	659	3	dobson_
dobsons	10	3	620	3	dobsons
doby	10	60	2216	3	dob__y
doody	10	55	1791	3	do_ody
dooly	9	48	2180	3	do_oly
doomy	11	60	1826	3	do_omy
doozy	18	68	1371	3	do_ozy
downy	12	57	1455	3	do_wny
ebon	6	68	2110	3	_ebon_
ebons	7	43	1609	3	_ebons
embody	14	3	503	3	embody
emboly	13	3	672	3	emboly
eobiont	9	5	994	3	eobiont
felony	12	37	1032	3	felony
footy	11	58	2053	3	fo_oty
gabby	13	55	1295	3	gab_by
gabion	9	32	1103	3	gabion_
gabions	10	24	1005	3	gabions
gaboon	9	32	1177	3	gaboon
gaboons	10	28	990	3	gaboons
gaby	10	71	2319	3	gab__y
geobotany	15	5	173	3	geobotany
geology	12	25	732	3	geology
gibbon	11	3	532	3	gibbon_
gibbons	12	3	498	3	gibbons
gibing	10	37	1235	3	gibing
gibson	9	3	512	3	gibson_
gibsons	10	4	504	3	gibsons
ginny	9	53	1457	3	g_inny
gipon	8	42	1241	3	gipon_
gipons	9	38	960	3	gipons
giron	6	61	1899	3	giron_
girons	7	50	1437	3	girons
globby	14	3	468	3	glob_by
globin	9	30	972	3	globin_
globing	11	32	1000	3	globing
globins	10	27	895	3	globins
globoid	11	4	597	3	globoid
globose	10	3	554	3	globose
globous	10	3	650	3	globous
gloomy	12	52	876	3	gloomy
glory	9	64	1329	3	g_lory
gluon	6	3	1122	3	gluon_
gluons	7	3	850	3	gluons
gnomon	9	3	618	3	gnomon_
gnomons	10	3	575	3	gnomons
goanna	7	3	665	3	goanna
gob	6	89	5089	3	gob___
gobangs	11	38	583	3	gobangs
gobbed	12	46	1388	3	gobbed
gobbet	11	42	1444	3	gobbet
gobbing	13	29	1070	3	gobbing
gobble	11	35	1298	3	gobble
gobies	9	54	1806	3	gobies
gobioid	11	4	602	3	gobioid
goblet	9	32	1948	3	goblet
goblin	9	3	950	3	goblin
goblins	10	3	924	3	goblins
gobs	7	69	3557	3	gob__s
godly	10	49	1329	3	go_dly
godown	11	3	603	3	godown
godowns	12	3	467	3	godowns
godson	8	5	738	3	godson_
godsons	9	6	666	3	godsons
goggly	12	33	705	3	goggly
gogo	6	97	2283	3	gogo__
gogos	7	75	1652	3	gogo_s
going	7	52	1849	3	go_ing
golly	9	51	2110	3	go_lly
golosh	10	3	646	3	golosh
gombo	10	58	1404	3	gombo__
gombos	11	43	1109	3	gombo_s
gone	5	56	3904	3	g__one
gong	6	68	2719	3	g__ong
gonion	7	36	1283	3	gonion_
gonof	9	52	1865	3	gono_f
gonofs	10	45	986	3	gonofs
gonoph	12	3	540	3	gonoph
goo	4	77	5477	3	go_o__
goober	9	39	1174	3	goober
good	6	65	3180	3	go_o_d
goodby	13	40	628	3	goodby
goodly	11	41	930	3	goodly
goods	7	51	2448	3	go_ods
goof	8	54	3687	3	go_o_f
goofs	9	48	2100	3	go_ofs
googly	11	41	788	3	googly
gook	9	64	2960	3	go_o_k
gooks	10	54	2288	3	go_oks
gooneys	11	40	707	3	go_oneys
goonie	7	36	1556	3	go_onie
goop	7	58	2948	3	go_o_p
goops	8	66	2096	3	go_ops
goos	5	76	4491	3	go_o_s
goose	6	59	2590	3	go_ose
goosey	10	59	1351	3	goosey
gorgon	8	3	1024	3	gorgon_
gorgons	9	3	885	3	gorgons
gorily	10	6	1250	3	gorily
goring	8	41	1957	3	goring
gorsy	9	59	1578	3	go_rsy
gory	8	61	2966	3	g__ory
gouty	9	52	1736	3	go_uty
gowan	9	54	1574	3	gowan_
gowans	10	55	1229	3	gowans
gown	8	57	2407	3	go_wn_
gowns	9	51	1510	3	go_wns
goy	7	78	4455	3	g__o_y
grainy	10	39	1421	3	grainy
granny	10	43	1116	3	granny
greeny	10	48	1145	3	greeny
grody	10	34	1206	3	g_rody
groovy	13	37	540	3	groovy
gunny	9	44	1366	3	g_unny
gybing	13	35	593	3	gybing
gyron	9	53	1462	3	gyron_
gyrons	10	55	1122	3	gyrons
hobby	15	59	1373	3	hob_by
hobnob	13	3	513	3	hobnob
hobo	9	70	2608	3	hobo__
hoboed	12	45	1168	3	hoboed
hoboes	11	47	1744	3	hoboes
hoboing	13	30	945	3	hoboing
hobos	10	63	2135	3	hobo_s
hominy	14	45	1148	3	hominy
homonym	17	4	525	3	homonym
hoody	12	49	1972	3	ho_ody
hooey	11	49	2660	3	ho_oey
hooky	15	52	2026	3	ho_oky
hooly	11	50	2222	3	ho_oly
hooty	11	50	2244	3	ho_oty
horny	11	56	1962	3	ho_rny
imbody	14	3	411	3	imbody
incony	11	3	908	3	incony
ionone	6	3	1344	3	ionone
irony	8	50	1590	3	_irony
isogony	11	21	545	3	isogony
johnny	19	3	219	3	johnny
jomon	14	6	1008	3	jomon_
kobo	10	74	2210	3	kobo__
kobold	13	6	596	3	kobold
kobos	11	56	1689	3	kobo_s
kooky	11	44	1287	3	ko_oky
koruny	13	3	444	3	koruny
lemony	11	41	955	3	lemony
lobby	12	51	1392	3	lob_by
lobo	6	72	2986	3	lobo__
lobos	7	59	2184	3	lobo_s
logon	6	159	2231	3	logon_
logons	7	98	1817	3	logons
looby	10	81	1562	3	lo_oby
looey	8	48	2291	3	lo_oey
loon	4	73	4479	3	lo_on_
looney	9	47	1241	3	lo_oney
loons	5	57	3172	3	lo_ons
loopy	10	53	1664	3	lo_opy
lowboy	14	3	590	3	lowbo_y
monody	12	3	824	3	monody
mony	9	68	3001	3	__mony
moody	11	50	1749	3	mo_ody
moon	6	71	4081	3	mo_on_
moons	7	53	3100	3	mo_ons
moory	10	51	1579	3	mo_ory
moron	7	69	2542	3	moron_
morons	8	49	1954	3	morons
nobby	12	55	1346	3	nob_by
nobly	10	53	1440	3	nob_ly
nonbody	13	4	482	3	nonbody
nooky	12	48	1481	3	no_oky
noon	4	71	3462	3	no_on_
noons	5	41	2528	3	no_ons
obey	9	65	2130	3	_ob_ey
oblong	9	3	538	3	_oblong
oboe	6	68	2294	3	_obo_e
oboes	7	57	1771	3	_oboes
obol	6	52	2061	3	_obo_l
obole	7	59	1714	3	_obole
oboli	7	37	1287	3	_oboli
obols	7	37	1586	3	_obols
ology	9	41	1311	3	_ology
oniony	9	36	970	3	oniony
oogeny	10	11	792	3	oogeny
oology	10	32	1025	3	oology
oolong	7	3	807	3	oolong
oozy	16	70	1813	3	_o_ozy
ozone	14	3	1061	3	_ozone
peony	10	57	1756	3	_peony
phony	13	67	1544	3	_phony
poboys	13	9	731	3	poboys
pony	9	64	3405	3	__pony
poofy	13	62	1327	3	po_ofy
poon	6	73	4126	3	po_on_
poons	7	54	3097	3	po_ons
porny	10	60	2019	3	po_rny
potboy	13	9	781	3	potbo_y
rebody	12	3	815	3	rebody
ribbony	14	4	354	3	ribbony
roband	9	23	1072	3	roband
robin	7	48	2028	3	robin_
robing	9	36	1800	3	robing
robins	8	36	1745	3	robins
robot	7	3	2597	3	robo_t
robotry	12	4	417	3	robotry
robots	8	3	1315	3	robots
rooky	12	61	1762	3	ro_oky
roomy	10	71	1806	3	ro_omy
rooty	8	64	2302	3	ro_oty
rosiny	9	44	1453	3	rosiny
saxony	16	3	623	3	saxony
simony	11	3	790	3	simony
sodomy	12	7	667	3	sodomy
solon	5	50	2613	3	solon_
solons	6	51	2002	3	solons
somoni	8	3	1074	3	somoni
sonny	8	50	1610	3	so_nny
sooey	8	45	2243	3	so_oey
soon	4	62	4050	3	so_on_
sooty	8	49	2484	3	so_oty
spoony	11	41	1179	3	spoony
stony	8	58	1864	3	_stony
swoony	12	40	826	3	swoony
toby	9	63	2229	3	tob__y
tomboy	13	5	821	3	tombo_y
tony	7	56	3515	3	__tony
toon	4	77	4063	3	to_on_
toons	5	50	2753	3	to_ons
toponym	14	4	516	3	toponym
towny	11	61	1449	3	to_wny
toyon	8	67	1567	3	toyon_
toyons	9	55	1213	3	toyons
wobbly	16	34	709	3	wobbly
woody	12	51	1688	3	wo_ody
wooly	11	44	1767	3	wo_oly
woozy	20	44	1060	3	wo_ozy
zooey	17	39	1480	3	zo_oey
zoon	13	73	2698	3	zo_on_
zoons	14	49	1969	3	zo_ons
zooty	17	54	1535	3	zo_oty

Search took 6 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	112716	0.373	479064.3
2	DLD Change Limit	112716	327	5.313	21215.1
3	Display Results	327	327	0.110	2972.7
	(SQL Overall)	178691	327	5.796	30830.1