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

214 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
gruffing163527(None) 
ruffing143210841_ruffing
bluffing17275492bluffing
buffing163411392_buffing
chuffing2055042chuffing
cuffing163210252_cuffing
fluffing14275412fluffing
gaffing15379732g_affing
grafting13319622grafting
griffin1434512griffin_
griffins1544782griffins
grifting13299262grifting
grubbing14295402grubbing
grudging12255992grudging
grueling1078272grueling
gruffier1544702gruffier
gruffily1863082gruffily
gruffish1843942gruffish
grumping14266902grumping
grunting10269582grunting
gulfing12339472g_ulfing
huffing17278832_huffing
luffing143310102_luffing
muffing163210402_muffing
puffing162910942_puffing
reffing143712172_reffing
riffing144011272_riffing
ruffling1546092_ruffling
scuffing17287112scuffing
sluffing15247302sluffing
snuffing15256802snuffing
stuffing15247842stuffing
argufying1742153argufying
baffing164011603_baffing
biffing163510013_biffing
boffing16339983_boffing
briefing1436943briefing
bruising11279143bruising
bruiting11259973bruiting
brushing14359963brushing
bruting102612993bru_ting
bruxing17236823bru_xing
chaffing2036323chaffing
cheffing2034463cheffing
coffing163811253_coffing
coiffing1755933coiffing
crafting143710173crafting
crudding1335723crudding
cruising112610153cruising
crumbing15267813crumbing
crumping15319903crumping
crushing143010053crushing
crusting113612793crusting
daffing15369733_daffing
doffing15357793_doffing
drafting13339403drafting
drifting13338733drifting
drubbing14286053drubbing
drudging12256233drudging
drugging12326443drugging
drumming14265783drumming
eructing112110173eructing
erupting11218443erupting
feoffing1432963feoffing
frugging14317053frugging
fruiting12229063fruiting
gauffering1842453gauffering
gauging10339963gau_ging
gauming11319713gau_ming
gifting123810893g_ifting
glueing9338713glu_eing
glugging10316353glugging
gluing83812053glu__ing
glutting10247643glutting
golfing12368943g_olfing
goofing123510633g_oofing
gouging103410703gou_ging
grabbing14267313grabbing
gracing113216443gr_acing
grading103918713gr_ading
graffiti1542983graffiti
graffiting1842923graffiting
graffito1542873graffito
graining102813183graining
granting103514523granting
graphing1538533graphing
grasping12348833grasping
grassing103311973grassing
grating93923183gr_ating
graving123114563gr_aving
graying124115883gr_aying
grayling1338003grayling
grazing183514553gr_azing
greasing102811393greasing
greeing93613783gr_eeing
greening103112533greening
greeting103112353greeting
greying124110893gr_eying
griding103014973gr_iding
grieving1385893grieving
griffon1443103griffon_
griffons1542573griffons
grilling103811533grilling
griming113612493gr_iming
grinding1139863grinding
grinning1037863grinning
griping113012063gr_iping
gripping14277543gripping
gritting10309983gritting
groaning102410283groaning
groining102310633groining
grokking1334813grokking
grooming12309513grooming
grooving13286713grooving
groping113313103gr_oping
grossing103111063grossing
grouching1644943grouching
grounding1236083grounding
grouping12308533grouping
grousing103410453grousing
grouting103410793grouting
growing123512473gr_owing
growling1348163growling
gruelings1163763gruelings
gruelling1155603gruelling
gruff124712143gruff___
gruffed1544943gruff_ed
gruffer1475793gruff_er
gruffest1544593gruffest
gruffiest1634533gruffiest
gruffly17413893gruff_ly
gruffs13337453gruff__s
gruffy16396013gruff__y
grumbling1544083grumbling
gruntling1134263gruntling
grutching16224373grutching
guffawing2041863g_uffawing
guiding102911843g_uiding
guiling93214213g_uiling
guising93511413g_uising
gulling94019563g_ulling
gulping11309753g_ulping
gumming133810193g_umming
gunning93413173g_unning
gurging102910113g_urging
gurgling11267323gurgling
gushing124014223g_ushing
gusting93917163g_usting
gutting93415923g_utting
guying11379723g_u_ying
miffing16298403_miffing
muffin14298873_muffin_
muffins15308343_muffins
muffling1765503_muffling
naffing14359033_naffing
offing13368643__offing
piaffing1733923piaffing
proofing1439313proofing
pruning10311733pru_ning
puffin141149003_puffin_
puffins15278913_puffins
purfling1467763purfling
quaffing2434353quaffing
raffling1567063_raffling
rafting113815753_rafting
rebuffing1843263rebuffing
reefing114016863_reefing
riffling1556113_riffling
rifling112815013_rifling
rifting113515003_rifting
rolfing113710653_rolfing
roofing113814353_roofing
rubbing123412273_rubbing
rubying13297933_rubying
ruching133612933_ruching
rucking143216673_rucking
ruffian1344133_ruffian
ruffians1443793_ruffians
rugging102512763_rugging
ruing67221053_ru__ing
ruining83514883_ruining
ruling73219553_ru_ling
running83514593_running
rushing113817703_rushing
rusting83821263_rusting
rutting82718043_rutting
scoffing17275943scoffing
scuffling1843613scuffling
shroffing1943313shroffing
shuffling1933453shuffling
sniffing15227453sniffing
snuffling1643563snuffling
spiffing17237083spiffing
staffing15247493staffing
stiffing15248703stiffing
stuffings16233493stuffings
surfing112914483_surfing
tariffing1644113tariffing
tiffing14339383_tiffing
trifling122411503trifling
trucing103211843tru_cing
trucking153310163trucking
trudging11266443trudging
trueing83410183tru_eing
truing73913933tru__ing
trumping13308733trumping
trussing9268653trussing
trusting93411653trusting
tufting11289873_tufting
turfing113010053_turfing
uncuffing1843703uncuffing
waffing173710243_waffing
whiffing2134703whiffing
yaffing17337823_yaffing

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 Filter1786911461620.500357382.0
2DLD Change Limit1461622146.07624055.6
3Display Results2142140.0762815.8
 (SQL Overall)1786912146.65226862.7
 
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.