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

246 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
clubbers1437858(None) 
blubbers11408141blubbers
clabbers14359901clabbers
clobbers14397511clobbers
clubber13319591clubber_
clumbers143910411clumbers
flubbers15346891flubbers
lubbers113913721_lubbers
slubbers12349941slubbers
blabbers11308152blabbers
blubber10399292blubber_
blubbery14294782blubbery
clabber134210112clabber_
clambers144211292clambers
climbers14318412climbers
clobber13378162clobber_
clubbed14307452clubbe_d
clubbier1434832clubbier_
clumber134011442clumber_
clunkers14327552clunkers
clusters102912402clusters
clutters103210352clutters
cobbers134114752c_obbers
crabbers14358752crabbers
cribbers14306442cribbers
crumbers14338242crumbers
cubers105318352c_u_bers
cumbers134515412c_umbers
curbers115514382c_urbers
drubbers13386032drubbers
dubbers124011822_dubbers
flubber14287712flubber_
grubbers13316202grubbers
libbers113812832_libbers
lobbers113713942_lobbers
lubber104214622_lubber_
lumbers113815912_lumbers
plumbers14418512plumbers
rubbers113913192_rubbers
scrubbers1543372scrubbers
slabbers123610122slabbers
slobbers12398522slobbers
slubber113010762slubber_
slumbers123110272slumbers
snubbers12326672snubbers
tubbers113411252_tubbers
bibbers103911353_bibbers
blabber10418923blabber_
blubbed11338393blubbe_d
blubbered13164113blubbered
blubberer12173453blubberer
blubberers13162843blubberers
bluchers15359033bluchers
bludgers12397853bludgers
bluffers16405703bluffers
blunders113911343blunders
blungers11469843blungers
blurters10348373blurters
blushers133911293blushers
blusters104413893blusters
bobbers103614283_bobbers
bubblers11448943_bubblers
cabers105023923c__abers
cablers114416713c_ablers
calibers1238523calibers
cambers134017443c_ambers
caulkers14375653caulkers
causers94014793cau_sers
chambers173410623chambers
chubbier1733893chubbier_
chudders15235563chudders
chuggers1554863chuggers
chukkers1633483chukkers
chunters133910903chunters
churners13316893churners
clabbered16184763clabbered
clackers163911703clackers
claimers12298743claimers
clamber133311743clamber_
clammers143510693clammers
clampers143211893clampers
clangers114312343clangers
clappers143310833clappers
claquers19226203claquers
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
clavers124314903cl_avers
claviers1367103claviers
clawers123910973cl_awers
cleaners103610543cleaners
clearers10349303clearers
cleavers13398873cleavers
clickers163910203clickers
climber13449133climber_
clingers113810663clingers
clinkers14339833clinkers
clippers14368843clippers
clivers123411753cl_ivers
clobbered16164103clobbered
clockers16369813clockers
cloggers12437283cloggers
cloners94514823cl_oners
closers94415323cl_osers
clouters10399803clouters
clovers125114663cl_overs
clowders14357473clowders
clubbiest1534273clubbiest
clubbiness1642993clubbiness
clubbing15266513clubbing
clubbish1743813clubbish
clubby1534683clubb__y
clubfeet1543793clubfeet
clubhead1662773clubhead
clubheads1762483clubheads
clubmen1334253clubme_n
clubs95415103clu_b__s
clueless1035883clueless
clues74623033clu__e_s
clunker13419453clunker_
cluster94013333cluster_
clustery13317113clustery
clutter94211663clutter_
cluttery13346323cluttery
clysters13227843clysters
cobber124116843c_obber_
cobblers14359593cobblers
combers134516623c_ombers
couchers153513863couchers
coughers14399963coughers
coulters103614313coulters
counters103320193counters
couplers123311323couplers
couriers103213173couriers
coursers104412303coursers
courters103015373courters
couters93827303cou_ters
crabber133810733crabber_
cribber13367663cribber_
cruisers10438273cruisers
crullers1047303crullers
crumber13339643crumber_
cruppers14317323cruppers
crushers134010093crushers
cubbies133312883c_ubbies
cubebs12508683c_u_bebs
cuber95222533c_u_ber_
cubes95028163c_u_be_s
cucumbers1742493cucumbers
cudbears1343483c_udbears
cullers93418853c_ullers
culvers12329833c_ulvers
cumber124016703c_umber_
cummers133713483c_ummers
cunners93913473c_unners
cuppers133712213c_uppers
curber104517053c_urber_
curers84923193c_u_rers
curlers94218073c_urlers
cursers94317163c_ursers
cussers94213403c_ussers
cutlers94217003c_utlers
cutters94218963c_utters
dabbers123813213_dabbers
daubers104610423dau_bers
dibbers124013173_dibbers
dobbers123513253_dobbers
doublers11288503doublers
doubters11257393doubters
drubber12357863drubber_
dubber113814553_dubber_
eluders8409903elu_ders
fibbers144510603_fibbers
flubbed15306633flubbe_d
fluffers13335293fluffers
flunkers15347533flunkers
flushers14279733flushers
flusters113811503flusters
fluters103713683flu_ters
flutters114010823flutters
gabbers124612833_gabbers
gibbers124710983_gibbers
glibber1235163glibber_
gluers75011153glu__ers
grabbers13337883grabbers
grubber12417913grubber_
hobbers143512343_hobbers
jabbers183610583_jabbers
jibbers18449703_jibbers
jobbers182911133_jobbers
lambers113817113_lambers
libber104414013_libber_
libers84721443_l_ibers
limbers113614743_limbers
lobber104016603_lobber_
lobbyers1533193_lobbyers
lubberly1543663_lubberly
lubes74727993_lu_be_s
lugers74617023_lu_gers
luggers93713483_luggers
lullers73213353_lullers
lumbars11289763_lumbars
lumber103817773_lumber_
lumpers113514483_lumpers
lungers83817093_lungers
lunkers113414603_lunkers
lurers64217493_lu_rers
lurkers113910083_lurkers
lusters73921443_lusters
mobbers133610923_mobbers
nabbers113710463_nabbers
numbers113711243_numbers
pluckers16316553pluckers
pluggers12297023pluggers
plumber13339983plumber_
plumbery17315533plumbery
plumpers14357293plumpers
plunders11329833plunders
plungers11379403plungers
plunkers14328333plunkers
ribbers113913183_ribbers
robbers112814163_robbers
rubber104715793_rubber_
rubbery14337593_rubbery
scrubber1434123scrubber_
slabber113311393slabber_
slabbery15375773slabbery
slobber11388903slobber_
slobbery15375663slobbery
slubbed12339283slubbe_d
slubbered14175253slubbered
sluggers10348483sluggers
slumber113811003slumber_
slumbery15296043slumbery
slummers12358933slummers
snubber11277733snubber_
sobbers114114263_sobbers
stabbers12268733stabbers
subers85722643_su_bers
swabbers15316743swabbers
swobbers15355593swobbers
tubber104313203_tubber_
tubers85017033_tu_bers
umbers104215213__umbers
yabbers14389353_yabbers

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 Limit1461622467.37619815.9
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.87522690.9
 
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.