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

216 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
crumbled1535744(None) 
crumbed14378471crumb_ed
crumble133410401crumble_
crumbles14329681crumbles
crumpled15296871crumpled
drumbled14266031drumbled
grumbled14256751grumbled
rumbled124514591_rumbled
brambled15316732brambled
bumbled144113042_bumbled
cribbled15305802cribbled
crimpled15366932crimpled
crumber13339642crumb_er
crumbier1456362crumbier
crumblier1543872crumblier
crumbly16347522crumbl_y
crumped144311222crum_ped
crumple13368362crumple_
crumples14348812crumples
drumble12337892drumble_
drumbles13277722drumbles
fumbled153710492_fumbled
grumble12349232grumble_
grumbler13866682grumbler
grumbles13288872grumbles
humbled153711812_humbled
jumbled19379962_jumbled
mumbled143010762_mumbled
rambled123913522_rambled
rubbled124611622_rubbled
rumbaed12287492_rumbaed
rumble103718812_rumble_
rumbler113514112_rumbler
rumbles114018392_rumbles
rumpled123810012_rumpled
scrambled16164812scrambled
scumbled1535052scumbled
stumbled1335622stumbled
trembled1335252trembled
tumbled123412242_tumbled
ambled115116373__ambled
bejumbled23102043bejumbled
brabbled12337633brabbled
bramble133710033bramble_
brambles14308973brambles
brumbies1436533brumbies
bubbled113612123_bubbled
bumble124216893_bumble_
bumbler134013233_bumbler
bumbles134016843_bumbles
burbled124312673_burbled
cabled114819873c__abled
chimbley2063133chimbley
chuckled2045163chuckled
chummed17396443chum_med
chumped17379493chum_ped
climbed14336983climb_ed
clubbed14307453clu_bbed
clumber134011443clumb_er
clumped143610663clum_ped
cobbled143411633c_obbled
combed135516543c_omb_ed
corymbed1842613corymb_ed
coupled124312673cou_pled
craaled10339423cr_aaled
crabbed14388873cr_abbed
crackled17428863crackled
cradled113410813cr_adled
crambe1239073cramb_e_
crambes1339963cramb_es
cramboes1436543cramboes
crammed143710123cram_med
cramped144712183cram_ped
crankled15408153crankled
crawled133710403cr_awled
creeled104012013cr_eeled
cremated133412963cremated
creneled11326893creneled
cribbed14407663cr_ibbed
crimped143910763crim_ped
crimple13408693crimple_
crimples14308963crimples
crinkled15357153crinkled
crippled15336793crippled
crucible1445193crucible_
crucibles1543743crucibles
crudded1235733cru_dded
crueler939023cru_eler
crueller1056453crueller
cruised103710213cru_ised
cruller968753cru_ller
crumb114313593crumb___
crumbers14338243crumbers
crumbiest1536253crumbiest
crumbing15267813crumbing
crumbliest1643903crumbliest
crumbling1655083crumbling
crumbs12409233crumb__s
crumbum1543743crumb_um
crumbums1642733crumbums
crumby15408113crumb__y
crummie1336153crummie_
crummier1435603crummier
crummies1437643crummies
crumpet133711063crum_pet
crumplier1543783crumplier
crumply16336093crumpl_y
crunched16328163crunched
crusaded1244233crusaded
crushed134111963cru_shed
crusted103712753cru_sted
crutched16307463crutched
cubed105519703c_u_b_ed
cuddled124110763c_uddled
culled94022473c_u_lled
cumber124016703c_umb_er
cumbered15157963c_umbered
cupeled1257793c_upeled
curable112414513curable_
curbed114615873c_urb_ed
curdled113910663c_urdled
curled95021653c_u_rled
cuttled10319933c_uttled
doubled11289953dou_bled
drabbled14367053drabbled
dribbled14376593dribbled
drubbed13406983dru_bbed
drummed13306323drum_med
dumbed124012083_dumb_ed
fribbled16305743fribbled
fumble133214263_fumble_
fumbler143610813_fumbler
fumbles143514413_fumbles
gambled134112163_gambled
grabbled14327373grabbled
grubbed13406433gru_bbed
grueled937133gru_eled
gruelled1034893gruelled
grumblers14245023grumblers
grumbly15355403grumbl_y
grumped13337333grum_ped
gruntled10274943gruntled
humble133615053_humble_
humbler143411943_humbler
humbles143215803_humbles
jumble174012653_jumble_
jumbler183910273_jumbler
jumbles183013323_jumbles
mumble123614343_mumble_
mumbler133510913_mumbler
mumbles133014433_mumbles
numbed114111443_numb_ed
numbles113814273_numbles
plumbed14317273plumb_ed
preambled1643893preambled
rabbled123514423_rabbled
ramble104519973_ramble_
rambler113313263_rambler
rambles113118313_rambles
rhumbaed1672753rhumbaed
rimpled123311423_rimpled
rubbed114515083_ru_bbed
rubble104315673_rubble_
rubbles113715113_rubbles
rubied94312413_ru_bied
ruble74521253_ru_ble_
rubles83921703_ru_bles
ruckled144111033_ruckled
ruddled103010873_ruddled
ruffled14369153_ruffled
ruled65822523_ru__led
rumblers123610743_rumblers
rumbly134412163_rumbl_y
rumored1046643_rumored
rumple103913013_rumple_
rumples113313133_rumples
runkled12399013_runkled
rustled83311323_rustled
scrabbled16154973scrabbled
scramble14177253scramble_
scrambler15165043scrambler
scrambles15146383scrambles
scribbled16174033scribbled
scrubbed1533853scru_bbed
scrummed1554313scrum_med
scrupled1335823scru_pled
scumble1337013scumble_
scumbles1447023scumbles
shambled16156153shambled
stubbled1385073stubbled
stumble1147553stumble_
stumbler1235813stumbler
stumbles1237493stumbles
thumbed15336173thumb_ed
trameled11309073trameled
trampled13247903trampled
trebled1038483tr_ebled
tremble1138003tremble_
trembler1235363trembler
trembles1237353trembles
troubled1134983troubled
truckled15327313truckled
truebred1142753truebred
truffled1563993truffled
trumped12439713trum_ped
trundled10306393trundled
tumble103215643_tumble_
tumbler113412823_tumbler
tumbles113816023_tumbles
umbeled12208193__umbeled
umbles103817493__umbles
uncrumpled1742403uncrumpled
unhumbled1743073unhumbled
unrumpled1443673unrumpled
wambled153610753_wambled
wimbled15298153_wimbled

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.406440125.6
2DLD Change Limit1461622166.32623105.0
3Display Results2162160.0962250.0
 (SQL Overall)1786912166.82826170.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.