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

219 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
flubbers1534689(None) 
blubbers11408141blubbers
clubbers14378581clubbers
flubber14287711flubber_
lubbers113913721_lubbers
slubbers12349941slubbers
blabbers11308152blabbers
blubber10399292blubber_
blubbery14294782blubbery
clabbers14359902clabbers
clobbers14397512clobbers
clubber13319592clubber_
clumbers143910412clumbers
drubbers13386032drubbers
dubbers124011822_dubbers
fibbers144510602f_ibbers
flubbed15306632flubbe_d
fluffers13335292fluffers
flunkers15347532flunkers
flushers14279732flushers
flusters113811502flusters
fluters103713682flu_ters
flutters114010822flutters
grubbers13316202grubbers
libbers113812832_libbers
lobbers113713942_lobbers
lubber104214622_lubber_
lumbers113815912_lumbers
plumbers14418512plumbers
rubbers113913192_rubbers
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
clabber134210113clabber_
clambers144211293clambers
climbers14318413climbers
clobber13378163clobber_
clubbed14307453clubbe_d
clubbier1434833clubbier_
clumber134011443clumber_
clunkers14327553clunkers
clusters102912403clusters
clutters103210353clutters
cobbers134114753_cobbers
crabbers14358753crabbers
cribbers14306443cribbers
crumbers14338243crumbers
cubers105318353_cu_bers
cumbers134515413_cumbers
curbers115514383_curbers
dabbers123813213_dabbers
daubers104610423dau_bers
dibbers124013173_dibbers
dobbers123513253_dobbers
doublers11288503doublers
doubters11257393doubters
drubber12357863drubber_
dubber113814553_dubber_
eluders8409903elu_ders
fabber134814113f_abber_
fablers124812613f_ablers
fibber134811933f_ibber_
fibers114717523f__ibers
flabbier1534093flabbier_
flaggers13328073flaggers
flakers143613273fl_akers
flambes14419503flambe_s
flamers124616363fl_amers
flangers123311373flangers
flankers15349303flankers
flappers15388383flappers
flashers143912653flashers
flatbeds14364543flatbeds
flatters113814203flatters
flaunters1234513flaunters
flayers133912033fl_ayers
fleecers13325933fleecers
fleers96015793fl__eers
flensers1135463flensers
fleshers14339443fleshers
flickers17338883flickers
fliers94417193fl__iers
flinders12439263flinders
flingers123410193flingers
flippers15338003flippers
flirters11337933flirters
flitters114312173flitters
flivvers1733113flivvers
floaters112711513floaters
floggers13387863floggers
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
flossers11307863flossers
flounders1374613flounders
flouters11419273flouters
flowers133413173fl_owers
flubbing16275883flubbing
flubdubs1641513flubdubs
flubs105515443flu_b__s
flues84626923flu__e_s
fluffer12336503fluffer_
flukes135114193flu_ke_s
flukier14397853flukier_
flumes115119733flu_me_s
flummery1833053flummery
flunker14389363flunker_
flunkeys18263173flunkeys
fluors94311373flu__ors
flusher133012273flusher_
flushes134114143flushe_s
fluster103913063fluster_
fluter95316863flu_ter_
flutes95421783flu_te_s
flutier103011553flutier_
flutter104012093flutter_
fluttery14376143fluttery
fluxes165212933flu_xe_s
flyers125712803fl__yers
flyovers1733673flyovers
flytiers14254483flytiers
founders123911673founders
fribblers16314193fribblers
fruiters11328183fruiters
fubbed144711243f_ubbe_d
fuckers163611593f_uckers
fuelers103912393f_uelers
fuhrers1334813f_uhrers
fullers103817373f_ullers
fumblers15318713fumblers
fumers113613383f_u_mers
funders113813933f_unders
funkers143712063f_unkers
furlers104214223f_urlers
fussers104210813f_ussers
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
scrubbers1543373scrubbers
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 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.436409841.7
2DLD Change Limit1461622196.03324227.1
3Display Results2192190.0932354.8
 (SQL Overall)1786912196.56227231.2
 
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.