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

230 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
drumble1233789(None) 
crumble133410401crumble
drumbled14266031drumbled
drumbles13277721drumbles
grumble12349231grumble
rumble103718811_rumble
bramble133710032bramble
bumble124216892_bumble
crumbled15357442crumbled
crumbles14329682crumbles
crumbly16347522crumbly
crumple13368362crumple
double94013992dou_ble
drabble12238882drabble
dribble12368602dribble
drumly1235702drum_ly
dryable13237432dryable
dumbly14399602d_umbly
durable102312722durable
fumble133214262_fumble
grumbled14256752grumbled
grumbler13866682grumbler
grumbles13288872grumbles
grumbly15355402grumbly
humble133615052_humble
jumble174012652_jumble
mumble123614342_mumble
ramble104519972_ramble
rubble104315672_rubble
ruble74521252_ru_ble
rumbled124514592_rumbled
rumbler113514112_rumbler
rumbles114018392_rumbles
rumbly134412162_rumbly
rumple103913012_rumple
scumble1337012scumble
stumble1147552stumble
tremble1138002tremble
tumble103215642_tumble
abubble1044523abubble
amble95924643__amble
arable81821003ar_able
arguable1135903arguable
atremble1244113atremble
bauble103813213bau_ble
bejumble2172773bejumble
brabble10349973brabble
brambled15316733brambled
brambles14308973brambles
brambly16296253brambly
brumal1049503brumal_
brumbies1436533brumbies
brumby15385953brumb_y
brume95817983brum__e
bubble94016593_bubble
bumbled144113043_bumbled
bumbler134013233_bumbler
bumbles134016843_bumbles
burble104617703_burble
crambe1239073cramb_e
crimple13408693crimple
crucible1445193crucible
crumb114313593crumb__
crumbed14378473crumbed
crumber13339643crumber
crumbier1456363crumbier
crumblier1543873crumblier
crumbs12409233crumb_s
crumbum1543743crumbum
crumby15408113crumb_y
crummie1336153crummie
crumpled15296873crumpled
crumples14348813crumples
crumply16336093crumply
curable112414513curable
dabble114515193d_abble
datable101714233datable
daube85015303dau_b_e
dibble114013843d_ibble
dimmable1536113dimmable
dimple113512793d_imple
disable10516433disable
doable93115243d_oable
doubled11289953dou_bled
doubler103110083dou_bler
doubles103113353dou_bles
doublet103914033dou_blet
doubly12328963dou_bly
dowable13189453dowable
drabbled14367053drabbled
drabbles13308523drabbles
drably123511613dr_ably
draggle1056103draggle
drapable1377573drapable
drawable1467113drawable
dribbled14376593dribbled
dribbler13316313dribbler
dribbles13348393dribbles
dribblet13347543dribblet
dribbly15274953dribbly
driblet103712243dr_iblet
drivable1438023drivable
drizzle16285913drizzle
drub75920133dru_b__
drubbed13406983drubbed
drubber12357863drubber
drubs85913833dru_b_s
drudge9317903dru_dge
druggie10134073druggie
drum76521593drum___
drumbeat1343973drumbeat
drumbling1544033drumbling
drumfire1442543drumfire
drumlier1134523drumlier
drumlike1543793drumlike
drumlin1044423drumlin
drummed13306323drummed
drummer12407503drummer
drumroll1141773drumroll
drums85415873drum__s
drupe85012993dru__pe
drupelet1145663drupelet
druse64817663dru__se
duffle13368533d_uffle
dumb97124103d_umb__
dumbed124012083d_umbed
dumber114414173d_umber
dumbo105614063d_umb_o
dumbos114111083d_umbos
dumbs105915753d_umb_s
dupable12238383dupable
duple85315863d_u_ple
durables11237013durables
durably13229053durably
dyable12308983d_yable
dyeable1337303dyeable
equable1849253equable
errable9312183errable
fimble133611753_fimble
framable1537573framable
friable122612563friable
fribble14287783fribble
fryable15277463fryable
fumbled153710493_fumbled
fumbler143610813_fumbler
fumbles143514413_fumbles
gamble115417183_gamble
grabble12339643grabble
gribble12297273gribble
grumblers14245023grumblers
grume86218163grum__e
grumose1035723grumose
gruntle8257053gruntle
humbled153711813_humbled
humbler143411943_humbler
humbles143215803_humbles
humbly164010523_humbly
jumbled19379963_jumbled
jumbler183910273_jumbler
jumbles183013323_jumbles
mumbled143010763_mumbled
mumbler133510913_mumbler
mumbles133014433_mumbles
mumbly15319463_mumbly
nimble103412943_nimble
nubble103813713_nubble
numbles113814273_numbles
numbly134410663_numbly
plumule1134303plumule
preamble1436383preamble
prunable1237843prunable
rabble103818243_rabble
rambla103510933_rambla
rambled123913523_rambled
rambler113313263_rambler
rambles113118313_rambles
rimple103814583_rimple
roble75223023_r_oble
rouble83913313_rouble
rubbled124611623_rubbled
rubbles113715113_rubbles
rubbly133710613_rubbly
rube65532013_ru_b_e
rubel75416833_ru_bel
rubles83921703_ru_bles
ruckle124414583_ruckle
ruddle83414203_ruddle
ruffle124111673_ruffle
rulable9310533_rulable
rule49938423_ru__le
rumba93612513_rumb_a
rumbaed12287493_rumbaed
rumbas102512013_rumbas
rumblers123610743_rumblers
rumpled123810013_rumpled
rumples113313133_rumples
rumply13348573_rumply
rundle73214233_rundle
runkle103611543_runkle
rustle63615413_rustle
rutile65217683_rutile
scramble14177253scramble
scumbled1535053scumbled
scumbles1447023scumbles
shamble14149263shamble
stubble1136843stubble
stumbled1335623stumbled
stumbler1235813stumbler
stumbles1237493stumbles
suable83920553_suable
thimble1435873thimble
trample11299703trample
treble8311663tr_eble
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
triable92515393triable
trouble957713trouble
truckle13358863truckle
trueblue1042163trueblue
truffle1384893truffle
trundle8307873trundle
tumbled123412243_tumbled
tumbler113412823_tumbler
tumbles113816023_tumbles
umbel93612843__umbel
umbles103817493__umbles
wamble134415753_wamble
wimble133211923_wimble

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272305.84322938.0
3Display Results2302300.0763026.3
 (SQL Overall)1786912306.07529414.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.