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

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

317 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
concha	13	42	1328	(None)
cancha	13	44	1161	1	cancha
conch	12	46	2007	1	conch_
conchae	14	39	1164	1	conchae
conchal	14	42	1159	1	conchal
conchas	14	40	1331	1	conchas
concho	13	44	1426	1	concho
conchs	13	47	1490	1	conchs
conchy	16	37	1022	1	conchy
canchas	14	32	1240	2	canchas
cinch	12	45	1624	2	cinch_
coach	12	59	1945	2	coach_
coca	8	80	3064	2	co_c_a
cocoa	9	85	1788	2	co_coa
conceal	11	33	1302	2	conceal
conches	14	40	1981	2	conches
conchie	14	33	1268	2	conchie
conchos	14	43	1396	2	conchos
concur	10	4	1110	2	concur
conga	8	54	1987	2	con_ga
contra	8	33	1470	2	contra
cooch	12	49	1683	2	cooch_
couch	12	53	2011	2	couch_
gotcha	12	3	463	2	gotcha
honcho	14	38	938	2	honcho
mocha	12	4	992	2	mo_cha
poncho	13	33	1012	2	poncho
acantha	12	5	466	3	acantha
ancho	10	45	1530	3	_ancho
bench	12	56	1950	3	bench_
boccia	12	33	879	3	boccia
boche	12	42	1695	3	bo_che
bonita	8	3	1294	3	bonita
botch	12	67	1745	3	botch_
botchy	16	53	782	3	botchy
bronchi	14	17	631	3	bronchi
bronchia	15	19	599	3	bronchia
broncho	14	20	646	3	broncho
bunch	12	51	1860	3	bunch_
bunchy	16	43	746	3	bunchy
caca	8	55	2808	3	c_ac_a
cache	12	51	2248	3	c_ache
caeca	9	39	1513	3	caec_a
cancan	10	3	1410	3	cancan
cancel	10	53	1668	3	cancel
cancer	10	42	2092	3	cancer
canna	7	59	1933	3	can_na
canola	8	3	1362	3	canola
canthal	12	4	1005	3	canthal
canthi	11	3	1097	3	canthi
canula	8	3	1297	3	canula
catch	12	51	2037	3	catch_
catchy	16	55	958	3	catchy
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
chica	12	58	1826	3	chic_a
chichi	16	3	709	3	chichi
chinch	16	39	1124	3	chinch_
chinchy	20	33	552	3	chinchy
cinched	15	39	1086	3	cinched
cinches	14	42	1577	3	cinches
cinchona	15	5	441	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
clench	13	39	1005	3	clench_
cliche	13	37	1245	3	cliche
clinch	13	39	1035	3	clinch_
cloaca	10	3	726	3	cloac_a
cloche	13	43	1237	3	cloche
cnida	8	7	896	3	c_nida
coached	15	33	1384	3	coached
coacher	14	37	1412	3	coacher
coaches	14	40	1869	3	coaches
coachman	17	4	498	3	coachman
coact	9	61	3058	3	coac_t
coacts	10	53	1433	3	coacts
coala	7	75	2112	3	co_ala
coanchor	15	4	525	3	coanchor
cobia	9	41	1751	3	co_bia
cobra	9	52	1440	3	co_bra
cocas	9	59	2657	3	co_cas
coccal	9	3	1022	3	coccal
cocci	8	28	1267	3	co_cci
coccic	8	29	894	3	coccic
coccid	10	29	1074	3	coccid
coccus	9	7	928	3	coccus
coccyx	19	4	266	3	coccyx
cochair	14	4	631	3	co_chair
cochin	13	13	1320	3	co_chin
cochlea	14	3	534	3	co_chlea
cock	12	63	3290	3	co_c_k
cocks	13	52	2716	3	co_cks
cocky	16	42	1593	3	co_cky
coco	8	73	3060	3	co_c_o
cocoas	10	49	1574	3	co_coas
cocos	9	56	2469	3	co_cos
coda	7	70	2935	3	co__da
codeia	9	41	1219	3	codeia
coho	9	75	2449	3	co__ho
cola	6	65	4139	3	co__la
colza	16	51	1298	3	co_lza
coma	8	71	3485	3	co__ma
comma	11	45	1479	3	co_mma
con	5	102	6802	3	con___
concave	14	3	937	3	concave
conceals	12	31	1103	3	conceals
concede	12	3	1010	3	concede
conceit	11	32	1807	3	conceit
concent	11	44	2251	3	concent
concept	13	33	1444	3	concept
concern	11	30	1196	3	concern
concert	11	33	2522	3	concert
conchies	15	32	1485	3	conchies
conchoid	16	8	804	3	conchoid
concise	11	3	1447	3	concise
conclave	15	5	640	3	conclave
concoct	10	3	1290	3	concoct
concord	12	5	1034	3	concord
concurs	11	3	1147	3	concurs
concuss	11	3	806	3	concuss
condo	8	53	2259	3	con_do
condom	11	42	1536	3	condom
condor	9	46	1697	3	condor
condos	9	43	2233	3	condos
cone	6	72	5696	3	con__e
coned	8	60	4005	3	con_ed
cones	7	64	5742	3	con_es
coney	10	59	3288	3	con_ey
coneys	11	52	1842	3	coneys
confab	13	4	706	3	confab
confer	11	40	1868	3	confer
confit	11	33	1640	3	confit
congas	9	44	1703	3	congas
conge	8	52	2759	3	con_ge
congeal	10	40	1168	3	congeal
congee	9	60	2447	3	congee
conger	9	50	2427	3	conger
conges	9	49	2817	3	conges
congii	9	5	736	3	congii
congo	8	56	2313	3	con_go
congos	9	42	1988	3	congos
congou	9	43	1324	3	congou
coni	6	55	3480	3	con__i
conic	9	53	2979	3	con_ic
conical	11	3	1620	3	conical
conics	10	39	2059	3	conics
conidia	10	6	930	3	conidia
conies	8	43	3859	3	conies
conin	7	62	3272	3	con_in
conine	8	45	2855	3	conine
coning	9	43	3183	3	coning
conins	8	43	2723	3	conins
conium	10	4	1531	3	conium
conk	10	65	3144	3	con__k
conked	13	50	1911	3	conked
conker	12	47	2155	3	conker
conks	11	55	2570	3	con_ks
conky	14	58	1874	3	con_ky
conn	6	62	2913	3	con__n
conned	9	51	1970	3	conned
conner	8	44	2396	3	conner
conns	7	50	2423	3	con_ns
conoid	9	8	1888	3	conoid
cons	6	60	5769	3	con__s
consol	8	26	1411	3	consol
consul	8	23	1230	3	consul
conte	7	66	3320	3	con_te
contes	8	44	3291	3	contes
conto	7	60	2717	3	con_to
contos	8	49	2323	3	contos
contras	9	30	1562	3	contras
conus	7	67	2653	3	con_us
convex	18	36	774	3	convex
convey	14	46	1022	3	convey
convoy	14	34	854	3	convoy
cony	9	65	3783	3	con__y
cooches	14	35	1583	3	cooches
coocoo	10	6	969	3	coocoo
cooncan	11	4	723	3	cooncan
coppra	12	30	683	3	coppra
copra	9	81	1546	3	co_pra
coprah	13	37	1060	3	coprah
copula	10	28	1205	3	copula
coria	7	58	2832	3	co_ria
corncob	13	4	566	3	corncob
cornea	8	40	1893	3	cornea
corniche	15	7	592	3	corniche
cornua	8	54	1190	3	cornua
corona	8	38	1740	3	corona
coryza	20	7	458	3	coryza
cosh	9	61	2762	3	co_sh_
costa	7	55	2373	3	co_sta
cotta	7	58	1857	3	co_tta
couchant	15	4	905	3	couchant
couched	15	41	1579	3	couched
coucher	14	45	1585	3	coucher
couches	14	40	2047	3	couches
cough	11	58	1964	3	cough_
coughs	12	55	1454	3	coughs
council	11	3	747	3	council
couth	10	61	2249	3	couth_
couths	11	57	1541	3	couths
cowpea	13	3	764	3	cowpea
coxa	13	69	2296	3	co__xa
cranch	13	36	1353	3	cranch_
creche	13	3	1076	3	creche
crotch	13	34	1008	3	crotch_
crouch	13	39	1020	3	crouch_
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_
dacha	11	48	1257	3	_dacha
datcha	12	6	656	3	datcha
dona	5	55	2963	3	don__a
donga	7	67	1842	3	don_ga
donna	6	62	1503	3	don_na
douche	12	46	1322	3	douche
dunch	11	53	1626	3	dunch_
finca	10	47	1450	3	finc_a
finch	13	54	1697	3	finch_
gonia	6	41	1753	3	gon_ia
gotchas	13	3	461	3	gotchas
honchos	15	36	957	3	honchos
honda	9	4	1498	3	hon_da
hooch	13	58	1370	3	hooch_
hotch	13	62	1473	3	hotch_
hunch	13	64	1621	3	hunch_
inch	9	54	2082	3	_inch_
kench	14	55	1392	3	kench_
kwacha	18	3	298	3	kwacha
loach	10	51	1636	3	loach_
loca	6	55	2768	3	lo_c_a
loch	9	55	2713	3	lo_ch_
lochan	11	3	909	3	lo_chan
lochia	11	5	831	3	lo_chia
lochs	10	67	1551	3	lo_chs
louche	11	52	1266	3	louche
lunch	10	49	1724	3	lunch_
lynch	13	46	898	3	lynch_
manche	13	35	1510	3	manche
mochas	13	3	1066	3	mo_chas
monachal	15	4	571	3	monachal
month	10	48	1842	3	month_
months	11	38	1293	3	months
mooch	12	53	1361	3	mooch_
mouch	12	47	1580	3	mouch_
munch	12	49	1710	3	munch_
nona	4	69	2906	3	non__a
nonce	7	57	1982	3	nonc_e
nonces	8	44	1883	3	nonces
noncola	9	4	830	3	noncola
noncom	10	3	968	3	noncom
notch	10	56	1332	3	notch_
nucha	10	22	979	3	_nucha
oca	5	67	3173	3	_o_c_a
once	6	54	2308	3	_onc_e
oncet	7	46	2654	3	_oncet
orca	6	55	2277	3	_orc_a
ouch	9	57	2463	3	_ouch_
pacha	12	65	1806	3	_pacha
panchax	21	3	498	3	panchax
panocha	14	4	498	3	panocha
pinch	12	56	1930	3	pinch_
poach	12	49	1786	3	poach_
poachy	16	38	896	3	poachy
poisha	11	3	572	3	poisha
ponce	9	52	2251	3	ponc_e
ponced	11	43	1481	3	ponced
ponces	10	47	2084	3	ponces
ponchos	14	34	1070	3	ponchos
pooch	12	48	1530	3	pooch_
porch	12	59	1862	3	porch_
pouch	12	46	1708	3	pouch_
pouchy	16	53	866	3	pouchy
punch	12	51	1842	3	punch_
punchy	16	39	852	3	punchy
ranch	10	50	1979	3	ranch_
rancho	11	43	1085	3	rancho
rhonchal	16	4	268	3	rhonchal
rhonchi	15	4	250	3	rhonchi
roach	10	57	1700	3	roach_
rotch	10	58	1593	3	rotch_
rotche	11	43	1198	3	rotche
rouche	11	47	1431	3	rouche
sancta	8	3	983	3	sancta
sconce	10	47	1172	3	sconc_e
sconced	12	35	917	3	sconced
sconces	11	38	1145	3	sconces
scooch	13	22	812	3	scooch_
scorch	13	19	809	3	scorch_
scotch	13	20	752	3	scotch_
soca	6	63	3005	3	so_c_a
sonata	6	3	1322	3	sonata
synch	13	50	1179	3	synch_
synchs	14	40	845	3	synchs
tench	10	56	2000	3	tench_
tonga	6	56	1970	3	ton_ga
torch	10	74	2093	3	torch_
torchy	14	54	953	3	torchy
touch	10	65	1939	3	touch_
touche	11	49	1617	3	touche
touchy	14	50	1050	3	touchy
uncia	7	50	1516	3	_uncia
vinca	10	53	1516	3	vinc_a
vouch	13	46	1190	3	vouch_
wench	13	62	1478	3	wench_
winch	13	50	1666	3	winch_
zoecia	17	3	555	3	zoecia
zona	13	63	2196	3	zon__a
zonula	15	3	722	3	zonula

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.373	479064.3
2	DLD Change Limit	112716	317	5.393	20900.4
3	Display Results	317	317	0.093	3408.6
	(SQL Overall)	178691	317	5.859	30498.5