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 “grumbles” 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
grumbles1328887(None) 
crumbles14329681crumbles
drumbles13277721drumbles
grumble12349231grumble_
grumbled14256751grumbled
grumbler13866681grumbler
grumblers14245021grumblers
rumbles114018391_rumbles
brambles14308972brambles
brumbies1436532brumbies
bumbles134016842_bumbles
crumble133410402crumble_
crumbled15357442crumbled
crumples14348812crumples
drumble12337892drumble_
drumbled14266032drumbled
fumbles143514412_fumbles
gambles124016202g_ambles
grabbles13339892grabbles
gribbles13307362gribbles
grumbly15355402grumbl_y
grumes94415552grum__es
gruntles9287232gruntles
humbles143215802_humbles
jumbles183013322_jumbles
mumbles133014432_mumbles
numbles113814272_numbles
rambles113118312_rambles
rubbles113715112_rubbles
rubles83921702_ru_bles
rumble103718812_rumble_
rumbled124514592_rumbled
rumbler113514112_rumbler
rumblers123610742_rumblers
rumples113313132_rumples
scumbles1447022scumbles
stumbles1237492stumbles
trembles1237352trembles
tumbles113816022_tumbles
umbles103817482__umbles
ambles105121853__ambles
arables91814973ar_ables
baubles113611863bau_bles
bejumbles22122443bejumbles
brabbles11349753brabbles
bramble133710033bramble_
brambled15316723brambled
brumes106417073brum__es
bubbles104315963_bubbles
bumble124216893_bumble_
bumbled144113043_bumbled
bumbler134013233_bumbler
bumblers143710733_bumblers
burbles114916803_burbles
crambes1339953cramb_es
cramboes1436543cramboes
crimples14308963crimples
crucibles1543743crucibles
crumbed14378473crumb_ed
crumber13339643crumb_er
crumbers14338223crumbers
crumbier1456363crumbier
crumbiest1536253crumbiest
crumblier1543873crumblier
crumbliest1643893crumbliest
crumbly16347523crumbl_y
crumbs12409233crumb__s
crumbums1642733crumbums
crummies1437643crummies
crumple13368363crumple_
crumpled15296873crumpled
doubles103113353dou_bles
drabbles13308523drabbles
dribbles13348393dribbles
durables11237013durables
fimbles143510653_fimbles
fribbles15287713fribbles
fumble133214263_fumble_
fumbled153710493_fumbled
fumbler143610813_fumbler
fumblers15318713_fumblers
gabbles124415413g_abbles
gables94222333g__ables
gambes116318313g_amb_es
gamble115417183g_amble_
gambled134112163g_ambled
gambler123612683g_ambler
gamblers13369733g_amblers
garbles104016923g_arbles
gemmules13183213gemmules
glumes94516813glum__es
gobbles123512583g_obbles
grabble12339643grabble_
grabbled14327373grabbled
grabbler13377693grabbler
grabblers14345513grabblers
graciles112511613graciles
grackles15309183grackles
grammes123611323gram_mes
granules939933granules
grapples13348123grapples
grebes93813613gr_eb_es
gremmies1355993gremmies
gribble12297273gribble_
griddles1145753griddles
grilles83715023gr_illes
grimaces1355383grimaces
grimes94619033grim__es
gristles9189203gristles
grizzles17286193grizzles
grubbed13406433gru_bbed
grubber12417913gru_bber
grubbers13316193grubbers
grubbier13344753grubbier
grubbiest1434253grubbiest
grubs86312603gru_b__s
grudges10349423gru_dges
grueled937133gru_eled
grueler837023gru_eler
gruelers936173gru_elers
gruelled1034893gruelled
grueller935333grueller
gruellers1034183gruellers
gruels73910153gru_el_s
grues65721963gru___es
grumbling1544083grumbling
grume86218163grum__e_
grummer12338783grum_mer
grummest13286363grum_mest
grummet12298873grum_met
grummets13275033grummets
grumose1035723grumose_
grumous1086603grum_ous
grumped13337333grum_ped
grumphies1743653grumphies
grumpier1334803grumpier
grumpiest1435023grumpiest
grumps114510573grum__ps
grunges93310403gru_nges
gruntle8257053gruntle_
gruntled10274943gruntled
grutches14285853grutches
gruyeres1242863gruyeres
guggles103410543g_uggles
guiles73919283g_u_iles
gules64831043g_u__les
gumballs1345313g_umballs
gumbos114610873g_umb_os
gumless10228273g_um_less
gurgles94312873g_urgles
guttles83011933g_uttles
guzzles16328043g_uzzles
humble133615053_humble_
humbled153711813_humbled
humbler143411943_humbler
humblers15379803_humblers
humblest15288283_humblest
jumble174012653_jumble_
jumbled19379963_jumbled
jumbler183910273_jumbler
jumblers19358323_jumblers
mumble123614343_mumble_
mumbled143010763_mumbled
mumbler133510913_mumbler
mumblers14328763_mumblers
nombles113212343_nombles
nubbles113412433_nubbles
plumules1234663plumules
preambles1545323preambles
rabbles113517973_rabbles
ramblas112710263_ramblas
ramble104519973_ramble_
rambled123913513_rambled
rambler113313263_rambler
ramblers124010373_ramblers
rimples113114223_rimples
robles85321693_r_obles
roubles93413503_roubles
rubbies114114113_rubbies
rubble104315673_rubble_
rubbled124611623_rubbled
rubels84112993_ru_bels
rubes74928413_ru_b_es
rubies84420333_ru_bies
ruble74521253_ru_ble_
ruckles133414603_ruckles
ruddles92813873_ruddles
ruffles133512263_ruffles
rugbies10339353_rugbies
rules55234253_ru__les
rumbaed12287493_rumbaed
rumbas102512013_rumb_as
rumbly134412163_rumbl_y
rummies113212793_rummies
rumple103913013_rumple_
rumpled123810013_rumpled
rumpless12256543_rumpless
rundles83214713_rundles
runkles114111943_runkles
rustles73416413_rustles
rutiles74315843_rutiles
scrambles15146383scrambles
scumble1337013scumble_
scumbled1535053scumbled
shambles15159043shambles
stubbles1236843stubbles
stumble1147553stumble_
stumbled1335623stumbled
stumbler1235813stumbler
stumblers1334373stumblers
thimbles1536013thimbles
thumbless1643423thumbless
tramples122610203tramples
trebles9311443tr_ebles
tremble1138003tremble_
trembled1335243trembled
trembler1235363trembler
tremblers1334473tremblers
troubles1057183troubles
truckles14319383truckles
trueblues1142043trueblues
truffles1485583truffles
trundles9278473trundles
tumble103215643_tumble_
tumbled123412243_tumbled
tumbler113412823_tumbler
tumblers123110623_tumblers
umbels104510583__umbels
wambles143714023_wambles
wimbles143010843_wimbles

Search took 8 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.1731032896.0
2DLD Change Limit1461622307.72018932.9
3Display Results2302300.0932473.1
 (SQL Overall)1786912307.98622375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.