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

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

166 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
conchae	14	39	1164	(None)
concha	13	42	1328	1	concha_
conchal	14	42	1159	1	conchal
conchas	14	40	1331	1	conchas
conchie	14	33	1268	1	conchie
cancha	13	44	1161	2	cancha_
canchas	14	32	1240	2	canchas
concave	14	3	937	2	concave
conceal	11	33	1302	2	conceal
concede	12	3	1010	2	concede
conch	12	46	2007	2	conch__
conches	14	40	1981	2	conches
conchies	15	32	1485	2	conchies
concho	13	44	1426	2	conch_o
conchos	14	43	1396	2	conchos
conchs	13	47	1490	2	conch_s
conchy	16	37	1022	2	conch_y
concise	11	3	1447	2	concise
conclave	15	5	640	2	conclave
acanthae	13	4	337	3	acanthae
boche	12	42	1695	3	bo_ch_e
bouchee	14	33	1354	3	bouchee
cache	12	51	2248	3	c_ach_e
cancan	10	3	1410	3	canc_an
canthal	12	4	1005	3	canthal
canulae	9	3	1119	3	canulae
cinch	12	45	1624	3	cinch__
cinched	15	39	1086	3	cinched
cinches	14	42	1577	3	cinches
clachan	14	3	718	3	clachan
cliche	13	37	1245	3	clich_e
cloacae	11	4	523	3	cloac_ae
cloche	13	43	1237	3	cloch_e
cnidae	9	7	814	3	c_nidae
coach	12	59	1945	3	coach__
coachable	18	4	630	3	coachable
coached	15	33	1384	3	coached
coacher	14	37	1412	3	coacher
coaches	14	40	1869	3	coaches
coachman	17	4	498	3	coachman
coachmen	17	4	501	3	coachmen
coanchor	15	4	525	3	coanchor
coca	8	80	3064	3	co_c_a_
cocas	9	59	2657	3	co_c_as
coccal	9	3	1022	3	co_ccal
cochair	14	4	631	3	co_chair
cochin	13	13	1320	3	co_chin
cochlea	14	3	534	3	co_chlea
cochleae	15	4	464	3	co_chleae
cockade	16	3	813	3	co_ckade
cockle	14	39	1357	3	co_ckle
cocoa	9	85	1788	3	co_coa_
cocoas	10	49	1574	3	co_coas
coincide	13	4	649	3	coincide
comae	9	71	2842	3	co__mae
concaved	16	3	622	3	concaved
concaves	15	3	891	3	concaves
concealed	14	5	813	3	concealed
concealer	13	6	822	3	concealer
conceals	12	31	1103	3	conceals
conceded	14	3	829	3	conceded
conceder	13	3	874	3	conceder
concedes	13	3	1106	3	concedes
conceit	11	32	1807	3	conceit
conceive	15	3	923	3	conceive
concent	11	44	2251	3	concent
concept	13	33	1444	3	concept
concern	11	30	1196	3	concern
concert	11	33	2522	3	concert
conchoid	16	8	804	3	conchoid
conciser	12	3	1024	3	conciser
conclaves	16	4	654	3	conclaves
conclude	13	4	467	3	conclude
concoct	10	3	1290	3	concoct
concord	12	5	1034	3	concord
concrete	12	4	1108	3	concrete
concur	10	4	1110	3	conc_ur
concurs	11	3	1147	3	concurs
concuss	11	3	806	3	concuss
condole	10	29	1495	3	condole
condone	10	26	1629	3	condone
conduce	12	13	923	3	conduce
condyle	13	24	705	3	condyle
cone	6	72	5696	3	con___e
conepate	12	7	1253	3	conepate
confab	13	4	706	3	con_fab
confide	13	3	1020	3	confide
confine	12	3	1558	3	confine
conflate	13	3	1117	3	conflate
confuse	12	3	885	3	confuse
confute	12	3	926	3	confute
conga	8	54	1987	3	con_ga_
congaed	11	39	974	3	con_gaed
congas	9	44	1703	3	con_gas
conge	8	52	2759	3	con__ge
congeal	10	40	1168	3	congeal
congee	9	60	2447	3	con_gee
conical	11	3	1620	3	conical
coniine	9	3	1680	3	coniine
conine	8	45	2856	3	con_ine
conjure	16	10	907	3	conjure
connate	9	3	1575	3	connate
connive	12	3	899	3	connive
connote	9	3	1161	3	connote
console	9	27	1598	3	console
consume	11	5	1013	3	consume
conte	7	66	3320	3	con__te
contra	8	33	1470	3	contra_
contras	9	30	1562	3	contras
contuse	9	3	1141	3	contuse
convene	12	33	1432	3	convene
convoke	16	20	717	3	convoke
cooch	12	49	1683	3	cooch__
cooches	14	35	1583	3	cooches
cooncan	11	4	723	3	coonc_an
copihue	14	4	414	3	copihue
copulae	11	28	1062	3	copulae
corncake	16	4	526	3	corncake
corncrake	17	4	326	3	corncrake
corniche	15	7	592	3	cornich_e
coronae	9	42	1489	3	coronae
costae	8	53	1968	3	co_stae
cottae	8	46	1570	3	co_ttae
couch	12	53	2011	3	couch__
couchant	15	4	905	3	couchant
couched	15	41	1579	3	couched
coucher	14	45	1585	3	coucher
couches	14	40	2047	3	couches
couthie	12	18	1055	3	couthie
cowhage	16	3	630	3	co_whage
coxae	14	61	1518	3	co__xae
creche	13	3	1076	3	crech_e
douche	12	46	1322	3	douch_e
enchase	12	3	947	3	_enchase
gotcha	12	3	463	3	gotcha_
gotchas	13	3	461	3	gotchas
honcho	14	38	938	3	honch_o
honchoed	17	4	573	3	honchoed
honchos	15	36	957	3	honchos
hoochie	15	3	780	3	hoochie
lochan	11	3	909	3	lo_chan
louche	11	52	1266	3	louch_e
manche	13	35	1510	3	manch_e
mocha	12	4	992	3	mo_cha_
mochas	13	3	1066	3	mo_chas
monachal	15	4	571	3	monachal
moschate	15	4	659	3	moschate
nonce	7	57	1982	3	nonc__e
noncore	9	4	1195	3	noncore
nuchae	11	21	851	3	_nuchae
ochre	10	34	1159	3	_o_chre
once	6	54	2308	3	_onc__e
panchax	21	3	498	3	panchax
ponce	9	52	2251	3	ponc__e
poncho	13	33	1012	3	ponch_o
ponchoed	16	4	613	3	ponchoed
ponchos	14	34	1070	3	ponchos
rhonchal	16	4	268	3	rhonchal
rotche	11	43	1198	3	rotch_e
rouche	11	47	1431	3	rouch_e
sconce	10	47	1172	3	sconc__e
touche	11	49	1617	3	touch_e
unciae	8	32	1531	3	_unciae
vouchee	15	34	1126	3	vouchee
zonae	14	51	1644	3	zon__ae
zonulae	16	4	596	3	zonulae

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	134027	0.390	458182.1
2	DLD Change Limit	134027	166	6.300	21274.1
3	Display Results	166	166	0.060	2766.7
	(SQL Overall)	178691	166	6.750	26472.7