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

313 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
clumbers14391041(None) 
clambers144211291clambers
climbers14318411climbers
clubbers14378581clubbers
clumber134011441clumber_
crumbers14338241crumbers
cumbers134515411c_umbers
lumbers113815911_lumbers
plumbers14418511plumbers
slumbers123110271slumbers
blubbers11408142blubbers
cambers134017442c_ambers
chambers173410622chambers
clabbers14359902clabbers
clamber133311742clamber_
clammers143510692clammers
clampers143211892clampers
climber13449132climber_
clobbers14397512clobbers
clubber13319592clubber_
clunkers14327552clunkers
clusters102912402clusters
clutters103210352clutters
combers134516622c_ombers
crumber13339642crumber_
cubers105318352c_u_bers
cucumbers1742492cucumbers
cumber124016702c_umber_
cummers133713482c_ummers
curbers115514382c_urbers
flubbers15346892flubbers
lambers113817112_lambers
limbers113614742_limbers
lubbers113913722_lubbers
lumbars11289762_lumbars
lumber103817772_lumber_
lumpers113514482_lumpers
numbers113711242_numbers
plumber13339982plumber_
plumbery17315532plumbery
plumpers14357292plumpers
slubbers12349942slubbers
slumber113811002slumber_
slumbery15296042slumbery
slummers12358932slummers
umbers104215212__umbers
almners9399563al_mners
ambers104519583__ambers
blabbers11308153blabbers
blamers115314213blam_ers
blubber10399293blubber_
blubbery14294783blubbery
bluchers15359033bluchers
bludgers12397853bludgers
bluffers16405703bluffers
blumes105917793blum_e_s
blunders113911343blunders
blungers11469843blungers
blurters10348373blurters
blushers133911293blushers
blusters104413893blusters
bombers134512593_bombers
bumblers143710733_bumblers
bummers133712443_bummers
bumpers133912053_bumpers
cabers105023923c__abers
calibers1238523calibers
calumets1236283calum_ets
camber124418483c_amber_
campers134220293c_ampers
caulkers14375653caulkers
causers94014793cau_sers
chamber164011063chamber_
chamfers18409223chamfers
champers173311623champers
chimers144515143chim_ers
chompers17369593chompers
chudders15235563chudders
chuggers1554863chuggers
chukkers1633483chukkers
chunters133910903chunters
churners13316893churners
clabber134210113clabber_
clackers163911703clackers
claimers12298743claimers
clambered16146133clambered
clamberer15185273clamberer
clamberers16174113clamberers
clammer134211793clammer_
clamorers1345783clamorers
clamors11710093clam_ors
clamours1255993clamours
clamper134012993clamper_
clangers114312343clangers
clappers143310833clappers
claquers19226203claquers
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
clavers124314903cl_avers
claviers1367103claviers
clawers123910973cl_awers
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
clickers163910203clickers
climbed14336983climbe_d
climbs12498723climb__s
climes104720003clim_e_s
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cl_ivers
clobber13378163clobber_
clockers16369813clockers
cloggers12437283cloggers
cloners94514823cl_oners
closers94415323cl_osers
clouters10399803clouters
clovers125114663cl_overs
clowders14357473clowders
clubbed14307453clubbe_d
clubbier1434833clubbier_
clubmen1334253clubme_n
clubs95415103clu_b__s
clueless1035883clueless
clues74623033clu__e_s
clumped143610663clumpe_d
clumpier1435583clumpier_
clumps1215314643clum__ps
clumsier1234733clumsier_
clunker13419453clunker_
cluster94013333cluster_
clustery13317113clustery
clutter94211663clutter_
cluttery13346323cluttery
clysters13227843clysters
cobbers134114753c_obbers
columbary1842963columbary
columels1244813colum_els
columneas1343013columneas
comber125118503c_omber_
combes125321733c_ombe_s
comembers1744223comembers
comers105328083c_om_ers
coombes133810663coombe_s
couchers153513863couchers
coughers14399963coughers
coulters103614313coulters
counters103320193counters
couplers123311323couplers
couriers103213173couriers
coursers104412303coursers
courters103015373courters
couters93827303cou_ters
crabbers14358753crabbers
crambes1339963crambe_s
crammers14369353crammers
cribbers14306443cribbers
crimmers14298543crimmers
crimpers14318933crimpers
cruisers10438273cruisers
crullers1047303crullers
crumbed14378473crumbe_d
crumbier1456363crumbier_
crumbles14329683crumbles
crumbs12409233crumb__s
crumbums1642733crumbums
crumpets14335943crumpets
cruppers14317323cruppers
crushers134010093crushers
cubebs12508683c_u_bebs
cuber95222533c_u_ber_
cubes95028163c_u_be_s
cucumber1642603cucumber_
cudbears1343483c_udbears
cullers93418853c_ullers
culvers12329833c_ulvers
cumbered15157963c_umbered
cumberer14266993c_umberer
cumberers15176003c_umberers
cumbias13338963c_umbias
cummer124414593c_ummer_
cunners93913473c_unners
cuppers133712213c_uppers
curber104517053c_urber_
curers84923193c_u_rers
curlers94218073c_urlers
cursers94317163c_ursers
cussers94213403c_ussers
cutlers94217003c_utlers
cutters94218963c_utters
daubers104610423dau_bers
drubbers13386033drubbers
drummers13316163drummers
dubbers124011823_dubbers
dumber114414173_dumber_
dumpers123412663_dumpers
eluders8409903elu_ders
embers104116183__embers
encumbers1543793encumbers
flambes14419503flambe_s
flamers124616363flam_ers
flubber14287713flubber_
fluffers13335293fluffers
flumes115119733flum_e_s
flummery1833053flummery
flunkers15347533flunkers
flushers14279733flushers
flusters113811503flusters
fluters103713683flu_ters
flutters114010823flutters
fumblers15318713_fumblers
fumers113613383_fum_ers
glimmers13396153glimmers
gluers75011153glu__ers
glumes94516813glum_e_s
glummer12417983glummer_
glumness1135203glumness
grubbers13316203grubbers
grumblers14245023grumblers
gummers123712203_gummers
humblers15379803_humblers
hummers143813063_hummers
humpers142713523_humpers
incumbers1544003incumbers
jumblers19358323_jumblers
jumpers18399843_jumpers
lamber104418493_lamber_
lambert113617113_lambert
lamberts12348793_lamberts
lampers113817333_lampers
libbers113812833_libbers
libers84721443_l_ibers
limber104316793_limber_
limmers113413083_limmers
limners93311563_limners
limpers113815223_limpers
lobbers113713943_lobbers
lubber104214623_lubber_
lubes74727993_lu_be_s
lugers74617023_lu_gers
luggers93713483_luggers
lullers73213353_lullers
lumbar103610593_lumbar_
lumbered13188233_lumbered
lumberer12177583_lumberer
lumberers13196013_lumberers
lumberly1544683_lumberly
lumens85013973_lum_ens
lumpens11298263_lumpens
lumper103816653_lumper_
lungers83817093_lungers
lunkers113414603_lunkers
lurers64217493_lu_rers
lurkers113910083_lurkers
lusters73921443_lusters
members13258603_members
mumblers14328763_mumblers
mummers103712843_mummers
mumpers133311373_mumpers
number103913223_number_
ombers104214403__ombers
pluckers16316553pluckers
pluggers12297023pluggers
plumbed14317273plumbe_d
plumbeous1542903plumbeous
plumberies1645123plumberies
plumbness1543133plumbness
plumbous1444283plumbous
plumbs12459333plumb__s
plumbums1642943plumbums
plumes104318133plum_e_s
plumier113510043plumier_
plummer13298523plummer_
plummets14304773plummets
plumpens14304953plumpens
plumper13318773plumper_
plunders11329833plunders
plungers11379403plungers
plunkers14328333plunkers
pumpers133113673_pumpers
renumbers1344123renumbers
rubbers113913193_rubbers
rumblers123610743_rumblers
rummers113513653_rummers
scrubbers1543373scrubbers
scummers14277783scummers
slabbers123610123slabbers
slammers123511223slammers
slimmers12369633slimmers
slobbers12398523slobbers
slubber113010763slubber_
sluggers10348483sluggers
slumbered14215593slumbered
slumberer13194803slumberer
slumberers14203683slumberers
slumberous1443363slumberous
slummer113711203slummer_
snubbers12326673snubbers
stumblers1334383stumblers
stumpers12318313stumpers
subers85722643_su_bers
summers113616503_summers
thumpers15365713thumpers
timbers113111853_timbers
tubbers113411253_tubbers
tubers85017033_tu_bers
tumblers123110623_tumblers
umbels104510593__umbels
umber94617593__umber_
unlimbers1342583unlimbers

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.406440125.6
2DLD Change Limit1461623136.78321548.3
3Display Results3133130.1102845.5
 (SQL Overall)1786913137.29924481.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.