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

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

348 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
canopy	13	3	773	(None)
anomy	10	51	1339	2	_anomy
atopy	10	68	1339	2	_atopy
calory	11	3	1284	2	calory
campy	14	51	1618	2	ca_mpy
canape	10	9	1352	2	canape
canary	11	3	1469	2	canary
candy	11	51	1982	2	can_dy
canny	10	58	1769	2	can_ny
canoe	7	56	2725	2	cano_e
canoed	9	46	1896	2	canoed
canoer	8	51	2107	2	canoer
canoes	8	47	2588	2	canoes
canola	8	3	1362	2	canola
canon	7	47	2530	2	cano_n
canonry	12	3	592	2	canonry
canons	8	55	2206	2	canons
canopic	13	3	880	2	canopic
canty	10	52	2680	2	can_ty
copy	11	62	2980	2	c__opy
jalopy	18	32	586	2	jalopy
panoply	14	3	471	2	panoply
acnode	9	3	820	3	acnode
adopt	8	12	1974	3	_adopt
agony	9	64	1565	3	_agony
ahoy	10	19	1918	3	_aho_y
angry	9	3	1087	3	_angry
annoy	8	6	971	3	_annoy
anoa	4	56	3447	3	_ano_a
anoas	5	72	2649	3	_anoas
anode	6	50	2104	3	_anode
anole	5	53	3038	3	_anole
anon	4	61	3485	3	_ano_n
anonym	11	3	638	3	_anonym
anopia	8	34	1239	3	_anopia
antsy	8	57	1279	3	_antsy
any	6	84	4049	3	_an__y
atomy	10	74	1519	3	_atomy
atony	8	72	1885	3	_atony
atop	6	61	2475	3	_atop_
bandy	11	48	2419	3	ban_dy
banty	10	66	2400	3	ban_ty
barony	11	59	1530	3	barony
cabby	14	53	1456	3	ca_bby
cabob	11	46	1681	3	cabo_b
cabobs	12	43	1189	3	cabobs
cacodyl	15	4	321	3	cacodyl
caconym	16	4	495	3	caconym
caddy	12	54	1402	3	ca_ddy
cadgy	12	52	1078	3	ca_dgy
caeoma	10	3	903	3	caeoma
cagey	11	59	1782	3	ca_gey
cagily	12	4	1156	3	cagily
cagy	10	63	2199	3	ca__gy
cahoot	11	4	1647	3	cahoot
cahow	13	51	1094	3	caho_w
cahows	14	39	912	3	cahows
cairny	11	55	782	3	cairny
cajole	15	40	1118	3	cajole
cajon	14	45	1390	3	cajo_n
cakey	14	55	1727	3	ca_key
caky	13	62	2244	3	ca__ky
caliph	13	3	1140	3	caliph
calmly	13	3	761	3	calmly
calo	6	49	3644	3	calo__
calos	7	44	3190	3	calo_s
camo	8	57	3175	3	camo__
camos	9	59	2761	3	camo_s
camp	10	63	3645	3	ca_mp_
campi	11	62	1778	3	ca_mpi
campo	11	52	1976	3	ca_mpo
campos	12	52	1795	3	campos
camps	11	63	3026	3	ca_mps
can	5	77	6014	3	can___
canal	7	54	2804	3	can_al
canals	8	44	2167	3	canals
canapes	11	12	1308	3	canapes
canard	9	3	1476	3	canard
cancan	10	3	1410	3	cancan
cancel	10	53	1668	3	cancel
cancer	10	42	2092	3	cancer
cancha	13	44	1161	3	cancha
candid	10	45	1785	3	candid
candle	9	43	2148	3	candle
candor	9	45	1642	3	candor
candors	10	42	1676	3	candors
candour	10	42	1024	3	candour
cane	6	66	5312	3	can__e
caned	8	58	3809	3	can_ed
caner	7	53	3477	3	can_er
caners	8	46	2920	3	caners
canes	7	53	5037	3	can_es
canful	11	6	1026	3	canful
cangue	9	10	1245	3	cangue
canid	8	55	2634	3	can_id
canids	9	51	1813	3	canids
canine	8	38	2670	3	canine
caning	9	41	2862	3	caning
canker	12	44	2252	3	canker
canna	7	59	1933	3	can_na
cannas	8	45	1840	3	cannas
canned	9	50	2206	3	canned
cannel	8	42	1640	3	cannel
canner	8	46	2598	3	canner
cannery	12	36	1001	3	cannery
cannie	8	38	1936	3	cannie
cannily	12	3	926	3	cannily
cannoli	9	3	726	3	cannoli
cannon	8	45	1444	3	cannon
cannonry	13	4	329	3	cannonry
cannons	9	44	1288	3	cannons
cannot	8	36	1677	3	cannot
canoers	9	43	1837	3	canoers
canolas	9	3	1399	3	canolas
canonic	11	3	1293	3	canonic
canopied	13	3	635	3	canopied
canopies	12	3	1185	3	canopies
canopying	17	4	506	3	canopy~~ing~~
cans	6	50	5085	3	can__s
canso	7	50	1940	3	can_so
cansos	8	49	1538	3	cansos
canst	7	49	3221	3	can_st
cant	6	63	6203	3	can__t
cantal	8	41	2203	3	cantal
canted	9	48	2578	3	canted
canter	8	52	3011	3	canter
canthi	11	3	1097	3	canthi
cantic	10	39	2054	3	cantic
cantle	8	45	2215	3	cantle
canto	7	49	3101	3	can_to
canton	8	57	2299	3	canton
cantons	9	52	2120	3	cantons
cantor	8	56	2152	3	cantor
cantors	9	46	2075	3	cantors
cantos	8	48	2697	3	cantos
cants	7	70	3694	3	can_ts
cantus	8	51	1776	3	cantus
canula	8	3	1297	3	canula
canvas	11	38	1333	3	canvas
canyon	11	45	1203	3	canyon
canyons	12	45	1159	3	canyons
canzona	18	3	607	3	canzona
canzone	18	5	881	3	canzone
canzoni	18	3	615	3	canzoni
cap	7	67	5898	3	ca__p_
cape	8	72	4278	3	ca__pe
caph	11	66	2329	3	ca__ph
capo	8	58	2921	3	ca__po
capon	9	52	2187	3	capo_n
capons	10	41	1950	3	capons
capos	9	48	2607	3	capo_s
capote	10	3	1573	3	capote
caps	8	71	4789	3	ca__ps
carboy	13	49	1418	3	carboy
carhop	13	36	1076	3	carhop_
carhops	14	32	970	3	carhops
carney	11	53	1570	3	carney
carnify	15	5	588	3	carnify
carny	10	58	2292	3	ca_rny
carob	9	53	2522	3	caro_b
carobs	10	48	1810	3	carobs
caroch	13	9	1176	3	caroch
carol	7	51	2861	3	caro_l
caroli	8	59	1823	3	caroli
carols	8	51	2498	3	carols
carom	9	50	2556	3	caro_m
caroms	10	56	1957	3	caroms
carp	8	51	3981	3	ca_rp_
carpi	9	43	1939	3	ca_rpi
carps	9	69	3225	3	ca_rps
carroty	12	4	894	3	carroty
carry	10	58	2378	3	ca_rry
cartop	10	42	1356	3	cartop_
casefy	14	3	627	3	casefy
casky	14	45	1268	3	ca_sky
catchy	16	55	958	3	catchy
catnap	10	9	838	3	catnap_
catnaps	11	9	703	3	catnaps
catnip	10	9	797	3	catnip_
catnips	11	9	589	3	catnips
catty	10	45	2041	3	ca_tty
causey	11	35	1327	3	causey
cavity	14	3	1001	3	cavity
cavort	11	3	1617	3	cavort
cavy	12	59	2000	3	ca__vy
cay	8	71	5598	3	ca___y
cenote	8	37	1584	3	cenote
champy	18	50	961	3	champy
chancy	16	40	1086	3	chan_cy
chanoyu	15	4	448	3	chanoyu
chantey	15	41	1254	3	chantey
chantry	15	38	822	3	chantry
chanty	14	52	1582	3	chan_ty
charpoy	17	3	571	3	charpoy
chippy	18	43	761	3	chippy
chirpy	16	49	891	3	chirpy
choky	17	57	1122	3	c_hoky
choosy	14	45	910	3	choosy
chop	11	60	2492	3	c_hop_
choppy	18	37	629	3	choppy
chops	12	50	1987	3	c_hops
chromy	16	30	990	3	chromy
clanky	15	46	907	3	clan_ky
clop	8	69	2989	3	c_lop_
clops	9	59	2485	3	c_lops
cloy	9	66	2383	3	c_lo_y
clumpy	15	40	957	3	clumpy
coky	13	75	2682	3	c__oky
colony	11	54	1727	3	colony
coly	9	69	4053	3	c__oly
conchy	16	37	1022	3	conchy
coney	10	59	3288	3	con_ey
conky	14	58	1874	3	con_ky
conoid	9	8	1888	3	conoid
convey	14	46	1022	3	convey
convoy	14	34	854	3	convoy
cony	9	65	3783	3	c__ony
cooey	10	58	2822	3	c_ooey
cooky	14	53	2136	3	c_ooky
cooly	10	55	2542	3	c_ooly
coop	8	72	3865	3	c_oop_
coops	9	62	2964	3	c_oops
coopt	9	59	2985	3	c_oopt
cop	7	111	6237	3	c__op_
copay	12	65	1631	3	c__opay
cope	8	68	4738	3	c__ope
cops	8	67	5137	3	c__ops
corody	12	14	970	3	corody
cory	9	69	4151	3	c__ory
cosy	9	72	3270	3	c__osy
cowy	12	64	2736	3	c__owy
coy	8	105	5755	3	c__o_y
cozy	18	58	2380	3	c__ozy
crampy	15	47	1099	3	crampy
crankly	16	35	812	3	crankly
cranky	15	39	1063	3	cran_ky
cranny	11	42	1027	3	cran_ny
crappy	15	44	680	3	crappy
creepy	13	41	880	3	creepy
crepy	12	48	1270	3	c_repy
crimpy	15	48	939	3	crimpy
crispy	13	47	856	3	crispy
crony	10	59	1867	3	c_rony
crop	8	76	2863	3	c_rop_
crops	9	61	2524	3	c_rops
croupy	13	45	873	3	croupy
cuppy	14	47	1038	3	c_uppy
cyano	10	55	1249	3	cyano__
dandy	10	44	1670	3	dan_dy
dangly	11	42	1227	3	dangly
dankly	14	41	946	3	dankly
dopy	10	62	2415	3	__dopy
droopy	12	45	824	3	droopy
economy	14	4	543	3	economy
fancy	13	46	1548	3	fan_cy
fanny	11	48	1604	3	fan_ny
fano	7	58	3169	3	fano__
fanon	8	46	1901	3	fano_n
fanons	9	61	1521	3	fanons
fanos	8	59	2650	3	fano_s
galop	8	47	1622	3	galop_
galops	9	47	1262	3	galops
gangly	11	39	1159	3	gangly
ganof	9	54	2036	3	gano_f
ganofs	10	40	1029	3	ganofs
ganoid	8	3	1444	3	ganoid
gantry	10	38	1011	3	gantry
gappy	13	62	1203	3	ga_ppy
gapy	10	63	2091	3	ga__py
gonoph	12	3	540	3	gonoph
goopy	11	58	1662	3	_goopy
handy	12	55	2087	3	han_dy
hanky	15	54	1829	3	han_ky
happy	15	58	1353	3	ha_ppy
harpy	13	64	1821	3	ha_rpy
jalop	14	42	1260	3	jalop_
jaloppy	21	30	248	3	jaloppy
jalops	15	32	959	3	jalops
jangly	17	43	1061	3	jangly
janty	15	68	1696	3	jan_ty
knop	10	71	1660	3	_knop_
knops	11	59	1181	3	_knops
lanely	9	39	1448	3	lanely
lankly	13	43	962	3	lankly
lanky	12	55	1748	3	lan_ky
lanose	6	3	1359	3	lanose
loopy	10	53	1664	3	_loopy
mangey	12	36	1453	3	mangey
mangy	11	50	2125	3	man_gy
manly	10	50	2295	3	man_ly
mano	6	65	3681	3	mano__
manor	7	80	2393	3	mano_r
manors	8	44	2088	3	manors
manos	7	49	3362	3	mano_s
manrope	11	3	803	3	manrope
many	9	57	3186	3	man__y
monody	12	3	824	3	monody
mopy	11	57	2197	3	__mopy
myopy	15	45	735	3	_myopy
nancy	10	52	1492	3	nan_cy
nanny	8	48	1381	3	nan_ny
nappy	12	63	1233	3	na_ppy
nope	6	59	3419	3	__nope
nosy	7	63	2289	3	__nosy
pandy	11	50	2117	3	pan_dy
panfry	14	45	641	3	panfry
pansophy	18	9	213	3	pansophy
pansy	10	57	1797	3	pan_sy
pantry	11	50	1410	3	pantry
panty	10	59	2930	3	pan_ty
pappy	11	47	1380	3	pa_ppy
parody	12	4	1009	3	parody
randy	9	50	2208	3	ran_dy
rangy	9	53	2039	3	ran_gy
rankly	13	39	1045	3	rankly
raspy	10	65	1170	3	ra_spy
recopy	13	3	904	3	recopy
ropy	9	63	2341	3	__ropy
sandy	9	42	2113	3	san_dy
sanely	9	31	1461	3	sanely
sanity	9	3	1620	3	sanity
sannop	8	3	737	3	sannop_
sannops	9	3	669	3	sannops
sappy	12	54	1347	3	sa_ppy
savory	12	43	1056	3	savory
savoy	11	47	1388	3	savo_y
saxony	16	3	623	3	saxony
scantly	12	41	955	3	scantly
scanty	11	40	1466	3	scan_ty
snappy	13	6	610	3	snappy
snoopy	11	44	947	3	snoopy
snowy	11	50	1156	3	_snowy
swoopy	14	48	728	3	swoopy
tangly	10	44	1393	3	tangly
tangy	9	45	1995	3	tan_gy
tannoy	9	5	836	3	tannoy
tansy	8	45	1494	3	tan_sy
vampy	15	53	940	3	va_mpy
vanity	12	3	1194	3	vanity
vapory	14	39	876	3	vapory
waney	11	51	2032	3	wan_ey
wanly	11	51	1802	3	wan_ly
wany	10	64	3236	3	wan__y
waspy	13	54	1099	3	wa_spy
wicopy	16	3	403	3	wicopy
zanily	18	3	1018	3	zanily
zany	16	73	1699	3	zan__y
zappy	21	54	894	3	za_ppy

Search took 7 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.420	425454.8
2	DLD Change Limit	112716	348	5.923	19030.2
3	Display Results	348	348	0.110	3163.6
	(SQL Overall)	178691	348	6.453	27691.2