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

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

351 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
dated	7	55	3099	(None)
bated	8	59	3553	1	bated
dared	7	59	3501	1	dared
darted	8	46	2092	1	darted
date	5	64	4332	1	date_
dater	6	53	3231	1	dater
dates	6	56	3915	1	dates
dauted	8	41	1493	1	dauted
dawed	10	62	2281	1	dawed
dawted	11	48	968	1	dawted
dazed	16	59	1936	1	dazed
doated	8	41	1818	1	doated
doted	7	52	2707	1	doted
fated	9	56	3213	1	fated
gated	7	53	2977	1	gated
hated	9	57	3402	1	hated
lated	6	52	4067	1	lated
mated	8	55	3778	1	mated
pated	8	52	3784	1	pated
rated	6	54	4138	1	rated
sated	6	62	3853	1	sated
aahed	9	178	1644	2	aahed
abated	9	59	1845	2	abated
abed	7	97	3413	2	_abed
aced	7	95	4088	2	_aced
acted	8	85	2173	2	acted
adapted	11	3	584	2	adapted
added	8	49	1843	2	added
adzed	16	60	1254	2	adzed
aged	6	73	3425	2	_aged
ahed	8	95	3625	2	_ahed
alated	7	56	2515	2	alated
anted	6	63	2824	2	anted
aped	7	85	3815	2	_aped
ate	3	70	5924	2	_ate_
ates	4	50	4792	2	_ates
awed	8	84	3603	2	_awed
axed	12	88	2961	2	_axed
baaed	8	52	1816	2	baaed
baited	9	53	1924	2	baited
baked	12	61	3077	2	baked
baled	8	54	3644	2	baled
baned	8	54	3635	2	baned
bared	8	51	4448	2	bared
based	8	53	3158	2	based
basted	9	52	2723	2	basted
bate	6	65	5242	2	bate_
bates	7	58	4634	2	bates
bathed	12	55	1874	2	bathed
batted	9	56	2365	2	batted
bayed	11	54	2302	2	bayed
boated	9	42	2197	2	boated
caged	9	54	2636	2	caged
caked	12	61	2862	2	caked
caned	8	58	3809	2	caned
canted	9	48	2578	2	canted
caped	10	49	3180	2	caped
cared	8	60	5009	2	cared
carted	9	86	3144	2	carted
cased	8	60	3241	2	cased
cate	6	62	5460	2	cate_
cater	7	48	4072	2	cater
cates	7	59	5189	2	cates
catted	9	54	2247	2	catted
caved	11	62	2756	2	caved
cawed	11	66	2706	2	cawed
cited	8	44	2195	2	cited
coated	9	49	2704	2	coated
coted	8	50	3385	2	coted
crated	9	48	2777	2	crated
dabbed	12	44	1614	2	dabbed
dace	7	69	3492	2	dace_
daces	8	50	3068	2	daces
dad	5	84	5616	2	da__d
dadoed	9	44	990	2	dadoed
daffed	14	42	949	2	daffed
dafter	10	48	1334	2	dafter
dale	5	56	4398	2	dale_
daledh	11	3	374	2	daledh
dales	6	64	3974	2	dales
dame	7	71	4031	2	dame_
dames	8	54	3585	2	dames
dammed	12	42	1479	2	dammed
damned	10	42	1291	2	damned
damped	12	43	1558	2	damped
danced	10	53	1525	2	danced
danged	9	48	1948	2	danged
dapped	12	45	1676	2	dapped
dare	5	58	4886	2	dare_
darer	6	52	3079	2	darer
dares	6	61	4670	2	dares
darked	12	39	1963	2	darked
darned	8	50	1848	2	darned
darter	7	53	2036	2	darter
dartled	9	40	985	2	dartled
dashed	11	59	2056	2	dashed
data	5	60	2665	2	dat_a
datedly	12	3	602	2	datedly
daters	7	48	2737	2	daters
dato	5	61	2994	2	dat_o
datos	6	52	2278	2	datos
datto	6	54	1642	2	datto
datum	8	3	1063	2	datum
daubed	10	46	1178	2	daubed
daunted	9	38	1019	2	daunted
daven	9	49	1647	2	daven
dawen	9	54	1372	2	dawen
dawned	11	39	1209	2	dawned
daybed	13	43	867	2	daybed
daze	14	73	2723	2	daze_
dazes	15	50	2414	2	dazes
deaned	8	46	2045	2	deaned
deaved	11	49	1655	2	deaved
debated	11	39	1608	2	debated
deed	6	53	4090	2	d_eed
deked	11	57	1853	2	deked
delated	9	37	2287	2	delated
deled	7	53	2654	2	deled
dented	8	41	2051	2	dented
derated	9	36	2350	2	derated
deter	6	50	2804	2	deter
dewed	10	50	2030	2	dewed
dialed	8	47	1645	2	dialed
diced	9	58	2468	2	diced
died	6	61	3785	2	d_ied
dieted	8	31	1549	2	dieted
diked	11	50	2468	2	diked
dilated	9	31	1582	2	dilated
dined	7	64	3199	2	dined
dinted	8	44	1984	2	dinted
dite	5	55	4755	2	dite_
dites	6	63	3915	2	dites
dived	10	63	2137	2	dived
doited	8	50	1663	2	doited
doled	7	54	3091	2	doled
domed	9	54	2326	2	domed
donated	9	35	1386	2	donated
doped	9	53	2671	2	doped
dosed	7	66	2691	2	dosed
dote	5	54	4288	2	dote_
doter	6	54	2862	2	doter
dotes	6	58	3669	2	dotes
dotted	8	47	1752	2	dotted
dowed	10	46	3261	2	dowed
dozed	16	56	1935	2	dozed
drafted	12	43	903	2	drafted
draped	10	53	1436	2	draped
dratted	9	35	859	2	dratted
drayed	11	59	1139	2	drayed
dreed	7	52	2284	2	dreed
dried	7	53	2138	2	dried
ducted	10	40	1212	2	ducted
duded	8	44	1713	2	duded
dueted	8	41	1359	2	dueted
duked	11	52	1846	2	duked
dunted	8	47	1850	2	dunted
duped	9	51	1832	2	duped
dured	7	50	2540	2	dured
dusted	8	39	1837	2	dusted
dyed	9	67	2076	2	d_yed
dyked	14	53	1095	2	dyked
eared	6	51	3950	2	eared
eased	6	54	3040	2	eased
eaten	5	53	2305	2	eaten
eater	5	46	3984	2	eater
eaved	9	59	2450	2	eaved
edited	8	39	1367	2	edited
elated	7	47	2582	2	elated
faced	11	77	2765	2	faced
faded	10	50	2524	2	faded
faked	13	52	2548	2	faked
famed	11	59	2834	2	famed
fared	9	58	4234	2	fared
farted	10	51	2178	2	farted
fasted	10	53	2095	2	fasted
fate	7	54	4428	2	fate_
fates	8	51	3923	2	fates
fatted	10	54	1984	2	fatted
faxed	16	62	2053	2	faxed
fayed	12	64	2215	2	fayed
fazed	18	62	2296	2	fazed
feted	9	44	2093	2	feted
gaed	6	60	3151	2	ga_ed
gaged	8	55	2231	2	gaged
gaited	8	44	1692	2	gaited
gamed	9	51	2639	2	gamed
gaped	9	61	2353	2	gaped
gasted	8	48	2158	2	gasted
gate	5	57	4657	2	gate_
gater	6	45	3365	2	gater
gates	6	59	3951	2	gates
gazed	16	55	2033	2	gazed
grated	8	45	2392	2	grated
haded	10	52	2762	2	haded
haed	8	63	3858	2	ha_ed
hafted	13	47	1383	2	hafted
haled	9	53	3582	2	haled
halted	10	50	1960	2	halted
hanted	10	41	2431	2	hanted
hared	9	57	4218	2	hared
hasted	10	51	2528	2	hasted
hate	7	84	5017	2	hate_
hater	8	50	3475	2	hater
hates	8	67	4257	2	hates
hatred	10	48	1433	2	hatred
hatted	10	49	2151	2	hatted
hawed	12	60	2542	2	hawed
hayed	12	58	2201	2	hayed
hazed	18	52	2220	2	hazed
heated	10	45	2559	2	heated
ideated	9	3	1097	2	ideated
iodated	9	3	1002	2	iodated
jaded	14	44	1703	2	jaded
japed	15	62	1763	2	japed
jawed	16	55	1737	2	jawed
kited	10	51	2009	2	kited
laced	8	71	3264	2	laced
laded	7	42	3261	2	laded
laked	10	57	3112	2	laked
lamed	8	52	3529	2	lamed
lased	6	51	3234	2	lased
lasted	7	43	2360	2	lasted
late	4	75	6048	2	late_
laten	5	43	2834	2	laten
later	5	48	4392	2	later
latex	12	47	1711	2	latex
lathed	10	47	1846	2	lathed
laved	9	50	2859	2	laved
lawed	9	60	2832	2	lawed
layed	9	51	2738	2	layed
lazed	15	49	2584	2	lazed
luted	6	48	2614	2	luted
maced	10	85	2869	2	maced
malted	9	48	1986	2	malted
maned	8	66	3410	2	maned
marted	9	44	2521	2	marted
masted	9	40	2580	2	masted
mate	6	51	5422	2	mate_
mater	7	44	3886	2	mater
mates	7	52	5136	2	mates
matey	10	70	2266	2	matey
matted	9	45	2141	2	matted
mawed	11	58	2474	2	mawed
maxed	15	58	2119	2	maxed
mayed	11	55	2240	2	mayed
mazed	17	55	2387	2	mazed
meated	9	42	2240	2	meated
meted	8	54	2443	2	meted
moated	9	48	1900	2	moated
muted	8	50	2338	2	muted
naked	10	53	2085	2	naked
naled	6	55	2505	2	naled
named	8	52	2306	2	named
nates	5	52	3833	2	nates
nidated	9	3	986	2	nidated
noted	6	51	2384	2	noted
oared	6	50	3065	2	oared
oaten	5	52	2240	2	oaten
oater	5	54	3373	2	oater
opted	8	49	1427	2	opted
orated	7	42	2150	2	orated
outed	6	54	2906	2	outed
paced	10	69	3168	2	paced
paged	9	59	2678	2	paged
paled	8	55	3872	2	paled
paned	8	54	3718	2	paned
panted	9	50	2482	2	panted
pared	8	69	4676	2	pared
parted	9	42	2868	2	parted
pasted	9	44	2690	2	pasted
pate	6	53	5046	2	pate_
paten	7	48	2734	2	paten
pater	7	47	4072	2	pater
pates	7	60	4789	2	pates
patted	9	47	2468	2	patted
paved	11	55	2526	2	paved
pawed	11	57	2561	2	pawed
payed	11	59	2593	2	payed
plated	9	52	2577	2	plated
prated	9	49	2492	2	prated
raced	8	76	3531	2	raced
rafted	10	47	1470	2	rafted
raged	7	48	2945	2	raged
raked	10	58	3142	2	raked
ranted	7	43	2470	2	ranted
raped	8	53	3462	2	raped
rared	6	57	3832	2	rared
rased	6	50	3393	2	rased
rate	4	54	5876	2	rate_
ratel	5	42	2488	2	ratel
rater	5	49	4328	2	rater
rates	5	53	5201	2	rates
ratted	7	49	2334	2	ratted
raved	9	49	3143	2	raved
raxed	13	56	2266	2	raxed
rayed	9	51	2750	2	rayed
razed	15	50	2798	2	razed
redated	9	31	2092	2	redated
sabed	8	65	2681	2	sabed
salted	7	41	2120	2	salted
saned	6	56	3627	2	saned
sate	4	55	5610	2	sate_
satem	7	60	2146	2	satem
sates	5	49	4932	2	sates
sauted	7	41	1960	2	sauted
saved	9	51	2711	2	saved
sawed	9	56	2840	2	sawed
sayed	9	61	2714	2	sayed
seated	7	51	3106	2	seated
sedated	9	37	1435	2	sedated
sited	6	51	3074	2	sited
skated	11	44	1488	2	skated
slated	7	50	2831	2	slated
stated	7	54	2783	2	stated
tamed	8	55	2851	2	tamed
taped	8	53	2742	2	taped
tared	6	93	4005	2	tared
tarted	7	49	2337	2	tarted
tasted	7	41	2397	2	tasted
tate	4	47	4860	2	tate_
tater	5	41	3861	2	tater
tates	5	54	4498	2	tates
tatted	7	49	2053	2	tatted
tauted	7	53	1711	2	tauted
tawed	9	59	2619	2	tawed
taxed	13	56	2029	2	taxed
teated	7	49	2402	2	teated
ted	4	64	4656	2	__ted
toted	6	49	2948	2	toted
undated	9	31	1846	2	undated
updated	11	36	942	2	updated
vaned	9	46	2242	2	vaned
vatted	10	42	1473	2	vatted
voted	9	39	1914	2	voted
waded	10	60	2475	2	waded
wafted	13	40	1214	2	wafted
waged	10	48	2278	2	waged
waited	10	38	1977	2	waited
waked	13	56	2675	2	waked
waled	9	43	3099	2	waled
waned	9	58	3178	2	waned
wanted	10	43	1972	2	wanted
wared	9	63	3987	2	wared
warted	10	42	2323	2	warted
wasted	10	44	2302	2	wasted
water	8	47	3331	2	water
waved	12	52	2358	2	waved
waxed	16	60	1848	2	waxed
wited	9	47	2714	2	wited
wyted	12	52	947	2	wyted
yawed	12	60	2245	2	yawed

Search took 3 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	53800	0.296	603685.8
2	DLD Change Limit	53800	351	1.640	32804.9
3	Display Results	351	351	0.110	3190.9
	(SQL Overall)	178691	351	2.046	87336.8