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

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

514 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
canola	8	3	1362	(None)
canolas	9	3	1399	1	canolas
canula	8	3	1296	1	canula
anoa	4	56	3447	2	_ano_a
anole	5	53	3038	2	_anole
cabala	10	35	1691	2	cabala
caeoma	10	3	903	2	caeoma
cajole	15	40	1118	2	cajole
calla	7	48	2707	2	ca_lla
canal	7	54	2804	2	canal_
canals	8	44	2167	2	canals
cancha	13	44	1161	2	cancha
candela	10	8	974	2	candela
candle	9	43	2148	2	candle
canella	9	3	1079	2	canella
canna	7	59	1933	2	can_na
cannoli	9	3	726	2	cannoli
cannula	9	3	743	2	cannula
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
canon	7	47	2530	2	cano_n
canons	8	55	2206	2	canons
canopy	13	3	773	2	canopy
cantal	8	41	2203	2	cantal
cantala	9	41	1467	2	cantala
cantle	8	45	2215	2	cantle
canulae	9	3	1118	2	canulae
canular	9	3	1032	2	canular
canulas	9	3	1285	2	canulas
canzona	18	3	607	2	canzona
carol	7	51	2861	2	carol_
caroli	8	59	1823	2	caroli
carols	8	51	2498	2	carols
chola	10	47	1803	2	c_hola
citola	8	3	839	2	citola
cola	6	65	4139	2	c__ola
crapola	11	3	691	2	crapola
cupola	10	31	769	2	cupola
granola	8	3	791	2	granola
mandola	10	3	902	2	mandola
manila	8	45	1830	2	manila
payola	11	20	811	2	payola
ranula	6	3	1181	2	ranula
abolla	8	4	1019	3	_abolla
aboma	9	11	1460	3	_aboma
acantha	12	5	466	3	acantha
acerola	9	4	782	3	acerola
acholia	12	3	997	3	acholia
acnode	9	3	820	3	acnode
acold	8	62	1493	3	_acold
agora	6	9	1433	3	_agora
ahold	9	47	1425	3	_ahold
aioli	5	3	1831	3	_aioli
akela	9	3	1134	3	_akela
ala	3	124	6360	3	_a__la
aloha	8	5	1362	3	_aloha
alula	5	3	1709	3	_alula
amole	7	57	2459	3	_amole
ana	3	95	5983	3	_an__a
anal	4	80	3752	3	_anal_
anele	5	56	2883	3	_anele
anga	5	68	3136	3	_an_ga
angle	6	45	2888	3	_angle
anglo	6	52	1538	3	_anglo
angora	7	11	1157	3	_angora
anil	4	64	3743	3	_anil_
anile	5	46	3446	3	_anile
anils	5	63	2672	3	_anils
anima	7	46	2007	3	_anima
ankle	9	52	2025	3	_ankle
anlas	5	56	2693	3	_an_las
anna	4	55	2901	3	_an_na
annal	5	65	2076	3	_annal
annona	6	4	887	3	annona
anoas	5	72	2649	3	_anoas
anodal	7	25	1212	3	_anodal
anode	6	50	2104	3	_anode
anoles	6	48	2743	3	_anoles
anomy	10	51	1339	3	_anomy
anon	4	61	3485	3	_ano_n
anopia	8	34	1239	3	_anopia
anorak	10	3	892	3	_anorak
anoxia	13	35	1002	3	_anoxia
ansa	4	59	2777	3	_an_sa
anta	4	68	3958	3	_an_ta
antra	5	65	2192	3	_antra
apnoea	8	6	709	3	apnoea
areola	6	8	1367	3	areola
aroma	7	12	2014	3	_aroma
asyla	8	3	933	3	_asyla
atoll	5	79	1392	3	_atoll
awol	7	56	2067	3	_awol_
awols	8	47	1352	3	_awols
azole	14	51	1803	3	_azole
bacula	10	31	1267	3	bacula
banal	7	59	2599	3	banal_
banana	8	32	1341	3	banana
banda	8	52	2311	3	ban_da
bandora	10	3	881	3	bandora
bangle	9	40	1896	3	bangle
bola	6	60	3556	3	__bola
cabal	9	52	2215	3	cabal_
cabalas	11	35	1600	3	cabalas
cabals	10	40	2015	3	cabals
cabana	10	39	1356	3	cabana
cabbala	13	6	718	3	cabbala
cable	9	53	2991	3	ca_ble
cabob	11	46	1681	3	cabo_b
cabobs	12	43	1189	3	cabobs
cabomba	15	4	408	3	cabomba
caca	8	55	2808	3	ca__ca
cackle	14	34	1692	3	cackle
caeca	9	39	1513	3	ca_eca
caecal	10	37	1373	3	caecal
caeomas	11	3	840	3	caeomas
cagily	12	4	1156	3	cagily
cahoot	11	4	1647	3	cahoot
cahow	13	51	1094	3	caho_w
cahows	14	39	912	3	cahows
cajoled	17	42	828	3	cajoled
cajoler	16	39	839	3	cajoler
cajoles	16	37	1210	3	cajoles
cajon	14	45	1390	3	cajo_n
calesa	8	4	1247	3	calesa
calf	9	63	3956	3	ca__lf
calk	10	55	2766	3	ca__lk
call	6	68	3867	3	ca__ll
callan	8	36	1960	3	ca_llan
callas	8	45	2675	3	ca_llas
callow	11	47	1466	3	callow
calls	7	56	3473	3	ca_lls
calm	8	50	3236	3	ca__lm
calmly	13	3	761	3	calmly
calo	6	49	3644	3	ca__lo
calory	11	3	1284	3	calory
calos	7	44	3190	3	calo_s
calx	13	57	2279	3	ca__lx
cambia	12	49	1315	3	cambia
camel	9	68	2280	3	camel_
camelia	11	5	1044	3	camelia
camels	10	52	1708	3	camels
camera	10	3	1369	3	camera
camisa	10	31	1432	3	camisa
camo	8	57	3175	3	camo__
camorra	11	11	577	3	camorra
camos	9	59	2761	3	camo_s
can	5	77	6014	3	can___
canaled	10	36	1556	3	canaled
canape	10	9	1352	3	canape
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
canasta	9	3	836	3	canasta
cancan	10	3	1410	3	cancan
cancel	10	53	1668	3	cancel
cancels	11	41	1331	3	cancels
cancer	10	42	2092	3	cancer
canchas	14	32	1240	3	canchas
candelas	11	3	953	3	candelas
candid	10	45	1785	3	candid
candida	11	41	1025	3	candida
candled	11	38	1574	3	candled
candler	10	35	1659	3	candler
candles	10	44	2234	3	candles
candor	9	45	1642	3	candor
candors	10	42	1676	3	candors
candour	10	42	1024	3	candour
candy	11	51	1982	3	can_dy
cane	6	66	5312	3	can__e
caned	8	58	3809	3	can_ed
canellas	10	3	1056	3	canellas
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
canfuls	12	4	842	3	canfuls
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
cannas	8	45	1840	3	cannas
canned	9	50	2206	3	canned
cannel	8	42	1640	3	cannel
cannels	9	34	1336	3	cannels
canner	8	46	2598	3	canner
cannie	8	38	1936	3	cannie
cannily	12	3	926	3	cannily
cannolis	10	3	786	3	cannolis
cannon	8	45	1444	3	cannon
cannons	9	44	1288	3	cannons
cannot	8	36	1677	3	cannot
cannulae	10	4	649	3	cannulae
cannular	10	4	628	3	cannular
cannulas	10	3	758	3	cannulas
canny	10	58	1769	3	can_ny
canoers	9	43	1837	3	canoers
canonic	11	3	1293	3	canonic
canonry	12	3	592	3	canonry
canoodle	11	4	418	3	canoodle
canopic	13	3	880	3	canopic
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
cantalas	10	40	1352	3	cantalas
cantals	9	39	1957	3	cantals
cantata	9	38	1181	3	cantata
canted	9	48	2578	3	canted
canter	8	52	3011	3	canter
canthal	12	4	1005	3	canthal
canthi	11	3	1097	3	canthi
cantic	10	39	2054	3	cantic
cantina	9	34	1725	3	cantina
cantles	9	47	2141	3	cantles
canto	7	49	3101	3	can_to
canton	8	57	2299	3	canton
cantonal	10	3	890	3	cantonal
cantons	9	52	2120	3	cantons
cantor	8	56	2152	3	cantor
cantors	9	46	2075	3	cantors
cantos	8	48	2697	3	cantos
cantrap	11	33	1028	3	cantrap
cants	7	70	3694	3	can_ts
cantus	8	51	1776	3	cantus
canty	10	52	2680	3	can_ty
canulate	10	3	1455	3	canulate
canvas	11	38	1333	3	canvas
canyon	11	45	1203	3	canyon
canyons	12	45	1159	3	canyons
canzonas	19	3	538	3	canzonas
canzone	18	5	881	3	canzone
canzoni	18	3	615	3	canzoni
capelan	11	3	900	3	capelan
capita	10	29	1377	3	capita
capo	8	58	2921	3	capo__
capon	9	52	2187	3	capo_n
capons	10	41	1950	3	capons
caporal	11	4	1094	3	caporal
capos	9	48	2607	3	capo_s
capote	10	3	1573	3	capote
carbora	11	3	1070	3	carbora
cardia	9	9	1638	3	cardia
carina	8	43	2533	3	carina
carioca	11	3	968	3	carioca
cariole	9	8	1834	3	cariole
carl	6	51	4478	3	ca_rl_
carle	7	45	3570	3	ca_rle
carload	10	3	978	3	carload
carls	7	70	3742	3	ca_rls
carnal	8	39	1921	3	carnal_
carob	9	53	2522	3	caro_b
carobs	10	48	1810	3	carobs
caroch	13	9	1176	3	caroch
caroled	10	37	1769	3	caroled
caroler	9	38	1675	3	caroler
carolus	9	46	1260	3	carolus
carom	9	50	2556	3	caro_m
caroms	10	56	1957	3	caroms
carpal	10	37	1625	3	carpal
casa	6	56	3086	3	ca__sa
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
casita	8	29	1370	3	casita
cassia	8	37	1476	3	cassia
castle	8	49	1896	3	castle
casual	8	11	1286	3	casual
catalo	8	3	1485	3	catalo
catalpa	11	3	650	3	catalpa
catclaw	14	4	397	3	catclaw
catena	8	3	1248	3	catena
cattle	8	51	1890	3	cattle
caudal	9	16	1148	3	caudal
caudle	9	39	1291	3	caudle
caul	6	56	3000	3	ca_ul_
cauld	8	53	1844	3	ca_uld
caulk	11	53	1545	3	ca_ulk
cauls	7	57	2777	3	ca_uls
causal	8	14	1320	3	causal
cavalla	12	5	788	3	cavalla
cavil	10	38	1649	3	cavil_
cavils	11	40	1439	3	cavils
cavort	11	3	1617	3	cavort
cedula	9	7	764	3	cedula
cella	7	54	2031	3	c_ella
cenote	8	37	1584	3	cenote
cental	8	44	2096	3	cental
centra	8	41	1388	3	centra
challa	11	40	1419	3	challa
chanoyu	15	4	448	3	chanoyu
chela	10	39	1680	3	c_hela
chimla	13	3	759	3	chimla
cholas	11	48	1800	3	c_holas
cholla	11	39	1102	3	cholla
cholo	10	52	1797	3	c_holo
chroma	13	29	1247	3	chroma
cibol	9	5	1202	3	cibol_
cibols	10	3	952	3	cibols
cicala	10	3	1006	3	cicala
cinema	10	4	765	3	cinema
cineol	8	10	820	3	cineol_
cineole	9	10	1000	3	cineole
cineols	9	12	885	3	cineols
cingula	10	32	717	3	cingula
citolas	9	3	936	3	citolas
citole	8	3	1150	3	citole
clonal	8	3	1091	3	clonal
cnida	8	7	895	3	c_nida
coagula	10	4	541	3	coagula
coal	6	69	3925	3	c__oal
coala	7	75	2112	3	c_oala
coca	8	80	3064	3	c__oca
cocoa	9	85	1788	3	coco_a
coda	7	70	2934	3	c__oda
col	5	93	6035	3	c__ol_
colas	7	54	3677	3	c__olas
cold	7	73	3877	3	c__old
cole	6	69	5611	3	c__ole
cols	6	65	5308	3	c__ols
colt	6	71	5824	3	c__olt
coly	9	69	4053	3	c__oly
colza	16	51	1298	3	c__olza
coma	8	71	3485	3	c__oma
concha	13	42	1328	3	concha
condole	10	29	1495	3	condole
conga	8	54	1987	3	con_ga
conoid	9	8	1888	3	conoid
consol	8	26	1411	3	consol_
console	9	27	1598	3	console
consols	9	29	1407	3	consols
contra	8	33	1470	3	contra
cool	6	69	4049	3	c_ool_
cools	7	56	3263	3	c_ools
cooly	10	55	2542	3	c_ooly
copula	10	28	1204	3	copula
corolla	9	3	862	3	corolla
corona	8	38	1740	3	corona
coxa	13	69	2296	3	c__oxa
crania	8	24	1843	3	cran_ia
cranial	9	21	1468	3	cranial
crankle	13	36	1006	3	crankle
crankly	16	35	812	3	crankly
crapolas	12	4	740	3	crapolas
creole	8	9	1373	3	creole
cuneal	8	6	1151	3	cuneal
cupolas	11	27	775	3	cupolas
cupula	10	32	843	3	cupula
cyano	10	55	1249	3	cyano__
cymol	12	8	762	3	cymol_
cymols	13	7	719	3	cymols
dagoba	10	7	494	3	dagoba
dandle	8	42	1809	3	dandle
dangle	8	41	1931	3	dangle
dangly	11	42	1227	3	dangly
dankly	14	41	946	3	dankly
dongola	9	4	547	3	dongola
eidola	7	3	768	3	eidola
enol	4	58	2382	3	_enol_
enols	5	47	1840	3	_enols
facula	11	29	1223	3	facula
fanega	10	5	578	3	fanega
fanfold	14	8	537	3	fanfold
fanga	9	61	1963	3	fan_ga
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
favela	12	3	703	3	favela
gala	5	56	3516	3	ga__la
ganglia	9	4	661	3	ganglia
gangly	11	39	1159	3	gangly
ganja	13	14	1000	3	gan_ja
ganof	9	54	2036	3	gano_f
ganofs	10	40	1029	3	ganofs
ganoid	8	3	1444	3	ganoid
gaol	5	69	2541	3	ga_ol_
gaols	6	67	1757	3	ga_ols
genoa	6	43	1582	3	geno_a
gondola	9	4	666	3	gondola
granolas	9	3	805	3	granolas
halala	9	47	1509	3	halala
halloa	9	49	1812	3	halloa
handle	10	42	1929	3	handle
haniwa	12	3	674	3	haniwa
hansa	8	54	1678	3	han_sa
hantle	9	43	1820	3	hantle
haole	8	48	2008	3	ha_ole
hawala	12	36	891	3	hawala
jangle	14	44	1630	3	jangle
jangly	17	43	1061	3	jangly
kabala	12	40	1155	3	kabala
kamala	12	33	996	3	kamala
kana	8	59	2853	3	kan__a
kanaka	9	35	752	3	kanaka
knoll	9	38	960	3	_knoll
kola	8	51	2496	3	__kola
lanely	9	39	1448	3	lanely
lankly	13	43	962	3	lankly
lanolin	7	3	1064	3	lanolin
lanose	6	3	1359	3	lanose
lunula	6	3	617	3	lunula
macula	10	30	1367	3	macula
magnolia	11	4	479	3	magnolia
mana	6	53	4196	3	man__a
manana	8	48	1607	3	manana
mandala	10	3	1021	3	mandala
mandolas	11	3	913	3	mandolas
manga	8	50	2621	3	man_ga
mangle	9	39	2133	3	mangle
mangold	11	3	721	3	mangold
manhole	12	3	1134	3	manhole
mania	7	56	3415	3	man_ia
manilas	9	39	1587	3	manilas
manilla	9	30	1247	3	manilla
manioca	11	35	894	3	manioca
manly	10	50	2295	3	man_ly
manna	7	55	2254	3	man_na
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
manta	7	56	2991	3	man_ta
mantle	8	44	2092	3	mantle
mantra	8	41	1609	3	mantra
mantua	8	44	1202	3	mantua
manual	8	3	1346	3	manual
masala	8	3	1181	3	masala
mola	6	60	3563	3	__mola
moola	7	51	1703	3	_moola
nala	4	69	3039	3	__nala
nana	4	66	3290	3	nan__a
nolo	4	62	2931	3	__nolo
noma	6	75	2946	3	__noma
nona	4	69	2906	3	__nona
noncola	9	4	830	3	noncola
nota	4	68	3077	3	__nota
nova	7	65	1895	3	__nova
octanol	9	4	474	3	octanol_
octanols	10	4	455	3	octanols
paella	8	4	1091	3	paella
pagoda	10	48	787	3	pagoda
pakora	12	4	728	3	pakora
panada	9	41	1305	3	panada
panama	10	42	1335	3	panama
panda	8	50	2261	3	pan_da
pandora	10	3	954	3	pandora
panel	7	60	2362	3	panel_
panels	8	47	1652	3	panels
panga	8	53	2354	3	pan_ga
panocha	14	4	498	3	panocha
panoply	14	3	471	3	panoply
papula	10	30	1111	3	papula
parol	7	48	2627	3	parol_
parole	8	44	2525	3	parole
parols	8	47	2261	3	parols
payolas	12	14	897	3	payolas
pinole	8	32	1878	3	pinole
planula	9	3	577	3	planula
pyrola	11	3	900	3	pyrola
qabala	17	39	919	3	qabala
radula	7	4	931	3	radula
rambla	10	35	1093	3	rambla
ramona	8	4	1241	3	ramona
rankle	10	34	1488	3	rankle
rankly	13	39	1045	3	rankly
ranular	7	3	943	3	ranular
ranulas	7	3	1177	3	ranulas
rugola	7	3	629	3	rugola
salol	5	52	2214	3	salol_
salols	6	40	1787	3	salols
samosa	8	5	1020	3	samosa
sancta	8	3	983	3	sancta
sandal	7	33	1728	3	sandal
sanely	9	31	1461	3	sanely
sanga	6	60	2380	3	san_ga
santol	6	45	1524	3	santol_
santols	7	35	1332	3	santols
sapota	8	3	1021	3	sapota
scandal	10	3	867	3	scandal
scandia	10	3	806	3	scandia
scantly	12	41	955	3	scantly
scapula	11	3	634	3	scapula
senora	6	32	1616	3	senora
sola	4	55	4186	3	__sola
stanol	6	3	1072	3	stanol_
stanols	7	3	973	3	stanols
tabla	7	33	1836	3	ta_bla
tala	4	59	3805	3	ta__la
tanga	6	49	2371	3	tan_ga
tangle	7	40	1997	3	tangle
tangly	10	44	1393	3	tangly
tanka	9	38	1749	3	tan_ka
tantra	6	37	1336	3	tantra
taxol	12	40	1136	3	taxol_
taxols	13	32	863	3	taxols
tola	4	52	3633	3	__tola
vanda	9	45	1592	3	van_da
vandal	10	37	1383	3	vandal
vanilla	10	23	874	3	vanilla
vanload	11	4	470	3	vanload
variola	10	6	889	3	variola
viola	8	59	1554	3	_viola
walla	8	53	2103	3	wa_lla
wandle	10	53	1666	3	wandle
wangle	10	38	1751	3	wangle
wanly	11	51	1802	3	wan_ly
yantra	9	44	962	3	yantra
zanana	15	38	1036	3	zanana
zanily	18	3	1018	3	zanily
zanza	13	7	870	3	zan_za
zonula	15	3	722	3	zonula

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	514	5.720	19705.6
3	Display Results	514	514	0.173	2971.1
	(SQL Overall)	178691	514	6.313	28305.2