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

Here are the results of your fuzzy-string dictionary search for “date” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

468 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
date	5	64	4332	(None)
ate	3	70	5924	1	_ate
bate	6	65	5242	1	bate
cate	6	62	5460	1	cate
dace	7	69	3492	1	dace
dale	5	56	4398	1	dale
dame	7	71	4031	1	dame
dare	5	58	4886	1	dare
data	5	60	2665	1	data
dated	7	55	3099	1	dated
dater	6	53	3231	1	dater
dates	6	56	3915	1	dates
dato	5	61	2994	1	dato
daze	14	73	2723	1	daze
dite	5	55	4755	1	dite
dote	5	54	4288	1	dote
fate	7	54	4428	1	fate
gate	5	57	4657	1	gate
hate	7	84	5017	1	hate
late	4	75	6048	1	late
mate	6	51	5422	1	mate
pate	6	53	5046	1	pate
rate	4	54	5876	1	rate
sate	4	55	5610	1	sate
tate	4	47	4860	1	tate
abate	7	66	2784	2	abate
ace	5	96	5683	2	_ace
adage	7	4	1405	2	adage
adnate	7	29	1348	2	adnate
adze	14	128	2057	2	adze
ae	2	125	9029	2	_a_e
agate	6	65	2515	2	agate
age	4	71	5433	2	_age
alate	5	53	4032	2	alate
ale	3	65	7234	2	_ale
ane	3	78	6695	2	_ane
ante	4	65	3890	2	ante
ape	5	72	5118	2	_ape
are	3	78	7457	2	_are
at	2	123	9340	2	_at_
ates	4	50	4792	2	_ates
att	3	54	5465	2	_att
ave	6	77	4870	2	_ave
awe	6	77	4662	2	_awe
axe	10	82	3949	2	_axe
aye	6	71	5176	2	_aye
babe	8	68	3582	2	babe
bade	7	51	4088	2	bade
bake	10	56	3751	2	bake
bale	6	63	5384	2	bale
bane	6	52	5043	2	bane
bare	6	54	6052	2	bare
base	6	48	4702	2	base
baste	7	48	2998	2	baste
bat	5	109	8895	2	bat_
bated	8	59	3553	2	bated
bates	7	58	4634	2	bates
bath	9	59	4008	2	bath
bathe	10	58	2288	2	bathe
bats	6	69	6233	2	bats
batt	6	50	5387	2	batt
bite	6	65	4700	2	bite
blate	7	59	3378	2	blate
bute	6	67	3967	2	bute
byte	9	65	2181	2	byte
cade	7	64	4391	2	cade
cafe	9	52	3032	2	cafe
cage	7	53	3906	2	cage
cake	10	54	3996	2	cake
came	8	76	4875	2	came
cane	6	66	5312	2	cane
cape	8	72	4278	2	cape
care	6	69	6837	2	care
carte	7	59	4042	2	carte
case	6	58	4808	2	case
caste	7	59	3236	2	caste
cat	5	82	8234	2	cat_
cater	7	48	4072	2	cater
cates	7	59	5189	2	cates
cats	6	63	5634	2	cats
cave	9	59	4126	2	cave
cete	6	49	3478	2	cete
cite	6	56	4034	2	cite
cote	6	66	4873	2	cote
crate	7	65	3740	2	crate
cute	6	64	4045	2	cute
dab	6	74	5556	2	da_b
dabs	7	71	3940	2	dabs
daces	8	50	3068	2	daces
dacite	9	11	1588	2	dacite
dad	5	84	5616	2	da_d
dada	6	64	2244	2	dada
dado	6	71	2633	2	dado
dads	6	74	4277	2	dads
daff	11	52	2968	2	daff
daft	8	55	3725	2	daft
dafter	10	48	1334	2	dafter
dag	5	77	5301	2	da_g
dago	6	57	2509	2	dago
dags	6	66	4260	2	dags
dah	7	81	4898	2	da_h
dahl	8	70	1922	2	dahl
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
dak	8	63	4069	2	da_k
daks	9	71	3060	2	daks
dal	4	75	5495	2	da_l
dales	6	64	3974	2	dales
dals	5	71	4512	2	dals
dam	6	74	5704	2	da_m
dames	8	54	3585	2	dames
damn	7	57	2432	2	damn
damp	9	62	2884	2	damp
dams	7	74	4437	2	dams
dan	4	68	5967	2	da_n
dance	8	52	2313	2	dance
dang	6	51	3154	2	dang
dank	9	58	2824	2	dank
dans	5	67	4815	2	dans
dap	6	66	5245	2	da_p
daps	7	72	3916	2	daps
darb	7	60	3353	2	darb
dared	7	59	3501	2	dared
darer	6	52	3079	2	darer
dares	6	61	4670	2	dares
dark	9	51	3321	2	dark
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
darted	8	46	2092	2	darted
darter	7	53	2036	2	darter
dartle	7	37	1483	2	dartle
darts	6	76	3573	2	darts
dash	8	70	3163	2	dash
daters	7	48	2737	2	daters
dative	10	3	1181	2	dative
datos	6	52	2278	2	datos
datto	6	54	1642	2	datto
datum	8	3	1063	2	datum
daub	7	74	2344	2	daub
daube	8	50	1530	2	daube
daut	5	64	4356	2	daut
dauted	8	41	1493	2	dauted
dautie	7	29	1470	2	dautie
dauts	6	78	2224	2	dauts
daven	9	49	1647	2	daven
davy	11	60	1552	2	davy
daw	7	71	4836	2	da_w
dawed	10	62	2281	2	dawed
dawen	9	54	1372	2	dawen
dawk	12	61	1728	2	dawk
dawn	8	56	2420	2	dawn
daws	8	66	3824	2	daws
dawt	8	54	3594	2	dawt
dawted	11	48	968	2	dawted
dawtie	10	30	1109	2	dawtie
dawts	9	72	1612	2	dawts
day	7	62	5411	2	da_y
days	8	76	3713	2	days
dazed	16	59	1936	2	dazed
dazes	15	50	2414	2	dazes
de	3	70	4954	2	d__e
death	9	48	2252	2	death
deave	9	50	2233	2	deave
debate	9	44	1919	2	debate
dee	4	76	6582	2	d_ee
deet	5	73	5658	2	deet
deke	9	52	2876	2	deke
delate	7	38	2775	2	delate
dele	5	68	4308	2	dele
deme	7	65	3628	2	deme
dene	5	66	4341	2	dene
derate	7	45	3123	2	derate
dere	5	68	4590	2	dere
deter	6	50	2804	2	deter
dice	7	58	4189	2	dice
die	4	67	5965	2	d_ie
diet	5	73	5753	2	diet
dike	9	59	3576	2	dike
dilate	7	32	2069	2	dilate
dime	7	62	3764	2	dime
dine	5	55	5533	2	dine
dire	5	66	4414	2	dire
dit	4	70	7133	2	dit_
dita	5	60	3252	2	dita
dites	6	63	3915	2	dites
dits	5	64	5052	2	dits
ditz	14	69	2951	2	ditz
dive	8	56	3477	2	dive
doat	5	69	4767	2	doat_
doated	8	41	1818	2	doated
doats	6	52	2488	2	doats
doe	4	73	6195	2	d_oe
doge	6	62	3380	2	doge
dole	5	65	5000	2	dole
dome	7	72	4073	2	dome
donate	7	36	1950	2	donate
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dore	5	63	5330	2	dore
dose	5	64	4243	2	dose
dot	4	75	7318	2	dot_
doted	7	52	2707	2	doted
doter	6	54	2862	2	doter
dotes	6	58	3669	2	dotes
doth	8	62	2571	2	doth
dots	5	56	4766	2	dots
doty	8	61	2822	2	doty
dove	8	51	3156	2	dove
doze	14	58	2908	2	doze
drake	10	49	1830	2	drake
drape	8	53	1963	2	drape
drat	5	62	4783	2	drat_
drats	6	66	2837	2	drats
drave	9	52	1927	2	drave
dree	5	66	3832	2	dree
duce	7	69	3350	2	duce
dude	6	56	2966	2	dude
due	4	52	4986	2	d_ue
duet	5	64	4626	2	duet
duke	9	56	2810	2	duke
dune	5	61	3758	2	dune
dupe	7	66	3060	2	dupe
dure	5	63	4181	2	dure
duty	8	53	2145	2	duty
dye	7	53	3484	2	d_ye
dyke	12	64	1818	2	dyke
dyne	8	53	2093	2	dyne
ease	4	50	4233	2	ease
eat	3	69	8905	2	eat_
eaten	5	53	2305	2	eaten
eater	5	46	3984	2	eater
eath	7	57	3566	2	eath
eats	4	70	5487	2	eats
eave	7	57	3358	2	eave
elate	5	53	3588	2	elate
enate	5	44	2815	2	enate
face	9	61	4012	2	face
fade	8	57	3634	2	fade
fake	11	55	3494	2	fake
fame	9	56	3939	2	fame
fane	7	53	4357	2	fane
fare	7	63	5446	2	fare
fat	6	81	7808	2	fat_
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
fats	7	62	5250	2	fats
fave	10	55	3296	2	fave
faze	16	56	3004	2	faze
fete	7	57	3492	2	fete
gae	4	64	5770	2	ga_e
gage	6	59	3610	2	gage
gale	5	63	4732	2	gale
game	7	66	4432	2	game
gane	5	51	4530	2	gane
gape	7	51	3451	2	gape
gat	4	68	8051	2	gat_
gated	7	53	2977	2	gated
gater	6	45	3365	2	gater
gates	6	59	3951	2	gates
gats	5	67	5344	2	gats
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
gite	5	54	3861	2	gite
grate	6	49	3288	2	grate
hade	8	54	4019	2	hade
hae	6	73	6400	2	ha_e
haet	7	56	5950	2	haet
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hare	7	62	5573	2	hare
haste	8	59	2786	2	haste
hat	6	72	8996	2	hat_
hated	9	57	3402	2	hated
hater	8	50	3475	2	hater
hates	8	67	4257	2	hates
hath	10	59	3391	2	hath
hats	7	68	5825	2	hats
haute	8	95	2161	2	haute
have	10	61	3707	2	have
haze	16	48	3339	2	haze
hyte	10	90	1894	2	hyte
ideate	7	3	1368	2	ideate
iodate	7	3	1350	2	iodate
irate	5	56	2798	2	irate
jade	12	53	2544	2	jade
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
jato	11	58	2268	2	jato
jete	11	59	2725	2	jete
jute	11	53	2789	2	jute
kae	7	67	4454	2	ka_e
kale	8	65	3375	2	kale
kame	10	57	2823	2	kame
kane	8	51	3397	2	kane
kat	7	74	6829	2	kat_
kata	8	56	2602	2	kata
kats	8	59	4433	2	kats
kite	8	53	3824	2	kite
kyte	11	70	1776	2	kyte
lace	6	68	4847	2	lace
lade	5	63	4598	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lane	4	51	5333	2	lane
lase	4	61	4851	2	lase
lat	3	75	9340	2	lat_
lated	6	52	4067	2	lated
laten	5	43	2834	2	laten
later	5	48	4392	2	later
latex	12	47	1711	2	latex
lath	7	66	4038	2	lath
lathe	8	56	2671	2	lathe
lati	4	64	3827	2	lati
latke	9	48	1709	2	latke
lats	4	59	6270	2	lats
latte	5	54	2630	2	latte
latu	4	79	3418	2	latu
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
lite	4	70	5454	2	lite
lute	4	63	4101	2	lute
mabe	8	57	3336	2	mabe
mace	8	73	4579	2	mace
made	7	54	4024	2	made
mae	5	76	5911	2	ma_e
mage	7	57	3913	2	mage
make	10	55	3789	2	make
male	6	60	5230	2	male
mane	6	50	5203	2	mane
mare	6	47	5933	2	mare
mat	5	80	8394	2	mat_
mated	8	55	3778	2	mated
mater	7	44	3886	2	mater
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
math	9	54	3745	2	math
mats	6	54	6029	2	mats
matt	6	57	5266	2	matt
matte	7	56	2684	2	matte
maze	15	54	3498	2	maze
mete	6	44	3813	2	mete
mite	6	62	4941	2	mite
mote	6	70	4808	2	mote
mute	6	51	3687	2	mute
nabe	6	60	2949	2	nabe
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nape	6	52	3080	2	nape
nates	5	52	3833	2	nates
nave	7	57	3231	2	nave
nidate	7	3	1378	2	nidate
nite	4	59	4358	2	nite
note	4	62	3996	2	note
oat	3	98	8826	2	oat_
oaten	5	52	2240	2	oaten
oater	5	54	3373	2	oater
oath	7	61	3215	2	oath
oats	4	65	5421	2	oats
orate	5	51	3330	2	orate
ovate	8	42	1439	2	ovate
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pale	6	60	5501	2	pale
pane	6	49	5029	2	pane
pare	6	67	6084	2	pare
pase	6	53	4686	2	pase
paste	7	49	3295	2	paste
pat	5	80	8946	2	pat_
pated	8	52	3784	2	pated
paten	7	48	2734	2	paten
pater	7	47	4072	2	pater
pates	7	60	4789	2	pates
path	9	91	3491	2	path
pats	6	64	6085	2	pats
paty	9	52	3456	2	paty
pave	9	61	3389	2	pave
pedate	9	31	1776	2	pedate
plate	7	46	3511	2	plate
prate	7	51	3598	2	prate
qat	12	52	5333	2	qat_
qats	13	53	3134	2	qats
quate	14	45	2141	2	quate
race	6	67	4626	2	race
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rat	3	78	9274	2	rat_
rated	6	54	4138	2	rated
ratel	5	42	2488	2	ratel
rater	5	49	4328	2	rater
rates	5	53	5201	2	rates
rath	7	60	3766	2	rath
rathe	8	58	2192	2	rathe
rato	4	54	3697	2	rato
rats	4	62	6037	2	rats
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
redate	7	41	2468	2	redate
rete	4	49	4413	2	rete
rite	4	58	4945	2	rite
rote	4	62	4902	2	rote
sabe	6	61	4057	2	sabe
sade	5	55	4447	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sat	3	62	8848	2	sat_
sated	6	62	3853	2	sated
satem	7	60	2146	2	satem
sates	5	49	4932	2	sates
sati	4	55	3933	2	sati
saute	5	50	2808	2	saute
save	7	57	4136	2	save
sedate	7	30	1981	2	sedate
site	4	70	5241	2	site
skate	9	47	2155	2	skate
slate	5	54	3828	2	slate
spate	7	47	3158	2	spate
state	5	62	3733	2	state
tace	6	53	4251	2	tace
tae	3	82	6705	2	ta_e
take	8	47	3926	2	take
tale	4	61	5416	2	tale
tame	6	63	4366	2	tame
tape	6	45	3814	2	tape
tare	4	59	5762	2	tare
taste	5	51	2723	2	taste
tat	3	76	9029	2	tat_
tater	5	41	3861	2	tater
tates	5	54	4498	2	tates
tats	4	68	5813	2	tats
tote	4	66	4367	2	tote
update	9	38	1029	2	update
urate	5	54	3216	2	urate
ute	3	53	3588	2	_ute
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vat	6	78	6345	2	vat_
vats	7	68	4174	2	vats
vatu	7	65	2433	2	vatu
vote	7	47	2862	2	vote
wade	8	52	3706	2	wade
wae	6	75	5695	2	wa_e
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
wale	7	45	4643	2	wale
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
waste	8	61	2505	2	waste
wat	6	73	7892	2	wat_
water	8	47	3331	2	water
wats	7	75	5588	2	wats
watt	7	55	4541	2	watt
wave	10	52	3473	2	wave
wite	7	54	4327	2	wite
wyte	10	60	1864	2	wyte
yare	7	56	3694	2	yare

Search took 2 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	29872	0.296	603685.8
2	DLD Change Limit	29872	468	0.796	37527.6
3	Display Results	468	468	0.110	4254.5
	(SQL Overall)	178691	468	1.202	148661.4