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

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

341 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
ceratins	10	28	1873	(None)
ceratin	9	30	2016	1	ceratin_
creatins	10	36	1751	1	creatins
keratins	12	23	1348	1	keratins
aerating	9	28	2100	2	aerating
aerations	9	3	1790	2	aerations
berating	11	32	2076	2	berating
carabins	12	3	1236	2	carabins
carotins	10	23	1558	2	carotins
ceramics	14	4	680	2	ceramics
cerates	9	54	2825	2	cerat_es
certain	9	26	1221	2	certain_
cortins	9	24	2133	2	cor_tins
crating	10	37	2520	2	c_rating
cratons	9	43	1603	2	c_ratons
creatin	9	36	1813	2	creatin_
creatine	10	34	1741	2	creatine
creatines	11	28	1443	2	creatines
creating	11	39	2195	2	creating
creations	11	26	1454	2	creations
cretins	9	32	1642	2	c_retins
curating	11	3	1429	2	curating
curtains	10	25	970	2	curtains
derating	10	32	2228	2	derating
gelatins	9	34	1409	2	gelatins
gratins	8	41	1918	2	_gratins
hematins	13	17	1468	2	hematins
keratin	11	33	1415	2	keratin_
pertains	10	21	1342	2	pertains
veratrins	12	4	775	2	veratrins
zeatins	16	3	1173	2	ze_atins
acerbating	15	4	629	3	acerbating
acetins	9	3	1317	3	ace__tins
acierating	13	4	832	3	acierating
acrasins	10	3	997	3	acrasins
aerates	7	46	2749	3	aerat_es
aeration	8	3	1993	3	aeration
aerators	8	3	1561	3	aerators
ascertains	12	4	426	3	ascertains
beating	10	43	2687	3	be_ating
beatings	11	41	1323	3	be_atings
beraking	15	36	1297	3	beraking
berates	9	41	2687	3	berat_es
berlins	9	32	1601	3	ber_lins
borating	11	34	1450	3	borating
brains	8	51	2547	3	_bra_ins
cabins	10	44	1892	3	c__abins
cains	7	53	3430	3	c__a_ins
canakins	14	20	1046	3	canakins
captains	12	18	1057	3	captains
carabids	13	3	819	3	carabids
carabin	11	3	1321	3	carabin_
carabine	12	4	1239	3	carabine
carabines	13	3	1147	3	carabines
carates	9	56	3061	3	carat_es
carats	8	59	2902	3	carat__s
caravans	13	3	862	3	caravans
carlins	9	39	2192	3	car_lins
carnations	12	3	1135	3	carnations
carotids	11	22	995	3	carotids
carotin	9	22	1673	3	carotin_
carrotins	11	23	996	3	carrotins
carting	10	42	2828	3	car_ting
cartons	9	41	2247	3	car_tons
caryatids	15	4	522	3	caryatids
caryotins	14	24	804	3	caryotins
cations	9	45	2414	3	c__ations
catkins	13	30	1256	3	c__atkins
catlins	9	38	1884	3	c__atlins
cavatina	13	4	733	3	cavatina
cavatinas	14	4	478	3	cavatinas
cavatine	13	3	1032	3	cavatine
ceasing	10	41	1826	3	ce_asing
cecities	12	3	1204	3	cecities
celadons	11	3	700	3	celadons
cephalins	16	6	660	3	cephalins
ceramals	12	4	651	3	ceramals
ceramic	13	3	982	3	cerami_c
ceramide	13	4	797	3	ceramide
ceramides	14	4	745	3	ceramides
ceramist	12	3	1093	3	ceramist
ceramists	13	4	672	3	ceramists
cerastes	10	11	1109	3	cerastes
cerate	8	48	2946	3	cerat__e
cerated	10	39	2247	3	cerat_ed
ceratodus	12	4	322	3	ceratodus
ceratoid	11	4	992	3	ceratoid
cercarians	14	4	478	3	cercarians
cercarias	13	4	689	3	cercarias
cercis	10	46	1449	3	cer_ci_s
cerias	8	33	2198	3	cer__ias
cering	9	45	2253	3	cer__ing
cerites	9	48	2343	3	cerit_es
cerotic	11	4	1506	3	ceroti_c
certainer	11	4	619	3	certainer
certainest	12	4	886	3	certainest
certainly	14	4	315	3	certainly
certainty	14	4	319	3	certainty
certes	8	46	2308	3	cer_t_es
certify	15	4	624	3	cer_tify
cerumens	12	3	576	3	cerumens
cervine	12	26	1080	3	cer_vine
cesarians	11	4	636	3	cesarians
cessations	12	5	647	3	cessations
chains	11	48	1970	3	c_ha_ins
characins	16	4	759	3	characins
charting	14	26	1419	3	charting
cheating	14	40	1452	3	cheating
chelating	15	4	936	3	chelating
chelations	15	3	908	3	chelations
chitins	12	27	1379	3	c_hitins
chromatins	17	4	912	3	chromatins
citations	11	3	1250	3	citations
cleating	11	35	1814	3	cleating
clematis	12	4	865	3	clemati_s
coating	10	35	2531	3	c_oating
coatings	11	38	1184	3	c_oatings
coatis	8	51	2260	3	c_oati_s
cocains	11	13	1392	3	coca_ins
comatiks	16	14	804	3	comatiks
conations	11	13	1890	3	conations
contains	10	3	1653	3	contains
cortin	8	24	2315	3	cor_tin_
cortina	9	19	1597	3	cor_tina
cortinas	10	22	1245	3	cor_tinas
crafting	14	37	1017	3	c_rafting
craning	10	36	2030	3	c_raning
craping	12	40	1871	3	c_raping
crasis	8	50	2047	3	c_rasi_s
craters	9	50	2189	3	c_raters
crates	8	57	3606	3	c_rat_es
craton	8	45	1719	3	c_raton_
cravens	12	40	1012	3	c_ravens
craving	13	40	1573	3	c_raving
cravings	14	42	822	3	c_ravings
crayons	12	43	923	3	c_rayons
crazies	18	34	1385	3	c_razies
crazing	19	39	1458	3	c_razing
creaking	15	34	1412	3	creaking
creaming	13	34	1314	3	creaming
creasing	11	33	1444	3	creasing
creates	9	52	2520	3	creat_es
creation	10	28	1651	3	creation
creative	13	28	1280	3	creative
creatives	14	27	969	3	creatives
creators	10	28	1441	3	creators
cremains	12	3	869	3	cremains
cremating	14	3	1220	3	cremating
cremations	14	4	1071	3	cremations
crenations	12	5	1169	3	crenations
cresting	11	40	1704	3	cresting
crestings	12	29	804	3	crestings
cretics	11	29	1165	3	c_retics
cretin	8	29	1791	3	c_retin_
critics	11	28	1109	3	c_ritics
crotons	9	37	1437	3	c_rotons
cumarins	12	3	864	3	cumarins
curacies	12	3	1176	3	curacies
curarine	10	6	1071	3	curarine
curarines	11	7	1055	3	curarines
curaris	9	41	1477	3	curari_s
curates	9	53	2383	3	curat_es
curative	13	3	1040	3	curative
curatives	14	3	782	3	curatives
curators	10	3	1172	3	curators
curtails	10	31	824	3	curtails
curtain	9	31	979	3	curtain_
cutins	8	39	1998	3	c__utins
cyanins	12	29	1001	3	c_yanins
cycasins	15	4	528	3	cycasins
debating	12	32	1373	3	debating
delating	10	31	1960	3	delating
delations	10	26	1659	3	delations
dentins	8	34	1922	3	de_ntins
deraigns	10	3	488	3	deraigns
derails	8	42	1639	3	dera_ils
derates	8	40	2889	3	derat_es
derats	7	46	2506	3	derat__s
deratting	11	3	951	3	deratting
destains	9	3	1181	3	destains
detains	8	37	1609	3	deta_ins
detrains	9	4	1176	3	detra_ins
drains	7	37	1940	3	_dra_ins
durations	10	3	1146	3	durations
eating	7	51	3440	3	_e_ating
eatings	8	46	1644	3	_e_atings
elains	6	49	1985	3	_ela_ins
elastins	8	21	1174	3	_elastins
elating	8	34	2308	3	_elating
elations	8	37	1912	3	_elations
emetins	9	8	1265	3	_emetins
emptins	11	7	940	3	_emptins
enations	8	33	1690	3	_enations
erasing	8	3	1796	3	_erasing
erasions	8	3	1098	3	_erasions
erotics	9	19	1415	3	_erotics
erratics	10	4	698	3	erratics
etamins	9	15	1183	3	_etamins
ferities	11	14	1672	3	ferities
ferritins	12	4	727	3	ferritins
fetations	12	5	1138	3	fetations
gelatin	8	35	1473	3	gelatin_
gelatine	9	32	1331	3	gelatine
gelatines	10	29	1054	3	gelatines
gelating	10	30	1573	3	gelating
gelations	10	25	1309	3	gelations
gelatis	8	33	1351	3	gelati_s
gradins	9	34	1623	3	_gradins
grains	7	42	2309	3	_gra_ins
gratin	7	45	2058	3	_gratin_
gratine	8	47	1919	3	_gratine
grating	9	39	2318	3	_grating
gratings	10	39	1076	3	_gratings
gratis	7	48	1924	3	_grati_s
greatens	9	30	759	3	greatens
gyrating	13	3	745	3	gyrating
gyrations	13	3	692	3	gyrations
haematins	14	14	775	3	haematins
heartens	11	30	1015	3	heartens
hearties	11	3	1542	3	hearties
hearting	12	5	1312	3	hearting
heating	11	40	2432	3	he_ating
hemateins	14	8	617	3	hemateins
hematics	15	17	1219	3	hematics
hematin	12	15	1602	3	hematin_
hematine	13	16	1467	3	hematine
hematines	14	13	1220	3	hematines
heparins	13	3	1012	3	heparins
hepatics	15	19	893	3	hepatics
heretics	13	3	1050	3	heretics
heroins	10	35	1801	3	her_oins
isatins	7	3	1077	3	_isatins
iterating	10	3	1425	3	iterating
iterations	10	4	1382	3	iterations
jerkins	18	35	825	3	jer_kins
keramics	16	4	482	3	keramics
keratinous	14	4	357	3	keratinous
keratitis	13	4	587	3	keratitis
lacerating	13	4	945	3	lacerating
lacerations	13	4	833	3	lacerations
lectins	9	25	1500	3	le_ctins
legatine	9	13	1140	3	legatine
legating	10	23	1311	3	legating
legations	10	27	1192	3	legations
leptins	9	24	1269	3	le_ptins
macerating	15	4	954	3	macerating
macerations	15	4	847	3	macerations
martins	9	33	2206	3	mar_tins
matins	8	45	2778	3	__matins
megatons	11	27	970	3	megatons
melanins	10	3	1038	3	melanins
meriting	11	3	1469	3	meriting
merlins	9	30	1581	3	mer_lins
neatens	7	33	1040	3	ne_atens
negating	10	20	1283	3	negating
negations	10	28	1196	3	negations
negatons	9	29	927	3	negatons
nervations	13	5	948	3	nervations
operatics	13	4	695	3	operatics
operating	12	3	1372	3	operating
operations	12	3	1295	3	operations
orating	8	35	2032	3	_orating
orations	8	15	1580	3	_orations
patins	8	75	2878	3	__patins
pectins	11	23	1523	3	pe_ctins
peracids	13	3	1007	3	peracids
pertain	9	27	1496	3	pertain_
pirating	11	3	1451	3	pirating
prating	10	34	2445	3	_prating
rains	5	51	4023	3	__ra_ins
ratans	6	38	1937	3	__ratans
ratine	6	51	3182	3	__ratine
ratines	7	53	2858	3	__ratines
rating	7	49	3870	3	__rating
ratings	8	42	1741	3	__ratings
rations	7	41	2343	3	__rations
ratios	6	49	2267	3	__ratios
ratlins	7	36	1558	3	__ratlins
ravins	9	46	2256	3	__ravins
rawins	9	56	1762	3	__rawins
reagins	8	42	1564	3	re_agins
rebating	11	24	1834	3	rebating
recrating	12	13	1879	3	recrating
redating	10	26	2017	3	redating
refrains	11	3	959	3	refra_ins
regains	8	43	1658	3	rega_ins
regrating	11	13	1621	3	regrating
relating	9	27	2544	3	relating
relations	9	24	1833	3	relations
relaxins	15	24	868	3	relaxins
remains	9	41	1791	3	rema_ins
remating	11	23	2242	3	remating
retains	7	45	2225	3	reta_ins
retrains	8	3	1453	3	retra_ins
rutins	6	38	1839	3	__rutins
satins	6	49	3048	3	__satins
sclerotins	12	4	443	3	sclerotins
seating	8	41	3068	3	se_ating
seatings	9	36	1430	3	se_atings
secretins	11	10	846	3	secretins
sedating	10	30	1411	3	sedating
sedations	10	3	1125	3	sedations
serails	7	33	1836	3	sera_ils
serais	6	43	2613	3	sera_i_s
sereins	7	37	1612	3	ser_eins
seriating	10	9	1640	3	seriating
seriations	10	3	1668	3	seriations
sericins	10	3	1246	3	sericins
serins	6	40	2967	3	ser__ins
serotine	8	3	1357	3	serotine
serotines	9	3	1207	3	serotines
serotiny	11	4	857	3	serotiny
serrating	10	5	1321	3	serrating
serrations	10	3	1310	3	serrations
sextains	15	24	681	3	sextains
sprains	9	30	1359	3	spra_ins
statins	7	37	1977	3	_statins
strains	7	42	1815	3	stra_ins
terais	6	40	2351	3	tera_i_s
teratism	10	3	1217	3	teratism
teratisms	11	4	1007	3	teratisms
terrains	8	4	1032	3	terrains
terrapins	11	4	618	3	terrapins
tertians	8	3	910	3	ter_tians
trains	6	47	2534	3	_tra_ins
treaties	8	3	1698	3	treaties
treating	9	25	1961	3	treating
ulcerating	13	4	698	3	ulcerating
ulcerations	13	4	636	3	ulcerations
uprating	11	3	1111	3	uprating
venations	12	3	1172	3	venations
veratrias	12	4	656	3	veratrias
veratrin	11	4	770	3	veratrin_
veratrine	12	4	775	3	veratrine
veratrines	13	4	726	3	veratrines
verdins	11	28	1233	3	ver_dins
verities	11	14	1804	3	verities
vernations	13	3	1033	3	vernations
vervains	14	3	529	3	vervains
vexations	19	3	775	3	vexations
zeatin	15	4	1282	3	ze_atin_

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	341	6.843	21359.3
3	Display Results	341	341	0.140	2435.7
	(SQL Overall)	178691	341	7.406	24127.9