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

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

331 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
cravat	11	3	1444	(None)
cravats	12	3	740	1	cravats
brava	10	64	1479	2	brava_
bravas	11	49	1332	2	bravas
carat	7	50	4879	2	c_arat
caravan	12	3	923	2	caravan
caveat	11	4	1772	2	c_aveat
clavate	12	3	871	2	clavate
craal	7	41	1775	2	cra_al
craft	10	53	2766	2	cra_ft
crave	10	56	2631	2	crav_e
craved	12	54	1777	2	craved
craven	11	41	1393	2	craven
craver	11	46	1847	2	craver
craves	11	58	2539	2	craves
rabat	7	28	3222	2	_rabat
acrobat	11	4	1181	3	acrobat
arhat	8	3	2709	3	ar_hat
arval	8	60	1701	3	ar_val
ava	6	101	3932	3	__ava_
avant	8	62	2466	3	__avant
avast	8	55	1936	3	__avast
bract	9	63	3272	3	bra_ct
brant	7	47	4217	3	bra_nt
brat	6	60	5554	3	br__at
bravado	13	4	360	3	bravado
brave	10	49	2550	3	brav_e
braved	12	48	1744	3	braved
braver	11	47	1904	3	braver
braves	11	55	2408	3	braves
bravest	12	42	1175	3	bravest
bravi	10	47	1575	3	brav_i
bravo	10	52	1434	3	brav_o
bravos	11	47	1139	3	bravos
braza	16	52	1425	3	braza_
brazas	17	58	1243	3	brazas
brevet	11	57	1733	3	brevet
cabal	9	52	2215	3	c_abal
caca	8	55	2808	3	c_aca_
cacao	9	54	2000	3	c_acao
cacas	9	56	2798	3	c_acas
cadet	8	53	3934	3	c_adet
camas	9	63	3352	3	c_amas
canal	7	54	2804	3	c_anal
canst	7	49	3221	3	c_anst
cant	6	63	6203	3	c_a_nt
canvas	11	38	1333	3	canvas
caput	9	8	2398	3	c_aput
carabao	11	3	967	3	carabao
caracal	11	3	1251	3	caracal
carapax	18	3	579	3	carapax
carate	8	47	3400	3	c_arate
carats	8	59	2902	3	c_arats
caravans	13	3	862	3	caravans
caravel	12	3	821	3	caravel
caraway	15	3	813	3	caraway
caret	7	53	6056	3	c_aret
carman	10	39	2074	3	carman
carnal	8	39	1920	3	carnal
carnet	8	47	3287	3	carnet
carpal	10	37	1625	3	carpal
carpet	10	45	3009	3	carpet
carrot	8	4	2312	3	carrot
cart	6	65	7034	3	c_a_rt
carve	10	62	2775	3	carv_e
carved	12	43	2085	3	carved
carvel	11	48	1757	3	carvel
carven	11	47	1666	3	carven
carver	11	44	2015	3	carver
carves	11	51	2845	3	carves
casa	6	56	3086	3	c_asa_
casas	7	53	2784	3	c_asas
casava	11	5	787	3	casava_
casavas	12	3	782	3	casavas
cast	6	71	5990	3	c_a_st
cat	5	82	8234	3	c___at
cave	9	59	4126	3	c_av_e
caveats	12	3	980	3	c_aveats
caved	11	62	2756	3	c_aved
caver	10	56	2906	3	c_aver
caves	10	56	3970	3	c_aves
caviar	11	3	1016	3	c_aviar
cavie	10	46	2159	3	c_avie
cavil	10	38	1649	3	c_avil
cavity	14	3	1001	3	c_avity
cavort	11	3	1617	3	c_avort
cavy	12	59	2000	3	c_av_y
ceramal	11	3	884	3	ceramal
chadar	12	3	935	3	chadar
chaeta	11	3	1068	3	chaeta
chalah	14	35	1166	3	chalah
chalet	11	38	2599	3	chalet
chalot	11	30	2013	3	chalot
chant	10	59	3269	3	cha_nt
chapati	14	11	802	3	chapati
chapt	12	58	2764	3	cha_pt
charas	11	42	2361	3	charas
chart	10	50	3828	3	cha_rt
chat	9	55	4613	3	c__hat
chaunt	11	6	1349	3	chaunt
chazan	20	26	913	3	chazan
cheat	10	57	3245	3	c_heat
civet	10	58	2873	3	c_ivet
clamant	11	3	1243	3	clamant
clapt	9	80	2717	3	cla_pt
claret	8	40	2657	3	claret
claspt	10	45	1341	3	claspt
clast	7	60	3058	3	cla_st
clave	10	54	2015	3	clav_e
claver	11	38	1697	3	claver
claves	11	50	2006	3	claves
clavi	10	49	1292	3	clav_i
clavus	11	34	735	3	clavus
cleat	7	63	3506	3	c_leat
coact	9	61	3058	3	coa_ct
coaeval	12	4	518	3	coaeval
coala	7	75	2112	3	coala_
coalas	8	74	1896	3	coalas
coapt	9	61	3153	3	coa_pt
coast	7	52	3627	3	coa_st
coat	6	75	5835	3	c__oat
coaxal	15	38	730	3	coaxal
coeval	11	3	889	3	coeval
combat	12	3	1675	3	combat
corvet	11	46	2693	3	corvet
covet	10	56	3894	3	c_ovet
cowpat	13	3	1203	3	cowpat
craals	8	41	1330	3	craals
crab	8	57	2767	3	cr__ab
crabby	15	34	675	3	crabby
crabmeat	14	4	548	3	crabmeat
crabs	9	54	2139	3	cra_bs
crack	13	41	2053	3	cra_ck
cracks	14	48	1700	3	cracks
cracky	17	50	1022	3	cracky
cradle	9	33	1316	3	cradle
crafts	11	53	1274	3	crafts
crafty	14	47	891	3	crafty
crag	7	56	2530	3	cr__ag
craggy	13	39	660	3	craggy
crags	8	56	2257	3	cra_gs
crake	11	48	2352	3	cra_ke
crakes	12	49	2181	3	crakes
cram	8	56	3549	3	cr__am
crambe	12	3	907	3	crambe
crambo	12	3	804	3	crambo
cramp	11	51	2069	3	cra_mp
crampit	13	3	886	3	crampit
cramps	12	56	1556	3	cramps
crampy	15	47	1099	3	crampy
crams	9	62	2915	3	cra_ms
cranch	13	36	1353	3	cranch
crane	7	53	3160	3	cra_ne
craned	9	61	2165	3	craned
cranes	8	43	3075	3	cranes
crania	8	24	1843	3	crania
cranial	9	21	1468	3	cranial
craniate	10	3	1256	3	craniate
crank	11	48	1961	3	cra_nk
cranks	12	50	1531	3	cranks
cranky	15	39	1063	3	cranky
cranny	11	42	1027	3	cranny
crap	8	57	3184	3	cr__ap
crape	9	61	2844	3	cra_pe
craped	11	61	2052	3	craped
crapes	10	47	2769	3	crapes
crappy	15	44	680	3	crappy
craps	9	53	2864	3	cra_ps
crases	8	55	3231	3	crases
crash	10	91	2001	3	cra_sh
crasis	8	50	2047	3	crasis
crass	7	63	2804	3	cra_ss
cratch	13	41	1079	3	cratch
crate	7	65	3740	3	cra_te
crated	9	48	2777	3	crated
crater	8	50	2664	3	crater
crates	8	57	3606	3	crates
craton	8	45	1719	3	craton
cravens	12	40	1012	3	cravens
cravers	12	44	1656	3	cravers
craving	13	40	1573	3	craving
craw	9	77	2526	3	cr__aw
crawdad	14	4	311	3	crawdad
crawl	10	49	1671	3	cra_wl
crawls	11	47	1208	3	crawls
crawly	14	46	1076	3	crawly
craws	10	57	2312	3	cra_ws
crayon	11	41	1000	3	crayon
craze	16	52	2146	3	cra_ze
crazed	18	47	1445	3	crazed
crazes	17	47	2013	3	crazes
crazy	19	55	1122	3	cra_zy
creak	11	54	1843	3	cr_eak
cream	9	57	2135	3	cr_eam
create	8	51	2638	3	cr_eate
credal	9	3	1167	3	credal
credit	9	3	1519	3	credit
cremate	11	38	1618	3	cremate
crenate	9	33	1711	3	crenate
crept	9	51	2589	3	cr_ept
crest	7	46	3269	3	cr_est
crista	8	3	1180	3	crista
crit	6	57	4371	3	cr__it
croak	11	52	1663	3	cr_oak
croft	10	56	2268	3	cr_oft
cruet	7	48	3184	3	cr_uet
crura	7	3	1258	3	crura_
crural	8	6	1063	3	crural
cruset	8	44	2509	3	cruset
crust	7	58	2766	3	cr_ust
crypt	12	37	1523	3	cr_ypt
curacao	11	4	629	3	curacao
curara	8	37	1220	3	curara_
curaras	9	39	1195	3	curaras
curvet	11	47	2024	3	curvet
cushat	11	35	1369	3	cushat
cyanate	12	25	970	3	cyanate
davit	9	34	2459	3	_davit
draft	9	55	2668	3	dra_ft
drama	8	51	1741	3	drama_
dramas	9	58	1465	3	dramas
drat	5	62	4783	3	dr__at
drave	9	52	1927	3	drav_e
fava	10	68	2026	3	_fava_
favas	11	56	1859	3	_favas
fracas	11	3	1199	3	fracas
frat	7	56	4854	3	fr__at
gavot	9	3	2112	3	_gavot
graal	6	43	1650	3	gra_al
gradate	9	5	1123	3	gradate
graft	9	53	2720	3	gra_ft
graham	12	3	785	3	graham
grama	8	56	2028	3	grama_
gramas	9	43	1720	3	gramas
grana	6	57	2209	3	grana_
grant	6	48	4002	3	gra_nt
grat	5	56	5128	3	gr__at
grave	9	46	2487	3	grav_e
graved	11	48	1881	3	graved
gravel	10	53	1382	3	gravel
graven	10	45	1352	3	graven
graver	10	50	1859	3	graver
graves	10	46	2400	3	graves
gravest	11	40	1163	3	gravest
gravid	11	37	1098	3	gravid
gravity	14	3	718	3	gravity
gravlax	18	4	264	3	gravlax
gravy	12	55	1211	3	grav_y
great	6	60	3424	3	gr_eat
grivet	10	35	1782	3	grivet
groat	6	55	3197	3	gr_oat
guava	9	3	858	3	guava_
guavas	10	3	716	3	guavas
java	14	73	1664	3	_java_
javas	15	59	1542	3	_javas
karat	9	68	3759	3	_karat
kava	11	58	1970	3	_kava_
kavas	12	59	1995	3	_kavas
kraal	9	45	1182	3	kra_al
kraft	12	57	2101	3	kra_ft
krait	9	47	2677	3	kra_it
kraut	9	52	2140	3	kra_ut
lariat	6	6	2904	3	lariat
larva	8	3	1248	3	larva_
larvae	9	3	884	3	larvae
larval	9	4	850	3	larval
larvas	9	3	1023	3	larvas
lava	7	67	2542	3	_lava_
lavas	8	54	2222	3	_lavas
lovat	8	3	2104	3	_lovat
manat	7	60	3999	3	_manat
naval	8	53	1583	3	_naval
navar	8	39	1273	3	_navar
octaval	12	4	358	3	octaval
orgeat	7	5	1503	3	orgeat
pavan	10	65	1847	3	_pavan
praam	9	48	1561	3	pra_am
prat	6	59	5204	3	pr__at
private	12	15	1326	3	private
privet	11	38	2134	3	privet
qanat	14	44	2684	3	_qanat
rabato	8	34	1326	3	_rabato
rabats	8	31	1622	3	_rabats
radar	6	13	1672	3	_radar
raft	7	62	4591	3	_ra_ft
raga	5	59	3081	3	_raga_
ragas	6	53	2606	3	_ragas
raia	4	66	3838	3	_raia_
raias	5	46	3112	3	_raias
raita	5	46	2307	3	_raita
raja	11	79	1868	3	_raja_
rajah	15	57	1142	3	_rajah
rajas	12	73	1772	3	_rajas
ramal	7	46	2224	3	_ramal
ramate	8	39	2168	3	_ramate
ramet	7	57	4314	3	_ramet
rant	4	58	6468	3	_ra_nt
rapt	6	72	4531	3	_ra_pt
rat	3	78	9274	3	_r__at
ratal	5	50	2511	3	_ratal
ratan	5	37	2266	3	_ratan
ravage	10	3	930	3	_ravage
rave	7	55	4209	3	_rav_e
raved	9	49	3143	3	_raved
ravel	8	46	2151	3	_ravel
raven	8	47	2344	3	_raven
raver	8	56	3149	3	_raver
raves	8	54	4197	3	_raves
ravin	8	56	2465	3	_ravin
raya	7	52	2482	3	_raya_
rayah	11	60	1350	3	_rayah
rayas	8	59	2205	3	_rayas
resat	5	51	3968	3	_resat
revet	8	49	3884	3	_revet
rival	8	52	1650	3	_rival
rivet	8	56	3636	3	_rivet
savant	9	4	1604	3	_savant
savate	9	3	1378	3	_savate
tract	7	56	3571	3	tra_ct
trait	5	69	4084	3	tra_it
trapan	8	24	1297	3	trapan
trapt	7	64	3339	3	tra_pt
travail	10	3	655	3	travail
trave	8	52	2303	3	trav_e
travel	9	41	1298	3	travel
traves	9	42	2274	3	traves
treat	5	62	4035	3	tr_eat
trevet	9	48	1891	3	trevet
trivet	9	37	2188	3	trivet
vat	6	78	6345	3	___vat
wrapt	10	51	2318	3	wra_pt

Search took 6 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.376	475242.0
2	DLD Change Limit	112716	331	4.860	23192.6
3	Display Results	331	331	0.093	3559.1
	(SQL Overall)	178691	331	5.329	33531.8