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

264 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
menacers1227931(None) 
menacer112610881menacer_
menaces112715521menace_s
defacers14237992defacers
fencers123810622fen_cers
macers105321272m__acers
managers112911002managers
meanders1168832meanders
meaners94415242me_aners
menace103216942menace__
menaced122710092menace_d
menages103615392menage_s
menders103818802men_ders
mercers114412772me_rcers
metamers1249622metamers
mincers113714852min_cers
tenaces92814512tenace_s
amenders11288353amen_ders
amercers1256133ame_rcers
amesaces1246693amesace_s
beaders104120183be_aders
beakers134216873be_akers
bearers94619593be_arers
beaters94925043be_aters
beavers124417323be_avers
behavers16205613behavers
bejabers1933633bejabers
belayers13298143belayers
benames112814603bename_s
benchers153611013benchers
benders104021063ben_ders
bracers114616703_bracers
cancers114018583can_cers
cenacles1238023cenacles
censers94313903cen_sers
centers94420603cen_ters
centners1057243centners
chancers154313493chancers
dancers103413093dan_cers
dealers84118613de_alers
debasers11377903debasers
debaters113511923debaters
decayers14307963decayers
defacer132810363defacer_
defaces133213403deface_s
defamers14258523defamers
deicers103612733de_icers
delayers12268663delayers
denars74621433dena__rs
deniers84515183den_iers
denuders10165873denuders
detachers1536483detachers
dewaters122910723dewaters
eagers74523683_e_agers
eaters65535953_e_aters
effacers16244233effacers
elaters74420193_elaters
embracers15105153embracers
emenders11319033emen_ders
empalers12226743empalers
enablers10196913_enablers
enactors1038453_enactors
enacts84012973_enac_ts
enamels9128163_enamels
enamors939123_enamors
enates64026433_enate_s
enders74324053_en_ders
enfaces122110913_enface_s
engagers10246553_engagers
enhancers1445103_enhancers
enlaces92313393_enlace_s
enters64425643_en_ters
enticers10139093_enticers
enviers1036993_enviers
erasers74413943_erasers
evaders1136933_evaders
exacters1736773_exacters
facers115519443__facers
fearers104815273fe_arers
fencer114613533fen_cer_
fences114617113fen_ce_s
fenders113717263fen_ders
genders93616783gen_ders
gennakers1442793gennakers
glancers11408003glancers
gnawers11356393_gnawers
hanapers1346963hanapers
headers113819393he_aders
healers104319463he_alers
heapers123616673he_apers
hearers104319783he_arers
heaters104225223he_aters
heavers133717193he_avers
knackers13286843_knackers
kneaders1384713kneaders
lacers85225253__lacers
lancers93616643lan_cers
leachers133712813le_achers
leaders83819603le_aders
leakers113415423le_akers
leaners73718173le_aners
leapers93716663le_apers
leasers74717843le_asers
leavers103717783le_avers
lenders84419643len_ders
macer912126943m__acer_
maces97139963m__ace_s
maenades1137473maenade_s
makers123921733m__akers
manacles1239523manacles
manager103413583manager_
manages103418963manage_s
manatees10310423manatees
mangers103521263man_gers
manglers113311903manglers
manners93417833man_ners
manurers1037593manurers
masers84623453m__asers
maters85032393m__aters
mazers173917093m__azers
meager94515203me_ager_
meander1049973meander_
meaner84617843me_aner_
meanies93620743meanie_s
meanness1037183meanness
meddlers12318203meddlers
meeters94714543me_eters
megabars1344403megabars
meisters103313843meisters
melders103213913me_lders
melters93918313me_lters
members13258603me_mbers
menacing1339783menacing
menads95514383mena__ds
menage93216543menage__
menagerie1245013menagerie
menageries1345853menageries
menarches1646683menarches
menazons1945733menazons
mender93520793men_der_
menhadens1543003menhadens
menhirs1235913men_hirs
mensches1536303mensches
menses84222453men_se_s
menshes12310453menshe_s
mentees93214503men_tees
mentors9314993men_tors
mercer105214203me_rcer_
mercery14397623me_rcery
merces105720743me_rce_s
mergers103813423me_rgers
metages102714973metage_s
metamer1139613metamer_
metamere1257353metamere
metameres1347453metameres
metates92720013metate_s
meters85625833me__ters
metiers93312843me_tiers
mewlers12288983me_wlers
minarets1048843minarets
mincer104017363min_cer_
minces104420803min_ce_s
minders103720123min_ders
miners84126633min__ers
minglers113011293minglers
minicars12118523minicars
minivers1337483minivers
minsters103813923minsters
minters93822473min_ters
misavers1348063misavers
moaners92813553m_oaners
monacids13137513monacids
monades103713823monade_s
moneyers1337423moneyers
mongers104217273mon_gers
monickers1745083monickers
monikers1437413monikers
monomers12311033monomers
monsters103314553monsters
muensters1143253muensters
munchers15318773munchers
munsters104010553munsters
mynheers1642113mynheers
nacres85614453__nacres
namers84517333__namers
negaters9349783negaters
onagers838103_onagers
pacers105124543__pacers
panaceas1236763panaceas
peaces106324083pe_ace_s
peachers153213843pe_achers
pedalers11239393pedalers
penances12312443penance_s
penates93321603penate_s
pencels113610053pen_cels
penners93414183pen_ners
pensters103012123pensters
petnapers1343823petnapers
pincers113916503pin_cers
placers114515263_placers
prancers123210333prancers
prefacers1636293prefacers
racers84725433__racers
reachers133515723re_achers
readers83823773re_aders
reamers94221083re_amers
reapers93520453re_apers
rearers74323563re_arers
reavers108320743re_avers
rebaters103413943rebaters
reducers1147263reducers
refaces123216743reface_s
regalers94311133regalers
relaces93420883relace_s
relaters83218153relaters
relaxers15298263relaxers
remakers143811303remakers
renames92418053rename_s
renders83821673ren_ders
renegers9248793renegers
renewers11238183renewers
renters74224813ren_ters
rentiers83311763rentiers
repapers1258833repapers
replacers13266833replacers
retakers123511133retakers
retracers11149553retracers
sealers74323553se_alers
seamers94719433se_amers
seances93015343seance_s
seaters74028943se_aters
seducers1145383seducers
senates73322613senate_s
senators8312953senators
senders83022353sen_ders
smearers10308623sme_arers
snackers143010223_snackers
snarers74216663_snarers
sneakers12308643sneakers
solacers10268893solacers
spacers113813873_spacers
spencers12269193spen_cers
tanagers9259003tanagers
teachers133212393te_achers
tearers75218233te_arers
teasers75317243te_asers
teenagers10114493teenagers
tenace82715693tenace__
tenders83719723ten_ders
tenners74014923ten_ners
tenoners858713tenoners
tenters73921103ten_ters
tracers94917843_tracers
vealers103214293ve_alers
vendaces1457183vendace_s
venders113717003ven_ders
veneers103710293ven_eers
venomers1336703venomers
venters103717733ven_ters
weaners104613833we_aners
wearers104615903we_arers
weavers133714463we_avers
wenchers16319213wenchers
wincers123415363win_cers

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 Filter1786911461620.453394461.4
2DLD Change Limit1461622646.73321708.3
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.29624491.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.