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

232 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
gruffy1639601(None) 
gruff124712141gruff_
gruffly17413891gruffly
gruffs13337451gruffs
buffy165013372_buffy
chuffy20445862chuffy
draffy16486632draffy
fluffy14315782fluffy
griff124416462griff_
griffe13438092griffe
griffs13398992griffs
grubby14324502grubby
gruffed1544942gruffed
gruffer1475792gruffer
gruffily1863082gruffily
grumpy14498152grumpy
grungy11345972grungy
guff114624932g_uff_
guffs124414822g_uffs
gulfy124612002g_ulfy
huffy174810232_huffy
pouffy17395882pouffy
puffy164410752_puffy
ruff105127652_ruff_
ruffe114713812_ruffe
ruffly15336672_ruffly
ruffs114516742_ruffs
scruffy1842642scruffy
snuffy15356242snuffy
stuffy15317082stuffy
truffe1276232truffe
agraffe1443333agraffe
argufy1344093argufy
baffy165511923_baffy
biffy164711133_biffy
bluff134413833bluff_
bluffly1833433bluffly
bluffs14388373bluffs
bouffe14438313bouffe
brumby15385953brumby
brushy14468263brushy
brutify1543883brutify
buff125229863_buff_
buffi136112203_buffi
buffo135112183_buffo
buffs135519513_buffs
chaffy20456473chaffy
chuff164812493chuff_
chuffs17427783chuffs
cliffy17435243cliffy
crafty14478913crafty
crucify1744063crucify
cruddy1334193cruddy
crumby15408113crumby
crummy15365893crummy
crusty114911343crusty
cuff125327993_cuff_
cuffs135017493_cuffs
daffy155510283_daffy
draff125615663draff_
draffs13617903draffs
drafty13638933drafty
drifty13418223drifty
druggy12344743druggy
drumly1235703drumly
duff114326643_duff_
duffs125216623_duffs
fluff103913613fluff_
fluffs11347783fluffs
fruity12429693fruity
frumpy16466883frumpy
gadfly1434663gadfly
gaff114828153g_aff_
gaffe124111653g_affe
gaffs124914653g_affs
gasify1336333gasify
gaudy106611463gau_dy
gauffer1474423gauffer
gauzy18489213gau_zy
giraffe1442993giraffe
gliff124915663gliff_
gliffs13436323gliffs
gluey95715263glu_ey
gluily10308293gluily
glumly12356623glumly
glumpy14527193glumpy
goofy124915623g_oofy
gouty95217363gou_ty
grabby14336183grabby
graft95327203gr_aft
grafts105013253grafts
grainy103914213grainy
granny104311163granny
grapey126012303grapey
grapy115416433gr_apy
grassy10619093grassy
gratify1436113gratify
gravy125512113gr_avy
gray85329893gr__ay
grayly13287963grayly
greasy10419463greasy
greedy11518853greedy
greeny104811453greeny
gremmy1454473gremmy
grey85624043gr__ey
greyly13316543greyly
grief95319783grief_
griefs10418723griefs
griffes14367923griffes
griffin1434513griffin
griffon1443103griffon
grift95924463gr_ift
grifts104511683grifts
grimly12459933grimly
grimy114312603gr_imy
gripey124111203gripey
grippy14447763grippy
gripy115115253gr_ipy
grisly104310583grisly
gritty10338403gritty
grody103412063gr_ody
groggy1234803groggy
groovy13375403groovy
groszy19395703groszy
grotty10389833grotty
grouchy16294243grouchy
grouty104710983grouty
growly13499173growly
grub77220083gru__b
grubs86312603gru_bs
grudge9388583grudge
grue55825713gru__e
gruel66014743gru_el
gruels73910153gruels
grues65721963gru_es
gruffest1544593gruffest
gruffier1544703gruffier
gruffing1635273gruffing
gruffish1843943gruffish
grugru842933grugru
grum75625083gru__m
grumbly15355403grumbly
grume86218163gru_me
grumes94415553grumes
grump105115313gru_mp
grumphy18443623grumphy
grumps114510573grumps
grunge8359583grunge
grunt65523543gru_nt
grunts75511853grunts
grutch12285563grutch
guffaw1642793g_uffaw
gulf84929423g_ulf_
gulfs94915303g_ulfs
gully94020683g_ully
gulpy114612763g_ulpy
gummy135413653g_ummy
gunky135514113g_unky
gunny94413663g_unny
guppy135211273g_uppy
gurney10429413gurney
gurry94515413g_urry
gushy125213123g_ushy
gussy95314323g_ussy
gusty95119573g_usty
gutsy96412843g_utsy
gutty94516993g_utty
guy75728943g_u__y
huff135623843_huff_
huffs144514743_huffs
iffy135312283__iffy
jiffy21458313_jiffy
luff104426703_luff_
luffa11409023_luffa
luffs114516283_luffs
miffy163910203_miffy
muff124723863_muff_
muffs134114213_muffs
pouff135215423pouff_
pouffe14448263pouffe
pouffs14418123pouffs
puff125525433_puff_
puffs134114933_puffs
purify14399153purify
raff104933043_raff_
raffs115017523_raffs
reefy114217703_reefy
refly113914563_refly
refry114412463_refry
reify114814973_reify
riff104430103_riff_
riffs115114613_riffs
rubby124413863_rubby
ruby97819943_ru_by
ruddy104511753_ruddy
ruffed134312743_ruffed
ruffes124112423_ruffes
ruffle124111673_ruffle
rugby11448133_rugby
ruly76323143_ru_ly
rummy124212413_rummy
runny84613483_runny
runty86119043_runty
rushy115414813_rushy
rusty85221053_rusty
rutty85617803_rutty
scruff1437963scruff_
scruffs1554173scruffs
scuff133914893scuff_
scuffs14419053scuffs
scurfy14338763scurfy
sluff114016813sluff_
sluffs12349583sluffs
sniffy15337193sniffy
snuff113514043snuff_
snuffly16305203snuffly
snuffs12358533snuffs
spiffy17326223spiffy
squiffy2542573squiffy
stuff113817053stuff_
stuffs123810223stuffs
surfy115319473_surfy
taffy145110823_taffy
toffy145310283_toffy
truffes1356773truffes
truffle1384893truffle
truly84111553tru_ly
trusty94710113trusty
tuff104528523_tuff_
tuffs115118263_tuffs
tufty114810413_tufty
turfy114315403_turfy

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162326.37317686.5
3Display Results2322320.423548.5
 (SQL Overall)1786912327.20224811.3
 
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.