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

213 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
snuffy1535624(None) 
sniffy15337191sniffy
snuff113514041snuff_
snuffly16305201snuffly
snuffs12358531snuffs
stuffy15317081stuffy
buffy165013372_buffy
chuffy20445862chuffy
fluffy14315782fluffy
gruffy16396012gruffy
huffy174810232_huffy
pouffy17395882pouffy
puffy164410752_puffy
scruffy1842642scruffy
scuff133914892scuff_
scuffs14419052scuffs
scurfy14338762scurfy
sluff114016812sluff_
sluffs12349582sluffs
sniff113915862sniff_
sniffly16265642sniffly
sniffs12378842sniffs
snubby1344532snubby
snuffed14308072snuffed
snuffer13318852snuffer
snuffily17124322snuffily
snuffle13267832snuffle
snugly1055662snugly
spiffy17326222spiffy
squiffy2542572squiffy
stuff113817052stuff_
stuffs123810222stuffs
surfy115319472s_urfy
baffy165511923_baffy
biffy164711133_biffy
bluff134413833bluff_
bluffly1833433bluffly
bluffs14388373bluffs
bouffe14438313bouffe
buff125229863_buff_
buffi136112203_buffi
buffo135112183_buffo
buffs135519513_buffs
chaffy20456473chaffy
chuff164812493chuff_
chuffs17427783chuffs
cliffy17435243cliffy
cuff125327993_cuff_
cuffs135017493_cuffs
daffy155510283_daffy
draffy16486633draffy
duff114326643_duff_
duffs125216623_duffs
enuf7323843enu_f_
fluff103913613fluff_
fluffs11347783fluffs
gruff124712143gruff_
gruffly17413893gruffly
gruffs13337453gruffs
guff114624933_guff_
guffs124414823_guffs
gulfy124612003_gulfy
huff135623843_huff_
huffs144514743_huffs
iffy135312283__iffy
jiffy21458313_jiffy
knubby1742783knubby
knurly13405533knurly
luff104426703_luff_
luffa11409023_luffa
luffs114516283_luffs
miffy163910203_miffy
muff124723863_muff_
muffs134114213_muffs
naff105128933_naff_
naffs116213963_naffs
nifty115211633_nifty
nubby125011033_nubby
nutsy85711503_nutsy
nutty84816873_nutty
pouff135215423pouff_
pouffe14448263pouffe
pouffs14418123pouffs
puff125525433_puff_
puffs134114933_puffs
ruff105127653_ruff_
ruffe114713813_ruffe
ruffly15336673_ruffly
ruffs114516743_ruffs
salify12311373salify
sandfly1435643sandfly
saucy104615163sau_cy
saughy13507463saughy
saury84317223sau_ry
sawfly1535133sawfly
scoff134413343scoff_
scoffs14347503scoffs
scruff1437963scruff_
scruffs1554173scruffs
scuffed16298243scuffed
scuffer15328883scuffer
scuffle15266893scuffle
scummy15265223scummy
scurf104719323scurf_
scurfs113210813scurfs
scurry11419593scurry
scurvy14386103scurvy
scuzzy1933083scuzzy
shifty15409263shifty
shuffle16276923shuffle
skiff153612813skiff_
skiffs16327013skiffs
skunky12436163skunky
sludgy11366253sludgy
sluffed14308303sluffed
sluicy1166483sluicy
slummy13325863slummy
slurry9378603slurry
slushy12417223slushy
slutty9248003slutty
smudgy13294133smudgy
smugly1274833smugly
smutty11266323smutty
snaffle13216253snaffle
snafu8412143sn_afu
snafus936743snafus
snaggy11488053snaggy
snakey135011273snakey
snaky125113913sn_aky
snappy1366103snappy
snarf86525423snarf_
snarfs95113423snarfs
snarky134210843snarky
snarly93815003snarly
snazzy1734013snazzy
sneaky13427843sneaky
sneery93610413sneery
sneezy18345273sneezy
sniffed14318183sniffed
sniffer13318903sniffer
sniffily17154033sniffily
sniffle13287653sniffle
snippy1374843snippy
snobby1334403snobby
snoopy11449473snoopy
snooty94211513snooty
snoozy18517233snoozy
snotty9489203snotty
snouty9419953snouty
snowy115011563sn_owy
snub65320763snu__b
snubs75412553snu_bs
snuck114411913snu_ck
snuffbox2341043snuffbox
snuffers14326923snuffers
snuffier14276943snuffier
snuffing15256803snuffing
snuffled15277033snuffled
snuffler14317413snuffler
snuffles14318413snuffles
snug55218693snu__g
snugs64913023snu_gs
softy115414483s_ofty
souffle13306803souffle
soupy106115403sou_py
sourly93612213sourly
spiff133616403spiff_
spiffs14328473spiffs
spoofy14498553spoofy
spumy124610363spu_my
spunky15427163spunky
spurry11429123spurry
staff113817713staff_
staffs12349753staffs
stiff114219243stiff_
stiffly16235173stiffly
stiffs12389963stiffs
stubby1345043stubby
studly10397693studly
study94411793stu_dy
stuffed14328973stuffed
stuffer13349793stuffer
stuffily17124163stuffily
stumpy13458133stumpy
stupefy1542903stupefy
sturdy1037043sturdy
sucky144415503s_ucky
sudsy95010683s_udsy
suety85318493s_uety
suffer124314513s_uffer
suffix1935233s_uffix
sulfa8313923s_ulfa
sulfo8313363s_ulfo
sulky124715363s_ulky
sully84622903s_ully
sundry1057943sundry
sunny84917743s_unny
sunray9310123sunray
surf76039313s_urf_
surfs85022543s_urfs
surgy95118523s_urgy
surly85124433s_urly
taffy145110823_taffy
toffy145310283_toffy
truffe1276233truffe
tuff104528523_tuff_
tuffs115118263_tuffs
tufty114810413_tufty
turfy114315403_turfy
uncuff1436113uncuff_
uncuffs1543143uncuffs
unify113611113un_ify
unstuffy1761673unstuffy

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 Filter1786911127160.440406115.9
2DLD Change Limit1127162135.71619719.4
3Display Results2132130.0633381.0
 (SQL Overall)1786912136.21928733.1
 
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.