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

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

358 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
fated	9	56	3213	(None)
bated	8	59	3553	1	bated
dated	7	55	3099	1	dated
faced	11	77	2765	1	faced
faded	10	50	2524	1	faded
faked	13	52	2548	1	faked
famed	11	59	2834	1	famed
fared	9	58	4234	1	fared
farted	10	51	2178	1	farted
fasted	10	53	2095	1	fasted
fate	7	54	4428	1	fate_
fates	8	51	3923	1	fates
fatted	10	54	1984	1	fatted
faxed	16	62	2053	1	faxed
fayed	12	64	2215	1	fayed
fazed	18	62	2296	1	fazed
feted	9	44	2093	1	feted
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
after	8	57	1979	2	after
aged	6	73	3425	2	_aged
ahed	8	95	3625	2	_ahed
alated	7	56	2514	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	5459	2	cate_
cater	7	48	4070	2	cater
cates	7	59	5187	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	2703	2	coated
coted	8	50	3385	2	coted
crated	9	48	2777	2	crated
dared	7	59	3501	2	dared
darted	8	46	2092	2	darted
date	5	64	4332	2	date_
dater	6	53	3231	2	dater
dates	6	56	3915	2	dates
dauted	8	41	1493	2	dauted
dawed	10	62	2281	2	dawed
dawted	11	48	968	2	dawted
dazed	16	59	1936	2	dazed
doated	8	41	1818	2	doated
doted	7	52	2707	2	doted
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
elated	7	47	2582	2	elated
fabled	12	42	1638	2	fabled
face	9	61	4012	2	face_
facer	10	55	2505	2	facer
faces	10	64	3943	2	faces
facet	10	60	3852	2	facet
faceted	13	50	956	2	faceted
fad	7	74	5241	2	fa__d
fade	8	57	3634	2	fade_
fader	9	44	2151	2	fader
fades	9	49	3286	2	fades
fadged	12	47	1235	2	fadged
fagged	12	47	1770	2	fagged
fagoted	12	3	607	2	fagoted
failed	10	54	2160	2	failed
fainted	11	42	1172	2	fainted
faired	10	59	1577	2	faired
faithed	14	3	716	2	faithed
fake	11	55	3494	2	fake_
faker	12	48	2459	2	faker
fakes	12	60	3248	2	fakes
fakey	15	55	1542	2	fakey
falter	9	45	1905	2	falter
fame	9	56	3939	2	fame_
fames	10	57	3592	2	fames
fane	7	53	4356	2	fane_
fanes	8	46	3989	2	fanes
fanged	11	43	1822	2	fanged
fanned	10	41	1747	2	fanned
fantod	10	20	1003	2	fantod
farad	9	57	2067	2	farad
farced	12	52	1653	2	farced
fard	8	56	3906	2	fa_rd
farded	11	45	1895	2	farded
fare	7	63	5446	2	fare_
farer	8	67	3314	2	farer
fares	8	58	5287	2	fares
farmed	12	51	1765	2	farmed
fashed	13	67	2025	2	fashed
fasten	9	51	1489	2	fasten
faster	9	46	2577	2	faster
fat	6	81	7808	2	fat__
fatal	8	48	1937	2	fatal
fathead	14	3	786	2	fathead
father	12	51	1671	2	father
fatly	11	57	1680	2	fatly
fats	7	62	5250	2	fat_s
fatso	8	51	1349	2	fatso
fatten	9	43	1490	2	fatten
fatter	9	45	2321	2	fatter
fatty	11	51	1741	2	fatty
fatwa	11	6	806	2	fatwa
fauld	9	52	1449	2	fauld
faulted	11	22	772	2	faulted
fave	10	55	3296	2	fave_
faves	11	53	3142	2	faves
fawned	13	49	1042	2	fawned
faxes	15	57	2665	2	faxes
faze	16	56	3004	2	faze_
fazes	17	55	2721	2	fazes
feared	10	63	2043	2	feared
feased	10	57	1871	2	feased
feasted	11	3	1084	2	feasted
feater	9	52	2405	2	feater
feazed	19	51	1263	2	feazed
fed	7	65	4835	2	f__ed
feed	8	45	3890	2	f_eed
felted	10	37	1465	2	felted
fete	7	57	3492	2	fete_
fetes	8	56	3014	2	fetes
fetid	9	37	1598	2	fetid
fetted	10	48	1789	2	fetted
feued	9	47	1566	2	feued
fifed	12	51	1597	2	fifed
filed	9	53	3190	2	filed
fined	9	49	3050	2	fined
fired	9	48	2974	2	fired
fisted	10	42	1870	2	fisted
fitted	10	47	1666	2	fitted
fixated	18	3	553	2	fixated
fixed	16	54	1695	2	fixed
flaked	14	47	1565	2	flaked
flamed	12	46	1897	2	flamed
flared	10	53	1760	2	flared
flatbed	13	39	798	2	flatbed
flatted	11	40	1294	2	flatted
flawed	13	47	1272	2	flawed
flayed	13	44	1405	2	flayed
fled	8	54	2977	2	f_led
flied	9	65	1943	2	flied
flited	10	46	1658	2	flited
floated	11	33	1270	2	floated
flued	9	50	2125	2	flued
fluted	10	49	1716	2	fluted
flyted	13	37	877	2	flyted
foaled	10	45	1596	2	foaled
foamed	12	60	1440	2	foamed
footed	10	44	1862	2	footed
foxed	16	51	1521	2	foxed
fracted	13	3	937	2	fracted
framed	12	51	1652	2	framed
frater	9	45	2059	2	frater
frayed	13	50	1216	2	frayed
freed	9	52	2354	2	freed
fried	9	53	2291	2	fried
fumed	11	61	1882	2	fumed
fused	9	48	2044	2	fused
futzed	19	41	898	2	futzed
fuzed	18	54	1525	2	fuzed
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	3364	2	gater
gates	6	59	3950	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
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	1845	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	1985	2	malted
maned	8	66	3409	2	maned
marted	9	44	2521	2	marted
masted	9	40	2580	2	masted
mate	6	51	5421	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
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
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	2145	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	3105	2	seated
sited	6	51	3074	2	sited
skated	11	44	1487	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
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 4 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.186	960704.3
2	DLD Change Limit	53800	358	2.843	18923.7
3	Display Results	358	358	0.236	1516.9
	(SQL Overall)	178691	358	3.265	54729.2