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

235 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
drummers1331616(None) 
drummer12407501drummer_
rummers113513651_rummers
brimmers14287072brimmers
bummers133712442_bummers
crammers14369352crammers
crimmers14298542crimmers
crumbers14338242crumbers
cummers133713482_cummers
dammers123214272d_ammers
dimmers123811562d_immers
dreamers11369002dreamers
drubbers13386032drubbers
drudgers11326852drudgers
drummed13306322drumme_d
druthers1275792druthers
dumpers123412662d_umpers
grummer12338782grummer_
grummets13275032grummets
gummers123712202_gummers
hummers143813062_hummers
krimmers16315672krimmers
mummers103712842_mummers
rammers113715042_rammers
rimmers113812882_rimmers
rummer104715482_rummer_
scummers14277782scummers
slummers12358932slummers
strummers1333692strummers
summers113616502_summers
thrummers1642412thrummers
trimmers12288912trimmers
armers85520273ar__mers
brimmer13348803brimmer_
bruisers10307953bruisers
bruiters10329143bruiters
brumes106417073bru_me_s
brushers134210573brushers
bummer124014103_bummer_
bumpers133912053_bumpers
clammers143510693clammers
clumbers143910413clumbers
crammer134010963crammer_
creamers124111313creamers
crimmer133310773crimmer_
crimpers14318933crimpers
cruisers10438283cruisers
crullers1047303crullers
crumber13339643crumber_
crummier1435603crummier_
crummies1437643crummies
crumpets14335943crumpets
cruppers14317323cruppers
crushers134010093crushers
cumbers134515413_cumbers
cummer124414593_cummer_
dammars12308193d_ammars
dammer114317933d_ammer_
damners104112113d_amners
dampers123915693d_ampers
daubers104610423dau_bers
daunders10278473daunders
daunters9329853daunters
defamers14258523defamers
dimers94321093d__imers
dimmer114112613d_immer_
dormers104313923d_ormers
doublers11288503doublers
doubters11257393doubters
dousers84817273dou_sers
drafters12338533drafters
draggers11357393draggers
drainers92811253drainers
drammed13378073dramme_d
drapers105313353dr_apers
drawers113610073dr_awers
drawlers12307313drawlers
dreamer104110843dreamer_
dredgers11256093dredgers
dressers9359863dressers
driers74516733dr__iers
drifters12417913drifters
drillers9429723drillers
drinkers13277823drinkers
drippers13327943drippers
drivers114412793dr_ivers
droners84114383dr_oners
droppers13318603droppers
drovers115212643dr_overs
drowners12428273drowners
drubber12357863drubber_
drudger10328323drudger_
drudgery14273633drudgery
drudges10308873drudge_s
druggets11313913druggets
drugmakers1841803drugmakers
druidess1043083druidess
drumbeat1343973drumbeat
drumbeats1442323drumbeats
drumbles13277723drumbles
drumfire1442543drumfire
drumfires1542553drumfires
drumhead1542653drumhead
drumheads1642293drumheads
drumlier1134523drumlier_
drumlins1144993drumlins
drumming14265783drumming
drums85415873dru_m__s
drunker12326633drunker_
drupes94912653dru_pe_s
druses75517253dru_se_s
dryers10449273dr__yers
dubbers124011823d_ubbers
duckers143214713d_uckers
duelers83412053d_uelers
duffers143410093d_uffers
duikers12369383d_uikers
dumber114414173d_umber_
dummies123012133d_ummies
dumper114615213d_umper_
dunkers123512193d_unkers
dupers94615603d_u_pers
duramens1195153duramens
dusters84918363d_usters
duumvirs1441223duumvirs
emmers104013223__emmers
flummery1833053flummery
framers125113823fr_amers
fruiters11328183fruiters
fumers113613383_fu_mers
gammers123214563_gammers
glimmers13396153glimmers
glummer12417983glummer_
grammars13345943grammars
grammes123611323gramme_s
grimmer123510093grimmer_
grommets13234663grommets
groomers11388483groomers
grubbers13316203grubbers
grudgers11266753grudgers
gruelers936173gruelers
grumblers14245023grumblers
grumes94415553gru_me_s
grummest13286363grummest
grummet12298873grumme_t
grungers10298503grungers
grunters9359043grunters
gummer114615453_gummer_
hammers144216063_hammers
hemmers143310843_hemmers
hummer133615273_hummer_
humpers142713523_humpers
jammers183710703_jammers
jumpers18399843_jumpers
krimmer15376873krimmer_
krullers1234133krullers
kummels15234793_kummels
limmers113413083_limmers
lumbers113815913_lumbers
lumpers113514483_lumpers
mammers104615693_mammers
midsummers1451393midsummers
mummer93614543_mummer_
mummery13336663_mummery
mumpers133311373_mumpers
numbers113711243_numbers
ormers84316143or__mers
plumbers14418513plumbers
plummer13298523plummer_
plummets14304773plummets
plumpers14357293plumpers
premiers122911653premiers
primers114215673pr_imers
primmer134310163primmer_
pruners93710723pru_ners
pummels13236543_pummels
pumpers133113673_pumpers
rammer103519653_rammer_
reamers94221083_reamers
rhymers15365543_rhymers
rimers84522553_r_imers
rimmer103516033_rimmer_
roamers93713463_roamers
rompers113412243_rompers
roomers95416413_roomers
rubbers113913193_rubbers
rudders93210653_rudders
ruers515019413_ru__ers
ruggers94612313_ruggers
ruiners74213023_ruiners
rulers64317093_ru_lers
rumblers123610743_rumblers
rumens83611813_ru_mens
rummagers1443033_rummagers
rummest11279833_rummest
rummier11309563_rummier_
rummies113212793_rummies
rumors81110403_ru_mors
rumours976373_rumours
runners74212453_runners
rushers103816103_rushers
scammers14339773scammers
scummer13398753scummer_
shammers153710843shammers
shimmers15269413shimmers
simmers113314613_simmers
skimmers16296463skimmers
slammers123511223slammers
slimmers12369633slimmers
slumbers123110273slumbers
slummer113711203slummer_
spammers14378693spammers
stammers123611523stammers
stemmers12378443stemmers
strummer1234783strummer_
stumpers12318313stumpers
summer104017713_summer_
summery14329413_summery
swimmers15276693swimmers
thrummer1542933thrummer_
thumpers15365713thumpers
trammels12295413trammels
trampers123210393trampers
trimers94615143tr_imers
trimmer113610833trimmer_
trommels12254333trommels
truckers14279013truckers
trudgers10256863trudgers
trumpery1533613trumpery
trumpets12315573trumpets
trussers8348283trussers
trusters83112263trusters
tummlers12295703_tummlers
umbers104215213__umbers
yammers143410323_yammers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622356.33023090.4
3Display Results2352350.0932526.9
 (SQL Overall)1786912356.82926166.5
 
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.