Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

297 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
enface11251035(None) 
efface14366671efface
enfaced13218911enfaced
enfaces122110911enfaces
enlace82213231enlace
anlace82513922anlace
biface1358102biface
deface123113862deface
effaced16225572effaced
effacer15255412effacer
effaces15277272effaces
enact73525362en_act
enate54428152en_ate
encage93713502encage
encase83714362encase
enflame1236572enflame
enforce12237422enforce
enframe1247362enframe
engage82812102engage
enhance1239692enhance
enlaced102410522enlaced
enlaces92313392enlaces
enrage72715072enrage
entice81316862entice
face96140122__face
infare9313082infare
inlace82513042inlace
menace103216942men_ace
reface113616352reface
tenace82715692ten_ace
uniface1236952uniface
unlace82215172unlace
vendace1357362vendace
ace59656833___ace
anlaces92313733anlaces
anlage72514233anlage
ansae55720973ansa_e
ansate64517863ansate
antae56828293anta_e
apace94718383_apace
bename103316073ben_ame
benefice1545003benefice
bifaces1448063bifaces
boniface1543863boniface
brace95629273_brace
catface1436763catface
cenacle1139123cen_acle
centare93113703centare
dace76934923__dace
defaced142910973defaced
defacer132810363defacer
defaces133213403defaces
defame123212433defame
dentate8315153dentate
dogface1454053dogface
each95530583e__ach
earache1239323earache
ease45042333e__ase
eave75733583e__ave
edifice1344933edifice
educe84313453e_duce
effable15106673effable
effacers16244233effacers
effect1437443effect
effete1235183effete
effuse1234963effuse
elate55335883e_late
eluate62315433eluate
embrace1388893embrace
empale102611263empale
emplace1338263emplace
enable83318483enable
enacted10310643en_acted
enacts84012973en_acts
enamel81210113en_amel
enates64026433en_ates
encaged113211083encaged
encages103313783encages
encamp1235943encamp
encased103512313encased
encases93116053encases
encash11276943encash
enchase1239463enchase
enclave1257533enclave
encode9310443encode
encore8314773encore
endarch1345443endarch
endash10297123endash
endgame1145233endgame
endite73817593endite
endive103310473endive
endue64215353en_due
endure74014143endure
enfacing1467293enfacing
enfever1344643enfever
enfilade1243743enfilade
enflamed1455723enflamed
enflames1357043enflames
enfold10137613enfold
enforced14216743enforced
enforcer13246503enforcer
enforces13208013enforces
enframed1466263enframed
enframes1357453enframes
engaged10379833engaged
engager9278603engager
engages92912493engages
engine71114863engine
engrave1137133engrave
enhalo987563enhalo
enhanced1436623enhanced
enhancer1346683enhancer
enhances1339293enhances
enisle63412093enisle
enlarge835533enlarge
ennuye973753ennuye
enolase7310193enolase
enounce937573enounce
enplane939723enplane
enraged93511783enraged
enrages83114853enrages
enrapt8313013enrapt
enrich1138943enrich
enrobe86610793enrobe
ensile62616473ensile
enslave1036273enslave
ensnare767123ensnare
ensue54013833en_sue
ensure63416003ensure
entail61114343entail
entases72816273entases
enticed101411193enticed
enticer91510423enticer
entices91616333entices
entire61617703entire
entrance10311333entrance
entree61817883entree
enure53520223en_ure
enzyme2054343enzyme
epact94921533e_pact
equate152012463equate
erase54925493e_rase
ergate7315143ergate
escape103811663escape
estate64719763estate
etape74413703e_tape
ethane94613243ethane
evade938183e_vade
evince1137763evince
exact143516933e_xact
exhale1636873exhale
faced117727653__faced
facer105525053__facer
faces106439433__faces
facet106038523__facet
fact97142543__fact
fade85736343__fade
fake115534943__fake
fame95639393__fame
fane75343573__fane
fanfare1336673fanfare
farce104925323__farce
fare76354463__fare
fate75444283__fate
fave105532963__fave
faze165630043__faze
fence105319913fen__ce
fice95737113__fice
fyce126316833__fyce
glace87420153_glace
grace85124543_grace
henbane1237353henbane
hence104920043hen__ce
inane52820343in_ane
incage93513623incage
incase83615283incase
induce93811533induce
infall939403infall
infamy1435653infamy
infancy1546173infancy
infant92315133infant
infante101910883infante
infarct1249013infarct
infares10313023infares
infect113413443infect
inflame1256963inflame
inflate10312313inflate
infract12610003infract
infuse93110573infuse
ingate73018243ingate
inhale9411513inhale
inlaced10239873inlaced
inlaces92512903inlaces
inmate82917363inmate
innage73011573innage
innate63917313innate
insane6314893insane
intact8314663intact
intake10510863intake
invade10157853invade
knack104311043kn_ack
knave12389463kn_ave
knawe12397883kn_awe
lace66848473__lace
leafage1194573leafage
mace87345793__mace
menaced122710093men_aced
menacer112610883men_acer
menaces112715523men_aces
menage93216543men_age
mensae84114053mensa_e
nabe66029493_n_abe
nacre75715363_n_acre
nae35952743_n_a_e
name65637413_n_ame
nance74721843_nance
nape65230803_n_ape
nave75732313_n_ave
negate72915573negate
nice65534713_n_ice
niece74814503_niece
nonce75719823_nonce
nonfact1248893nonfact
nuance859043_nuance
office1435693office
once65423083on__ce
outface123011973outface
pace86345773__pace
palace104516913palace
peace95026083_peace
penance11313443penance
pence94924453pen__ce
pennae84314033penna_e
penname11328553penname
pennate93314033pennate
pentacle1239383pentacle
pentane9415743pentane
pinnace113510313pinnace
place94824613_place
pomace123111913pomace
preface14510923preface
race66746263__race
refaced133713573refaced
refaces123216743refaces
relace83122153relace
rename82718813ren_ame
rennase738713rennase
replace113214283replace
respace11310913respace
retrace91417343retrace
rubace10310173rubace
senate63725173sen_ate
sensate7311893sensate
serfage1138403serfage
snack114718063sn_ack
snake94821113sn_ake
snare54429983sn_are
solace83415823solace
space95325673_space
surface1238653surface
tace65342513__tace
tenaces92814513ten_aces
tendance1147523tendance
teniae64517353tenia_e
tentacle1037693tentacle
tentage81010643tentage
terrace93311843terrace
trace75829613_trace
unbale83616403unbale
unbrace111910493unbrace
uncage93014873uncage
uncake122813523uncake
uncase83817433uncase
unease63816643unease
unfaded123111733unfaded
unfair936233unfair
unfaked153211173unfaked
unfancy1545203unfancy
unfazed20299053unfazed
unfence1239193unfence
unfree9413203unfree
unifaces1346393unifaces
unlaced102913733unlaced
unlaces92513623unlaces
unlade72714153unlade
unmade92911063unmade
unmake122811213unmake
unpack1457833unpack
unsafe9310693unsafe
untack1239763untack
untame82513603untame
venae85920983ven_a_e
vendaces1457183vendaces
ventage11109623ventage
vivace1436553vivace
welfare1335713welfare
wheyface2261553wheyface

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.390458182.1
2DLD Change Limit1127162975.29621283.2
3Display Results2972970.0933193.5
 (SQL Overall)1786912975.77930920.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.