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

333 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
slumbers12311027(None) 
clumbers143910391clumbers
lumbers113815911_lumbers
plumbers14418511plumbers
slubbers12349941slubbers
slumber113811001slumber_
slumbery15296041slumbery
slummers12358931slummers
blubbers11408142blubbers
clambers144211282clambers
climbers14318402climbers
clubbers14378572clubbers
clumber134011442clumber_
crumbers14338222crumbers
cumbers134515392_cumbers
flubbers15346892flubbers
lambers113817102_lambers
limbers113614722_limbers
lubbers113913722_lubbers
lumbars11289762_lumbars
lumber103817772_lumber_
lumpers113514482_lumpers
numbers113711242_numbers
plumber13339982plumber_
plumbery17315532plumbery
plumpers14357292plumpers
scummers14277782scummers
slabbers123610122slabbers
slammers123511222slammers
slimmers12369632slimmers
slobbers12398522slobbers
slubber113010762slubber_
sluggers10348482sluggers
slumbered14215592slumbered
slumberer13194802slumberer
slumberers14203682slumberers
slumberous1443362slumberous
slummer113711202slummer_
snubbers12326672snubbers
stumblers1334372stumblers
stumpers12318312stumpers
subers85722642s_u_bers
summers113616502s_ummers
umbers104215202__umbers
almners9399563al_mners
ambers104519563__ambers
assumers1064963assum_ers
blabbers11308153blabbers
blamers115314213blam_ers
blubber10399293blubber_
blubbery14294783blubbery
bluchers15359033bluchers
bludgers12397853bludgers
bluffers16405703bluffers
blumes105917793blum_e_s
blunders113911333blunders
blungers11469843blungers
blurters10348363blurters
blushers133911293blushers
blusters104413883blusters
bombers134512593_bombers
bumblers143710733_bumblers
bummers133712443_bummers
bumpers133912053_bumpers
cambers134017433_cambers
chambers173410613chambers
clabbers14359893clabbers
clamber133311733clamber_
clammers143510683clammers
clampers143211883clampers
climber13449133climber_
clobbers14397513clobbers
clubber13319593clubber_
clunkers14327543clunkers
clusters102912393clusters
clutters103210343clutters
combers134516613_combers
crumber13339643crumber_
cubers105318343_cu_bers
cucumbers1742483cucumbers
cumber124016703_cumber_
cummers133713473_cummers
curbers115514373_curbers
daubers104610423dau_bers
drubbers13386023drubbers
drummers13316163drummers
dubbers124011823_dubbers
dumber114414173_dumber_
dumpers123412663_dumpers
eluders8409903elu_ders
embers104116173__embers
encumbers1543793encumbers
flambes14419503flambe_s
flamers124616363flam_ers
flubber14287713flubber_
fluffers13335293fluffers
flumes115119733flum_e_s
flummery1833053flummery
flunkers15347533flunkers
flushers14279733flushers
flusters113811493flusters
fluters103713673flu_ters
flutters114010813flutters
fumblers15318713_fumblers
fumers113613383_fum_ers
glimmers13396153glimmers
gluers75011153glu__ers
glumes94516813glum_e_s
glummer12417983glummer_
glumness1135203glumness
grubbers13316193grubbers
grumblers14245023grumblers
gummers123712193_gummers
humblers15379803_humblers
hummers143813063_hummers
humpers142713523_humpers
incumbers1543993incumbers
jumblers19358323_jumblers
jumpers18399843_jumpers
lamber104418493_lamber_
lambert113617113_lambert
lamberts12348783_lamberts
lampers113817333_lampers
libbers113812823_libbers
libers84721433_l_ibers
limber104316773_limber_
limmers113413083_limmers
limners93311553_limners
limpers113815223_limpers
lobbers113713933_lobbers
lubber104214623_lubber_
lubes74727993_lu_be_s
lugers74617023_lu_gers
luggers93713483_luggers
lullers73213353_lullers
lumbar103610593_lumbar_
lumbered13188233_lumbered
lumberer12177583_lumberer
lumberers13196013_lumberers
lumberly1544673_lumberly
lumens85013973_lum_ens
lumpens11298263_lumpens
lumper103816653_lumper_
lungers83817083_lungers
lunkers113414603_lunkers
lurers64217493_lu_rers
lurkers113910083_lurkers
lusters73921433_lusters
members13258603_members
misnumbers1642223misnumbers
mumblers14328763_mumblers
mummers103712843_mummers
mumpers133311363_mumpers
number103913223_number_
ombers104214393__ombers
pluckers16316553pluckers
pluggers12297023pluggers
plumbed14317273plumbe_d
plumbeous1542903plumbeous
plumberies1645113plumberies
plumbness1543133plumbness
plumbous1444283plumbous
plumbs12459333plumb__s
plumbums1642943plumbums
plumes104318133plum_e_s
plumier113510043plumier_
plummer13298523plummer_
plummets14304773plummets
plumpens14304953plumpens
plumper13318773plumper_
plunders11329823plunders
plungers11379393plungers
plunkers14328323plunkers
pumpers133113673_pumpers
renumbers1344123renumbers
rubbers113913183_rubbers
rumblers123610743_rumblers
rummers113513653_rummers
sabers85224733s__abers
saluters8319853salu_ters
sambars115113843s_ambars
samburs11369343s_amburs
saucers93712133sau_cers
sauciers1076733sauciers
saugers83914053sau_gers
saunters82911743saunters
scammers14339773scammers
scampers143611033scampers
schmeers1574833schmeers
scribers12307953scribers
scrubbers1543363scrubbers
scuffers16307493scuffers
sculkers14306933sculkers
scullers103510473scullers
scumbags1543203scumbags
scumbles1447023scumbles
scumless1254993scumless
scummer13398753scummer_
scunners10357303scunners
scuppers1446533scuppers
scutters103311013scutters
seamers94719433seam_ers
seemers93814333seem_ers
shammers153710833shammers
shimmers15269413shimmers
shuckers17388133shuckers
shudders13316643shudders
shunners11317743shunners
shunters113210733shunters
shushers14267053shushers
shutters113611333shutters
simmers113314613s_immers
simpers113014113s_impers
skimmers16296453skimmers
skulkers11334923skulkers
slabber113311393slabber_
slabbery15375773slabbery
slackers143812743slackers
slakers114115753sl_akers
slammer113913033slammer_
slanders94014013slanders
slappers123710933slappers
slashers113313603slashers
slaters73123723sl_aters
slathers113914773slathers
slavers103716503sl_avers
slayers104513323sl_ayers
sledders10257373sledders
sleekers12377993sleekers
sleepers103110113sleepers
slicers94114923sl_icers
slickers143112553slickers
sliders83515223sl_iders
slimes84722043slim_e_s
slimier93212013slimier_
slimmer114211343slimmer_
slimness1036523slimness
slingers93712673slingers
slippers123711223slippers
slithers114212953slithers
slitters84014133slitters
slivers104115253sl_ivers
slobber11388903slobber_
slobbery15375653slobbery
sloggers10418783sloggers
slopers94213093sl_opers
slotters84012393slotters
slouchers14185623slouchers
slubbed12339283slubbe_d
slubbered14175253slubbered
slubs74719533slu_b__s
sludges93811993sludge_s
slues54527173slu__e_s
slugabeds1391143slugabeds
slugger93610673slugger_
sluices959073sluice_s
slumbering15105323slumbering
slumbrous1343973slumbrous
slumgums1342093slumgums
slumisms1244723slumisms
slumlord1141833slumlord
slumlords1241433slumlords
slummed12359273slumme_d
slummier1235473slummier_
slumped123710153slumpe_d
slumps104313583slum__ps
slums74623433slum___s
slurbs8439743slurb__s
slurs54123373slu___rs
slushes103514413slushe_s
snubber11277733snubber_
snuffers14326913snuffers
sobbers114114253s_obbers
sobers85218853s__obers
somber103713993s_omber_
sounders93214103sounders
souters74422583sou_ters
southers114214453southers
spammers14378693spammers
splurgers1253073splurgers
splutters11286263splutters
spudders12255633spudders
spumes1021314883spum_e_s
spumier1137903spumier_
spurners10288493spurners
spurrers10338453spurrers
spurters103311693spurters
sputters104012863sputters
squarers17338003squarers
stabbers12268723stabbers
stammers123611523stammers
stampers124211593stampers
stemmers12378443stemmers
stompers123610033stompers
strummers1333693strummers
studiers9236623studiers
stuffers14277383stuffers
stuivers11406673stuivers
stumbler1235813stumbler_
stumbles1237493stumbles
stumper113610093stumper_
stunners8277923stunners
stutters83210463stutters
suber74924503s_u_ber_
submerse1237633s_ubmerse
suckers133717623s_uckers
sudsers83310413s_udsers
suers55128483s_u__ers
suffers133113543s_uffers
suiters73618873s_uiters
sulkers113613343s_ulkers
sumless92611123s_umless
summer104017713s_ummer_
summery14329413s_ummery
sumpters1238023s_umpters
sunders84120053s_unders
supers84622403s_u_pers
suppers113314693s_uppers
surfers103614133s_urfers
surgers83517483s_urgers
sutlers73116973s_utlers
swabbers15316743swabbers
swampers15317473swampers
swimmers15276693swimmers
swobbers15355593swobbers
thumpers15365713thumpers
timbers113111833_timbers
tubbers113411243_tubbers
tubers85017023_tu_bers
tumblers123110623_tumblers
umbels104510583__umbels
umber94617583__umber_
unlimbers1342583unlimbers

Search took 9 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.1731032896.0
2DLD Change Limit1461623338.23317753.2
3Display Results3333330.1402378.6
 (SQL Overall)1786913338.54620909.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.