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

193 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
grumbler1386668(None) 
grumble12349231grumble_
grumbled14256751grumbled
grumblers14245021grumblers
grumbles13288871grumbles
rumbler113514111_rumbler
bumbler134013232_bumbler
crumber13339642crumb_er
crumbier1456362crumbier
crumble133410402crumble_
crumbled15357442crumbled
crumbles14329682crumbles
crumblier1543872crumblier
drumble12337892drumble_
drumbled14266032drumbled
drumbles13277722drumbles
fumbler143610812_fumbler
gambler123612682g_ambler
grabbler13377692grabbler
grubber12417912gru_bber
grubbier13344752grubbier
grueler837022gru_eler
grueller935332grueller
grumbly15355402grumbl_y
grummer12338782grum_mer
grumpier1334802grumpier
humbler143411942_humbler
jumbler183910272_jumbler
mumbler133510912_mumbler
rambler113313262_rambler
rumble103718812_rumble_
rumbled124514592_rumbled
rumblers123610742_rumblers
rumbles114018392_rumbles
stumbler1235812stumbler
trembler1235362trembler
tumbler113412822_tumbler
ambler104916453__ambler
brabbler11397373brabbler
bramble133710033bramble_
brambled15316733brambled
brambles14308973brambles
bramblier1543503bramblier
brumbies1436533brumbies
bubbler103611783_bubbler
bumble124216893_bumble_
bumbled144113043_bumbled
bumblers143710733_bumblers
bumbles134016843_bumbles
burbler114412423_burbler
clumber134011443clumb_er
crueler939023cru_eler
crueller1056453crueller
cruller968753cru_ller
crumbed14378473crumb_ed
crumbers14338243crumb_ers
crumbly16347523crumbl_y
crummier1435603crummier
crumple13368363crumple_
crumpled15296873crumpled
crumples14348813crumples
crumplier1543783crumplier
cumber124016703_cumb_er
doubler103110083dou_bler
dribbler13316313dribbler
drubber12357863dru_bber
drumlier1134523drumlier
drummer12407503drum_mer
dumber114414173_dumb_er
fribbler15265953fribbler
frumpier1534173frumpier
fumble133214263_fumble_
fumbled153710493_fumbled
fumblers15318713_fumblers
fumbles143514413_fumbles
gabbler124013303g_abbler
gambier124711973g_ambier
gamble115417183g_amble_
gambled134112163g_ambled
gamblers13369733g_amblers
gambles124016203g_ambles
garbler104012563g_arbler
glummer12417983glum_mer
glumpier1334873glumpier
gobbler123310023g_obbler
grabber12389763gr_abber
grabbier13316653grabbier
grabble12339643grabble_
grabbled14327373grabbled
grabblers14345513grabblers
grabbles13339893grabbles
grappler13336193grappler
gribble12297273gribble_
gribbles13307363gribbles
griller84513353gr_iller
grimacer1363963grimacer
grimier103210433grim_ier
grimmer123510093grim_mer
grizzler17335033grizzler
groveler12305843groveler
growler11318973gr_owler
grubbed13406433gru_bbed
grubbers13316203gru_bbers
grudger10368313gru_dger
grueled937133gru_eled
gruelers936173gru_elers
gruelled1034893gruelled
gruellers1034183gruellers
gruffer1475793gru_ffer
gruffier1544703gruffier
grumbling1544083grumbling
grume86218163grum__e_
grumes94415553grum__es
grummet12298873grum_met
grumose1035723grumose_
grumped13337333grum_ped
grunger9389783gru_nger
grungier1034983grungier
grunter83110783gru_nter
gruntle8257053gruntle_
gruntled10274943gruntled
gruntles9287233gruntles
gummer114615453g_um_mer
gummier12349473g_ummier
guttler8369163g_uttler
guzzler16286563g_uzzler
humble133615053_humble_
humbled153711813_humbled
humblers15379803_humblers
humbles143215803_humbles
jumble174012653_jumble_
jumbled19379963_jumbled
jumblers19358323_jumblers
jumbles183013323_jumbles
kruller1145153kru_ller
lumber103817773_lumb_er
mumble123614343_mumble_
mumbled143010763_mumbled
mumblers14328763_mumblers
mumbles133014433_mumbles
nimbler11358063_nimbler
number103913223_numb_er
numbles113814273_numbles
plumber13339983plumb_er
rabbler113514093_rabbler
ramble104519973_ramble_
rambled123913523_rambled
ramblers124010373_ramblers
rambles113118313_rambles
rubber104715793_ru_bber
rubble104315673_rubble_
rubbled124611623_rubbled
rubbles113715113_rubbles
rubblier1244913_rubblier
rubier84814743_ru_bier
ruble74521253_ru_ble_
rubles83921703_ru_bles
ruffler13369723_ruffler
ruler54923343_ru__ler
rumbaed12287493_rumbaed
rumbly134412163_rumbl_y
rummer104715483_rum_mer
rummier11309563_rummier
rumple103913013_rumple_
rumpled123810013_rumpled
rumples113313133_rumples
rumplier1235303_rumplier
rustler73512343_rustler
scrambler15165043scrambler
scumble1337013scumble_
scumbled1535053scumbled
scumbles1447023scumbles
slumber113811003slumb_er
stumble1147553stumble_
stumbled1335623stumbled
stumblers1334383stumblers
stumbles1237493stumbles
trampler12278013trampler
tremble1138003tremble_
trembled1335253trembled
tremblers1334483tremblers
trembles1237353trembles
tremblier1343283tremblier
troubler1035293troubler
truckler14297453truckler
trundler9256153trundler
tumble103215643_tumble_
tumbled123412243_tumbled
tumblers123110623_tumblers
tumbles113816023_tumbles
tummler11266613_tummler
umber94617593__umb_er
umbles103817493__umbles

Search took 9 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 Limit1461621937.89018525.0
3Display Results1931930.0802412.5
 (SQL Overall)1786911938.12621990.0
 
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.