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

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

434 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
caesar	8	4	1093	(None)
caesars	9	4	1073	1	caesars
caeca	9	39	1513	2	caeca_
caecal	10	37	1373	2	caecal
caesura	9	5	623	2	caesura
calcar	10	3	1275	2	calcar
calesa	8	4	1247	2	calesa_
calesas	9	4	1183	2	calesas
casa	6	56	3086	2	ca_sa_
casas	7	53	2784	2	ca_sas
causal	8	14	1320	2	causal
causer	8	41	1778	2	causer
caviar	11	3	1016	2	caviar
cedar	8	40	1432	2	c_edar
clear	7	62	1905	2	cle_ar
paesan	8	51	1409	2	paesan
sansar	6	36	1339	2	sansar
sarsar	6	30	1184	2	sarsar
aces	6	76	4509	3	aces__
aceta	7	40	1735	3	aceta_
acetal	8	43	1490	3	acetal
acinar	8	3	1048	3	acinar
afar	7	67	2078	3	_a_far
agar	5	87	2641	3	_a_gar
ajar	11	62	1770	3	_a_jar
alar	4	63	4007	3	_a_lar
alegar	7	3	928	3	alegar
altar	5	55	2064	3	_altar
anear	5	54	2032	3	_anear
ansa	4	59	2777	3	_ansa_
ansae	5	57	2097	3	_ansae
asea	4	63	2718	3	_asea_
assai	5	7	1154	3	_assai
assay	8	7	1028	3	_assay
attar	5	65	1669	3	_attar
aurar	5	44	2025	3	_aurar
balsa	7	79	2041	3	balsa_
balsam	10	56	1223	3	balsam
balsas	8	64	1752	3	balsas
baresark	14	4	388	3	baresark
basal	7	57	2228	3	ba_sal
baser	7	48	2892	3	ba_ser
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	ba_zar
bear	6	68	4464	3	_be_ar
blear	7	59	1868	3	ble_ar
bursar	8	54	1325	3	bursar
cabal	9	52	2215	3	ca_bal
caber	9	51	2683	3	ca_ber
cabestro	12	4	368	3	cabestro
cabler	10	45	1917	3	cabler
cabman	12	38	1250	3	cabman
cabs	8	67	3942	3	cabs__
caca	8	55	2808	3	ca_ca_
cacao	9	54	2000	3	ca_cao
cacas	9	56	2798	3	ca_cas
cades	8	54	4073	3	cades__
cadger	10	50	1391	3	cadger
cads	7	61	4452	3	cads__
caecum	12	3	818	3	caecum
caeoma	10	3	903	3	caeoma
caeomas	11	3	840	3	caeomas
caesarean	11	4	326	3	caesar~~ean~~
caesarian	11	4	705	3	caesar~~ian~~
caesarism	13	4	593	3	caesar~~ism~~
caesium	11	5	883	3	caesium
caestus	9	4	777	3	caestus
caesurae	10	5	512	3	caesurae
caesural	10	5	539	3	caesural
caesuras	10	5	573	3	caesuras
caesuric	12	4	422	3	caesuric
cafes	10	64	2692	3	cafes__
caftan	11	17	1012	3	caftan
cager	8	52	2922	3	ca_ger
cages	8	59	3601	3	cages__
cagier	9	37	1593	3	cagier
cahier	11	36	1577	3	cahier
caiman	10	36	1566	3	caiman
cakes	11	60	3767	3	cakes__
cakier	12	31	1524	3	cakier
calamar	11	4	929	3	calamar
calash	11	3	1243	3	calash
calcars	11	3	1265	3	calcars
calcspar	14	4	258	3	calcspar
calendar	11	4	501	3	calendar
calker	12	49	1708	3	calker
calla	7	48	2707	3	calla_
callan	8	36	1960	3	callan
callas	8	45	2675	3	callas
caller	8	51	2548	3	caller
calmer	10	52	1693	3	calmer
calpac	12	32	1106	3	calpac
calvary	15	3	718	3	calvary
camas	9	63	3352	3	ca_mas
camass	10	41	1418	3	camass
camber	12	44	1848	3	camber
camera	10	3	1369	3	camera_
camerae	11	3	1206	3	camerae
cameral	11	3	1128	3	cameral
cameras	11	3	1336	3	cameras
cames	9	70	4731	3	cames__
camisa	10	31	1432	3	camisa_
camisas	11	34	1192	3	camisas
camper	12	47	2221	3	camper
cams	8	70	4728	3	cams__
canal	7	54	2804	3	ca_nal
canard	9	3	1476	3	ca_nard
canary	11	3	1469	3	ca_nary
cancan	10	3	1410	3	cancan
cancer	10	42	2092	3	cancer
candor	9	45	1642	3	candor
caner	7	53	3477	3	ca_ner
canes	7	53	5037	3	canes__
caneware	13	4	780	3	caneware
canker	12	44	2252	3	canker
canna	7	59	1933	3	canna_
cannas	8	45	1840	3	cannas
canner	8	46	2598	3	canner
canoer	8	51	2107	3	canoer
cans	6	50	5085	3	cans__
canso	7	50	1940	3	cans_o
cansos	8	49	1538	3	cansos
canst	7	49	3221	3	cans_t
cantal	8	41	2203	3	cantal
canter	8	52	3011	3	canter
cantor	8	56	2152	3	cantor
canular	9	3	1032	3	canular
canvas	11	38	1333	3	canvas
capelan	11	3	900	3	capelan
caper	9	48	3162	3	ca_per
caperer	11	30	1340	3	caperer
capes	9	54	4192	3	capes__
capias	10	3	1835	3	capias
capper	12	44	2198	3	capper
caps	8	71	4789	3	caps__
capsid	11	3	1241	3	capsid
capstan	11	3	790	3	capstan
capsular	12	4	540	3	capsular
captan	10	16	1334	3	captan
captor	10	49	1460	3	captor
car	5	91	6556	3	c___ar
carat	7	50	4879	3	ca_rat
carbarn	11	3	945	3	carbarn
carder	9	45	2418	3	carder
career	8	58	2224	3	career
carer	7	49	4233	3	ca_rer
cares	7	73	6918	3	cares__
caress	8	57	2026	3	cares_s
caresser	10	3	880	3	caresser
carfare	12	3	1007	3	carfare
carman	10	39	2074	3	carman
carnal	8	39	1920	3	carnal
carpal	10	37	1625	3	carpal
carper	10	49	2363	3	carper
carr	6	54	3470	3	ca__rr
cars	6	73	6476	3	cars__
carse	7	49	3433	3	cars_e
carses	8	52	3365	3	carses
carter	8	49	3227	3	carter
carver	11	44	2014	3	carver
casaba	10	7	926	3	ca_saba
casava	11	5	787	3	ca_sava
casbah	13	3	790	3	casbah
cascara	11	3	831	3	cascara
case	6	58	4808	3	ca_s_e
casease	9	3	932	3	casease
caseate	9	3	1478	3	caseate
cased	8	60	3241	3	ca_sed
casefy	14	3	627	3	casefy
caseic	10	32	1237	3	caseic
casein	8	32	1645	3	casein
casern	8	47	1331	3	casern
cases	7	50	4838	3	ca_ses
cash	9	66	3628	3	ca_s_h
cashaw	14	43	979	3	cashaw
cask	10	56	2643	3	ca_s_k
casks	11	57	2006	3	ca_sks
casky	14	45	1268	3	ca_sky
cassaba	11	4	566	3	cassaba
cassata	9	3	814	3	cassata
cassava	12	5	500	3	cassava
cassia	8	37	1476	3	cassia
cassias	9	35	1434	3	cassias
cassis	8	48	1885	3	cassis
cast	6	71	5990	3	ca_s_t
caste	7	59	3236	3	ca_ste
caster	8	52	3257	3	caster
castor	8	44	1853	3	castor
casts	7	72	3779	3	ca_sts
casual	8	11	1286	3	casual
casus	7	64	1925	3	ca_sus
catena	8	3	1248	3	catena_
catenae	9	3	1137	3	catenae
catenary	13	4	658	3	catenary
catenas	9	3	1311	3	catenas
cater	7	48	4072	3	ca_ter
cateran	9	3	1377	3	cateran
caterer	9	28	1594	3	caterer
cates	7	59	5189	3	cates__
catnap	10	9	838	3	catnap
cats	6	63	5634	3	cats__
catspaw	14	4	335	3	catspaw
catsup	10	3	643	3	catsup
caudad	10	15	767	3	caudad
caudal	9	16	1148	3	caudal
causals	9	14	1118	3	causals
cause	7	52	2535	3	caus_e
caused	9	51	1704	3	caused
causers	9	40	1479	3	causers
causes	8	80	2647	3	causes
causey	11	35	1327	3	causey
caveat	11	4	1772	3	caveat
caveman	14	3	707	3	caveman
caver	10	56	2906	3	ca_ver
caves	10	56	3970	3	caves__
caviare	12	3	837	3	caviare
caviars	12	3	862	3	caviars
caws	9	60	3611	3	caws__
cayman	13	36	1321	3	cayman
cays	9	54	3767	3	cays__
cease	7	52	2765	3	ceas_e
ceased	9	49	2078	3	ceased
ceases	8	44	2707	3	ceases
ceca	8	48	2078	3	c_eca_
cecal	9	46	1911	3	c_ecal
cedarn	9	40	844	3	c_edarn
cedars	9	33	1283	3	c_edars
cedary	12	41	960	3	c_edary
ceder	8	53	2224	3	c_eder
cees	6	59	4159	3	cees__
cellar	8	45	1498	3	cellar
censer	8	45	1658	3	censer
censor	8	40	1129	3	censor
cess	6	53	2605	3	c_es_s
cesta	7	54	1948	3	c_esta
cestas	8	50	1854	3	c_estas
cesti	7	52	1742	3	c_esti
cesura	8	3	876	3	c_esura
chadar	12	3	935	3	chadar
chaeta	11	3	1068	3	chaeta_
chaetae	12	3	860	3	chaetae
chaetal	12	3	828	3	chaetal
char	9	51	3215	3	c__har
chaser	11	49	1838	3	chaser
cheap	12	69	1594	3	che_ap
cheat	10	57	3245	3	che_at
cheddar	14	25	473	3	cheddar
cheder	12	51	1349	3	cheder
cheer	10	54	2038	3	che_er
chela	10	39	1680	3	chela_
chelae	11	36	1460	3	chelae
chelas	11	38	1720	3	chelas
chess	10	50	1692	3	ches_s
chest	10	49	2614	3	ches_t
chests	11	49	1626	3	chests
chesty	14	46	1050	3	chesty
chetah	14	39	958	3	chetah
chewer	14	55	1262	3	chewer
chimar	13	39	1147	3	chimar
chresard	14	4	406	3	chresard
chukar	15	3	463	3	chukar
cigar	8	9	1180	3	c_igar
classer	9	36	1461	3	classer
clausal	9	3	627	3	clausal
clean	7	54	2041	3	cle_an
clears	8	41	1656	3	cle_ars
cleat	7	63	3506	3	cle_at
clever	11	46	1153	3	clever
closer	8	49	1820	3	closer
coaeval	12	4	518	3	coaeval
coarser	9	32	1120	3	coarser
coeval	11	3	889	3	coeval
collar	8	38	1617	3	collar
corsac	10	4	1017	3	corsac
corsair	9	3	763	3	corsair
costar	8	55	1861	3	costar
cottar	8	46	1381	3	cottar
cougar	9	5	878	3	cougar
crasser	9	41	1433	3	crasser
creak	11	54	1843	3	cre_ak
cream	9	57	2135	3	cre_am
crease	8	55	1957	3	crease
creaser	9	44	1573	3	creaser
creasy	11	46	1230	3	creasy
credal	9	3	1167	3	credal
cresol	8	3	1021	3	cresol
cress	7	50	2283	3	cres_s
cressy	11	43	911	3	cressy
crest	7	46	3269	3	cres_t
crestal	9	3	1213	3	crestal
crests	8	52	1870	3	crests
cresyl	11	3	513	3	cresyl
cues	6	54	3898	3	cues__
cuesta	8	3	851	3	cuesta
cuestas	9	5	793	3	cuestas
curser	8	47	2147	3	curser
cursor	8	41	1029	3	cursor
cusser	8	60	1609	3	cusser
cyeses	11	5	1012	3	cyeses
cyesis	11	4	857	3	cyesis
cymar	12	57	1126	3	c_ymar
czar	15	60	1313	3	c__zar
daedal	8	4	908	3	daedal
damar	8	41	1773	3	da_mar
dammar	11	43	890	3	dammar
darbar	9	5	995	3	darbar
daresay	11	3	543	3	daresay
daystar	11	4	344	3	daystar
dear	5	53	4360	3	_de_ar
debar	8	55	1786	3	_debar
denar	6	52	2329	3	_denar
dewar	9	58	1773	3	_dewar
drear	6	50	1690	3	dre_ar
ear	3	68	6788	3	__e_ar
escar	7	40	1199	3	__escar
eskar	9	45	745	3	__eskar
eyebar	11	3	532	3	eyebar
faecal	11	35	981	3	faecal
faena	8	50	1420	3	faena_
faenas	9	44	1276	3	faenas
falser	9	39	1241	3	falser
fear	7	53	3779	3	_fe_ar
feuar	8	3	1024	3	_feuar
gaes	5	63	4803	3	gaes__
gasser	7	50	1777	3	gasser
gaydar	11	3	550	3	gaydar
gazar	15	46	1298	3	ga_zar
gear	5	59	3497	3	_ge_ar
haar	7	73	2349	3	ha__ar
haemal	11	38	1164	3	haemal
haes	7	76	5102	3	haes__
hangar	10	41	1451	3	hangar
hansa	8	54	1678	3	hansa_
hansas	9	46	1604	3	hansas
hawser	12	59	1084	3	hawser
hear	7	61	4388	3	_he_ar
hussar	9	31	728	3	hussar
jaeger	14	39	719	3	jaeger
jaguar	14	3	528	3	jaguar
kabar	11	48	1555	3	ka_bar
kaes	8	57	3406	3	kaes__
kaiser	10	36	1037	3	kaiser
kantar	10	3	1115	3	kantar
kebar	11	51	1353	3	_kebar
lahar	8	31	1426	3	la_har
lapser	8	41	1314	3	lapser
lascar	8	6	857	3	lascar
laser	5	46	3332	3	la_ser
lazar	14	41	1364	3	la_zar
lear	4	70	4595	3	_le_ar
leaser	6	53	2267	3	leaser
maar	6	60	2506	3	ma__ar
maenad	9	3	941	3	maenad
maes	6	69	4840	3	maes__
maestri	9	4	548	3	maestri
maestro	9	4	572	3	maestro
makar	11	56	1497	3	ma_kar
malar	7	64	2444	3	ma_lar
mansard	10	4	931	3	mansard
masa	6	50	3472	3	ma_sa_
masas	7	56	3041	3	ma_sas
maser	7	50	2997	3	ma_ser
massa	7	55	1892	3	massa_
massas	8	51	1646	3	massas
matsah	11	3	823	3	matsah
mesa	6	70	2548	3	_mesa_
mesas	7	68	2320	3	_mesas
nasal	5	62	1759	3	na_sal
navar	8	39	1273	3	na_var
naysay	12	3	497	3	naysay
near	4	52	3650	3	_ne_ar
osar	4	68	2095	3	__osar
paean	7	72	2272	3	pae_an
paesani	9	34	868	3	paesani
paesano	9	33	879	3	paesano
paesans	9	33	1269	3	paesans
paisa	7	60	2107	3	paisa_
paisan	8	44	1707	3	paisan
paisas	8	43	1749	3	paisas
palmar	10	41	1346	3	palmar
parser	8	48	2237	3	parser
passer	8	47	2103	3	passer
pausal	8	15	1196	3	pausal
pauser	8	44	1596	3	pauser
pear	6	97	4523	3	_pe_ar
presa	7	43	1904	3	presa_
prewar	11	47	1258	3	prewar
pulsar	8	32	936	3	pulsar
quasar	15	3	683	3	quasar
radar	6	13	1672	3	ra_dar
raiser	6	66	2010	3	raiser
raser	5	56	3341	3	ra_ser
rear	4	56	4455	3	_re_ar
rebar	7	54	2019	3	_rebar
resat	5	51	3968	3	_resat
resaw	8	41	1725	3	_resaw
resay	8	53	2054	3	_resay
saggar	8	40	1085	3	saggar
salsa	5	67	1892	3	salsa_
salsas	6	53	1613	3	salsas
sambar	10	39	1416	3	sambar
samsara	9	3	691	3	samsara
sangar	7	36	1768	3	sangar
sansars	7	33	1391	3	sansars
sardar	7	30	1317	3	sardar
sarsars	7	35	1214	3	sarsars
scalar	8	36	1243	3	sca_lar
sear	4	73	5384	3	_se_ar
seesaw	9	3	597	3	seesaw
sewar	8	54	2110	3	_sewar
shear	8	54	2483	3	she_ar
smear	7	44	1639	3	sme_ar
spear	7	58	2106	3	spe_ar
stelar	6	40	1386	3	stelar
swear	8	53	1685	3	swe_ar
talar	5	62	2538	3	ta_lar
tarsal	6	33	1527	3	tarsal
tartar	6	32	1475	3	tartar
tatar	5	61	2206	3	ta_tar
tear	4	52	4288	3	_te_ar
teaser	6	54	2152	3	teaser
thenar	9	26	1000	3	thenar
tsar	4	78	1980	3	__tsar
tussar	6	36	954	3	tussar
valvar	12	38	865	3	valvar
vasa	7	65	2297	3	va_sa_
vasal	8	55	1629	3	va_sal
vassal	9	7	924	3	vassal
velar	8	58	1763	3	_velar
waes	7	60	4860	3	waes__
warsaw	12	3	619	3	warsaw
wear	7	58	3672	3	_we_ar
year	7	65	3425	3	_ye_ar
zaffar	21	38	504	3	zaffar

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.390	458182.1
2	DLD Change Limit	112716	434	5.513	20445.5
3	Display Results	434	434	0.143	3035.0
	(SQL Overall)	178691	434	6.046	29555.2