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

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

399 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
crayon	11	41	1000	(None)
craton	8	45	1719	1	craton
crayons	12	43	923	1	crayons
rayon	8	38	1570	1	_rayon
baryon	11	12	1161	2	baryon
cajon	14	45	1390	2	c_ajon
canon	7	47	2530	2	c_anon
canyon	11	45	1203	2	canyon
capon	9	52	2187	2	c_apon
carbon	10	49	1904	2	carbon
cardon	9	41	2085	2	cardon
carryon	12	3	703	2	carryon
carton	8	45	2266	2	carton
claxon	15	3	658	2	claxon
crampon	13	3	694	2	crampon
cratons	9	43	1603	2	cratons
craven	11	41	1393	2	craven
crayoned	14	3	500	2	crayoned
crayoner	13	4	486	2	crayoner
crepon	10	3	994	2	crepon
croon	7	55	2278	2	cr_oon
croton	8	44	1545	2	croton
dragon	8	3	884	2	dragon
racon	7	54	2214	2	_racon
radon	6	46	2050	2	_radon
rayons	9	41	1334	2	_rayons
acrasin	9	3	1122	3	acrasin
aeon	4	56	3461	3	__aeon
agon	5	65	3188	3	__agon
amazon	17	3	683	3	amazon
anon	4	61	3485	3	__anon
anyon	8	56	1522	3	_anyon
archon	11	3	1175	3	archon
argon	6	55	2059	3	ar_gon
arson	5	51	1883	3	ar_son
axon	11	55	2430	3	__axon
ayin	7	63	3174	3	__ayin
azon	13	57	2505	3	__azon
bacon	9	56	2059	3	_bacon
baron	7	81	3124	3	_baron
baryons	12	10	1047	3	baryons
baryton	12	4	600	3	baryton
baton	7	58	2242	3	_baton
bayou	10	5	1236	3	_bayou
beacon	10	5	1137	3	beacon
blazon	17	3	676	3	blazon
bradoon	10	3	735	3	bradoon
brain	7	62	2938	3	bra_in
bran	6	57	4038	3	bra__n
bravo	10	52	1434	3	bravo_
bravos	11	47	1140	3	bravos
brawn	10	60	1856	3	bra_wn
bray	9	52	3290	3	bray__
brayed	12	46	1578	3	brayed
brayer	11	53	1531	3	brayer
braying	13	44	1631	3	braying
brays	10	67	2311	3	bray_s
brazen	17	48	1245	3	brazen
bryony	14	3	583	3	br_yony
cabin	9	48	2094	3	c_abin
cabob	11	46	1681	3	c_abob
cahow	13	51	1094	3	c_ahow
cain	6	56	4391	3	c_a_in
cairn	7	57	1751	3	c_airn
calo	6	49	3644	3	c_alo_
calos	7	44	3190	3	c_alos
camion	10	39	1719	3	camion
camo	8	57	3175	3	c_amo_
camos	9	59	2761	3	c_amos
can	5	77	6014	3	c_a__n
cannon	8	45	1444	3	cannon
canoe	7	56	2725	3	c_anoe
canons	8	55	2206	3	c_anons
canton	8	57	2299	3	canton
canyons	12	45	1159	3	canyons
capo	8	58	2921	3	c_apo_
capons	10	41	1950	3	c_apons
capos	9	48	2607	3	c_apos
carabin	11	3	1321	3	carabin
caracol	11	3	1042	3	caracol
caravan	12	3	923	3	caravan
carbo	9	49	2384	3	carbo_
carbons	11	54	1894	3	carbons
carbos	10	51	2226	3	carbos
carboy	13	49	1418	3	carboy
cardamon	13	4	555	3	cardamon
cardons	10	45	1994	3	cardons
cardoon	10	48	1381	3	cardoon
careen	8	41	1949	3	careen
cargo	8	53	2207	3	cargo_
cargos	9	46	1918	3	cargos
carhop	13	36	1076	3	carhop
carlin	8	44	2182	3	carlin
carman	10	39	2076	3	carman
carmen	10	40	1935	3	carmen
carn	6	62	4543	3	c_a_rn
carob	9	53	2522	3	c_arob
carol	7	51	2861	3	c_arol
carom	9	50	2556	3	c_arom
carrion	9	3	1267	3	carrion
carrom	10	5	1340	3	carrom
carrot	8	4	2312	3	carrot
carryons	13	3	710	3	carryons
cartons	9	41	2247	3	cartons
cartoon	9	41	1446	3	cartoon
cartop	10	42	1356	3	cartop
carven	11	47	1666	3	carven
caryotin	13	26	835	3	caryotin
cation	8	39	2550	3	cation
cay	8	71	5598	3	c_ay__
cayman	13	36	1322	3	c_ayman
cays	9	54	3767	3	c_ay_s
celadon	10	3	691	3	celadon
ceratin	9	30	2016	3	ceratin
chador	12	3	867	3	chador
chain	10	57	2367	3	cha_in
chalone	12	3	1210	3	chalone
chalot	11	30	2013	3	chalot
chanson	12	3	804	3	chanson
chao	9	57	2731	3	cha_o_
chaos	10	56	2286	3	cha_os
chay	12	49	2487	3	chay__
chayote	15	3	649	3	chayote
chays	13	53	1974	3	chay_s
chazan	20	26	913	3	chazan
chiton	11	26	1239	3	chiton
chon	9	66	2779	3	c__hon
chronon	12	3	735	3	chronon
ciao	6	49	2419	3	cia_o_
cion	6	133	3092	3	c__ion
citron	8	31	1298	3	citron
clamor	10	4	945	3	clamor
clan	6	56	3392	3	cla__n
clarion	9	3	1166	3	clarion
claro	7	50	1869	3	claro_
claros	8	40	1511	3	claros
classon	9	3	769	3	classon
claxons	16	3	580	3	claxons
clay	9	59	2741	3	clay__
clayed	12	50	1304	3	clayed
clayey	14	40	766	3	clayey
claying	13	36	1430	3	claying
claypan	14	3	431	3	claypan
clays	10	55	2133	3	clay_s
clon	6	62	3248	3	c__lon
cocoon	10	3	1226	3	cocoon
codon	8	65	2285	3	c_odon
cogon	8	91	2090	3	c_ogon
colon	7	86	3019	3	c_olon
common	12	3	1080	3	common
con	5	102	6802	3	c___on
coon	6	72	4894	3	c__oon
cordon	9	50	1729	3	cordon
cotton	8	3	1299	3	cotton
coupon	10	28	1099	3	coupon
craal	7	41	1775	3	cra_al
craals	8	41	1330	3	craals
crab	8	57	2767	3	cra__b
crabby	15	34	675	3	crabby
crabs	9	54	2139	3	cra_bs
crack	13	41	2053	3	cra_ck
cracks	14	48	1700	3	cracks
cracky	17	50	1022	3	cracky
cradle	9	33	1316	3	cradle
craft	10	53	2766	3	cra_ft
crafts	11	53	1274	3	crafts
crafty	14	47	891	3	crafty
crag	7	56	2530	3	cra__g
craggy	13	39	660	3	craggy
crags	8	56	2257	3	cra_gs
crake	11	48	2352	3	cra_ke
crakes	12	49	2181	3	crakes
cram	8	56	3549	3	cra__m
crambe	12	3	907	3	crambe
crambo	12	3	804	3	crambo
crambos	13	3	678	3	crambos
cramp	11	51	2069	3	cra_mp
crampons	14	3	664	3	crampons
crampoon	14	4	454	3	crampoon
cramps	12	56	1556	3	cramps
crampy	15	47	1099	3	crampy
crams	9	62	2915	3	cra_ms
cranch	13	36	1353	3	cranch
crane	7	53	3160	3	cra_ne
craned	9	61	2165	3	craned
cranes	8	43	3075	3	cranes
crania	8	24	1843	3	crania
craning	10	36	2030	3	craning
crank	11	48	1961	3	cra_nk
cranks	12	50	1531	3	cranks
cranky	15	39	1063	3	cranky
crannog	10	4	424	3	crannog
cranny	11	42	1027	3	cranny
crap	8	57	3184	3	cra__p
crape	9	61	2844	3	cra_pe
craped	11	61	2053	3	craped
crapes	10	47	2769	3	crapes
craping	12	40	1871	3	craping
crapola	11	3	691	3	crapola
crappy	15	44	680	3	crappy
craps	9	53	2864	3	cra_ps
crases	8	55	3231	3	crases
crash	10	91	2001	3	cra_sh
crasis	8	50	2047	3	crasis
crass	7	63	2804	3	cra_ss
cratch	13	41	1079	3	cratch
crate	7	65	3740	3	cra_te
crated	9	48	2777	3	crated
crater	8	50	2664	3	crater
crates	8	57	3606	3	crates
crating	10	37	2520	3	crating
cratonic	12	3	912	3	cratonic
cravat	11	3	1444	3	cravat
crave	10	56	2631	3	cra_ve
craved	12	54	1777	3	craved
cravens	12	40	1012	3	cravens
craver	11	46	1847	3	craver
craves	11	58	2539	3	craves
craving	13	40	1573	3	craving
craw	9	77	2526	3	cra__w
crawl	10	49	1671	3	cra_wl
crawls	11	47	1208	3	crawls
crawly	14	46	1076	3	crawly
craws	10	57	2312	3	cra_ws
crayoners	14	4	450	3	crayon~~ers~~
crayoning	15	3	524	3	crayoning
crayonist	14	4	625	3	crayon~~ist~~
craze	16	52	2146	3	cra_ze
crazed	18	47	1445	3	crazed
crazes	17	47	2013	3	crazes
crazing	19	39	1458	3	crazing
crazy	19	55	1122	3	cra_zy
creatin	9	36	1813	3	creatin
creation	10	28	1651	3	creation
creator	9	37	1445	3	creator
credo	8	48	1557	3	credo_
credos	9	46	1285	3	credos
crepons	11	3	932	3	crepons
cresol	8	3	1021	3	cresol
cretin	8	29	1791	3	cretin
crimson	11	3	564	3	crimson
croc	8	57	2373	3	cr__oc
crone	7	52	3133	3	cr__one
crony	10	59	1867	3	cr__ony
crook	11	52	1757	3	cr_ook
croons	8	54	1842	3	cr_oons
crop	8	76	2863	3	cr__op
crotons	9	37	1437	3	crotons
crouton	9	4	713	3	crouton
crow	9	64	2813	3	cr__ow
crown	10	56	2008	3	cr_own
cruor	7	3	1045	3	cr_uor
cry	8	97	2624	3	cr_y__
crying	12	36	1228	3	cr_ying
cryogen	13	4	504	3	cr_yogen
cryonic	14	3	783	3	cr_yonic
crypt	12	37	1523	3	cr_ypt
curacoa	11	4	622	3	curacoa
curator	9	3	1221	3	curator
cyan	9	64	1962	3	c__yan
cyanin	11	39	1145	3	cyanin
cyano	10	55	1249	3	cyano_
cyton	10	15	1146	3	c_yton
deacon	9	5	1042	3	deacon
dragons	9	3	838	3	dragons
dragoon	9	3	528	3	dragoon
drain	6	52	2289	3	dra_in
drawn	9	56	1424	3	dra_wn
dray	8	54	2809	3	dray__
drayed	11	59	1139	3	drayed
draying	12	38	1384	3	draying
drayman	13	3	543	3	drayman
draymen	13	3	523	3	draymen
drays	9	58	1977	3	dray_s
dromon	9	3	936	3	dromon
erasion	7	3	1196	3	erasion
etalon	6	4	897	3	etalon
fanon	8	46	1901	3	_fanon
flacon	11	3	863	3	flacon
flagon	10	3	798	3	flagon
fray	10	54	2890	3	fray__
frayed	13	50	1216	3	frayed
fraying	14	34	1343	3	fraying
frays	11	69	2010	3	fray_s
garcon	9	29	1248	3	garcon
garron	7	31	1349	3	garron
graben	9	41	972	3	graben
gradin	8	35	1748	3	gradin
grain	6	51	2625	3	gra_in
gran	5	63	3501	3	gra__n
gratin	7	45	2058	3	gratin
graven	10	45	1352	3	graven
gray	8	53	2989	3	gray__
grayed	11	54	1564	3	grayed
grayer	10	60	1454	3	grayer
graying	12	41	1588	3	graying
grayly	13	28	796	3	grayly
grayout	11	4	851	3	grayout
grays	9	56	2133	3	gray_s
grison	7	3	1010	3	grison
halon	8	61	2486	3	_halon
iron	4	67	2846	3	ir__on
jargon	14	4	882	3	jargon
kaon	8	75	2103	3	_ka_on
kayo	11	64	1756	3	_kayo_
kayos	12	77	1470	3	_kayos
klaxon	17	3	385	3	klaxon
kraken	9	5	588	3	kraken
kroon	9	45	1448	3	kr_oon
lardon	7	44	1506	3	lardon
layin	8	47	2033	3	_layin
macon	9	45	1995	3	_macon
maroon	8	31	1820	3	maroon
marron	8	37	1754	3	marron
mason	7	48	2018	3	_mason
mayan	10	56	1690	3	_mayan
mayo	9	65	2430	3	_mayo_
mayor	10	66	1662	3	_mayor
mayos	10	55	2193	3	_mayos
octagon	10	4	524	3	octagon
oration	7	16	1771	3	oration
orator	6	3	1453	3	orator
organon	8	4	591	3	organon
orison	6	4	1166	3	orison
orlon	5	4	1500	3	or_lon
paeon	7	48	1949	3	_paeon
paragon	10	3	1102	3	paragon
pardon	9	46	1873	3	pardon
parson	8	38	1790	3	parson
parton	8	47	2099	3	parton
payor	10	54	1384	3	_payor
pinyon	11	45	976	3	pinyon
prao	6	62	2902	3	pra_o_
praos	7	49	2356	3	pra_os
prawn	10	53	1243	3	pra_wn
pray	9	63	3153	3	pray__
prayed	12	48	1543	3	prayed
prayer	11	48	1529	3	prayer
praying	13	37	1732	3	praying
prays	10	50	2243	3	pray_s
prion	7	51	1999	3	pr_ion
prison	8	5	1402	3	prison
proton	8	43	1889	3	proton
racons	8	43	1934	3	_racons
racoon	8	38	1447	3	_racoon
radons	7	41	1853	3	_radons
rain	4	62	5173	3	_ra_in
ramen	7	56	2519	3	_ramen
ramona	8	4	1241	3	_ramona
ramson	8	3	1046	3	_ramson
ran	3	82	6662	3	_ra__n
ratan	5	37	2266	3	_ratan
ration	6	42	2601	3	_ration
rato	4	54	3697	3	_rato_
ratoon	6	44	1737	3	_ratoon
ratos	5	55	2877	3	_ratos
ratton	6	41	1612	3	_ratton
raven	8	47	2344	3	_raven
ravin	8	56	2465	3	_ravin
rawin	8	55	2147	3	_rawin
ray	6	63	6199	3	_ray__
raya	7	52	2482	3	_ray_a
rayah	11	60	1350	3	_rayah
rayas	8	59	2205	3	_rayas
rayed	9	51	2750	3	_rayed
raying	10	50	2719	3	_raying
rays	7	76	4235	3	_ray_s
razor	14	30	1260	3	_razor
reason	6	26	1633	3	reason
recon	7	56	2424	3	_recon
redon	6	54	2488	3	_redon
rewon	8	69	2058	3	_rewon
rhyton	12	35	611	3	_rhyton
ronyon	9	30	913	3	ronyon
ryot	7	55	2856	3	_r_yot
sabayon	12	4	423	3	sabayon
salon	5	52	2855	3	_salon
season	6	27	1490	3	season
talon	5	58	2411	3	_talon
tardyon	11	3	467	3	tardyon
tarpon	8	28	1280	3	tarpon
tauon	5	48	1658	3	_tauon
taxon	12	44	1466	3	_taxon
toyon	8	67	1567	3	_toyon
train	5	65	2911	3	tra_in
trapan	8	24	1297	3	trapan
tray	7	76	3259	3	tray__
trays	8	56	2343	3	tray_s
treason	7	4	876	3	treason
trigon	7	45	1310	3	trigon
triton	6	39	1489	3	triton
trogon	7	36	1175	3	trogon
wagon	9	43	1295	3	_wagon
weakon	13	35	762	3	weakon
weapon	11	28	811	3	weapon
weason	9	32	1082	3	weason
yapon	10	46	1358	3	_yapon
yon	6	73	4895	3	___yon
zayin	17	45	1204	3	_zayin

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.390	458182.1
2	DLD Change Limit	112716	399	4.953	22757.1
3	Display Results	399	399	0.126	3166.7
	(SQL Overall)	178691	399	5.469	32673.4