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

119 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
gruffly1741389(None) 
gruffily1863081gruffily
gruffy16396011gruff_y
ruffly15336671_ruffly
bluffly1833432bluffly
gruff124712142gruff__
gruffed1544942gruffed
gruffer1475792gruffer
gruffs13337452gruff_s
grumbly15355402grumbly
ruffle124111672_ruffle
snuffly16305202snuffly
truffle1384892truffle
briefly1534573briefly
brutely1235933brutely
buffy165013373_buff_y
chuffy20445863chuff_y
crudely1336273crudely
cruelly1236563cruelly
crumbly16347523crumbly
crumply16336093crumply
crusily12199093crusily
draffy16486633draff_y
drumly1235703dru_mly
duffle13368533_duffle
fluffily1652923fluffily
fluffy14315783fluff_y
gadfly1434663g_adfly
gallfly1433523gallfly
gaudily1236523gaudily
gauffer1474423gauffer
gauntly1135333gauntly
gauzily2034393gauzily
glowfly1742673glowfly
gluily10308293glu_ily
glumly12356623glu_mly
goofily14105353goofily
goutily1137933goutily
grandly1238743grandly
gravely14469063gravely
grayly13287963gr_ayly
greatly1137613greatly
greenfly1554083greenfly
greenly11408193greenly
greyly13316543gr_eyly
griff124416463griff__
griffe13438093griff_e
griffes14367923griffes
griffin1434513griffin
griffon1443103griffon
griffs13398993griff_s
grimily1336523grimily
grimly12459933gr_imly
grisly104310583gr_isly
gristly11187333gristly
grizzly19354473grizzly
grossly1175983grossly
growly13499173gr_owly
grubbily1642973grubbily
grubby14324503gru_bby
gruel66014743gru_el_
gruels73910153gru_els
gruffest1544593gruffest
gruffier1544703gruffier
gruffing1635273gruffing
gruffish1843943gruffish
grumble12349233grumble
grumphy18443623grumphy
grumpily1643463grumpily
grumpy14498153gru_mpy
grungy11345973gru_ngy
gruntle8257053gruntle
guff114624933g_uff__
guffaw1642793g_uffaw
guffs124414823g_uff_s
gulfy124612003g_ulf_y
gully94020683g_u_lly
huffily1934693_huffily
huffy174810233_huff_y
muffle14339643_muffle
outfly1238273_outfly
pouffy17395883pouff_y
puffily1834843_puffily
puffy164410753_puff_y
raffle123910703_raffle
refly113914563_r_efly
rifely123710033_rifely
riffle124210233_riffle
rubbly133710613_rubbly
rudely10389973_rudely
ruff105127653_ruff__
ruffe114713813_ruff_e
ruffed134312743_ruffed
ruffes124112423_ruffes
ruffled14369153_ruffled
ruffler13369723_ruffler
ruffles133512273_ruffles
ruffs114516743_ruff_s
ruly76323143_ru__ly
rumbly134412163_rumbly
rumply13348573_rumply
scruffily2041883scruffily
scruffy1842643scruff_y
scuffle15266893scuffle
shuffle16276923shuffle
sniffly16265643sniffly
snuffily17124323snuffily
snuffle13267833snuffle
snuffy15356243snuff_y
souffle13306803souffle
stiffly16235173stiffly
stuffily17124163stuffily
stuffy15317083stuff_y
truffe1276233truff_e
truffes1356773truffes
truffled1563993truffled
truffles1485593truffles
truly84111553tru__ly
waffly18305433_waffly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271196.65620136.3
3Display Results1191190.0303966.7
 (SQL Overall)1786911197.09225196.1
 
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.