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

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

487 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
caviar	11	3	1016	(None)
caviare	12	3	837	1	caviare
caviars	12	3	862	1	caviars
avian	8	46	1605	2	_avian
aviary	12	33	841	2	_aviary
caesar	8	4	1093	2	caesar
cagier	9	37	1593	2	cagier
cahier	11	36	1577	2	cahier
cakier	12	31	1524	2	cakier
calcar	10	3	1275	2	calcar
capias	10	3	1835	2	capias
caveat	11	4	1772	2	caveat
caver	10	56	2906	2	cav_er
caviares	13	3	799	2	caviares
cavie	10	46	2159	2	cavi_e
cavies	11	45	2500	2	cavies
cavil	10	38	1649	2	cavi_l
caviler	12	4	906	2	caviler
cavils	11	40	1439	2	cavils
caving	12	48	2261	2	caving
cavitary	16	6	496	2	cavitary
cavity	14	3	1001	2	cavity
clavier	12	3	917	2	clavier
gavial	10	3	1008	2	gavial
havior	12	4	820	2	havior
navar	8	39	1273	2	nav_ar
pavior	11	3	853	2	pavior
savior	9	7	1017	2	savior
wavier	12	46	1308	2	wavier
acacia	10	3	1135	3	acacia_
acacias	11	5	1039	3	acacias
achier	11	39	1426	3	achier
acinar	8	3	1048	3	acinar
afar	7	67	2078	3	_a_far
agar	5	87	2641	3	_a_gar
air	3	80	5839	3	_a_i_r
aiver	8	57	2516	3	_aiver
ajar	11	62	1770	3	_a_jar
alar	4	63	4007	3	_a_lar
alias	5	58	3460	3	_alias
altar	5	55	2064	3	_altar
amia	6	68	3690	3	_amia_
amias	7	58	3147	3	_amias
amir	6	51	2975	3	_ami_r
anear	5	54	2032	3	_anear
antiar	6	3	1717	3	antiar
apian	7	50	1833	3	_apian
apiary	11	39	1038	3	_apiary
aria	4	62	4542	3	_aria_
ariary	9	41	1420	3	_ariary
arias	5	54	3802	3	_arias
attar	5	65	1669	3	_attar
aurar	5	44	2025	3	_aurar
ava	6	101	3932	3	_av_a_
avail	8	3	1388	3	_avail
avatar	9	3	752	3	_avatar
aver	7	59	3188	3	_av_er
avgas	9	69	1213	3	_avgas
avians	9	37	1156	3	_avians
aviate	9	3	1520	3	_aviate
aviator	10	22	966	3	_aviator
avid	8	83	2596	3	_avi_d
avion	8	42	1834	3	_avion
aviso	8	57	1396	3	_aviso
axial	12	45	1519	3	_axial
babier	10	35	1557	3	babier
banian	8	3	1538	3	banian
basilar	9	3	730	3	basilar
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	ba_zar
briar	7	57	1815	3	_briar
cabal	9	52	2215	3	ca_bal
caber	9	51	2683	3	ca_ber
cabin	9	48	2094	3	cabi_n
cabins	10	44	1892	3	cabins
cabler	10	45	1917	3	cabler
cabman	12	38	1250	3	cabman
caca	8	55	2808	3	ca_ca_
cacao	9	54	2000	3	ca_cao
cacas	9	56	2798	3	ca_cas
cadger	10	50	1389	3	cadger
cadi	7	57	3217	3	cadi__
cadis	8	44	2849	3	cadi_s
caeca	9	39	1513	3	caeca_
caecal	10	37	1373	3	caecal
caesars	9	4	1072	3	caesars
caftan	11	17	1012	3	caftan
cager	8	52	2922	3	ca_ger
cagily	12	4	1156	3	cagily
caging	10	53	2102	3	caging
cahiers	12	35	1067	3	cahiers
caid	7	78	3753	3	ca_i_d
caids	8	52	2642	3	ca_ids
caiman	10	36	1566	3	caiman
cain	6	56	4391	3	ca_i_n
cains	7	53	3430	3	ca_ins
caird	8	57	1723	3	ca_ird
cairn	7	57	1751	3	ca_irn
caking	13	46	2467	3	caking
calamar	11	4	929	3	calamar
calcars	11	3	1265	3	calcars
caliber	11	3	973	3	caliber
calibre	11	3	660	3	calibre
calico	10	34	1443	3	calico
calif	10	49	2910	3	cali_f
califs	11	49	1589	3	califs
caliper	11	4	1096	3	caliper
caliph	13	3	1140	3	caliph
calix	14	53	1734	3	cali_x
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
calving	13	41	1350	3	calving
camail	10	3	1482	3	camail
camas	9	63	3352	3	ca_mas
camber	12	44	1847	3	camber
cambia	12	49	1315	3	cambia_
cambial	13	40	1076	3	cambial
camera	10	3	1367	3	camera
camion	10	39	1719	3	camion
camisa	10	31	1432	3	camisa
camisas	11	34	1192	3	camisas
camise	10	33	1963	3	camise
camper	12	47	2221	3	camper
campier	13	33	1327	3	campier
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
canid	8	55	2634	3	cani_d
canids	9	51	1813	3	canids
canine	8	38	2670	3	canine
caning	9	41	2862	3	caning
canker	12	44	2252	3	canker
canna	7	59	1933	3	canna_
cannas	8	45	1840	3	cannas
canner	8	46	2598	3	canner
cannier	9	40	1416	3	cannier
canoer	8	51	2107	3	canoer
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
caper	9	48	3162	3	ca_per
capita	10	29	1377	3	capita
capital	11	23	1152	3	capital
capiz	18	5	1456	3	capi_z
capper	12	44	2198	3	capper
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
cardia	9	9	1637	3	cardia_
cardiac	12	7	881	3	cardiac
cardiae	10	7	1370	3	cardiae
cardias	10	7	1509	3	cardias
career	8	58	2224	3	career
carer	7	49	4233	3	ca_rer
carfare	12	3	1007	3	carfare
caribe	10	34	1675	3	caribe
caried	9	45	2869	3	caried
caries	8	51	4762	3	caries
carina	8	43	2532	3	carina
carinae	9	43	1858	3	carinae
carinal	9	43	1822	3	carinal
carinas	9	36	2238	3	carinas
caring	9	51	3799	3	caring
caritas	9	33	1694	3	caritas
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
carrier	9	36	1958	3	carrier
carter	8	49	3227	3	carter
carver	11	44	2014	3	carver
carving	13	39	1677	3	carving
casa	6	56	3086	3	ca_sa_
casas	7	53	2784	3	ca_sas
casbah	13	3	790	3	casbah
cascara	11	3	831	3	cascara
cashaw	14	43	979	3	cashaw
cashier	12	37	1332	3	cashier
casing	9	48	2910	3	casing
casini	8	46	1586	3	casini
casino	8	43	1755	3	casino
casita	8	29	1370	3	casita
casitas	9	33	1204	3	casitas
cassia	8	37	1476	3	cassia_
cassias	9	35	1434	3	cassias
caster	8	52	3257	3	caster
castor	8	44	1853	3	castor
casual	8	11	1286	3	casual
cater	7	48	4070	3	ca_ter
cation	8	39	2550	3	cation
catnap	10	9	838	3	catnap
cattier	9	33	1707	3	cattier
caudad	10	15	767	3	caudad
caudal	9	16	1148	3	caudal
causal	8	14	1320	3	causal
causer	8	41	1778	3	causer
cavalier	13	4	817	3	cavalier
cavalry	15	5	496	3	cavalry
cave	9	59	4126	3	cav__e
caveator	13	8	723	3	caveator
caveats	12	3	980	3	caveats
caved	11	62	2756	3	cav_ed
caveman	14	3	707	3	caveman
cavern	11	53	1245	3	cavern
cavers	11	50	2683	3	cavers
caves	10	56	3970	3	cav_es
cavicorn	15	4	383	3	cavicorn
caviled	13	4	872	3	caviled
cavilers	13	4	811	3	cavilers
caviller	13	3	705	3	caviller
cavings	13	47	1254	3	cavings
cavitate	13	15	983	3	cavitate
cavort	11	3	1617	3	cavort
cavy	12	59	2000	3	cav__y
cawing	12	43	2261	3	cawing
cayman	13	36	1321	3	cayman
cedar	8	40	1432	3	c_edar
celiac	10	19	1043	3	celiac
cellar	8	45	1498	3	cellar
ceria	7	51	2535	3	ceria_
cerias	8	33	2197	3	cerias
chadar	12	3	934	3	chadar
chair	10	55	1963	3	chai_r
char	9	51	3215	3	c__har
charier	12	43	1790	3	charier
chia	9	60	2662	3	c_hia_
chiao	10	56	1836	3	c_hiao
chias	10	46	2551	3	c_hias
chimar	13	39	1146	3	chimar
chirr	10	50	1590	3	c_hirr
chivari	15	3	603	3	chivari
choir	10	53	1359	3	choi_r
chukar	15	3	463	3	chukar
ciao	6	49	2418	3	c__iao
cigar	8	9	1179	3	c_igar
cilia	7	30	1676	3	cilia_
ciliary	12	4	792	3	ciliary
civic	12	34	1254	3	civi_c
civics	13	39	782	3	civics
civie	10	37	1635	3	civi_e
civies	11	41	1644	3	civies
civil	10	34	1193	3	civi_l
civism	13	3	724	3	civism
claver	11	38	1697	3	clav_er
clavi	10	49	1292	3	clavi__
claviers	13	6	710	3	claviers
clayier	12	4	832	3	clayier
clear	7	62	1905	3	c_lear
clivia	11	7	723	3	clivia_
clivias	12	6	669	3	clivias
coalier	9	34	1617	3	coalier
coaxial	16	15	700	3	coaxial
cobia	9	41	1751	3	cobia_
cobias	10	40	1498	3	cobias
coir	6	63	2724	3	c_oi_r
collar	8	38	1617	3	collar
copier	10	37	2289	3	copier
coria	7	58	2830	3	coria_
cosier	8	44	2375	3	cosier
costar	8	55	1861	3	costar
cottar	8	46	1381	3	cottar
cougar	9	5	878	3	cougar
covary	14	3	874	3	cov_ary
cover	10	54	3077	3	cov_er
covin	10	56	2112	3	covi_n
coving	12	43	2152	3	coving
covins	11	46	1806	3	covins
cowier	11	36	1616	3	cowier
cozier	17	33	1514	3	cozier
crania	8	24	1843	3	crania_
cranial	9	21	1468	3	cranial
cravat	11	3	1444	3	crav_at
craver	11	46	1846	3	crav_er
craving	13	40	1573	3	craving
crazier	18	36	1074	3	crazier
crier	7	47	2446	3	c_rier
curia	7	45	2376	3	curia_
curiae	8	45	1837	3	curiae
curial	8	40	1915	3	curial
curvier	12	31	1066	3	curvier
cymar	12	57	1126	3	c_ymar
czar	15	60	1313	3	c__zar
damar	8	41	1773	3	da_mar
dammar	11	43	890	3	dammar
darbar	9	5	995	3	darbar
davies	10	50	2051	3	davies
davit	9	34	2459	3	davi_t
davits	10	40	1236	3	davits
easier	6	42	1846	3	easier
envier	9	3	967	3	envier
facia	10	32	1846	3	facia_
faciae	11	29	1341	3	faciae
facial	11	36	1563	3	facial
facias	11	34	1580	3	facias
fair	7	63	3252	3	fa_i_r
fakir	12	51	1149	3	faki_r
faqir	17	54	864	3	faqi_r
fava	10	68	2026	3	fav_a_
favas	11	56	1859	3	fav_as
favism	14	3	791	3	favism
favor	11	47	1245	3	fav_or
favour	12	43	833	3	favour
fiar	7	64	2733	3	__fiar
foliar	9	32	1097	3	foliar
friar	8	54	1427	3	_friar
gamier	9	36	1793	3	gamier
gavials	11	3	660	3	gavials
gaydar	11	3	550	3	gaydar
gazar	15	46	1298	3	ga_zar
haar	7	73	2349	3	ha__ar
hair	7	63	3014	3	ha_i_r
hangar	10	41	1450	3	hangar
haver	11	51	2446	3	hav_er
having	13	42	2037	3	having
haviors	13	4	738	3	haviors
haviour	13	5	482	3	haviour
hazier	18	47	1240	3	hazier
heavier	13	42	942	3	heavier
invar	8	3	951	3	inv_ar
jaguar	14	3	528	3	jaguar
java	14	73	1664	3	jav_a_
javas	15	59	1542	3	jav_as
jivier	16	43	861	3	jivier
jovial	16	3	654	3	jovial
kabar	11	48	1555	3	ka_bar
kafir	12	48	890	3	kafi_r
kaiak	8	3	1035	3	ka_iak
kalian	10	3	1216	3	kalian
kantar	10	3	1115	3	kantar
kava	11	58	1970	3	kav_a_
kavas	12	59	1995	3	kav_as
labia	7	52	1901	3	labia_
labial	8	47	1434	3	labial
lacier	8	40	2009	3	lacier
lahar	8	31	1426	3	la_har
lair	4	59	3415	3	la_i_r
lakier	10	47	1627	3	lakier
lamia	7	53	2432	3	lamia_
lamiae	8	48	1745	3	lamiae
lamias	8	50	2061	3	lamias
laminar	9	38	1028	3	laminar
laniard	8	6	852	3	laniard
laniary	10	6	801	3	laniary
lariat	6	6	2904	3	lariat
lascar	8	6	857	3	lascar
lava	7	67	2542	3	lav_a_
lavas	8	54	2222	3	lav_as
laveer	9	41	1042	3	laveer
laver	8	50	3179	3	lav_er
laving	10	46	2357	3	laving
lavish	12	41	1298	3	lavish
lazar	14	41	1364	3	la_zar
lazier	15	42	1461	3	lazier
leavier	10	31	999	3	leavier
levier	9	40	1387	3	levier
liar	4	72	2968	3	__liar
livier	9	75	1459	3	livier
maar	6	60	2505	3	ma__ar
mafia	10	44	1803	3	mafia_
mafias	11	39	1357	3	mafias
magian	9	3	1283	3	magian
mair	6	61	3377	3	ma_i_r
makar	11	56	1497	3	ma_kar
malar	7	64	2444	3	ma_lar
mania	7	56	3414	3	mania_
maniac	10	39	1797	3	maniac
manias	8	40	2903	3	manias
maria	7	50	3288	3	maria_
matier	8	43	2152	3	matier
mavie	10	47	2256	3	mavi_e
mavies	11	49	2319	3	mavies
mavin	10	57	2295	3	mavi_n
mavins	11	51	1918	3	mavins
mavis	10	56	2272	3	mavi_s
mazier	17	50	1306	3	mazier
nadir	6	10	1297	3	nadi_r
naiad	6	3	1340	3	na_iad
naira	5	3	1474	3	na_ira
naiver	9	43	1135	3	naiver
narial	6	3	1795	3	narial
nasial	6	4	1328	3	nasial
navaid	10	3	764	3	navaid
naval	8	53	1583	3	nav_al
navars	9	28	1057	3	nav_ars
navies	9	52	1862	3	navies
oakier	10	40	1139	3	oakier
pacier	10	50	1868	3	pacier
pair	6	60	3151	3	pa_i_r
palier	8	50	2356	3	palier
palikar	13	3	545	3	palikar
palmar	10	41	1346	3	palmar
panier	8	44	2550	3	panier
pariah	11	43	2058	3	pariah
parian	8	32	2396	3	parian
pavan	10	65	1847	3	pav_an
paver	10	42	2583	3	pav_er
pavid	11	57	1700	3	pavi_d
pavin	10	56	2320	3	pavi_n
paving	12	45	1974	3	paving
pavins	11	49	1966	3	pavins
paviors	12	3	760	3	paviors
paviour	12	4	462	3	paviour
pavis	10	64	2273	3	pavi_s
pavise	11	47	1480	3	pavise
paviser	12	48	909	3	paviser
racial	8	34	1924	3	racial
racier	8	51	2097	3	racier
radar	6	13	1672	3	ra_dar
radial	7	40	2039	3	radial
radian	7	41	1727	3	radian
raia	4	66	3838	3	ra_ia_
raias	5	46	3112	3	ra_ias
rapier	8	40	1999	3	rapier
raver	8	56	3149	3	rav_er
ravin	8	56	2465	3	ravi_n
ravine	9	55	2222	3	ravine
raving	10	51	2885	3	raving
ravins	9	46	2256	3	ravins
ravish	12	34	1403	3	ravish
sabir	7	59	1700	3	sabi_r
saggar	8	40	1085	3	saggar
sagier	7	37	1716	3	sagier
salvia	9	33	1075	3	salvia_
salvias	10	27	993	3	salvias
sambar	10	39	1416	3	sambar
sangar	7	36	1768	3	sangar
sansar	6	36	1339	3	sansar
sardar	7	30	1317	3	sardar
sarsar	6	30	1184	3	sarsar
saver	8	48	3125	3	sav_er
savin	8	46	2508	3	savi_n
savine	9	42	2028	3	savine
saving	10	47	2451	3	saving
savins	9	39	2313	3	savins
saviors	10	5	899	3	saviors
saviour	10	3	521	3	saviour
savor	8	54	1794	3	sav_or
savour	9	41	1070	3	savour
savvier	13	3	548	3	savvier
scalar	8	36	1243	3	sca_lar
scalier	9	43	1691	3	scalier
scarier	9	40	1787	3	scarier
tafia	8	42	1549	3	tafia_
tafias	9	31	1196	3	tafias
talar	5	62	2538	3	ta_lar
tapir	7	59	1706	3	tapi_r
tartar	6	32	1475	3	tartar
tatar	5	61	2206	3	ta_tar
vair	7	56	2414	3	va_i_r
valvar	12	38	865	3	valvar
var	6	61	4833	3	__v_ar
varia	8	58	2420	3	varia_
varias	9	50	1990	3	varias
varier	9	46	1935	3	varier
via	6	56	3624	3	__via_
vial	7	67	3109	3	__vial
vicar	10	5	1386	3	__vicar
vier	7	54	2815	3	__vier
wair	7	58	3005	3	wa_i_r
waiver	12	42	1271	3	waiver
wanier	9	39	2068	3	wanier
warier	9	37	2289	3	warier
waver	11	50	2570	3	wav_er
wavies	12	50	1984	3	wavies
wavily	15	21	948	3	wavily
waving	13	40	1820	3	waving
waxier	16	43	990	3	waxier
zaffar	21	38	504	3	zaffar
zamia	16	51	1521	3	zamia_
zamias	17	42	1292	3	zamias
zanier	15	43	1471	3	zanier

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.143	1249587.4
2	DLD Change Limit	112716	487	6.670	16899.0
3	Display Results	487	487	0.156	3121.8
	(SQL Overall)	178691	487	6.969	25640.8