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

Here are the results of your fuzzy-string dictionary search for “cholate” 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
cholate	12	21	1493	(None)
chelate	12	29	1490	1	chelate
cholates	13	24	1476	1	cholates
apholate	13	4	1047	2	apholate
chelae	11	36	1461	2	chela_e
chelated	14	26	1049	2	chelated
chelates	13	27	1385	2	chelates
chlorate	13	31	1269	2	chlorate
chocolate	16	4	741	2	chocolate
chola	10	47	1803	2	chola__
cholas	11	48	1800	2	chola_s
choline	12	29	1538	2	choline
chorale	12	43	1335	2	chorale
chordate	14	4	803	2	chordate
chromate	15	3	1278	2	chromate
cohobate	15	4	701	2	cohobate
collate	9	29	1968	2	collate
comate	10	41	2484	2	c_omate
folate	9	33	2039	2	_folate
isolate	7	3	1392	2	isolate
phonate	12	4	1181	2	phonate
phorate	12	4	1336	2	phorate
prolate	9	4	1979	2	prolate
solate	6	45	2607	2	_solate
violate	10	3	1155	2	violate
ablate	8	22	1921	3	_ablate
accolade	13	4	605	3	accolade
acolyte	12	15	765	3	acolyte
acrylate	13	4	769	3	acrylate
acylate	12	3	1053	3	acylate
adulate	8	3	1323	3	adulate
alate	5	53	4033	3	__alate
anolyte	10	15	900	3	anolyte
apholates	14	4	968	3	apholates
areolate	8	10	1445	3	areolate
blate	7	59	3378	3	__blate
bolete	8	5	1961	3	_bolete
borate	8	50	2615	3	_borate
bromate	11	3	1355	3	bromate
bullate	9	34	1507	3	bullate
calotte	9	5	1056	3	calotte
canulate	10	3	1455	3	canulate
carate	8	47	3400	3	c_arate
caseate	9	3	1478	3	caseate
cate	6	62	5460	3	c___ate
caudate	10	3	1135	3	caudate
cellae	8	49	1593	3	cella_e
cellmate	12	3	787	3	cellmate
cerate	8	48	2946	3	c_erate
chaetae	12	3	860	3	chaetae
chafe	13	51	1735	3	ch__afe
chalah	14	35	1166	3	chala_h
chalahs	15	28	988	3	chalahs
chalaza	21	4	573	3	chalaza
chalazae	22	4	442	3	chalazae
chalet	11	38	2599	3	chalet_
chalets	12	28	1347	3	chalets
chalice	14	3	1104	3	chalice
challie	12	40	1285	3	challie
chalone	12	3	1210	3	chalone
chalot	11	30	2013	3	chalot_
chaloth	15	29	860	3	chaloth
chalutz	21	9	509	3	chalutz
chamade	15	13	845	3	chamade
chapati	14	11	802	3	chapati
chape	12	52	2114	3	ch__ape
charade	13	12	991	3	charade
chare	10	52	3198	3	ch__are
chase	10	51	2712	3	ch__ase
chaste	11	46	1739	3	ch_aste
chat	9	55	4613	3	ch__at_
chats	10	57	3009	3	ch__ats
chayote	15	3	649	3	chayote
cheat	10	57	3245	3	ch_eat_
cheated	13	44	1634	3	ch_eated
cheater	12	48	1696	3	ch_eater
cheats	11	45	1954	3	ch_eats
chedite	13	3	886	3	chedite
chela	10	39	1680	3	chela__
chelas	11	38	1720	3	chela_s
chelator	13	4	792	3	chelator
chicane	14	8	955	3	chicane
childe	12	47	1121	3	chil_de
chile	10	56	2689	3	chil__e
chlorates	14	25	1227	3	chlorates
chlorite	13	30	1284	3	chlorite
choana	11	3	844	3	cho_ana
choanae	12	3	686	3	choanae
chocolates	17	4	678	3	chocolates
chocolatey	20	5	351	3	chocolatey
chocolaty	19	5	405	3	chocolaty
choice	13	20	1052	3	cho_ice
choke	14	51	1802	3	cho__ke
cholent	12	3	1325	3	cholent
cholents	13	3	762	3	cholents
choler	11	37	1715	3	chol_er
cholera	12	40	909	3	cholera
cholers	12	42	1520	3	cholers
cholines	13	22	1449	3	cholines
cholla	11	39	1102	3	chol_la
chollas	12	38	1135	3	chollas
cholo	10	52	1797	3	chol__o
cholos	11	47	1685	3	chol_os
choose	11	51	1614	3	cho_ose
chopine	14	35	1226	3	chopine
choragi	13	4	668	3	choragi
choral	11	51	1849	3	chora_l
chorales	13	37	1288	3	chorales
chorals	12	46	1411	3	chorals
chordates	15	4	768	3	chordates
chore	10	51	2676	3	cho__re
chorine	12	32	1836	3	chorine
chorten	12	28	1130	3	cho_rten
chortle	12	42	1044	3	chortle
chose	10	59	2540	3	cho__se
chott	10	39	2393	3	cho__tt
chotts	11	36	1099	3	cho_tts
chouse	11	60	1756	3	cho_use
chowse	14	47	1175	3	cho_wse
chromates	16	3	1311	3	chromates
chromite	15	3	1083	3	chromite
chute	10	43	1646	3	ch__ute
chyle	13	49	1348	3	chyl__e
ciliate	9	5	1460	3	ciliate
ciliolate	11	4	597	3	ciliolate
cirrate	9	24	1349	3	cirrate
citrate	9	22	1680	3	citrate
clade	8	58	2101	3	c__lade
clavate	12	3	871	3	clavate
clave	10	54	2015	3	c__lave
climate	11	3	1283	3	climate
clodpate	13	4	408	3	clodpate
coat	6	75	5835	3	c_o_at_
coated	9	49	2704	3	c_o_ated
coatee	8	43	2722	3	c_o_atee
coater	8	43	2957	3	c_o_ater
coati	7	56	2464	3	c_o_ati
coats	7	56	3500	3	c_o_ats
cognate	10	3	1220	3	cognate
cohobated	17	4	488	3	cohobated
cohobates	16	4	652	3	cohobates
cola	6	65	4139	3	c_ola__
colas	7	54	3677	3	c_ola_s
cole	6	69	5611	3	c_ol__e
collage	10	28	1376	3	collage
collated	11	36	1506	3	collated
collates	10	30	1914	3	collates
collet	8	40	3036	3	c_ollet
collie	8	36	2199	3	c_ollie
colocate	12	3	1344	3	colocate
colone	8	54	2500	3	c_olone
colt	6	71	5824	3	c_ol_t_
colter	8	46	2509	3	c_ol_ter
colts	7	66	3329	3	c_ol_ts
colure	8	3	1416	3	c_olure
comade	11	44	1532	3	c_omade
comae	9	71	2842	3	c_oma_e
comake	14	44	1342	3	c_omake
comates	11	41	2364	3	c_omates
comte	9	61	2547	3	c_o_mte
conflate	13	3	1117	3	conflate
connate	9	3	1575	3	connate
conte	7	66	3320	3	c_o_nte
coolant	9	3	1646	3	coolant
coolants	10	3	994	3	coolants
coolie	8	38	2160	3	cool_ie
coolth	11	3	951	3	cool_th
copulate	12	26	1411	3	copulate
cordate	10	3	1522	3	cordate
corelate	10	5	1601	3	corelate
corollate	11	4	812	3	corollate
coronate	10	30	1821	3	coronate
corotate	10	28	1393	3	corotate
costae	8	53	1968	3	c_ostae
costate	9	40	1927	3	costate
cote	6	66	4873	3	c_o__te
cottae	8	46	1570	3	c_ottae
cowage	12	3	1067	3	c_owage
coxae	14	61	1518	3	c_oxa_e
coyote	11	4	1178	3	c_oyote
crate	7	65	3740	3	c__rate
create	8	51	2638	3	c_reate
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
croute	8	46	1727	3	cro_ute
cryolite	13	4	750	3	cryolite
culotte	9	7	689	3	culotte
cumulate	12	31	1022	3	cumulate
cuneate	9	3	1172	3	cuneate
cupulate	12	28	1003	3	cupulate
curate	8	52	2624	3	c_urate
curtate	9	3	1264	3	curtate
cuspate	11	3	823	3	cuspate
cyanate	12	25	970	3	cyanate
cyclase	14	3	661	3	cyclase
dealate	8	36	1784	3	dealate
deflate	11	36	1394	3	deflate
delate	7	38	2775	3	_delate
desolate	9	4	1199	3	desolate
dhole	9	52	1536	3	dhol__e
dilate	7	32	2069	3	_dilate
donate	7	36	1950	3	_donate
echinate	13	5	940	3	echinate
elate	5	53	3588	3	__elate
emulate	9	3	1412	3	emulate
enolase	7	3	1019	3	enolase
ephorate	13	5	950	3	ephorate
epilate	9	3	1428	3	epilate
ethylate	14	4	622	3	ethylate
etiolate	8	4	952	3	etiolate
evolute	10	4	568	3	evolute
fellate	10	3	1343	3	fellate
folates	10	32	1845	3	_folates
foliate	10	5	1353	3	_foliate
gallate	8	34	1713	3	gallate
gelate	7	34	2126	3	_gelate
globate	10	5	782	3	globate
halite	9	36	2423	3	_halite
hamate	11	33	1983	3	_hamate
hate	7	84	5017	3	_h__ate
holard	10	4	1057	3	_holard
hole	7	75	5339	3	_hol__e
holster	10	35	1221	3	_holster
holt	7	78	5258	3	_hol_t_
holts	8	56	2791	3	_hol_ts
homage	12	12	1060	3	_homage
hoplite	12	3	1107	3	_hoplite
horste	9	48	1741	3	_horste
humate	11	32	1444	3	_humate
ichnolite	14	4	436	3	ichnolite
idolater	9	3	686	3	idolater
immolate	12	4	654	3	immolate
inchoate	13	4	767	3	incho_ate
inflate	10	3	1231	3	inflate
insolate	8	3	1189	3	insolate
iodate	7	3	1350	3	_iodate
iolite	6	32	2198	3	_iolite
isolated	9	4	1052	3	isolated
isolates	8	6	1351	3	isolates
khanate	14	3	707	3	khanate
late	4	75	6048	3	___late
lobate	8	29	1524	3	_lobate
locate	8	39	1984	3	_locate
malate	8	46	2456	3	_malate
neonate	7	3	1133	3	neonate
niobate	9	3	770	3	niobate
notate	6	32	1786	3	_notate
oblate	8	22	1474	3	_oblate
obovate	12	3	546	3	obovate
ocellate	10	3	787	3	ocellate
odonate	8	4	840	3	odonate
oleate	6	3	1888	3	__oleate
oolite	6	33	1960	3	_oolite
orate	5	51	3330	3	__orate
ovate	8	42	1439	3	__ovate
ovulate	10	3	945	3	ovulate
oxalate	14	5	762	3	oxalate
ozonate	16	4	686	3	ozonate
palate	8	42	2679	3	_palate
phenate	12	4	1220	3	phenate
phenolate	14	4	749	3	phenolate
phonated	14	4	789	3	phonated
phonates	13	4	1064	3	phonates
phorates	13	4	1304	3	phorates
phylae	14	45	873	3	phyla_e
plate	7	46	3511	3	__plate
polite	8	36	2507	3	_polite
prelate	9	5	1969	3	prelate
probate	11	4	1448	3	probate
pronate	9	4	1887	3	pronate
prorate	9	4	1873	3	prorate
reflate	10	35	1626	3	reflate
relate	6	40	3363	3	_relate
replate	9	34	2005	3	replate
reslate	7	35	2059	3	reslate
rhyolite	14	4	551	3	rhyolite
rotate	6	33	2034	3	_rotate
scholar	12	3	695	3	schola_r
scholars	13	3	668	3	scholars
schoolmate	17	5	333	3	schoolmate
shoat	8	56	3395	3	sho_at_
shoats	9	41	1708	3	sho_ats
shoelace	13	4	530	3	shoelace
shote	8	55	2610	3	sho__te
slate	5	54	3828	3	__slate
solace	8	34	1582	3	_solace
solated	8	36	1802	3	_solated
solates	7	35	2385	3	_solates
solute	6	40	1666	3	_solute
solvate	10	27	1021	3	_solvate
spoliate	10	3	924	3	spoliate
stomate	9	3	1312	3	stomate
stylate	10	17	977	3	stylate
sublate	9	3	1536	3	sublate
thecate	12	32	1002	3	thecate
thionate	11	13	750	3	thionate
thole	8	56	2084	3	thol__e
thorite	10	3	1344	3	thorite
togate	7	45	1568	3	_togate
tolane	6	43	1658	3	_tolane
toluate	7	15	934	3	_toluate
ululate	7	4	996	3	ululate
urceolate	11	4	373	3	urceolate
vacuolate	14	4	522	3	vacuolate
vallate	10	30	1656	3	vallate
velate	9	37	2014	3	_velate
violated	12	3	788	3	violated
violater	11	3	725	3	violater
violates	11	3	1119	3	violates
volante	10	3	851	3	_volante
volte	8	53	2130	3	_vol_te
volute	9	39	1276	3	_volute
volvate	13	31	799	3	_volvate
whole	11	44	1809	3	whol__e
zeolite	16	3	890	3	zeolite
zonate	15	41	1492	3	_zonate
zoolater	17	4	609	3	zoolater

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	317	6.253	21434.0
3	Display Results	317	317	0.140	2264.3
	(SQL Overall)	178691	317	6.783	26343.9