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

317 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
crumbers1433824(None) 
clumbers143910411clumbers
crumber13339641crumber_
cumbers134515411c_umbers
cambers134017442c_ambers
chambers173410622chambers
clambers144211292clambers
climbers14318412climbers
clubbers14378582clubbers
clumber134011442clumber_
combers134516622c_ombers
crabbers14358752crabbers
crambes1339962crambe_s
crammers14369352crammers
cribbers14306442cribbers
crimmers14298542crimmers
crimpers14318932crimpers
cruisers10438272cruisers
crullers1047302crullers
crumbed14378472crumbe_d
crumbier1456362crumbier_
crumbles14329682crumbles
crumbs12409232crumb__s
crumbums1642732crumbums
crumpets14335942crumpets
cruppers14317322cruppers
crushers134010092crushers
cubers105318352c_u_bers
cucumbers1742492cucumbers
cumber124016702c_umber_
cummers133713482c_ummers
curbers115514382c_urbers
drubbers13386032drubbers
drummers13316162drummers
grubbers13316202grubbers
grumblers14245022grumblers
lumbers113815912_lumbers
numbers113711242_numbers
plumbers14418512plumbers
rubbers113913192_rubbers
rumblers123610742_rumblers
rummers113513652_rummers
scrubbers1543362scrubbers
slumbers123110272slumbers
umbers104215212__umbers
ambers104519583__ambers
armers85520273ar_m_ers
blubbers11408143blubbers
bombers134512593_bombers
bribers114111493br_ibers
brimmers14287073brimmers
bruisers10307953bruisers
bruiters10329143bruiters
brumbies1436533brumbies
brumes106417073brum_e_s
brushers134210573brushers
bumblers143710733_bumblers
bummers133712443_bummers
bumpers133912053_bumpers
cabers105023923c__abers
calibers1238523calibers
camber124418483c_amber_
campers134220293c_ampers
caulkers14375653caulkers
causers94014793cau_sers
cerumens1235763cerum_ens
chamber164011063chamber_
chamfers18409223chamfers
champers173311623champers
chimers144515143chim_ers
chompers17369593chompers
chudders15235563chudders
chuggers1554863chuggers
chukkers1633483chukkers
chunters133910903chunters
churners13316893churners
clabbers14359903clabbers
clamber133311743clamber_
clammers143510693clammers
clampers143211893clampers
climber13449133climber_
clobbers14397513clobbers
clubber13319593clubber_
clunkers14327553clunkers
clusters102912403clusters
clutters103210353clutters
cobbers134114753c_obbers
comber125118503c_omber_
combes125321733c_ombe_s
comembers1744223comembers
comers105328083c_om_ers
coombes133810663coombe_s
corulers1039773coru_lers
couchers153513863couchers
coughers14399963coughers
coulters103614313coulters
counters103320193counters
couplers123311323couplers
couriers103213173couriers
coursers104412303coursers
courters103015373courters
couters93827303cou_ters
crabber133810733crabber_
crackers164111723crackers
cradlers11309203cradlers
crafters13419953crafters
crambe1239073crambe__
cramboes1436543cramboes
crambos1336783cramb_os
crammer134010963crammer_
crappers144011023crappers
crashers134013233crashers
craters95021893cr_aters
cravers124416553cr_avers
crawlers13309003crawlers
creamers124111303creamers
creasers103612823creasers
creepers12318623creepers
cremes104517993crem_e_s
cribber13367663cribber_
criers83918583cr__iers
crimes105521583crim_e_s
crimmer133310773crimmer_
crimper136510423crimper_
cringers112511873cringers
crispers12309433crispers
critters103511323critters
croakers14288523croakers
crofters13358903crofters
crooners103911393crooners
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
croupiers1334653croupiers
crowbars1544433crowbars
crowders14398803crowders
crowers124614893cr_owers
crowners133710743crowners
crozers184111083cr_ozers
croziers19287003croziers
cruces105117543cru_ce_s
crucifers1643333crucifers
cruder95612383cru_der_
crudes96218623cru_de_s
crueler939023crueler_
cruets85314953cru__ets
cruiser93410433cruiser_
cruises93514443cruise_s
cruller968753cruller_
crumb114313593crumb___
crumbiest1536253crumbiest
crumbing15267813crumbing
crumble133410403crumb_le
crumbled15357443crumbled
crumblier1543873crumblier_
crumbly16347523crumb_ly
crumbum1543743crumb_um
crumby15408113crumb__y
crumhorn1542883crumhorn
crumhorns1642343crumhorns
crummier1435603crummier_
crummies1437643crummies
crumped144311223crumpe_d
crumpet133711063crumpe_t
crumples14348813crumples
crumps124514343crum__ps
crunchers16316243crunchers
cruors838633cru__ors
crupper13338563crupper_
crusaders1243453crusaders
cruses88127713cru_se_s
crusets93811043cru_sets
crusher124412323crusher_
crushes124215133crushe_s
cruxes154911563cru_xe_s
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_
curdlers11368493curdlers
curers84923193c_u_rers
curlers94218073c_urlers
curriers103410753curriers
cursers94317163c_ursers
cussers94213403c_ussers
cutlers94217003c_utlers
cutters94218963c_utters
daubers104610423dau_bers
drubber12357863drubber_
drudgers11326853drudgers
drumbeat1343973drumbeat
drumbeats1442323drumbeats
drumbles13277723drumbles
drummer12407503drummer_
druthers1275793druthers
dubbers124011823_dubbers
dumber114414173_dumber_
dumpers123412663_dumpers
embers104116183__embers
encumbers1543793encumbers
flubbers15346893flubbers
framers125113823fram_ers
fruiters11328183fruiters
fumblers15318713_fumblers
fumers113613383_fum_ers
grabbers13337883grabbers
grubber12417913grubber_
grudgers11266753grudgers
gruelers936173gruelers
grumbler13866683grumbler_
grumbles13288873grumbles
grumes94415553grum_e_s
grummer12338783grummer_
grummets13275033grummets
grungers10298503grungers
grunters9359033grunters
gummers123712203_gummers
humblers15379803_humblers
hummers143813063_hummers
humpers142713523_humpers
incumbers1544003incumbers
jumblers19358323_jumblers
jumpers18399843_jumpers
krimmers16315673krimmers
krullers1234133krullers
lambers113817113_lambers
limbers113614743_limbers
lubbers113913723_lubbers
lumbars11289763_lumbars
lumber103817773_lumber_
lumpers113514483_lumpers
members13258603_members
mumblers14328763_mumblers
mummers103712843_mummers
mumpers133311373_mumpers
number103913223_number_
ombers104214403__ombers
ormers84316143or_m_ers
plumber13339983plumber_
plumbery17315533plumbery
plumpers14357293plumpers
premiers122911653premiers
prenumbers1642713prenumbers
primers114215673prim_ers
probers113514583pr_obers
pruners93710723pru_ners
pumpers133113673_pumpers
ramblers124010373_ramblers
rammers113715043_rammers
renumbers1344123renumbers
ribbers113913183_ribbers
rimers84522553_rim_ers
rimmers113812883_rimmers
robbers112814163_robbers
rompers113412243_rompers
rubber104715793_rubber_
rubbery14337593_rubbery
rubels84112993_ru_bels
rubes74928413_ru_be_s
rudders93210653_rudders
ruers515019413_ru__ers
ruggers94612313_ruggers
ruiners74213023_ruiners
rulers64317093_ru_lers
rumbas102512013_rumb_as
rumbler113514113_rumbler_
rumbles114018393_rumbles
rumens83611813_rum_ens
rummer104715483_rummer_
rumors81110403_rum_ors
rumours976373_rumours
runners74212453_runners
rushers103816103_rushers
scramblers16183543scramblers
scribers12307953scr_ibers
scrimpers1554633scrimpers
scrubber1434113scrubber_
scummers14277783scummers
slubbers12349943slubbers
slumber113811003slumber_
slumbery15296043slumbery
slummers12358933slummers
snubbers12326673snubbers
strummers1333693strummers
stumblers1334383stumblers
stumpers12318313stumpers
subers85722643_su_bers
summers113616503_summers
thrummers1642413thrummers
thumpers15365713thumpers
timbers113111853_timbers
trampers123210393trampers
tremblers1334483tremblers
trimers94615143trim_ers
trimmers12288913trimmers
truckers14279013truckers
trudgers10256863trudgers
trumpery1533613trumpery
trumpets12315573trumpets
trussers8348283trussers
trusters83112263trusters
tubbers113411253_tubbers
tubers85017033_tu_bers
tumblers123110623_tumblers
umbels104510593__umbels
umber94617593__umber_

Search took 10 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.1561145455.1
2DLD Change Limit1461623179.20315882.0
3Display Results3173170.1232577.2
 (SQL Overall)1786913179.48218845.3
 
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.