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

466 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
defaced14291097(None) 
deface123113861deface_
defacer132810361defacer
defaces133213401defaces
defamed14309831defamed
refaced133713571refaced
belaced124112152belaced
deaned84620452de_aned
deaved114916552de_aved
debased113310582debased
debated113916082debated
decayed14309332decayed
deduced1266682deduced
defacers14237992defacers
defame123212432defame_
defamer132710322defamer
defames132812252defames
defanged1435432defanged
defatted1335672defatted
defeated132812162defeated
defected15289972defected
defenced1537202defenced
defied115016382def_ied
defiled124013102defiled
defined123813822defined
deflated133412302deflated
defoamed15356242defoamed
deforced15247372deforced
defrayed1635402defrayed
defused125211092defused
defuzed21447042defuzed
deiced104214482de_iced
delated93722872delated
delayed123310762delayed
derated93623502derated
detached1537732detached
deuced104112122de_uced
dewaxed19316052dewaxed
effaced16225572effaced
enfaced13218912enfaced
faced117727652__faced
menaced122710092menaced
peaced115818912pe_aced
prefaced1638422prefaced
reface113616352reface_
refaces123216742refaces
relaced103517212relaced
undefaced1644752undefaced
aced79540883___aced
aerated85322373aerated
afeared1176833afeared
barefaced1743693barefaced
beached154516553be_ached
beaded104922423be_aded
beaked135919493be_aked
beamed115720733be_amed
beaned95621473be_aned
begazed2036203begazed
behaved16176683behaved
belated103520013belated
belayed133610083belayed
benamed122911093benamed
beraked144312433beraked
berated104422133berated
betaxed17307023betaxed
bewared13310113bewared
biface1358103biface_
bifaces1448063bifaces
braced115420603_braced
ceased94920783ce_ased
cerated103922473cerated
dace76934923d__ace_
daces85030683d__aces
daffed14429493daf_fed
damaged1257453damaged
danced105315253d_anced
dared75935013d__ared
dated75530993d__ated
dawed106222813d__awed
dazed165919363d__azed
deacon9510423de_acon
deaconed1237493de_aconed
dead65434243de_a__d
deaden83714323de_aden
deader84220473de_ader
deafen10389673de_afen
deafened1335853deafened
deafer104114813de_afer
deaired9411533deaired
dealated103213603dealated
dealer74122143de_aler
dearer74822803de_arer
deashed123411303deashed
deave95022333de_ave_
deaves105319533de_aves
debacle1237443debacle
debacles1335723debacles
debagged1433723debagged
debarked16175823debarked
debarred12165633debarred
debase94014473debase_
debaser103510413debaser
debases103814133debases
debate94419193debate_
debater104114693debater
debates103718533debates
debauched18123343debauched
debeaked1634613debeaked
debited113311623debited
deboned113411633deboned
debuted11379333debuted
decade104216163decade_
decades113615513decades
decamped1634963decamped
decane93818873decane_
decanes103118913decanes
decanted122310493decanted
decapod1335433decapod
decare93919153decare_
decares102818533decares
decayer13339353decayer
deceased1247713deceased
decided124312423decided
decked145217623de_cked
declared1248743declared
declawed1545923declawed
decocted1437683decocted
decoded123212383decoded
decoyed14358333decoyed
decreed112710253decreed
decried112612853decried
deduce1079253deduce_
deduces1168793deduces
deducted1356243deducted
deed65340903de___ed
deeded94615543de_eded
deejayed2042443deejayed
deemed104713063de_emed
defacing15238683defacing
defalcated1744183defalcated
defamers14258523defamers
defang1137753defa_ng
defangs1235363defangs
defat95426693defa__t
defats105114553defa_ts
default1147893default
defaulted1443313defaulted
defeater122611663defeater
defecated1637493defecated
defect124816173defec_t
defects134511523defects
defence1339893defence_
defences1439633defences
defend113910493def_end
defended1437223defended
defensed1336223defensed
defer94619753def__er
deferred13106363deferred
deffer134411303def_fer
defiance1477633defiance_
defiances1557033defiances
deficit1339673deficit
defier105118653def_ier
defies104624053def_ies
defiladed15143473defiladed
defile105216663defile_
defiler113911883defiler
defiles114016843defiles
define104718143define_
definer114413773definer
defines114118683defines
deflate113613943deflate_
deflater123211603deflater
deflates123013943deflates
deflea1037443def_lea
defleaed1344943defleaed
deflect13399973deflect
deflected1635983deflected
deflexed2043873deflexed
defoamer14276213defoamer
defocus1335283defocus
defocused16143533defocused
defogged1533783defogged
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deformed15248263deformed
defragged1643043defragged
defraud1243913defraud
defrauded1542823defrauded
defrayer1534933defrayer
defrocked2043053defrocked
defter104215923def_ter
defuel10348933def_uel
defueled1374513defueled
defund11447983def_und
defunded1435163defunded
defuse105712723defuse_
defuser115110503defuser
defuses114814593defuses
defuze19487843defuze_
defuzes20398303defuzes
degage92711383degage_
degame102713183degame_
degames113312623degames
degases93413103degases
degassed11275963degassed
deglazed2034953deglazed
degraded12288323degraded
degreed10258883degreed
dehisced1583683dehisced
deice84320033de_ice_
deicer94114413de_icer
deices94119373de_ices
deified123112413deified
deigned1037503deigned
dejected19307593dejected
dekare112811563dekare_
dekares122710873dekares
deked115718533de__ked
delate73827753delate_
delates83526283delates
delayer113010533delayer
deleaded1148333deleaded
deleaved1346573deleaved
deled75326543de__led
deleted93314903deleted
delimed11310723delimed
deluded10158763deluded
deluged10167413deluged
delved114112753de_lved
demand104314253dema_nd
demanded13348513demanded
demarked16187223demarked
demasted1238763demasted
demeaned1237283demeaned
demised113613683demised
demoded123611123demoded
demoed103713443de_moed
demoted114313543demoted
denied84318633de_nied
denimed1159233denimed
denned84215633de_nned
denoted93512763denoted
dentated10411703dentated
dented84120513de_nted
denuded10167663denuded
departed1238823departed
depicted1437743depicted
deplaned1238653deplaned
deponed113712873deponed
deposed113412023deposed
depraved1535543depraved
deputed114610173deputed
derailed102410403derailed
deranged1137693deranged
derate74531233derate_
derates84028893derates
deratted1048403deratted
derided102914253derided
derived123912763derived
desalted1038313desalted
desand84812633desa_nd
desanded11227453desanded
descend11248153de_scend
desexed1636173desexed
desired9311983desired
detach12310413detac_h
detacher1437543detacher
detaches1439653detaches
detailed10319873detailed
detained103111643detained
detected12289733detected
deticked1635693deticked
detoxed1636103detoxed
detracted1357793detracted
deuce84517493de_uce_
deuces94015513de_uces
devalued1335013devalued
develed123611933develed
deviated13311043deviated
device124512163device_
devices133212583devices
deviled124112183deviled
devised123712563devised
devoiced15276063devoiced
devoted124111093devoted
dewater112912423dewater
dewaxes18297843dewaxes
dewed105020303de__wed
dezinced2183903dezinced
diacid10310633d_iacid
dialed84716453d_ialed
diced95824683d__iced
dilated93115823dilated
disced104914653d_isced
doated84118183d_oated
doffed14428503dof_fed
dogface1454053dogface_
dogfaces1554143dogfaces
donated93513863donated
drafted12439033drafted
draped105314363d_raped
drayed115911393d_rayed
dreaded103612023dreaded
dreamed114310633dreamed
eared65139503_e_ared
eased65430403_e_ased
eaved95924503_e_aved
educed10418853_educed
efface14366673efface_
effacer15255413effacer
effaces15277273effaces
elated74725823_elated
enacted10310643_enacted
enface112510353enface_
enfaces122110913enfaces
enlaced102410523enlaced
erased74816753_erased
evaded1137063_evaded
exacted1737303_exacted
face96140123__face_
facer105525053__facer
faces106439433__faces
facet106038523__facet
faded105025243__faded
faked135225483__faked
famed115928343__famed
farced125216533__farced
fared95842343__fared
fated95632133__fated
faxed166220533__faxed
fayed126422153__fayed
fazed186222963__fazed
feared106320433fe_ared
feased105718713fe_ased
feazed195112633fe_azed
fenced124412713fe_nced
geared85317743ge_ared
gelated93615633gelated
graced105217903_graced
headed114020473he_aded
healed105121443he_aled
heaped124516903he_aped
heated104525593he_ated
heaved134717863he_aved
hefted134911423hef_ted
ideated9310973ide_ated
inlaced10239873inlaced
jeaned143813463je_aned
laced87132643__laced
leached133715043le_ached
leaded84221543le_aded
leafed105713873le_afed
leaked114217703le_aked
leaned73422543le_aned
leaped94317773le_aped
leased74722883le_ased
leaved105719023le_aved
legated92513983legated
maced108528693__maced
meated94222403me_ated
medaled113411613medaled
medevaced1842333medevaced
melamed1249633melamed
menace103216943menace_
menacer112610883menacer
menaces112715523menaces
metaled102913883metaled
neared75119803ne_ared
negated93413233negated
outfaced14219463outfaced
paced106931683__paced
palaced124110773palaced
peace95026083pe_ace_
peaces106324083pe_aces
peached154315883pe_ached
peaked136117403pe_aked
pealed95322803pe_aled
pedaled113711883pedaled
penanced1338163penanced
peracid12312993peracid
petaled103614143petaled
placed114318003_placed
preface14510923preface_
prefacer1537983prefacer
prefaces15311063prefaces
prefaded1537823prefaded
raced87635313__raced
reached134619083re_ached
reacted103015713re_acted
reamed94326123re_amed
reaped94122453re_aped
reared75930013re_ared
reaved104523923re_aved
rebated103619703rebated
recaned102817203recaned
redacted12410243redacted
redated93120923redated
reduced11610323reduced
refected142311663refected
refed93921923ref__ed
refeed104717623ref_eed
refenced1438993refenced
reffed134712513ref_fed
refiled114318653refiled
refined114720003refined
refired115116993refired
refixed183611153refixed
reflated123514293reflated
refracted1557393refracted
reframed1437853reframed
refried113513873refried
refuged125410873refuged
refused115114443refused
refuted114313803refuted
regaled93615963regaled
relace83122153relace_
relaces93420883relaces
related83327573related
relaxed153312523relaxed
relayed113212753relayed
remated103522473remated
renamed103114523renamed
repacked17188743repacked
repaved133311133repaved
replaced133211393replaced
reracked15169123reracked
resawed113111183resawed
respaced1338503respaced
retacked15169273retacked
retaped103814283retaped
retaxed153512233retaxed
retraced111413023retraced
rewaked153811903rewaked
rewaxed18409343rewaxed
seabed95017693se_abed
sealed74328363se_aled
seamed94823883se_amed
seared75232843se_ared
seated75131053se_ated
sedated93714343sedated
seduced1186753seduced
sepaled10510593sepaled
sofabed1334333sofabed
solaced102911063solaced
spaced114517253_spaced
surfaced1436063surfaced
teamed95418593te_amed
teared75722153te_ared
teased74721153te_ased
teated74924023te_ated
tenace82715693tenace_
tenaces92814513tenaces
terraced11318123terraced
traced94821583_traced
uneffaced1842573uneffaced
unfaded123111733unfaded
unfaked153211173unfaked
unfazed20299053unfazed
unlaced102913733unlaced
vealed103916323ve_aled
weaned103816153we_aned
weaved133913483we_aved
wheyfaced246953wheyfaced
yeaned103813903ye_aned

Search took 8 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.1431249587.4
2DLD Change Limit1340274666.75019855.9
3Display Results4664660.1702741.2
 (SQL Overall)1786914667.06325299.6
 
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.