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

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

407 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
facade	12	3	880	(None)
facades	13	3	903	1	facades
alcade	9	11	1151	2	alcade
arcade	9	10	1364	2	arcade
cade	7	64	4391	2	__cade
cascade	12	11	860	2	cascade
decade	10	42	1616	2	decade
face	9	61	4012	2	fac__e
faced	11	77	2765	2	faced_
facete	11	50	1483	2	facete
faciae	11	29	1341	2	faciae
facile	11	25	1488	2	facile
fade	8	57	3634	2	f__ade
falcate	12	3	1161	2	falcate
farad	9	57	2067	2	farad_
farads	10	47	1327	2	farads
parade	9	47	2064	2	parade
saccade	12	10	703	2	saccade
vacate	11	3	1455	2	vacate
abase	7	60	2348	3	_abase
abate	7	66	2784	3	_abate
abide	8	62	2371	3	_abide
abode	8	55	1881	3	_abode
abrade	9	3	1305	3	abrade
academe	12	4	470	3	_academe
academy	15	4	309	3	_academy
acari	7	50	2028	3	_acari
accede	11	3	829	3	accede
ace	5	96	5683	3	_ac__e
aced	7	95	4088	3	_aced_
ache	9	68	2982	3	_ac_he
ached	11	92	2783	3	_ached
acid	7	75	3339	3	_acid_
acids	8	71	2100	3	_acids
acidy	11	72	1489	3	_acidy
ackee	11	58	2536	3	_ackee
acme	8	69	2432	3	_ac_me
acne	6	66	2587	3	_ac_ne
acned	8	75	2066	3	_acned
acnode	9	3	819	3	_acnode
acre	6	73	3077	3	_ac_re
acred	8	71	2635	3	_acred
acted	8	85	2173	3	_acted
acuate	8	3	1563	3	_acuate
acute	7	47	2036	3	_acute
adage	7	4	1405	3	_adage
aflame	11	3	872	3	aflame
agape	8	56	1484	3	_agape
agate	6	65	2514	3	_agate
agave	9	53	1403	3	_agave
agaze	15	61	1366	3	_agaze
aide	5	60	4499	3	_a_ide
alae	4	56	4375	3	_ala_e
alane	5	61	3561	3	_alane
alate	5	53	4032	3	_alate
alcades	10	10	1147	3	alcades
alcaide	10	8	845	3	alcaide
alcalde	10	10	495	3	alcalde
alcayde	13	10	372	3	alcayde
amaze	16	60	1660	3	_amaze
amide	8	61	2848	3	_amide
anadem	9	3	918	3	_anadem
anode	6	50	2103	3	_anode
apace	9	47	1838	3	_apace
aquacade	20	4	334	3	aquacade
arame	7	50	2662	3	_arame
arcaded	11	7	897	3	arcaded
arcades	10	11	1319	3	arcades
arcane	8	12	1674	3	arcane
aside	6	51	2208	3	_aside
aubade	9	3	922	3	aubade
awake	12	50	1478	3	_awake
aware	8	64	2002	3	_aware
azide	15	56	1716	3	_azide
baaed	8	52	1816	3	ba_aed
baccae	12	11	970	3	baccae
baccate	13	10	1126	3	baccate
bached	14	55	1989	3	bached
backed	15	57	2572	3	backed
bade	7	51	4088	3	__bade
ballade	10	40	1256	3	ballade
barde	8	53	3077	3	ba_rde
became	12	32	1316	3	became
blade	8	59	2333	3	_blade
brocade	12	3	853	3	brocade
caca	8	55	2808	3	caca__
cacao	9	54	2000	3	caca_o
cacaos	10	46	1618	3	cacaos
cacas	9	56	2798	3	caca_s
cache	12	51	2248	3	cac_he
cached	14	54	1920	3	cached
cackle	14	34	1692	3	cackle
cad	6	74	5636	3	__cad_
cades	8	54	4073	3	__cades
cadet	8	53	3933	3	__cadet
cadge	9	40	1878	3	__cadge
cadi	7	57	3217	3	__cadi
cadre	8	54	1901	3	__cadre
cads	7	61	4452	3	__cads
cafe	9	52	3032	3	__cafe
cage	7	53	3906	3	__cage
cake	10	54	3996	3	__cake
came	8	76	4875	3	__came
canape	10	9	1351	3	canape
cane	6	66	5311	3	__cane
cape	8	72	4278	3	__cape
carafe	11	54	1616	3	carafe
carate	8	47	3400	3	carate
carcase	11	3	1273	3	carcase
care	6	69	6837	3	__care
cascaded	14	13	570	3	cascaded
cascades	13	12	855	3	cascades
case	6	58	4808	3	__case
cate	6	62	5459	3	__cate
cave	9	59	4126	3	__cave
cede	7	49	2876	3	__cede
chamade	15	13	843	3	chamade
charade	13	12	990	3	charade
cicada	11	3	641	3	cicada
cicadae	12	4	485	3	cicadae
cicale	10	3	1450	3	cicale
clade	8	58	2101	3	_clade
cockade	16	3	813	3	cockade
code	7	73	4773	3	__code
comade	11	44	1532	3	comade
cycad	13	50	727	3	cycad_
cycads	14	47	621	3	cycads
dace	7	69	3492	3	dac__e
dacite	9	11	1588	3	dacite
damage	10	4	1077	3	damage
daycare	13	5	509	3	daycare
decades	11	36	1550	3	decades
decane	9	38	1887	3	decane
decare	9	39	1915	3	decare
decide	10	41	1687	3	decide
decode	10	44	1474	3	decode
encage	9	37	1350	3	encage
encase	8	37	1436	3	encase
encode	9	3	1044	3	encode
escape	10	38	1166	3	escape
evade	9	3	818	3	_evade
excide	16	3	842	3	excide
fable	10	58	2475	3	fa_ble
fabled	12	42	1638	3	fabled
faceable	15	10	849	3	faceable
facer	10	55	2505	3	fac_er
facers	11	55	1944	3	facers
faces	10	64	3943	3	fac_es
facet	10	60	3852	3	fac_et
faceted	13	50	956	3	faceted
facets	11	63	1665	3	facets
faceup	13	3	489	3	faceup
facia	10	32	1846	3	fac_ia
facial	11	36	1563	3	facial
facials	12	33	1074	3	facials
facias	11	34	1580	3	facias
facies	11	39	2159	3	facies
facing	12	53	2157	3	facing
fact	9	71	4254	3	fac__t
factor	11	9	1145	3	factor
facts	10	70	2189	3	fac_ts
facture	12	10	892	3	facture
facula	11	29	1223	3	facula
faculae	12	32	1035	3	faculae
fad	7	74	5241	3	f__ad_
fadable	13	3	1046	3	fadable
faddy	13	55	1162	3	fa_ddy
faded	10	50	2524	3	f__aded
fader	9	44	2151	3	f__ader
fades	9	49	3286	3	f__ades
fadge	10	48	1699	3	fa_dge
fadged	12	47	1235	3	fadged
fado	8	72	2646	3	f__ado
fads	8	69	3987	3	f__ads
faecal	11	35	981	3	faeca_l
faerie	9	35	1468	3	faerie
fagged	12	47	1770	3	fagged
failed	10	54	2160	3	failed
faille	9	34	1474	3	faille
faired	10	59	1577	3	faired
fake	11	55	3494	3	f__ake
faked	13	52	2548	3	faked_
falafel	13	8	390	3	falafel
falcated	14	3	847	3	falcated
false	8	48	1812	3	fa_lse
falsie	9	35	1385	3	falsie
fame	9	56	3939	3	f__ame
famed	11	59	2834	3	famed_
famine	11	43	1819	3	famine
fancied	13	33	1060	3	fancied
fane	7	53	4356	3	f__ane
fanfare	13	3	667	3	fanfare
fanged	11	43	1822	3	fanged
fanned	10	41	1747	3	fanned
faraday	14	4	563	3	faraday
faradic	13	3	769	3	faradic
faradise	12	21	939	3	faradise
faradize	21	23	782	3	faradize
farce	10	49	2532	3	fa_rce
farced	12	52	1653	3	farced_
farcie	11	48	1647	3	farcie
fard	8	56	3906	3	fa_rd_
farded	11	45	1895	3	fa_rded
fardel	10	47	1259	3	fa_rdel
fards	9	66	2984	3	fa_rds
fare	7	63	5446	3	f__are
fared	9	58	4234	3	fared_
farle	8	69	2924	3	fa_rle
farmed	12	51	1765	3	farmed
farside	11	3	860	3	farside
farted	10	51	2178	3	farted
fasciae	12	4	752	3	fasciae
fasciate	13	4	756	3	fasciate
fascine	12	5	1058	3	fascine
fashed	13	67	2025	3	fashed
fasted	10	53	2095	3	fasted
fatal	8	48	1937	3	fata_l
fate	7	54	4428	3	f__ate
fated	9	56	3213	3	fated_
fatted	10	54	1984	3	fatted
faucal	11	33	996	3	fauca_l
faucals	12	32	656	3	faucals
fauld	9	52	1449	3	fauld_
faulds	10	43	896	3	faulds
faunae	9	52	1037	3	faunae
fauve	11	47	1207	3	fa_uve
fava	10	68	2026	3	fava__
favas	11	56	1859	3	fava_s
fave	10	55	3296	3	f__ave
fawned	13	49	1042	3	fawned
faxed	16	62	2053	3	faxed_
fayed	12	64	2215	3	fayed_
faze	16	56	3004	3	f__aze
fazed	18	62	2296	3	fazed_
fease	8	48	2487	3	f_ease
feaze	17	52	1631	3	f_eaze
fecal	10	51	1921	3	feca_l
female	11	3	1055	3	female
fiacre	11	3	762	3	fiac_re
fice	9	57	3711	3	fic__e
fiche	13	46	1674	3	fic_he
fickle	15	39	1297	3	fickle
finale	9	41	1676	3	finale
fixate	16	3	873	3	fixate
flacked	17	37	1158	3	flacked
flake	12	51	1997	3	f_lake
flame	10	51	2444	3	f_lame
flare	8	48	2363	3	f_lare
focal	10	49	1767	3	foca_l
folate	9	33	2039	3	folate
forage	10	46	1700	3	forage
forbade	13	25	910	3	forbade
fracas	11	3	1199	3	fraca_s
fracases	13	3	699	3	fracases
fracted	13	3	937	3	fracted
frae	7	53	3047	3	f_ra_e
frame	10	58	2180	3	f_rame
fucked	16	41	1448	3	fucked
fucose	11	16	768	3	fucose
furane	9	40	1549	3	furane
furcate	12	3	1045	3	furcate
fyce	12	63	1683	3	fyc__e
gambade	13	3	638	3	gambade
garage	8	3	1451	3	garage
gavage	11	3	719	3	gavage
glade	7	51	2196	3	_glade
grade	7	51	2609	3	_grade
hacked	16	49	2351	3	hacked
hackee	15	49	2183	3	hackee
hackie	15	46	1562	3	hackie
hackle	15	49	1681	3	hackle
hade	8	54	4019	3	__hade
halide	10	34	1799	3	halide
hamada	12	3	991	3	hamada
hamate	11	33	1982	3	hamate
hexade	17	43	890	3	hexade
incage	9	35	1362	3	incage
incase	8	36	1528	3	incase
invade	10	15	785	3	invade
irade	6	56	1815	3	_irade
jacal	14	3	1370	3	jaca_l
jacales	16	3	1032	3	jacales
jacals	15	3	987	3	jacals
jacana	15	3	793	3	jacana
jacked	20	48	1752	3	jacked
jade	12	53	2544	3	__jade
karate	10	53	2092	3	karate
lace	6	68	4847	3	lac__e
laced	8	71	3264	3	laced_
lacked	13	53	2465	3	lacked
lactase	9	3	795	3	lactase
lactate	9	3	1269	3	lactate
lacune	8	16	967	3	lacune
lade	5	63	4598	3	__lade
lanate	6	4	2126	3	lanate
lavage	10	3	826	3	lavage
locale	8	39	1565	3	locale
locate	8	39	1984	3	locate
macaber	13	3	616	3	macaber
macabre	13	3	522	3	macabre
macaco	12	4	785	3	macaco
macadam	14	4	685	3	macadam
macaque	20	4	405	3	macaque
macaw	12	3	1176	3	maca_w
macaws	13	3	702	3	macaws
mace	8	73	4578	3	mac__e
maced	10	85	2869	3	maced_
mache	12	59	2530	3	mac_he
mackle	14	37	1643	3	mackle
macle	9	61	2700	3	mac_le
macled	11	67	1811	3	macled
macrame	13	3	871	3	macrame
macule	10	41	1527	3	macule
madame	11	3	985	3	madame
made	7	54	4023	3	__made
malady	12	3	786	3	malady
malate	8	46	2455	3	malate
manage	9	38	1890	3	manage
manmade	12	3	796	3	manmade
nacre	7	57	1536	3	nac_re
nacred	9	52	1249	3	nacred
naiad	6	3	1340	3	naiad_
naiades	8	3	821	3	naiades
naiads	7	3	901	3	naiads
nicad	8	3	1261	3	nicad_
nicads	9	3	833	3	nicads
noyade	10	3	642	3	noyade
oatcake	13	4	536	3	oatcake
paca	8	51	3224	3	paca__
pacas	9	60	2940	3	paca_s
pace	8	63	4577	3	pac__e
paced	10	69	3168	3	paced_
package	16	12	801	3	package
packed	15	48	2260	3	packed
palace	10	45	1691	3	palace
palate	8	42	2678	3	palate
panada	9	41	1305	3	panada
pancake	15	3	667	3	pancake
paraded	11	40	1426	3	paraded
parader	10	39	1486	3	parader
parades	10	41	2146	3	parades
parae	7	63	3570	3	para_e
parkade	14	3	758	3	parkade
passade	10	3	923	3	passade
pavane	11	41	1344	3	pavane
pesade	9	3	1110	3	pesade
placate	11	3	1243	3	placate
pomade	11	36	1133	3	pomade
race	6	67	4626	3	rac__e
raced	8	76	3531	3	raced_
raceme	10	3	973	3	raceme
racked	13	45	2608	3	racked
rackle	12	39	1729	3	rackle
ramada	9	3	1018	3	ramada
ramate	8	39	2168	3	ramate
ravage	10	3	930	3	ravage
recane	8	30	2287	3	recane
recede	9	55	1553	3	recede
recode	9	36	1871	3	recode
remade	9	43	1698	3	remade
saccades	13	13	724	3	saccades
saccate	11	13	1176	3	saccate
sacked	13	55	2521	3	sacked
sacque	17	10	711	3	sacque
sacred	9	49	1710	3	sacred
sade	5	55	4447	3	__sade
salad	6	53	2183	3	salad_
salads	7	53	1696	3	salads
sarape	8	48	1757	3	sarape
sarode	7	53	1751	3	sarode
savage	10	4	1017	3	savage
savate	9	3	1378	3	savate
scad	7	57	2576	3	_scad_
scads	8	54	1995	3	_scads
scalade	10	35	926	3	scalade
scale	7	46	2914	3	_scale
scape	9	69	2184	3	_scape
scare	7	53	3446	3	_scare
secede	9	33	1199	3	secede
shade	9	51	2558	3	_shade
socage	9	10	1212	3	socage
spade	8	44	2332	3	_spade
stade	6	48	2530	3	_stade
tace	6	53	4251	3	tac__e
tache	10	62	2237	3	tac_he
tacked	13	47	2394	3	tacked
tackle	12	38	1573	3	tackle
tacnode	10	4	508	3	tacnode
takahe	13	3	579	3	takahe
tamale	8	37	1739	3	tamale
teacake	13	3	545	3	teacake
tirade	7	3	1169	3	tirade
trade	6	50	2604	3	_trade
tsade	6	43	1112	3	_tsade
uncage	9	30	1487	3	uncage
uncake	12	28	1352	3	uncake
uncase	8	38	1743	3	uncase
unlade	7	27	1415	3	unlade
unmade	9	29	1106	3	unmade
vacant	11	4	1513	3	vacant
vacated	13	4	935	3	vacated
vacates	12	3	1283	3	vacates
wacke	14	59	1862	3	wac_ke
wade	8	52	3706	3	__wade
wakame	15	3	543	3	wakame
watape	11	20	848	3	watape
yacked	16	45	1679	3	yacked

Search took 7 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.126	1418182.5
2	DLD Change Limit	112716	407	6.030	18692.5
3	Display Results	407	407	0.126	3230.2
	(SQL Overall)	178691	407	6.282	28444.9