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

262 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
stuffy1531708(None) 
snuffy15356241snuffy
stuff113817051stuff_
stuffs123810221stuffs
buffy165013372_buffy
chuffy20445862chuffy
fluffy14315782fluffy
gruffy16396012gruffy
huffy174810232_huffy
pouffy17395882pouffy
puffy164410752_puffy
scruffy1842642scruffy
scuff133914892scuff_
scuffs14419052scuffs
scurfy14338762scurfy
sluff114016812sluff_
sluffs12349582sluffs
sniffy15337192sniffy
snuff113514042snuff_
snuffly16305202snuffly
snuffs12358532snuffs
spiffy17326222spiffy
squiffy2542572squiffy
staff113817712staff_
staffs12349752staffs
stiff114219242stiff_
stiffly16235172stiffly
stiffs12389962stiffs
stubby1345042stubby
studly10397692studly
study94411792stu_dy
stuffed14328972stuffed
stuffer13349792stuffer
stuffily17124162stuffily
stumpy13458132stumpy
stupefy1542902stupefy
sturdy1037042sturdy
surfy115319472s_urfy
taffy145110822_taffy
toffy145310282_toffy
tuff104528522_tuff_
tuffs115118262_tuffs
tufty114810412_tufty
turfy114315402_turfy
unstuffy1761672unstuffy
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
estuary1034683estuary
fluff103913613fluff_
fluffs11347783fluffs
gruff124712143gruff_
gruffly17413893gruffly
gruffs13337453gruffs
guff114624933_guff_
guffs124414823_guffs
gulfy124612003_gulfy
huff135623843_huff_
huffs144514743_huffs
iffy135312283__iffy
jiffy21458313_jiffy
luff104426703_luff_
luffa11409023_luffa
luffs114516283_luffs
miffy163910203_miffy
muff124723863_muff_
muffs134114213_muffs
outfly1238273outfly
pouff135215423pouff_
pouffe14448263pouffe
pouffs14418123pouffs
puff125525433_puff_
puffs134114933_puffs
restuff1346953restuff_
restuffs1444193restuffs
ruff105127653_ruff_
ruffe114713813_ruffe
ruffly15336673_ruffly
ruffs114516743_ruffs
salify12311373salify
satisfy1344183satisfy
saucy104615163sau_cy
saughy13507463saughy
saury84317223sau_ry
sawfly1535133sawfly
scoff134413343scoff_
scoffs14347503scoffs
scruff1437963scruff_
scruffs1554173scruffs
scuffed16298243scuffed
scuffer15328883scuffer
scuffle15266893scuffle
scummy15265223scummy
scurf104719323scurf_
scurfs113210813scurfs
scurry11419593scurry
scurvy14386103scurvy
scuzzy1933083scuzzy
setoff1238913setoff_
setoffs1334133setoffs
shifty15409263shifty
shuffle16276923shuffle
skiff153612803skiff_
skiffs16327013skiffs
skunky12436163skunky
sludgy11366253sludgy
sluffed14308303sluffed
sluicy1166483sluicy
slummy13325863slummy
slurry9378603slurry
slushy12417223slushy
slutty9248003slutty
smudgy13294133smudgy
smugly1274833smugly
smutty11266323smutty
sniff113915863sniff_
sniffly16265643sniffly
sniffs12378843sniffs
snubby1344533snubby
snuffed14308073snuffed
snuffer13318853snuffer
snuffily17124323snuffily
snuffle13267833snuffle
snugly1055663snugly
softy115414483s_ofty
souffle13306803souffle
soupy106115403sou_py
sourly93612213sourly
spiff133616403spiff_
spiffs14328473spiffs
spoofy14498553spoofy
spumy124610363spu_my
spunky15427163spunky
spurry11429123spurry
stably113314123stably
staffed14298283staffed
staffer13299093staffer
stagey105915583stagey
staggy115510393staggy
stagy96618893st_agy
stalky13499303stalky
starry94911673starry
stay78333723st__ay
steady103510203steady
steamy115112373steamy
steely93612573steely
stemmy13417033stemmy
stewy116112063st_ewy
stey76224413st__ey
sticky154711343sticky
stiffed14359583stiffed
stiffen13286023stiffen
stiffer13319393stiffer
stiffie13245773stiffie
stifle93611903stifle
stilly93714093stilly
stimy105114743st_imy
stingy105213203stingy
stinky134611073stinky
stithy12398213stithy
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083st_ogy
stoney96217353stoney
stony85818643st_ony
storey95217613storey
stormy115510733stormy
story86723033st_ory
stoury9529943stoury
stoutly1035833stoutly
strafe95215983strafe
strawy1210312823strawy
stray88525573st_ray
strife95318363strife
stripy115812743stripy
stroy87720393st_roy
stub66221843stu__b
stubbly1444473stubbly
stubs75016073stu_bs
stucco1044253stucco
stuck114515773stu_ck
stud56220093stu__d
studio7247133studio
studs64415873stu_ds
stuffers14277383stuffers
stuffier14336623stuffier
stuffing15247843stuffing
stull54916273stu_ll
stulls63912983stulls
stultify1442723stultify
stum65526023stu__m
stump94616463stu_mp
stumps104912283stumps
stums75320083stu_ms
stun45623453stu__n
stung65417153stu_ng
stunk94616293stu_nk
stuns54719493stu_ns
stunt55328173stu_nt
stunts65615253stunts
stupa74112313stu_pa
stupas83910883stupas
stupe75217753stu_pe
stupes84116953stupes
stupid937593stupid
stupor836013stupor
sturt56028963stu_rt
sturts63915143sturts
sty66227313st___y
stymy13358293st_ymy
sucky144415503s_ucky
sudsy95010683s_udsy
suety85318493s_uety
suffer124314513s_uffer
suffix1935233s_uffix
sulfa8313923s_ulfa
sulfo8313363s_ulfo
sulky124715363s_ulky
sully84622903s_ully
sunny84917743s_unny
surf76039313s_urf_
surfs85022543s_urfs
surgy95118523s_urgy
surly85124433s_urly
teff106023763_teff_
teffs115111733_teffs
tiff104727723_tiff_
tiffs114414883_tiffs
toff105929903_toff_
toffs116016723_toffs
truffe1276233truffe
tubby124511403_tubby
tufa75016613_tu_fa
tufas85314383_tufas
tuffet122612083_tuffet
tuft76929513_tu_ft
tufts85713273_tufts
tumefy1434223_tumefy
tummy124711993_tummy
tunny86515033_tunny
turf75334053_turf_
turfs84620443_turfs
tushy114212993_tushy
tutty85217023_tutty

Search took 6 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.376475242.0
2DLD Change Limit1127162624.65324224.4
3Display Results2622620.0803275.0
 (SQL Overall)1786912625.10934975.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.