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 “enfaces” 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.

305 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
enfaces12211091(None) 
effaces15277271effaces
enface112510351enface_
enfaced13218911enfaced
enlaces92313391enlaces
anlaces92313732anlaces
bifaces1448062bifaces
defaces133213402defaces
efface14366672efface_
effaced16225572effaced
effacer15255412effacer
effacers16244232effacers
enacts84012972en_acts
enates64026432en_ates
encages103313782encages
encases93116052encases
enflames1357042enflames
enforces13208012enforces
enframes1357452enframes
engages92912492engages
enhances1339292enhances
enlace82213232enlace_
enlaced102410522enlaced
enrages83114852enrages
entases72816272entases
entices91616332entices
faces106439432__faces
infares10313022infares
inlaces92512902inlaces
menaces112715522men_aces
refaces123216742refaces
tenaces92814512ten_aces
unifaces1346392unifaces
unlaces92513622unlaces
vendaces1457182vendaces
aces67645093___aces
anlace82513923anlace_
anlages82414113anlages
anlases72514903anlases
annates72415423annates
benames112814603ben_ames
benefices1645063benefices
biface1358103biface_
bonifaces1643733bonifaces
boraces113716853boraces
braces108427773_braces
catfaces1536963catfaces
cenacles1238023cen_acles
centares102913893centares
daces85030683__daces
deface123113863deface_
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defames132812253defames
dogfaces1554143dogfaces
earaches13411303earaches
eases56041613e__ases
eaves85231993e__aves
ectases92911673ectases
edifices1454863edifices
educes94011953e_duces
effects1535283effects
effuses1335903effuses
elates65032363e_lates
eluates72014683eluates
embraces14128873embraces
empales112411433empales
emplaces1438413emplaces
enables92813123enables
enact73525363en_ac_t
enacted10310643en_acted
enamel81210113en_amel
enamels9128163en_amels
enate54428153en_ate_
encage93713503encage_
encaged113211083encaged
encamps1335423encamps
encase83714363encase_
encased103512313encased
encashes13227673encashes
enchases13310273enchases
enclaves1357703enclaves
encodes10310643encodes
encores9315213encores
endashes12217453endashes
endgames1245423endgames
endites83717063endites
endives113710693endives
endues73813903en_dues
endures83314603endures
enemies9313693enemies
enfacing1467293enfacing
enfever1344643enfever
enfevers1444513enfevers
enfilades1343883enfilades
enflame1236573enflame_
enflamed1455723enflamed
enfolds11136253enfolds
enforce12237423enforce_
enforced14216743enforced
enforcer13246503enforcer
enforcers14215213enforcers
enframe1247363enframe_
enframed1466263enframed
engage82812103engage_
engaged10379833engaged
engager9278603engager
engagers10246553engagers
engines81114463engines
engraves1237233engraves
enhaloes1197343enhaloes
enhalos1087533enhalos
enhance1239693enhance_
enhanced1436623enhanced
enhancer1346683enhancer
enhancers1445103enhancers
enisles72312603enisles
enlarges946073enlarges
enolases8411013enolases
enounces1037603enounces
enplanes1039483enplanes
enrage72715073enrage_
enraged93511783enraged
enriches1337263enriches
enrobes92211113enrobes
ensiles72714833ensiles
enskies1138573enskies
enslaves1136393enslaves
ensnares856893ensnares
ensues63313813en_sues
ensures73315903ensures
entails7912823entails
entasis73012573entasis
entice81316863entice_
enticed101411193enticed
enticer91510423enticer
enticers10139093enticers
entires71517783entires
entrances11310953entrances
entrees71813773entrees
entries71523163entries
enures63919713en_ures
envies9314053en_vies
enzymes2164413enzymes
epacts105010393e_pacts
equates162012323equates
erases64425403e_rases
ergates8314493ergates
escapes113811673escapes
estates74520183estates
etapes85415293e_tapes
ethanes103713513ethanes
evades1039023e_vades
evinces1237803evinces
exacts15359613e_xacts
exhales1737143exhales
eyases94513683e_yases
face96140123__face_
faced117727653__faced
facer105525053__facer
facers115519443__facers
facet106038523__facet
facets116316653__facets
facies113921593__facies
facts107021893__facts
fades94932863__fades
faeces114713123__faeces
fakes126032483__fakes
falces115216003__falces
fames105735923__fames
fanes84639893__fanes
fanfares1436773fanfares
farces115223323__farces
fares85852873__fares
fasces114914543__fasces
fates85139233__fates
fauces114916153__fauces
faves115331423__faves
faxes155726653__faxes
fazes175527213__fazes
feces105625363__feces
fences114617113fen__ces
fices106031163__fices
fyces139813643__fyces
glaces94218023_glaces
graces94523493_graces
henbanes1336573henbanes
hyraces1537913hyraces
inanes62519803in_anes
incages103013883incages
incases93615973incases
indices103513443indices
induces103611813induces
infalls1038943infalls
infamies1346683infamies
infancies1446973infancies
infantes11249633infantes
infants102210773infants
infarcts1345233infarcts
infare9313083infare_
infects12279713infects
infixes17238133infixes
inflames1377323inflames
inflates11512193inflates
infracts1346623infracts
infuses102711873infuses
ingates82716913ingates
inhales10511863inhales
inlace82513043inlace_
inlaced10239873inlaced
inmates92715783inmates
innages82911303innages
intakes11310943intakes
invades11118293invades
knacks11428543kn_acks
knaves13439523kn_aves
knawes13328393kn_awes
laces76141763__laces
leafages1244623leafages
maces97139963__maces
menace103216943men_ace_
menaced122710093men_aced
menacer112610883men_acer
menacers12279313men_acers
menages103615393men_ages
nabes75427093_n_abes
naches114622413_n_aches
nacres85614453_n_acres
names74833363_n_ames
nances83618643_nances
napes74828463_n_apes
nares55544153_n_ares
nates55238333_n_ates
naves87030383_n_aves
negates83215843negates
nieces84112713_nieces
nonces84418833_nonces
nonfacts1346073nonfacts
nuances938523_nuances
offices1536243offices
outfaces132311393outfaces
paces96741113__paces
palaces114216453palaces
peaces106324083_peaces
penances12312443penances
penates93321603pen_ates
pennames12287793pennames
pentacles1338773pentacles
pentanes10316083pentanes
pinnaces12268863pinnaces
places104323703_places
pomaces132712123pomaces
prefaces15311063prefaces
races74943243__races
reface113616353reface_
refaced133713573refaced
relaces93420883relaces
renames92418053ren_ames
rennases848983rennases
replaces123114123replaces
respaces12311043respaces
retraces101417273retraces
rubaces1139313rubaces
senates73322613sen_ates
sensates8511143sensates
serfages1238233serfages
snacks124514553sn_acks
snakes103919603sn_akes
snares65329033sn_ares
solaces93116133solaces
spaces104722633_spaces
surfaces1338673surfaces
taces76237803__taces
tenace82715693ten_ace_
tendances1247573tendances
teniases838623teniases
tentacles1146713tentacles
tentages91011043tentages
terraces102712253terraces
traces85329933_traces
unbales92914863unbales
unbraces12229413unbraces
uncages103213773uncages
uncakes133012743uncakes
uncases93516553uncases
uneases73316263uneases
unfaded123111733unfaded
unfaked153211173unfaked
unfazed20299053unfazed
unfences1337933unfences
unfixes17238113unfixes
unfrees1048643unfrees
uniface1236953uniface_
unlace82215173unlace_
unlaced102913733unlaced
unlades82612833unlades
unmakes132810793unmakes
unpacks1576093unpacks
untacks1357503untacks
vendace1357363vendace_
ventages12119773ventages
vivaces1536413vivaces
welfares1445543welfares
wheyfaces2351523wheyfaces

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340273055.84322938.0
3Display Results3053050.1262420.6
 (SQL Overall)1786913056.37528030.0
 
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.