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

195 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
scumble133701(None) 
scumbled1535051scumbled
scumbles1447021scumbles
stumble1147551stumble
bumble124216892_bumble
crumble133410402crumble
drumble12337892drumble
fumble133214262_fumble
grumble12349232grumble
humble133615052_humble
jumble174012652_jumble
mumble123614342_mumble
rumble103718812_rumble
scabble13168652scabble
scramble14177252scramble
scuffle15266892scuffle
scumbag1443572scumbag
scuttle936462scuttle
shamble14149262shamble
stubble1136842stubble
stumbled1335622stumbled
stumbler1235812stumbler
stumbles1237492stumbles
suable83920552s_uable
tumble103215642_tumble
abubble1044523abubble
actable11313473actable
amble95924643__amble
assemble1254823assemble
assumable1344543assumable
bauble103813213bau_ble
bejumble2172773bejumble
bramble133710033bramble
bubble94016593_bubble
bumbled144113043_bumbled
bumbler134013233_bumbler
bumbles134016843_bumbles
burble104617703_burble
cable95329913_c_able
cobble123615263_cobble
coble94823173_c_oble
combe116223543_comb_e
crumbled15357443crumbled
crumbles14329683crumbles
crumbly16347523crumbly
crumple13368363crumple
cube85830213_cu_b_e
cuddle104414533_cuddle
cumber124016703_cumber
cumbia12379893_cumbia
cumuli1036273_cumuli
cupule103410723_cupule
curable112414513_curable
curdle95514313_curdle
curule83614123_curule
cuttle84113893_cuttle
double94013993dou_ble
drumbled14266033drumbled
drumbles13277723drumbles
dumbly14399603_dumbly
equable1849253equable
fimble133611753_fimble
fumbled153710493_fumbled
fumbler143610813_fumbler
fumbles143514413_fumbles
gamble115417183_gamble
grumbled14256753grumbled
grumbler13866683grumbler
grumbles13288873grumbles
grumbly15355403grumbly
humbled153711813_humbled
humbler143411943_humbler
humbles143215803_humbles
humbly164010523_humbly
issuable1046873issuable
jumbled19379963_jumbled
jumbler183910273_jumbler
jumbles183013323_jumbles
mumbled143010763_mumbled
mumbler133510913_mumbler
mumbles133014433_mumbles
mumbly15319463_mumbly
nimble103412943_nimble
nubble103813713_nubble
numbles113814273_numbles
numbly134410663_numbly
oscule838193oscu__le
plumule1134303plumule
ramble104519973_ramble
rescuable1347583rescuable
rouble83913313rou_ble
rubble104315673_rubble
ruble74521253_ru_ble
rumbled124514593_rumbled
rumbler113514113_rumbler
rumbles114018393_rumbles
rumbly134412163_rumbly
rumple103913013_rumple
sable74732163s__able
salable91415463salable
sample104215013s_ample
savable121711863savable
sayable121411613sayable
scabbled15156303scabbled
scabbles14167983scabbles
scalable121710233scalable
scale74629143sc__ale
schmalz2345293schmalz
schmelze2443153schmelze
schmoe13328333schm_oe
scrabble14196993scrabble
scrambled16164813scrambled
scrambler15165043scrambler
scrambles15146383scrambles
scribble14175433scribble
scribe104613533scrib_e
scruple1137193scruple
scrutable1346043scrutable
scuba94211593scu_b_a
scubaed1236123scu_baed
scubas103710223scu_bas
scuffled17256203scuffled
scuffler16286703scuffler
scuffles16287863scuffles
sculk115112463scu__lk
scull75315763scu__ll
sculled102911693scu_lled
sculler99812153scu_ller
sculls84613883scu_lls
sculp95314843scu__lp
scum85924523scum___
scumbags1543203scumbags
scumbling1634423scumbling
scumless1254993scum_less
scumlike1644353scumlike
scummed14347913scummed
scummer13398753scummer
scummier1445083scummier
scummily1743303scummily
scummy15265223scum_my
scums95017423scum__s
scurrile1055073scurrile
scutage1036333scutage
scutate9310323scutate
scute75520943scu__te
scuttled1134533scuttled
scuttles1056503scuttles
securable1347773securable
seeable91113943seeable
semple103212753s_emple
sewable121911173sewable
shamable15168803shamable
shambled16156153shambled
shambles15159043shambles
shuffle16276923shuffle
shuttle1046103shuttle
simile83115633s_imile
simple104315173s_imple
sizable1839893sizable
skiable1338883skiable
slumber113811003slumber
smile74823923s__mile
smuggle11265013smuggle
snuffle13267833snuffle
snuggle9275713snuggle
sociable1239503sociable
soluble966103soluble
sombre10729473s_ombre
souffle13306803souffle
sowable121610753sowable
spume95817313spum__e
spumone1154383spumone
spurtle937453spurtle
squabble2143883squabble
stable83921643s_table
stubbled1385073stubbled
stubbles1236843stubbles
stubbly1444473stubbly
stumblers1334383stumblers
suably112814533s_uably
sublet82827243s_u_blet
subtle82113433s_ubtle
suckle124015963s_uckle
summable1436903summable
summae103911013s_ummae
supple10410203s_upple
thimble1435873thimble
tremble1138003tremble
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.516346300.4
2DLD Change Limit1340271955.95322514.2
3Display Results1951950.0802437.5
 (SQL Overall)1786911956.54927285.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.