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

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

421 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
canolas	9	3	1399	(None)
canola	8	3	1362	1	canola_
canulas	9	3	1285	1	canulas
anlas	5	56	2693	2	_an_las
anoas	5	72	2649	2	_ano_as
anoles	6	48	2742	2	_anoles
cabalas	11	35	1600	2	cabalas
caeomas	11	3	839	2	caeomas
cajoles	16	37	1210	2	cajoles
callas	8	45	2675	2	ca_llas
canals	8	44	2166	2	canal_s
canchas	14	32	1240	2	canchas
candelas	11	3	953	2	candelas
candles	10	44	2234	2	candles
canellas	10	3	1056	2	canellas
cannas	8	45	1840	2	can_nas
cannolis	10	3	786	2	cannolis
cannulas	10	3	758	2	cannulas
canoers	9	43	1837	2	canoers
canoes	8	47	2588	2	cano_es
canons	8	55	2206	2	cano_ns
cantalas	10	40	1352	2	cantalas
cantals	9	39	1957	2	cantals
cantles	9	47	2141	2	cantles
canula	8	3	1296	2	canula_
canulae	9	3	1118	2	canulae
canular	9	3	1032	2	canular
canvas	11	38	1333	2	can_vas
canzonas	19	3	538	2	canzonas
carols	8	51	2498	2	carol_s
carolus	9	46	1260	2	carolus
cholas	11	48	1799	2	c_holas
citolas	9	3	934	2	citolas
colas	7	54	3677	2	c__olas
crapolas	12	4	740	2	crapolas
cupolas	11	27	775	2	cupolas
granolas	9	3	805	2	granolas
mandolas	11	3	913	2	mandolas
manilas	9	39	1587	2	manilas
payolas	12	14	897	2	payolas
ranulas	7	3	1177	2	ranulas
abomas	10	11	1358	3	_abomas
acerolas	10	4	805	3	acerolas
acholias	13	4	957	3	acholias
acnodes	10	3	782	3	acnodes
agoras	7	6	1334	3	_agoras
aholds	10	46	948	3	_aholds
aiolis	6	3	1684	3	_aiolis
akelas	10	3	1119	3	_akelas
alas	4	63	5812	3	_a__las
alohas	9	4	1170	3	_alohas
amoles	8	41	2219	3	_amoles
anabas	8	3	1408	3	_anabas
anas	4	66	4986	3	_an__as
aneles	6	46	2629	3	_aneles
angas	6	58	2798	3	_an_gas
angles	7	44	2670	3	_angles
anglos	7	44	1390	3	_anglos
angoras	8	8	1136	3	_angoras
anils	5	63	2672	3	_anil_s
animas	8	44	1872	3	_animas
ankles	10	48	1838	3	_ankles
annals	6	64	1592	3	_annals
annas	5	58	2488	3	_an_nas
annonas	7	3	879	3	annonas
anoa	4	56	3447	3	_ano_a_
anodal	7	25	1211	3	_anodal
anodes	7	44	1875	3	_anodes
anole	5	53	3037	3	_anol_e
anopias	9	24	1247	3	_anopias
anorak	10	3	892	3	_anorak
anoraks	11	3	760	3	_anoraks
anoxias	14	25	910	3	_anoxias
antas	5	54	3203	3	_an_tas
apnoeas	9	4	635	3	apnoeas
areolas	7	10	1386	3	areolas
aromas	8	10	1861	3	_aromas
atlas	5	58	2158	3	_a_tlas
atolls	6	55	1135	3	_atolls
awols	8	47	1352	3	_awol_s
azoles	15	46	1461	3	_azoles
balas	7	69	3721	3	ba__las
bananas	9	33	1222	3	bananas
bandas	9	51	2054	3	ban_das
bandoras	11	3	874	3	bandoras
bangles	10	36	1741	3	bangles
bolas	7	47	3376	3	__bolas
cabala	10	35	1691	3	cabala_
cabals	10	40	2015	3	cabal_s
cabanas	11	24	1303	3	cabanas
cabbalas	14	6	737	3	cabbalas
cables	10	45	2755	3	ca_bles
cabobs	12	43	1189	3	cabo_bs
cabombas	16	4	381	3	cabombas
cacas	9	56	2798	3	ca__cas
cackles	15	37	1720	3	cackles
caeoma	10	3	903	3	caeoma_
cahoots	12	3	847	3	cahoots
cahows	14	39	912	3	caho_ws
cajole	15	40	1118	3	cajol_e
cajoled	17	42	827	3	cajoled
cajoler	16	39	839	3	cajoler
cajolers	17	26	713	3	cajolers
cajones	16	33	1133	3	cajones
calash	11	3	1243	3	ca__lash
calesas	9	4	1182	3	calesas
calfs	10	49	1938	3	ca__lfs
calks	11	54	2160	3	ca__lks
calla	7	48	2707	3	ca_lla_
callan	8	36	1960	3	ca_llan
callans	9	45	1847	3	ca_llans
callous	9	35	1659	3	callous
calls	7	56	3473	3	ca__lls
callus	8	53	1707	3	ca_llus
calms	9	52	2235	3	ca__lms
calos	7	44	3190	3	ca__los
camas	9	63	3352	3	ca__mas
camelias	12	5	1029	3	camelias
camels	10	52	1708	3	camel_s
cameras	11	3	1334	3	cameras
camisas	11	34	1192	3	camisas
camorras	12	11	649	3	camorras
camos	9	59	2761	3	camo__s
canal	7	54	2804	3	can__al
canaled	10	36	1555	3	canaled
canalise	10	8	1621	3	canalise
canapes	11	12	1308	3	canapes
canards	10	3	1120	3	canards
canastas	10	3	769	3	canastas
cancan	10	3	1410	3	can_can
cancans	11	3	1187	3	cancans
cancels	11	41	1331	3	cancels
cancers	11	40	1858	3	cancers
cancha	13	44	1161	3	cancha_
candela	10	8	974	3	candela_
candidas	12	33	864	3	candidas
candids	11	38	1269	3	candids
candies	10	41	2561	3	candies
candle	9	43	2148	3	candl_e
candled	11	38	1573	3	candled
candler	10	35	1659	3	candler
candlers	11	42	1410	3	candlers
candors	10	42	1676	3	candors
candours	11	40	861	3	candours
canella	9	3	1079	3	canella
caners	8	46	2919	3	can_ers
canes	7	53	5037	3	can__es
canfuls	12	4	842	3	canfuls
cangues	10	6	1182	3	cangues
canids	9	51	1813	3	can_ids
canines	9	37	2403	3	canines
cankers	13	44	1875	3	cankers
canna	7	59	1933	3	can_na_
cannels	9	34	1336	3	cannels
canners	9	38	2266	3	canners
cannoli	9	3	726	3	cannol_i
cannons	9	44	1288	3	cannons
cannula	9	3	743	3	cannula_
cannulae	10	4	649	3	cannulae
cannular	10	4	628	3	cannular
canoe	7	56	2725	3	cano__e
canoed	9	46	1895	3	cano_ed
canoeist	10	3	1069	3	canoeist
canoer	8	51	2107	3	cano_er
canon	7	47	2530	3	cano__n
canoness	10	3	939	3	canoness
canonic	11	3	1293	3	canonic
canonise	10	5	1109	3	canonise
canonist	10	5	1353	3	canonist
canonry	12	3	592	3	canonry
canoodles	12	4	399	3	canoodles
canopic	13	3	880	3	canopic
canopies	12	3	1185	3	canopies
canopy	13	3	772	3	cano_py
canorous	10	3	1019	3	canorous
cans	6	50	5084	3	can___s
cansos	8	49	1538	3	can_sos
cantal	8	41	2203	3	can_tal
cantala	9	41	1467	3	cantala
cantatas	10	34	1008	3	cantatas
canters	9	48	2772	3	canters
canthal	12	4	1005	3	canthal
canthus	12	4	870	3	canthus
cantinas	10	27	1377	3	cantinas
cantle	8	45	2215	3	cantl_e
cantonal	10	3	890	3	cantonal
cantons	9	52	2120	3	cantons
cantors	9	46	2075	3	cantors
cantos	8	48	2697	3	can_tos
cantrap	11	33	1027	3	cantrap
cantraps	12	31	911	3	cantraps
cants	7	70	3694	3	can__ts
cantus	8	51	1776	3	can_tus
canulate	10	3	1455	3	canulate
canulates	11	3	1286	3	canulates
canvass	12	37	687	3	canvass
canyons	12	45	1159	3	canyons
canzona	18	3	607	3	canzona_
canzones	19	3	915	3	canzones
capelan	11	3	900	3	capelan
capelans	12	3	801	3	capelans
capias	10	3	1835	3	ca_pias
capons	10	41	1950	3	capo_ns
caporal	11	4	1094	3	caporal
caporals	12	3	892	3	caporals
capos	9	48	2607	3	capo__s
capotes	11	3	1464	3	capotes
carboras	12	3	1157	3	carboras
cardias	10	7	1509	3	cardias
carinas	9	36	2238	3	carinas
cariocas	12	3	966	3	cariocas
carioles	10	8	1706	3	carioles
caritas	9	33	1694	3	caritas
carles	8	54	3508	3	ca_rles
carload	10	3	978	3	carload
carloads	11	3	839	3	carloads
carls	7	70	3742	3	ca_rl_s
carobs	10	48	1810	3	caro_bs
carol	7	51	2861	3	carol__
caroled	10	37	1768	3	caroled
caroler	9	38	1675	3	caroler
carolers	10	33	1417	3	carolers
caroli	8	59	1823	3	carol_i
caroms	10	56	1957	3	caro_ms
carpals	11	34	1462	3	carpals
casabas	11	3	998	3	casabas
casas	7	53	2784	3	ca__sas
casavas	12	3	781	3	casavas
casitas	9	33	1204	3	casitas
cassias	9	35	1434	3	cassias
castles	9	49	1773	3	castles
casuals	9	14	1052	3	casuals
catalase	10	3	921	3	catalase
catalos	9	4	1416	3	catalos
catalpas	12	4	673	3	catalpas
catclaw	14	4	397	3	catclaw
catclaws	15	4	363	3	catclaws
catenas	9	3	1310	3	catenas
caudles	10	39	1281	3	caudles
caulds	9	55	1238	3	ca_ulds
caules	8	59	2725	3	ca_ules
caulis	8	53	2007	3	ca_ulis
caulks	12	56	1186	3	ca_ulks
cauls	7	57	2777	3	ca_ul_s
causals	9	14	1118	3	causals
cavallas	13	6	684	3	cavallas
cavils	11	40	1439	3	cavil_s
cavorts	12	3	793	3	cavorts
cedulas	10	5	850	3	cedulas
cenotes	9	28	1454	3	cenotes
centals	9	43	1705	3	centals
centas	8	50	2070	3	cen_tas
challas	12	44	1412	3	challas
chanoyus	16	4	391	3	chanoyus
chelas	11	38	1720	3	c_helas
chimlas	14	3	745	3	chimlas
chola	10	47	1803	3	c_hola_
chollas	12	38	1135	3	chollas
cholos	11	47	1685	3	c_holos
chromas	14	25	1268	3	chromas
cibols	10	3	952	3	cibol_s
cicalas	11	3	929	3	cicalas
cinemas	11	3	802	3	cinemas
cineoles	10	10	940	3	cineoles
cineols	9	12	885	3	cineol_s
citola	8	3	839	3	citola_
citoles	9	3	1255	3	citoles
coalas	8	74	1896	3	c_oalas
coals	7	61	2960	3	c__oals
cocas	9	59	2657	3	c__ocas
cocoas	10	49	1574	3	coco_as
codas	8	47	2424	3	c__odas
cola	6	65	4139	3	c__ola_
colds	8	57	2697	3	c__olds
coles	7	60	5506	3	c__oles
cols	6	65	5308	3	c__ol_s
colts	7	66	3329	3	c__olts
colzas	17	40	1050	3	c__olzas
comas	9	58	3300	3	c__omas
conchas	14	40	1331	3	conchas
condoles	11	30	1580	3	condoles
congas	9	44	1703	3	con_gas
conoids	10	8	1388	3	conoids
consoles	10	32	1615	3	consoles
consols	9	29	1407	3	consol_s
contras	9	30	1560	3	contras
cools	7	56	3263	3	c_ool_s
copulas	11	38	1156	3	copulas
corollas	10	3	920	3	corollas
coronas	9	39	1690	3	coronas
crankles	14	35	1015	3	crankles
crapola	11	3	691	3	crapola_
creoles	9	9	1332	3	creoles
cupola	10	31	769	3	cupola_
cutlas	8	3	1309	3	c_utlas
cyanoses	13	3	742	3	cyanoses
cyanosis	13	4	627	3	cyanosis
cymols	13	7	719	3	cymol_s
dagobas	11	4	514	3	dagobas
dandles	9	42	1853	3	dandles
dangles	9	36	1842	3	dangles
dongolas	10	4	534	3	dongolas
enolase	7	3	1019	3	_enolase
enols	5	47	1840	3	_enol_s
fanegas	11	4	571	3	fanegas
fanfolds	15	10	407	3	fanfolds
fangas	10	50	1719	3	fan_gas
fanons	9	61	1521	3	fano_ns
fanos	8	59	2650	3	fano__s
favelas	13	3	702	3	favelas
galas	6	57	3164	3	ga__las
ganjas	14	14	911	3	gan_jas
ganofs	10	40	1029	3	gano_fs
ganoids	9	3	932	3	ganoids
gaols	6	67	1757	3	ga_ol_s
genoas	7	40	1362	3	geno_as
gondolas	10	4	619	3	gondolas
granola	8	3	791	3	granola_
halalas	10	42	1408	3	halalas
halloas	10	43	1846	3	halloas
handles	11	40	2065	3	handles
hansas	9	46	1604	3	han_sas
hantles	10	41	1751	3	hantles
haoles	9	49	1980	3	ha_oles
hawalas	13	34	835	3	hawalas
jangles	15	40	1568	3	jangles
kabalas	13	39	1106	3	kabalas
kamalas	13	33	912	3	kamalas
kanakas	10	32	721	3	kanakas
kanas	9	53	2691	3	kan__as
knolls	10	36	741	3	_knolls
kolas	9	48	2223	3	__kolas
lanolin	7	3	1064	3	lanolin
lanolins	8	3	1052	3	lanolins
maculas	11	31	1401	3	maculas
magnolias	12	4	471	3	magnolias
mananas	9	34	1473	3	mananas
manas	7	62	4042	3	man__as
mandalas	11	3	943	3	mandalas
mandola	10	3	902	3	mandola_
mangas	9	41	2292	3	man_gas
mangles	10	40	2146	3	mangles
mangolds	12	3	519	3	mangolds
manholes	13	3	1118	3	manholes
manias	8	40	2903	3	man_ias
manila	8	45	1830	3	manila_
manillas	10	26	1116	3	manillas
maniocas	12	29	846	3	maniocas
mannas	8	50	1980	3	man_nas
manors	8	44	2088	3	mano_rs
manos	7	49	3361	3	mano__s
mantas	8	57	2536	3	man_tas
mantles	9	48	2070	3	mantles
mantras	9	38	1586	3	mantras
mantuas	9	34	1099	3	mantuas
manuals	9	3	1121	3	manuals
masalas	9	3	1205	3	masalas
molas	7	51	3209	3	__molas
moolas	8	36	1559	3	_moolas
nalas	5	55	2836	3	__nalas
nanas	5	59	2863	3	nan__as
nolos	5	44	2335	3	__nolos
nomas	7	47	2641	3	__nomas
nonas	5	51	2665	3	__nonas
noncolas	10	4	861	3	noncolas
novas	8	52	1536	3	__novas
octanols	10	4	455	3	octanol_s
paellas	9	4	1141	3	paellas
pagodas	11	36	755	3	pagodas
pakoras	13	3	747	3	pakoras
panadas	10	33	1221	3	panadas
panamas	11	31	1275	3	panamas
pandas	9	55	2196	3	pan_das
pandoras	11	3	1005	3	pandoras
panels	8	47	1652	3	panel_s
pangas	9	99	2110	3	pan_gas
panochas	15	4	565	3	panochas
paroles	9	50	2588	3	paroles
parols	8	47	2261	3	parol_s
payola	11	20	811	3	payola_
pinoles	9	34	1870	3	pinoles
pyrolas	12	3	986	3	pyrolas
qabalas	18	28	950	3	qabalas
radulas	8	3	958	3	radulas
ramblas	11	27	1026	3	ramblas
ramonas	9	3	1109	3	ramonas
rankles	11	31	1454	3	rankles
ranula	6	3	1181	3	ranula_
ranular	7	3	943	3	ranular
rugolas	8	3	637	3	rugolas
salols	6	40	1787	3	salol_s
samosas	9	3	929	3	samosas
sandals	8	27	1520	3	sandals
sangas	7	52	2265	3	san_gas
santols	7	35	1332	3	santol_s
sapotas	9	3	960	3	sapotas
scandals	11	3	699	3	scandals
scandias	11	3	786	3	scandias
scapulas	12	4	613	3	scapulas
senoras	7	27	1495	3	senoras
stanols	7	3	973	3	stanol_s
tablas	8	37	1616	3	ta_blas
talas	5	59	3589	3	ta__las
tangles	8	39	2004	3	tangles
tankas	10	46	1376	3	tan_kas
tantras	7	31	1209	3	tantras
taxols	13	32	863	3	taxol_s
tolas	5	45	3277	3	__tolas
vandals	11	32	1166	3	vandals
vandas	10	39	1599	3	van_das
vanillas	11	22	812	3	vanillas
vanload	11	4	470	3	vanload
vanloads	12	6	416	3	vanloads
variolas	11	6	853	3	variolas
violas	9	37	1352	3	_violas
wallas	9	57	1939	3	wa_llas
wangles	11	34	1693	3	wangles
yantras	10	25	900	3	yantras
zananas	16	31	956	3	zananas
zanzas	14	8	705	3	zan_zas
zonulas	16	3	702	3	zonulas

Search took 9 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	134027	0.156	1145455.1
2	DLD Change Limit	134027	421	7.703	17399.3
3	Display Results	421	421	0.156	2698.7
	(SQL Overall)	178691	421	8.015	22294.6