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

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

382 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
face	9	61	4012	(None)
ace	5	96	5683	1	_ace
dace	7	69	3492	1	dace
faced	11	77	2765	1	faced
facer	10	55	2505	1	facer
faces	10	64	3943	1	faces
facet	10	60	3852	1	facet
fact	9	71	4254	1	fact
fade	8	57	3635	1	fade
fake	11	55	3494	1	fake
fame	9	56	3939	1	fame
fane	7	53	4357	1	fane
farce	10	49	2532	1	farce
fare	7	63	5446	1	fare
fate	7	54	4428	1	fate
fave	10	55	3296	1	fave
faze	16	56	3004	1	faze
fice	9	57	3712	1	fice
fyce	12	63	1683	1	fyce
lace	6	68	4847	1	lace
mace	8	73	4579	1	mace
pace	8	63	4577	1	pace
race	6	67	4626	1	race
tace	6	53	4251	1	tace
aced	7	95	4088	2	_aced
aces	6	76	4509	2	_aces
ache	9	68	2982	2	_ache
acme	8	69	2432	2	_acme
acne	6	66	2587	2	_acne
acre	6	73	3077	2	_acre
act	5	95	5784	2	_act
ae	2	125	9029	2	_a_e
age	4	71	5433	2	_age
ale	3	65	7234	2	_ale
ane	3	78	6695	2	_ane
apace	9	47	1838	2	apace
ape	5	72	5118	2	_ape
are	3	78	7457	2	_are
ate	3	70	5924	2	_ate
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
bach	11	61	3139	2	bach
back	12	55	3576	2	back
bade	7	51	4089	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
bate	6	65	5242	2	bate
bice	8	62	3557	2	bice
biface	13	5	810	2	biface
brace	9	56	2927	2	brace
caca	8	55	2808	2	caca
cache	12	51	2248	2	cache
cade	7	64	4392	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
case	6	58	4808	2	case
cate	6	62	5460	2	cate
cave	9	59	4126	2	cave
daces	8	50	3068	2	daces
dale	5	56	4398	2	dale
dame	7	71	4031	2	dame
dance	8	52	2313	2	dance
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daze	14	73	2723	2	daze
deface	12	31	1386	2	deface
dice	7	58	4190	2	dice
duce	7	69	3350	2	duce
each	9	55	3058	2	each
ease	4	50	4233	2	ease
eave	7	57	3358	2	eave
efface	14	36	667	2	efface
enface	11	25	1035	2	enface
fa	5	101	4845	2	fa__
fab	8	74	5313	2	fa_b
fable	10	58	2475	2	fable
fabs	9	86	3586	2	fabs
facade	12	3	880	2	facade
facers	11	55	1944	2	facers
facete	11	50	1483	2	facete
facets	11	63	1665	2	facets
faceup	13	3	489	2	faceup
facia	10	32	1846	2	facia
faciae	11	29	1341	2	faciae
facies	11	39	2159	2	facies
facile	11	25	1488	2	facile
facts	10	70	2189	2	facts
fad	7	74	5242	2	fa_d
faded	10	50	2524	2	faded
fader	9	44	2151	2	fader
fades	9	49	3286	2	fades
fadge	10	48	1700	2	fadge
fado	8	72	2647	2	fado
fads	8	69	3988	2	fads
faeces	11	47	1312	2	faeces
fag	7	68	5236	2	fa_g
fags	8	69	3912	2	fags
fail	7	48	4024	2	fail
fain	7	58	4056	2	fain
fair	7	63	3252	2	fair
faked	13	52	2548	2	faked
faker	12	48	2459	2	faker
fakes	12	60	3248	2	fakes
fakey	15	55	1542	2	fakey
falces	11	52	1600	2	falces
fall	7	55	3531	2	fall
false	8	48	1812	2	false
falx	14	71	2078	2	falx
famed	11	59	2834	2	famed
fames	10	57	3592	2	fames
fan	6	71	5886	2	fa_n
fancy	13	46	1548	2	fancy
fanes	8	46	3989	2	fanes
fang	8	54	3256	2	fang
fano	7	58	3169	2	fano
fans	7	62	4737	2	fans
far	6	77	6260	2	fa_r
farced	12	52	1653	2	farced
farcer	11	50	1608	2	farcer
farces	11	52	2332	2	farces
farci	10	59	1931	2	farci
farcie	11	48	1647	2	farcie
farcy	13	52	1709	2	farcy
fard	8	56	3906	2	fard
fared	9	58	4234	2	fared
farer	8	67	3314	2	farer
fares	8	58	5287	2	fares
farl	7	63	3855	2	farl
farle	8	69	2924	2	farle
farm	9	59	3454	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
fas	6	82	6293	2	fa_s
fasces	11	49	1454	2	fasces
fash	10	72	3229	2	fash
fast	7	70	5231	2	fast
fat	6	81	7808	2	fa_t
fated	9	56	3213	2	fated
fates	8	51	3923	2	fates
fats	7	62	5250	2	fats
fauces	11	49	1615	2	fauces
faucet	11	58	1655	2	faucet
faun	7	62	2662	2	faun
fauve	11	47	1207	2	fauve
faux	14	65	1907	2	faux
fava	10	68	2026	2	fava
faves	11	53	3142	2	faves
fawn	10	53	2195	2	fawn
fax	13	81	4331	2	fa_x
faxed	16	62	2053	2	faxed
faxes	15	57	2665	2	faxes
fay	9	74	5486	2	fa_y
fayed	12	64	2215	2	fayed
fays	10	85	3536	2	fays
fazed	18	62	2296	2	fazed
fazes	17	55	2721	2	fazes
fe	5	79	4474	2	f__e
fease	8	48	2487	2	fease
feaze	17	52	1631	2	feaze
feces	10	56	2536	2	feces
feck	13	49	2343	2	feck
fee	6	68	6201	2	f_ee
feme	9	61	3054	2	feme
fence	10	53	1991	2	fence
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
fiacre	11	3	762	2	fiacre
fiance	11	3	1074	2	fiance
fices	10	60	3116	2	fices
fiche	13	46	1674	2	fiche
fico	9	58	2460	2	fico
fie	6	71	5245	2	f_ie
fife	10	60	2771	2	fife
file	7	54	4665	2	file
fine	7	51	4796	2	fine
fire	7	62	4560	2	fire
five	10	76	2975	2	five
flack	14	45	1941	2	flack
flake	12	51	1997	2	flake
flame	10	51	2444	2	flame
flare	8	48	2363	2	flare
flee	7	62	3879	2	flee
floe	7	61	2977	2	floe
flue	7	53	2985	2	flue
foci	9	45	2101	2	foci
foe	6	63	5081	2	f_oe
force	10	53	2427	2	force
fore	7	83	5147	2	fore
frae	7	53	3047	2	frae
frame	10	58	2180	2	frame
free	7	59	4018	2	free
froe	7	53	2999	2	froe
fuci	9	57	2031	2	fuci
fuck	13	49	2463	2	fuck
fume	9	67	2763	2	fume
fuse	7	64	2999	2	fuse
fuze	16	64	2237	2	fuze
fyces	13	98	1364	2	fyces
fyke	14	59	1529	2	fyke
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
gate	5	57	4657	2	gate
gave	8	46	3405	2	gave
gaze	14	50	3241	2	gaze
glace	8	74	2016	2	glace
grace	8	51	2454	2	grace
hacek	14	54	1184	2	hacek
hack	13	51	3454	2	hack
hade	8	54	4020	2	hade
hae	6	73	6400	2	ha_e
hake	11	56	3784	2	hake
hale	7	60	5283	2	hale
hame	9	70	4313	2	hame
hance	10	54	2415	2	hance
hare	7	62	5573	2	hare
hate	7	84	5017	2	hate
have	10	61	3707	2	have
haze	16	48	3339	2	haze
ice	5	67	3725	2	_ice
jack	17	52	2486	2	jack
jade	12	53	2545	2	jade
jake	15	59	2577	2	jake
jane	11	50	3148	2	jane
jape	13	49	2342	2	jape
kae	7	67	4455	2	ka_e
kale	8	65	3376	2	kale
kame	10	57	2825	2	kame
kane	8	51	3398	2	kane
lac	5	101	5582	2	lac_
laced	8	71	3264	2	laced
lacer	7	58	3375	2	lacer
laces	7	61	4176	2	laces
lacey	10	58	2091	2	lacey
lack	10	58	3768	2	lack
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
lade	5	63	4599	2	lade
lake	8	57	4160	2	lake
lame	6	68	4929	2	lame
lance	7	51	2672	2	lance
lane	4	51	5333	2	lane
lase	4	61	4851	2	lase
late	4	75	6048	2	late
lave	7	56	4214	2	lave
laze	13	62	3505	2	laze
lice	6	60	4507	2	lice
luce	6	51	3257	2	luce
mabe	8	57	3336	2	mabe
mac	7	80	5393	2	mac_
maced	10	85	2869	2	maced
macer	9	121	2694	2	macer
maces	9	71	3996	2	maces
mach	11	61	3448	2	mach
mache	12	59	2530	2	mache
mack	12	57	3365	2	mack
macle	9	61	2700	2	macle
macs	8	67	4251	2	macs
made	7	54	4025	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
mate	6	51	5422	2	mate
maze	15	54	3498	2	maze
mice	8	74	4224	2	mice
nabe	6	60	2949	2	nabe
nacre	7	57	1536	2	nacre
nae	3	59	5274	2	na_e
name	6	56	3741	2	name
nance	7	47	2184	2	nance
nape	6	52	3080	2	nape
nave	7	57	3231	2	nave
nice	6	55	3472	2	nice
once	6	54	2308	2	once
pac	7	90	5408	2	pac_
paca	8	51	3224	2	paca
paced	10	69	3168	2	paced
pacer	9	61	3161	2	pacer
paces	9	67	4111	2	paces
pacey	12	67	2028	2	pacey
pack	12	55	3544	2	pack
pacs	8	58	4218	2	pacs
pact	8	66	4872	2	pact
pacy	11	53	2868	2	pacy
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
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
peace	9	50	2608	2	peace
pice	8	46	4110	2	pice
place	9	48	2461	2	place
puce	8	51	2788	2	puce
raced	8	76	3531	2	raced
racer	7	52	3302	2	racer
races	7	49	4324	2	races
rack	10	62	3488	2	rack
racy	9	58	2568	2	racy
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rance	7	50	2851	2	rance
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
reface	11	36	1635	2	reface
rice	6	49	4292	2	rice
sabe	6	61	4057	2	sabe
sac	5	74	5286	2	sac_
sack	10	53	3731	2	sack
sacs	6	57	3907	2	sacs
sade	5	55	4448	2	sade
sae	3	83	6518	2	sa_e
safe	7	59	3095	2	safe
sage	5	50	4459	2	sage
saice	7	54	2405	2	saice
sake	8	52	4496	2	sake
sale	4	49	5970	2	sale
same	6	52	4564	2	same
sane	4	59	5434	2	sane
sate	4	55	5610	2	sate
sauce	7	51	2165	2	sauce
save	7	57	4136	2	save
sice	6	55	4560	2	sice
space	9	53	2567	2	space
syce	9	58	2028	2	syce
taces	7	62	3780	2	taces
tacet	7	58	4002	2	tacet
tach	9	61	3275	2	tach
tache	10	62	2237	2	tache
tack	10	65	3629	2	tack
taco	6	70	3135	2	taco
tact	6	73	4903	2	tact
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	3815	2	tape
tare	4	59	5762	2	tare
tate	4	47	4860	2	tate
trace	7	58	2961	2	trace
vac	8	65	3714	2	vac_
vacs	9	62	2620	2	vacs
vale	7	49	3734	2	vale
vane	7	55	3469	2	vane
vase	7	56	2965	2	vase
vice	9	57	3286	2	vice
wack	13	53	3091	2	wack
wacke	14	59	1862	2	wacke
wade	8	52	3707	2	wade
wae	6	75	5695	2	wa_e
wage	8	48	3408	2	wage
wake	11	49	3570	2	wake
wale	7	45	4644	2	wale
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
wave	10	52	3473	2	wave
yack	13	54	2597	2	yack
yare	7	56	3694	2	yare

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	29872	0.563	317390.8
2	DLD Change Limit	29872	382	1.810	16503.9
3	Display Results	382	382	0.190	2010.5
	(SQL Overall)	178691	382	2.563	69719.5