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

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

405 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
racoon	8	38	1447	(None)
raccoon	11	7	616	1	raccoon
racon	7	54	2214	1	rac_on
racoons	9	39	1243	1	racoons
ratoon	6	44	1737	1	ratoon
aboon	7	49	1870	2	_aboon
acorn	7	56	1662	2	_acorn
archon	11	3	1175	2	archon
baboon	10	36	1391	2	baboon
bacon	9	56	2059	2	bac_on
bradoon	10	3	735	2	bradoon
cocoon	10	3	1226	2	cocoon
coon	6	72	4894	2	__coon
dacron	9	43	1069	2	dacron
dahoon	10	3	905	2	dahoon
dragoon	9	3	528	2	dragoon
gaboon	9	32	1177	2	gaboon
lagoon	7	4	1048	2	lagoon
macon	9	45	1995	2	mac_on
macron	10	36	1567	2	macron
maroon	8	31	1820	2	maroon
raccoons	12	6	545	2	raccoons
racons	8	43	1934	2	racons
radon	6	46	2050	2	ra_don
ramson	8	3	1046	2	ramson
ration	6	42	2601	2	ration
ratoons	7	38	1547	2	ratoons
ratton	6	41	1612	2	ratton
rattoon	7	35	924	2	rattoon
rayon	8	38	1570	2	ra_yon
reckon	12	30	1054	2	reckon
recoin	8	43	2029	2	recoin
recon	7	56	2424	2	rec_on
recook	12	55	1392	2	recook
rockoon	13	4	565	2	rockoon
saloon	6	44	1802	2	saloon
tycoon	11	3	602	2	tycoon
achoo	10	3	1508	3	_achoo
acock	13	21	1021	3	_acock
acold	8	62	1493	3	_acold
acorns	8	50	1301	3	_acorns
actin	7	49	2255	3	_actin
action	8	47	1968	3	_action
actor	7	11	1608	3	_actor
adorn	6	49	1709	3	_adorn
adown	9	56	1166	3	_adown
aeon	4	56	3461	3	_a_eon
afoot	8	4	2011	3	_afoot
agon	5	65	3188	3	_a_gon
aloin	5	52	2742	3	_aloin
aloof	8	35	2157	3	_aloof
ancon	7	57	1823	3	_ancon
anion	5	50	2881	3	_anion
anon	4	61	3485	3	_a_non
anyon	8	56	1522	3	_anyon
apron	7	3	1883	3	_apron
archons	12	3	1158	3	archons
arco	6	83	3154	3	arc_o_
argon	6	55	2059	3	_argon
arson	5	51	1883	3	_arson
aswoon	9	4	701	3	aswoon
avion	8	42	1834	3	_avion
axion	12	113	1691	3	_axion
axon	11	55	2430	3	_a_xon
azlon	14	43	1287	3	_azlon
azon	13	57	2505	3	_a_zon
baboo	9	43	1950	3	baboo_
babool	10	30	1215	3	babool
baboons	11	32	1108	3	baboons
baboos	10	35	1701	3	baboos
bacons	10	49	1758	3	bacons
ballon	8	41	1749	3	ballon
balloon	9	37	1143	3	balloon
baron	7	81	3124	3	ba_ron
barracoon	13	4	330	3	~~bar~~racoon
baryon	11	12	1161	3	baryon
basion	8	43	1585	3	basion
bassoon	9	3	761	3	bassoon
baton	7	58	2242	3	ba_ton
bazoo	16	38	1567	3	bazoo_
bazoos	17	32	1262	3	bazoos
beacon	10	5	1137	3	beac_on
beckon	14	30	938	3	beckon
bicorn	10	36	1010	3	bicorn
bicron	10	37	1077	3	bicron
boon	6	71	4217	3	__boon
bracken	15	40	981	3	bracken
bradoons	11	3	676	3	bradoons
bridoon	10	4	620	3	bridoon
cacao	9	54	2000	3	cacao_
cacaos	10	46	1618	3	cacaos
cachou	13	3	1062	3	cachou
cahoot	11	4	1647	3	cahoot
cajon	14	45	1390	3	ca_jon
camion	10	39	1719	3	camion
cannon	8	45	1444	3	cannon
canon	7	47	2530	3	ca_non
canton	8	57	2299	3	canton
canyon	11	45	1203	3	canyon
capon	9	52	2187	3	ca_pon
carbon	10	49	1904	3	carbon
cardon	9	41	2085	3	cardon
cardoon	10	48	1381	3	cardoon
carton	8	45	2266	3	carton
cartoon	9	41	1446	3	cartoon
cation	8	39	2550	3	cation
chon	9	66	2779	3	__chon
cion	6	133	3091	3	__cion
clon	6	62	3248	3	__clon
cocoons	11	3	1056	3	cocoons
codon	8	65	2285	3	__codon
cogon	8	91	2090	3	__cogon
coin	6	66	4535	3	__coin
colon	7	86	3019	3	__colon
con	5	102	6802	3	__c_on
conn	6	62	2913	3	__conn
coo	5	95	6636	3	__coo_
coof	9	66	4327	3	__coof
cook	10	72	3693	3	__cook
cool	6	69	4049	3	__cool
coons	7	67	3728	3	__coons
coop	8	72	3865	3	__coop
coos	6	74	5649	3	__coos
coot	6	78	6038	3	__coot
corn	6	99	4581	3	__corn
crampon	13	3	694	3	crampon
crampoon	14	4	454	3	crampoon
craton	8	45	1719	3	cra_ton
crayon	11	41	1000	3	cra_yon
croon	7	55	2278	3	_croon
dacoit	9	4	1545	3	dacoit
dacrons	10	32	1103	3	dacrons
daemon	9	27	959	3	daemon
dahoons	11	3	775	3	dahoons
daikon	11	21	724	3	daikon
daimon	9	25	971	3	daimon
dalton	7	3	1127	3	dalton
damson	9	3	806	3	damson
deacon	9	5	1042	3	deac_on
dragon	8	3	884	3	dra_gon
dragoons	10	4	501	3	dragoons
erasion	7	3	1196	3	erasion
faction	12	26	1333	3	faction
factor	11	9	1146	3	factor
falcon	11	3	1029	3	falcon
fanion	9	45	1432	3	fanion
fanon	8	46	1901	3	fa_non
flacon	11	3	863	3	flac_on
fraction	13	5	948	3	fraction
gabion	9	32	1103	3	gabion
gaboons	10	28	990	3	gaboons
gadroon	9	3	817	3	gadroon
gallon	7	37	1581	3	gallon
galloon	8	29	1064	3	galloon
galoot	7	27	1916	3	galoot
gammon	11	3	890	3	gammon
garcon	9	29	1248	3	garcon
garron	7	31	1349	3	garron
gascon	9	33	972	3	gascon
gazoo	15	31	1287	3	gazoo_
gazoos	16	30	1022	3	gazoos
goon	5	72	3617	3	__goon
haboob	13	7	788	3	haboob
hadron	10	29	1375	3	hadron
hagdon	11	8	828	3	hagdon
halcyon	15	4	392	3	halcyon
halon	8	61	2486	3	ha_lon
harpoon	12	3	831	3	harpoon
icon	6	69	2204	3	_ic_on
jacobin	18	4	439	3	jacobin
jargon	14	4	882	3	jargon
jargoon	15	4	519	3	jargoon
kaon	8	75	2102	3	ka__on
karoo	9	25	1958	3	karoo_
karoos	10	24	1580	3	karoos
kation	10	43	1568	3	kation
kazoo	18	33	1153	3	kazoo_
kazoos	19	25	911	3	kazoos
kroon	9	45	1448	3	_kroon
lactone	9	3	1141	3	lactone
ladron	7	34	1332	3	ladron
lagoons	8	3	925	3	lagoons
lampoon	11	26	719	3	lampoon
lardon	7	44	1506	3	lardon
lardoon	8	34	1037	3	lardoon
loon	4	73	4479	3	__loon
macaroon	12	4	634	3	macaroon
macho	12	61	2015	3	macho_
machos	13	52	1749	3	machos
macons	10	40	1724	3	macons
macro	9	47	1817	3	macro_
macrons	11	35	1489	3	macrons
macros	10	40	1701	3	macros
madzoon	19	9	606	3	madzoon
mammon	9	3	964	3	mammon
maroons	9	26	1555	3	maroons
marron	8	37	1754	3	marron
mascon	10	36	1274	3	mascon
mason	7	48	2018	3	ma_son
matron	8	39	1831	3	matron
matzoon	18	9	647	3	matzoon
micron	10	37	1428	3	micron
moon	6	71	4081	3	__moon
nacho	10	54	1438	3	nacho_
nachos	11	50	1418	3	nachos
nasion	6	39	1408	3	nasion
nation	6	43	2280	3	nation
natron	6	41	1602	3	natron
neocon	8	3	671	3	neocon
noon	4	71	3462	3	__noon
oration	7	16	1771	3	oration
paction	11	27	1396	3	paction
paeon	7	48	1949	3	pa_eon
pardon	9	46	1873	3	pardon
parson	8	38	1790	3	parson
parton	8	47	2099	3	parton
patron	8	40	1804	3	patron
patroon	9	28	1197	3	patroon
platoon	9	3	895	3	platoon
pocoson	11	5	675	3	pocoson
poon	6	73	4126	3	__poon
precook	15	7	780	3	precook
precool	11	3	901	3	precool
prenoon	9	3	1004	3	prenoon
puccoon	13	4	350	3	puccoon
rabbin	10	31	1230	3	rabbin
rabboni	11	4	480	3	rabboni
race	6	67	4626	3	rac__e
raced	8	76	3531	3	rac_ed
raceme	10	3	973	3	raceme
racer	7	52	3302	3	rac_er
racers	8	47	2543	3	racers
races	7	49	4324	3	rac_es
rachet	11	50	2897	3	rachet
rachis	11	40	1765	3	rachis
racial	8	34	1924	3	racial
racier	8	51	2097	3	racier
racily	11	7	1517	3	racily
racing	9	50	3053	3	racing
racism	10	32	1419	3	racism
racist	8	28	2279	3	racist
rack	10	62	3488	3	rac__k
racked	13	45	2608	3	racked
racker	12	48	2455	3	racker
racket	12	52	2942	3	racket
racking	14	43	2366	3	racking
rackle	12	39	1729	3	rackle
racks	11	50	2885	3	rac_ks
racy	9	58	2568	3	rac__y
radian	7	41	1727	3	radian
radio	6	49	2249	3	radio_
radios	7	40	1867	3	radios
radome	9	5	1187	3	radome
radons	7	41	1853	3	radons
raglan	7	37	1150	3	raglan
ragman	9	40	1371	3	ragman
ragmen	9	37	1218	3	ragmen
ragout	7	3	1718	3	ragout
ragtop	9	3	668	3	ragtop
rain	4	62	5173	3	ra__in
raisin	6	27	1692	3	raisin
ramen	7	56	2519	3	ra_men
ramona	8	4	1241	3	ramona
ramose	8	3	1440	3	ramose
ramous	8	4	1711	3	ramous
rampion	11	29	858	3	rampion
ramrod	9	3	683	3	ramrod
ramsons	9	3	956	3	ramsons
ran	3	82	6662	3	ra___n
rancho	11	43	1085	3	rancho_
ranchos	12	39	1139	3	ranchos
rancor	8	8	1037	3	rancor
rancors	9	8	1137	3	rancors
rancour	9	8	713	3	rancour
randan	7	3	1525	3	randan
random	9	25	1355	3	random
ransom	8	24	1094	3	ransom
rappen	10	35	1271	3	rappen
raptor	8	39	1282	3	raptor
ratan	5	37	2266	3	ra_tan
ratio	5	52	2758	3	ratio_
rations	7	41	2343	3	rations
ratios	6	49	2267	3	ratios
ratlin	6	41	1652	3	ratlin
rato	4	54	3697	3	ra_to_
ratooned	9	7	710	3	ratooned
ratooner	8	8	700	3	ratooner
ratos	5	55	2876	3	ra_tos
rattan	6	36	1360	3	rattan
ratten	6	42	1738	3	ratten
rattons	7	38	1532	3	rattons
rattoons	8	32	751	3	rattoons
raucous	9	3	830	3	raucous
raven	8	47	2344	3	ra_ven
ravin	8	56	2465	3	ra_vin
rawin	8	55	2147	3	ra_win
rayons	9	41	1334	3	rayons
razor	14	30	1260	3	ra_zor
razors	15	47	1166	3	razors
reaction	10	6	1260	3	reaction
reactor	9	30	1166	3	reactor
readorn	8	3	1048	3	readorn
reason	6	26	1633	3	reason
rebook	12	52	1320	3	rebook
reboot	8	41	1933	3	reboot
reborn	8	100	1696	3	reborn
reckons	13	26	965	3	reckons
recoal	8	41	1797	3	recoal
recoat	8	40	2427	3	recoat
recock	14	51	1272	3	recock
recode	9	36	1871	3	recode
recoil	8	40	1672	3	recoil
recoins	9	40	1924	3	recoins
recolor	9	7	869	3	recolor
recomb	12	3	887	3	recomb
recons	8	49	2299	3	recons
recooks	13	47	1123	3	recooks
recopy	13	3	904	3	recopy
record	9	61	1743	3	record
recork	12	63	1549	3	recork
recount	9	3	1517	3	recount
recoup	10	8	1037	3	recoup
recrown	12	25	757	3	recrown
recto	7	45	2080	3	recto_
rector	8	40	1975	3	rector
rectos	8	57	1878	3	rectos
redon	6	54	2488	3	r_edon
region	7	46	1490	3	region
rejoin	13	40	1224	3	rejoin
reloan	6	4	1569	3	reloan
relook	10	48	1374	3	relook
renown	9	36	998	3	renown
reroof	9	3	1500	3	reroof
resown	9	41	1292	3	resown
retook	10	43	1344	3	retook
retool	6	39	1448	3	retool
retorn	6	109	2343	3	retorn
rewon	8	69	2058	3	r_ewon
reworn	9	81	2220	3	reworn
rhyton	12	35	611	3	rhyton
ribbon	10	3	653	3	ribbon
richen	11	38	1251	3	richen
ricin	7	46	2021	3	ric_in
rigadoon	10	4	319	3	rigadoon
roan	4	72	3420	3	r__oan
rockoons	14	4	500	3	rockoons
rococo	10	3	681	3	rococo
rococos	11	4	590	3	rococos
ronion	6	33	1564	3	ronion
ronyon	9	30	913	3	ronyon
rood	5	67	3300	3	r__ood
roof	7	57	3883	3	r__oof
rook	8	55	3203	3	r__ook
room	6	62	3508	3	r__oom
root	4	56	5592	3	r__oot
ruction	9	36	1161	3	ruction
sacaton	9	3	899	3	sacaton
salmon	8	46	1418	3	salmon
salon	5	52	2855	3	sa_lon
saloons	7	44	1532	3	saloons
saloop	8	42	1258	3	saloop
scion	7	22	1499	3	_scion
scoop	9	56	1716	3	_scoop
scoot	7	57	2915	3	_scoot
scorn	7	58	1745	3	_scorn
shoon	8	40	2201	3	_shoon
simoon	8	5	806	3	simoon
soon	4	62	4050	3	__soon
spoon	7	47	1944	3	_spoon
swoon	8	50	1478	3	_swoon
taboo	7	34	1809	3	taboo_
taboos	8	38	1543	3	taboos
tachyon	15	4	462	3	tachyon
taco	6	70	3135	3	tac_o_
tacos	7	70	2355	3	tac_os
taction	9	32	1302	3	taction
talion	6	3	1771	3	talion
talon	5	58	2411	3	ta_lon
tampon	10	29	1123	3	tampon
tarpon	8	28	1280	3	tarpon
tauon	5	48	1658	3	ta_uon
taxon	12	44	1466	3	ta_xon
toon	4	77	4063	3	__toon
traction	10	4	1268	3	traction
tractor	9	3	1134	3	tractor
tricorn	9	3	796	3	tricorn
tycoons	12	3	517	3	tycoons
uncool	8	6	1011	3	uncool
varoom	11	4	1141	3	varoom
wacko	14	55	1438	3	wacko_
wackos	15	52	1099	3	wackos
waggon	11	3	639	3	waggon
wagon	9	43	1295	3	wa_gon
wahoo	11	24	1308	3	wahoo_
wahoos	12	23	1059	3	wahoos
wanion	9	32	1306	3	wanion
wanton	9	44	1381	3	wanton
wazoo	17	30	1117	3	wazoo_
wazoos	18	28	855	3	wazoos
yahoo	11	29	1154	3	yahoo_
yahoos	12	20	924	3	yahoos
yapon	10	46	1358	3	ya_pon
yaupon	11	34	549	3	yaupon
zacaton	18	4	563	3	zacaton
zoon	13	73	2698	3	__zoon

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	405	5.000	22543.2
3	Display Results	405	405	0.143	2832.2
	(SQL Overall)	178691	405	5.516	32395.0