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

121 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
grumbling154408(None) 
crumbling1655081crumbling
drumbling1544031drumbling
rumbling131910101_rumbling
brambling1635542brambling
bumbling15249762_bumbling
crumbing15267812crumb_ing
crumblings1742512crumblings
crumpling1645322crumpling
fumbling16208162_fumbling
gambling14218962g_ambling
grabbling1564582grabbling
grubbing14295402gru_bbing
grueling1078272gru_eling
gruelling1155602gruelling
grumblingly2071532grumblingly
grumping14266902grum_ping
gruntling1134262gruntling
humbling16208672_humbling
jumbling20217232_jumbling
mumbling15198532_mumbling
rambling131810772_rambling
rubbling13238072_rubbling
rumbaing13185302_rumbaing
rumblings14184632_rumblings
rumpling13178762_rumpling
scumbling1634422scumbling
stumbling1435002stumbling
trembling1435192trembling
tumbling13219292_tumbling
ambling121411793__ambling
bejumbling2441663bejumbling
brabbling1334963brabbling
bramblings1742613bramblings
bubbling12248223_bubbling
bumblings16194753_bumblings
burbling13249423_burbling
crimpling1645343crimpling
crumblier1543873crumblier
crumping15319903crum_ping
cymbling1834773_cymbling
doubling1238153dou_bling
drabbling1544553drabbling
dribbling1533713dribbling
drubbing14286053dru_bbing
drumlin1044423drum_lin_
drumlins1144993drum_lins
drumming14265783drum_ming
dumbing13319853_dumb_ing
dumpling14217893_dumpling
fribbling1733673fribbling
gabbling14238073g_abbling
gabling113514543g__abling
gamboling1556133g_amboling
garbling12249453g_arbling
gauming11319713gaum__ing
gimbaling15134443g_imbaling
gobbling14257533g_obbling
grabbing14267313gr_abbing
grappling1544993grappling
graveling1457383graveling
grayling1338003gr_ayling
greenling1136753greenling
gremlin1035563grem_lin_
gremlins1136053grem_lins
griddling1333933griddling
grilling103811533gr_illing
grimacing1544033grimacing
griming113612493grim__ing
grizzling1942843grizzling
groundling1343393groundling
groveling1435573groveling
growling1348163gr_owling
grudging12255993gru_dging
gruelings1163763gru_elings
gruellings1272323gruellings
gruffing1635273gru_ffing
grumble12349233grumbl__e
grumbled14256753grumbl_ed
grumbler13866683grumbl_er
grumblers14245023grumblers
grumbles13288873grumbl_es
grumbly15355403grumbl__y
grummeting1642453grummeting
grunting10269583gru_nting
grutching16224373grutching
guggling10236353g_uggling
guiling93214213g_u_iling
gulling94019563g_u_lling
gumline102810113g_um_line
gumming133810193g_um_ming
gurgling11267323g_urgling
guttling1037293g_uttling
guzzling18225063g_uzzling
numbing12269033_numb_ing
plumbing15286433plumb_ing
rabbling13239333_rabbling
rhumbaing1742243rhumbaing
rimpling13219663_rimpling
rubbing123412273_ru_bbing
rubying13297933_ru_bying
ruckling15258573_ruckling
ruddling11228553_ruddling
ruffling1546093_ruffling
ruling73219553_ru__ling
rumoring1136983_rumoring
runkling13217613_runkling
rustling9249983_rustling
scrambling1743473scrambling
shambling1735593shambling
thumbing16245513thumb_ing
trameling1249053trameling
trampling1436973trampling
trebling1139873tr_ebling
troubling1234943troubling
truckling1645073truckling
trumping13308733trum_ping
trundling1135003trundling
tumblings14184843_tumblings
wambling16198443_wambling
wimbling16186543_wimbling

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.420425454.8
2DLD Change Limit1486411217.20320636.0
3Display Results1211210.0631920.6
 (SQL Overall)1786911217.68623248.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.