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

Here are the results of your fuzzy-string dictionary search for “cancha” 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
cancha	13	44	1161	(None)
canchas	14	32	1240	1	canchas
concha	13	42	1328	1	concha
acantha	12	5	466	2	acantha
ancho	10	45	1530	2	_ancho
caca	8	55	2808	2	ca_c_a
cache	12	51	2248	2	ca_che
caeca	9	39	1513	2	caec_a
cancan	10	3	1410	2	cancan
cancel	10	53	1668	2	cancel
cancer	10	42	2092	2	cancer
canna	7	59	1933	2	can_na
canola	8	3	1362	2	canola
canthal	12	4	1005	2	canthal
canthi	11	3	1097	2	canthi
canula	8	3	1296	2	canula
catch	12	51	2037	2	catch_
catchy	16	55	958	2	catchy
cinch	12	45	1624	2	cinch_
conch	12	46	2007	2	conch_
conchae	14	39	1164	2	conchae
conchal	14	42	1158	2	conchal
conchas	14	40	1331	2	conchas
concho	13	44	1426	2	concho
conchs	13	47	1490	2	conchs
conchy	16	37	1022	2	conchy
cranch	13	36	1353	2	cranch_
dacha	11	48	1257	2	da_cha
datcha	12	6	656	2	datcha
manche	13	35	1510	2	manche
pacha	12	65	1806	2	pa_cha
panchax	21	3	498	2	panchax
panocha	14	4	498	2	panocha
ranch	10	50	1979	2	ranch_
rancho	11	43	1085	2	rancho
sancta	8	3	983	2	sancta
acacia	10	3	1135	3	acacia
acanthae	13	4	337	3	acanthae
acanthi	12	4	466	3	acanthi
ache	9	68	2982	3	_a_che
achy	12	63	1609	3	_a_chy
acta	6	95	2480	3	_a_cta
aecia	7	38	1928	3	_aecia
agha	8	74	1730	3	_a_gha
aha	6	112	4664	3	_a__ha
aloha	8	5	1362	3	_aloha
alpha	10	4	965	3	_alpha
ana	3	95	5983	3	_an__a
anchor	11	39	1197	3	_anchor
anchos	11	42	1489	3	_anchos
anchusa	12	4	433	3	_anchusa
ancon	7	57	1823	3	_ancon
anga	5	68	3135	3	_an_ga
anima	7	46	2007	3	_anima
ankh	11	11	1441	3	_ankh_
ankhs	12	11	672	3	_ankhs
anna	4	55	2901	3	_an_na
anoa	4	56	3447	3	_an_oa
ansa	4	59	2777	3	_an_sa
anta	4	68	3958	3	_an_ta
antra	5	65	2192	3	_antra
arch	9	86	2844	3	_arch_
bacca	11	10	1218	3	ba_cca
bach	11	61	3139	3	ba_ch_
banana	8	32	1341	3	banana
banco	9	40	1939	3	banc_o
bancos	10	47	1389	3	bancos
banda	8	52	2310	3	ban_da
barca	9	13	1943	3	barc_a
barchan	14	6	913	3	barchan
batch	12	46	2010	3	batch_
bench	12	56	1950	3	bench_
blanch	13	34	1085	3	blanch_
branch	13	40	1477	3	branch_
branchia	15	21	771	3	branchia
branchy	17	35	791	3	branchy
bunch	12	51	1860	3	bunch_
bunchy	16	43	746	3	bunchy
cabala	10	35	1691	3	cabala
cabana	10	39	1356	3	cabana
cacao	9	54	2000	3	ca_cao
cacas	9	56	2798	3	ca_cas
cached	14	54	1920	3	ca_ched
caches	13	79	2691	3	ca_ches
cachet	13	45	2641	3	ca_chet
cachou	13	3	1062	3	ca_chou
cachucha	17	4	171	3	cachucha
cacti	9	3	1864	3	ca_cti
caecal	10	37	1373	3	caecal
caecum	12	3	818	3	caecum
caeoma	10	3	903	3	caeoma
calcar	10	3	1275	3	calcar
calces	10	44	2005	3	calces
calcic	9	3	1187	3	calcic
caleche	14	29	795	3	caleche
calesa	8	4	1247	3	calesa
caliche	14	32	996	3	caliche
calla	7	48	2707	3	ca_lla
cambia	12	49	1315	3	cambia
camera	10	3	1369	3	camera
camisa	10	31	1432	3	camisa
can	5	77	6014	3	can___
canal	7	54	2804	3	can_al
canals	8	44	2167	3	canals
canape	10	9	1351	3	canape
canard	9	3	1476	3	canard
canary	11	3	1469	3	canary
canasta	9	3	836	3	canasta
cancans	11	3	1187	3	cancans
cancels	11	41	1331	3	cancels
cancers	11	40	1858	3	cancers
candela	10	8	974	3	candela
candid	10	45	1785	3	candid
candida	11	41	1025	3	candida
candle	9	43	2148	3	candle
candor	9	45	1642	3	candor
candy	11	51	1982	3	can_dy
cane	6	66	5312	3	can__e
caned	8	58	3809	3	can_ed
canella	9	3	1079	3	canella
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	1244	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
canner	8	46	2598	3	canner
cannie	8	38	1936	3	cannie
cannon	8	45	1444	3	cannon
cannot	8	36	1677	3	cannot
cannula	9	3	743	3	cannula
canny	10	58	1769	3	can_ny
canoe	7	56	2725	3	can_oe
canoed	9	46	1896	3	canoed
canoer	8	51	2107	3	canoer
canoes	8	47	2588	3	canoes
canolas	9	3	1399	3	canolas
canon	7	47	2530	3	can_on
canons	8	55	2206	3	canons
canopy	13	3	772	3	canopy
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
cantala	9	41	1467	3	cantala
cantata	9	38	1181	3	cantata
canted	9	48	2578	3	canted
canter	8	52	3011	3	canter
canthus	12	4	871	3	canthus
cantic	10	39	2054	3	cantic
cantina	9	34	1725	3	cantina
cantle	8	45	2215	3	cantle
canto	7	49	3101	3	can_to
canton	8	57	2299	3	canton
cantor	8	56	2152	3	cantor
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
canulae	9	3	1118	3	canulae
canular	9	3	1032	3	canular
canulas	9	3	1285	3	canulas
canvas	11	38	1333	3	canvas
canyon	11	45	1203	3	canyon
canzona	18	3	607	3	canzona
caph	11	66	2329	3	ca_ph_
caphs	12	45	1537	3	ca_phs
capita	10	29	1377	3	capita
capuche	16	4	443	3	capuche
carcel	10	50	1867	3	carcel
cardia	9	9	1638	3	cardia
carina	8	43	2533	3	carina
caroch	13	9	1176	3	caroch_
caroche	14	6	924	3	caroche
casa	6	56	3086	3	ca__sa
casaba	10	7	926	3	casaba
casava	11	5	787	3	casava
casbah	13	3	790	3	casbah
cascara	11	3	831	3	cascara
cash	9	66	3628	3	ca_sh_
cashaw	14	43	979	3	ca_shaw
casita	8	29	1370	3	casita
cassia	8	37	1476	3	cassia
catchall	15	4	623	3	catchall
catcher	14	31	1582	3	catcher
catches	14	43	2077	3	catches
catchup	16	4	479	3	catchup
catclaw	14	4	397	3	catclaw
catechu	14	4	447	3	catechu
catena	8	3	1248	3	catena
caucus	10	3	961	3	caucus
caught	12	49	1168	3	caught
ceca	8	48	2078	3	c_ec_a
centra	8	41	1388	3	centra
chachka	21	17	364	3	chachka
chacma	15	3	790	3	chacma
chance	13	46	1709	3	chanc_e
chanced	15	41	1321	3	chanced
chancel	14	40	1177	3	chancel
chancer	14	42	1563	3	chancer
chances	14	52	1809	3	chances
chancre	14	34	878	3	chancre
chancy	16	40	1086	3	chanc_y
charkha	19	40	515	3	charkha
chatchka	22	20	289	3	chatchka
chica	12	58	1826	3	chic_a
chichi	16	3	709	3	chichi
chinch	16	39	1123	3	chinch_
chinchy	20	33	551	3	chinchy
cinched	15	39	1086	3	cinched
cinches	14	42	1577	3	cinches
cinchona	15	5	440	3	cinchona
cinema	10	4	765	3	cinema
circa	9	3	1140	3	circ_a
clach	12	46	1782	3	clach_
clachan	14	3	718	3	clachan
clachs	13	35	1132	3	clachs
claucht	14	4	558	3	claucht
clench	13	39	1005	3	clench_
cliche	13	37	1245	3	cliche
clinch	13	39	1035	3	clinch_
cloche	13	43	1237	3	cloche
cnida	8	7	895	3	c_nida
coach	12	59	1945	3	coach_
coanchor	15	4	525	3	coanchor
coca	8	80	3064	3	c_oc_a
cocoa	9	85	1788	3	c_ocoa
conceal	11	33	1301	3	conceal
conches	14	40	1981	3	conches
conchie	14	33	1268	3	conchie
conchos	14	43	1396	3	conchos
concur	10	4	1110	3	concur
conga	8	54	1987	3	con_ga
contra	8	33	1470	3	contra
cooch	12	49	1683	3	cooch_
couch	12	53	2011	3	couch_
cranched	16	32	1041	3	cranched
cranches	15	31	1454	3	cranches
crania	8	24	1843	3	cran_ia
cratch	13	41	1079	3	cratch_
craunch	14	6	444	3	craunch_
creche	13	3	1076	3	creche
crunch	13	34	950	3	crunch_
crunchy	17	32	476	3	crunchy
culch	12	45	1283	3	culch_
curch	12	44	1541	3	curch_
cutch	12	51	1619	3	cutch_
dachas	12	41	1325	3	da_chas
dance	8	52	2313	3	danc_e
danced	10	53	1525	3	danced
dancer	9	48	1761	3	dancer
dances	9	51	2065	3	dances
datchas	13	4	742	3	datchas
dunch	11	53	1626	3	dunch_
each	9	55	3058	3	ea_ch_
facia	10	32	1846	3	fa_cia
fancy	13	46	1548	3	fanc_y
fanega	10	5	578	3	fanega
fanga	9	61	1962	3	fan_ga
fascia	11	4	870	3	fascia
finca	10	47	1450	3	finc_a
finch	13	54	1697	3	finch_
ganache	13	4	622	3	ganache
ganja	13	14	1000	3	gan_ja
ganjah	17	14	550	3	ganjah
gauche	12	3	856	3	gauche
gaucho	12	5	622	3	gaucho
gotcha	12	3	463	3	gotcha
haha	10	78	2106	3	ha__ha
halacha	15	38	802	3	halacha
hance	10	54	2415	3	hanc_e
hances	11	56	2128	3	hances
haniwa	12	3	674	3	haniwa
hansa	8	54	1678	3	han_sa
hatch	13	57	1959	3	hatch_
haunch	14	37	734	3	haunch_
honcho	14	38	938	3	honcho
hunch	13	64	1621	3	hunch_
inch	9	54	2082	3	_inch_
kana	8	59	2853	3	kan__a
kanaka	9	35	752	3	kanaka
kasha	12	47	1072	3	ka_sha
kench	14	55	1392	3	kench_
kwacha	18	3	298	3	kwacha
laich	10	59	2071	3	laich_
laichs	11	51	1089	3	laichs
lance	7	51	2672	3	lanc_e
lanced	9	37	1772	3	lanced
lancer	8	43	1997	3	lancer
lances	8	48	2410	3	lances
lancet	8	42	2357	3	lancet
larch	10	59	1979	3	larch_
latch	10	46	2046	3	latch_
launch	11	36	806	3	launch_
lunch	10	49	1724	3	lunch_
lynch	13	46	898	3	lynch_
macchia	16	4	589	3	macchia
mach	11	61	3448	3	ma_ch_
mache	12	59	2530	3	ma_che
macho	12	61	2015	3	ma_cho
machs	12	57	2256	3	ma_chs
maltha	11	3	751	3	maltha
mana	6	53	4196	3	man__a
manana	8	48	1607	3	manana
manches	14	38	1862	3	manches
manchet	14	33	1778	3	manchet
manga	8	50	2620	3	man_ga
mania	7	56	3415	3	man_ia
manila	8	45	1830	3	manila
manna	7	55	2254	3	man_na
manta	7	56	2991	3	man_ta
mantra	8	41	1609	3	mantra
mantua	8	44	1202	3	mantua
march	12	56	2289	3	march_
match	12	56	2110	3	match_
mocha	12	4	992	3	_mocha
munch	12	49	1710	3	munch_
nachas	11	49	1419	3	na_chas
nacho	10	54	1438	3	na_cho
nana	4	66	3290	3	nan__a
nance	7	47	2184	3	nanc_e
nances	8	36	1864	3	nances
nancy	10	52	1492	3	nanc_y
natch	10	50	1822	3	natch_
nucha	10	22	979	3	_nucha
paca	8	51	3224	3	pa_c_a
pachas	13	50	1714	3	pa_chas
painch	13	35	1132	3	painch_
pakeha	15	3	393	3	pakeha
panacea	11	3	779	3	panacea
panache	14	5	843	3	panache
panada	9	41	1305	3	panada
panama	10	42	1335	3	panama
panda	8	50	2261	3	pan_da
panga	8	53	2353	3	pan_ga
panochas	15	4	565	3	panochas
panoche	14	5	638	3	panoche
parch	12	51	2300	3	parch_
paschal	14	15	724	3	paschal
pasha	10	54	1718	3	pa_sha
patch	12	52	2122	3	patch_
patchy	16	50	957	3	patchy
paunch	13	36	985	3	paunch_
paunchy	17	32	444	3	paunchy
pinch	12	56	1930	3	pinch_
planch	13	37	1144	3	planch_
planche	14	29	975	3	planche
poncho	13	33	1012	3	poncho
punch	12	51	1842	3	punch_
punchy	16	39	852	3	punchy
rance	7	50	2851	3	ranc_e
rances	8	46	2544	3	rances
ranched	13	31	1360	3	ranched
rancher	12	30	1363	3	rancher
ranches	12	36	2011	3	ranches
ranchman	15	4	604	3	ranchman
ranchos	12	39	1139	3	ranchos
rancid	9	5	1386	3	rancid
rancor	8	8	1037	3	rancor
ranula	6	3	1181	3	ranula
ratch	10	42	2136	3	ratch_
raunch	11	35	843	3	raunch_
raunchy	15	28	431	3	raunchy
sacra	7	45	1699	3	sa_cra
sandhi	10	3	819	3	sandhi
sanga	6	60	2379	3	san_ga
sangh	9	55	1745	3	sangh_
sanghs	10	53	1206	3	sanghs
sauch	10	49	1877	3	sauch_
sauchs	11	51	1223	3	sauchs
scandia	10	3	806	3	scandia
stanch	11	38	1237	3	stanch_
synch	13	50	1179	3	synch_
synchs	14	40	845	3	synchs
tach	9	61	3275	3	ta_ch_
tache	10	62	2237	3	ta_che
tachs	10	58	2093	3	ta_chs
tanga	6	49	2369	3	tan_ga
tanka	9	38	1748	3	tan_ka
tantra	6	37	1335	3	tantra
tench	10	56	2000	3	tench_
tranche	12	33	1222	3	tranche
uncia	7	50	1516	3	_uncia
vacua	10	5	1046	3	va_cua
vanda	9	45	1592	3	van_da
vinca	10	53	1516	3	vinc_a
watch	13	56	1706	3	watch_
waucht	14	39	941	3	waucht
wench	13	62	1478	3	wench_
winch	13	50	1666	3	winch_
xanthan	17	3	601	3	xanthan
yacht	13	4	1739	3	ya_cht
yantra	9	44	962	3	yantra
zanana	15	38	1036	3	zanana
zanza	13	7	870	3	zan_za

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.406	440125.6
2	DLD Change Limit	112716	405	6.046	18643.1
3	Display Results	405	405	0.126	3214.3
	(SQL Overall)	178691	405	6.578	27164.9