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

127 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
grumblers1424502(None) 
grumbler13866681grumbler_
grumbles13288871grumble_s
rumblers123610741_rumblers
bumblers143710732_bumblers
crumbers14338242crumb_ers
crumbles14329682crumble_s
drumbles13277722drumble_s
fumblers15318712_fumblers
gamblers13369732g_amblers
grabblers14345512grabblers
grubbers13316202gru_bbers
gruelers936172gru_elers
gruellers1034182gruellers
grumble12349232grumble__
grumbled14256752grumble_d
humblers15379802_humblers
jumblers19358322_jumblers
mumblers14328762_mumblers
ramblers124010372_ramblers
rumbler113514112_rumbler_
rumbles114018392_rumble_s
stumblers1334382stumblers
tremblers1334482tremblers
tumblers123110622_tumblers
amblers115213563__amblers
brabblers12335563brabblers
brambles14308973bramble_s
brumbies1436533brumbie_s
bubblers11448943_bubblers
bumbler134013233_bumbler_
bumbles134016843_bumble_s
burblers12399263_burblers
clumbers143910413clumb_ers
crullers1047303cru_llers
crumber13339643crumb_er_
crumbier1456363crumbier_
crumble133410403crumble__
crumbled15357443crumble_d
crumblier1543873crumblier_
crumples14348813crumple_s
cumbers134515413_cumb_ers
doublers11288503dou_blers
dribblers14274453dribblers
drubbers13386033dru_bbers
drumble12337893drumble__
drumbled14266033drumble_d
drummers13316163drum_mers
fribblers16314193fribblers
fumbler143610813_fumbler_
fumbles143514413_fumble_s
gabblers134110083g_abblers
gambiers13337073g_ambiers
gambler123612683g_ambler_
gambles124016203g_amble_s
garblers113810283g_arblers
gobblers13308343g_obblers
grabbers13337883gr_abbers
grabbler13377693grabbler_
grabbles13339893grabble_s
grapplers14274303grapplers
gribbles13307363gribble_s
grillers93810813gr_illers
grimacers1463553grimacers
grizzlers18253233grizzlers
grovelers13305163grovelers
growlers12327093gr_owlers
grubber12417913gru_bber_
grubbier13344753grubbier_
grudgers11266753gru_dgers
grueler837023gru_eler_
grueller935333grueller_
grumbling1544083grumbling
grumbly15355403grumbl__y
grumes94415553grum__e_s
grummer12338783grum_mer_
grummets13275033grum_mets
grumpier1334803grumpier_
grungers10298503gru_ngers
grunters9359033gru_nters
gruntles9287233gruntle_s
gumless10228273g_um_less
gummers123712203g_um_mers
guttlers9306933g_uttlers
guzzlers17274863g_uzzlers
humbler143411943_humbler_
humbles143215803_humble_s
jumbler183910273_jumbler_
jumbles183013323_jumble_s
krullers1234133kru_llers
lumbers113815913_lumb_ers
mumbler133510913_mumbler_
mumbles133014433_mumble_s
numbers113711243_numb_ers
numbles113814273_numble_s
plumbers14418513plumb_ers
rabblers123810853_rabblers
rambler113313263_rambler_
rambles113118313_ramble_s
rubbers113913193_ru_bbers
rubbles113715113_rubble_s
rubles83921703_ru_ble_s
rufflers14347193_rufflers
rulers64317093_ru__lers
rumble103718813_rumble__
rumbled124514593_rumble_d
rummers113513653_rum_mers
rumples113313133_rumple_s
rumpless12256543_rumpless
rustlers8339853_rustlers
scramblers16183543scramblers
scumbles1447023scumble_s
slumbers123110273slumb_ers
stumbler1235813stumbler_
stumbles1237493stumble_s
thumbless1643433thumbless
tramplers13305883tramplers
trembler1235363trembler_
trembles1237353tremble_s
troublers1135003troublers
trucklers15295583trucklers
trundlers10215003trundlers
tumbler113412823_tumbler_
tumbles113816023_tumble_s
tummlers12295703_tummlers
umbers104215213__umb_ers
umbles103817493__umble_s

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411277.15620771.5
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.65523343.0
 
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.