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

230 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
fluffy1431578(None) 
fluff103913611fluff_
fluffs11347781fluffs
bluff134413832bluff_
bluffly1833432bluffly
bluffs14388372bluffs
buffy165013372_buffy
chuffy20445862chuffy
cliffy17435242cliffy
fluffed13295902fluffed
fluffer12336502fluffer
fluffily1652922fluffily
flukey16459812flukey
fluky154512292flu_ky
flunky16408092flunky
flurry12397112flurry
flutey125212522flutey
fluty114415642flu_ty
gruffy16396012gruffy
huffy174810232_huffy
luff104426702_luff_
luffa11409022_luffa
luffs114516282_luffs
pouffy17395882pouffy
puffy164410752_puffy
sluff114016812sluff_
sluffs12349582sluffs
snuffy15356242snuffy
stuffy15317082stuffy
baffy165511923_baffy
biffy164711133_biffy
blaff135216483blaff_
blaffs14426623blaffs
bluely113310083bluely
bluesy11448983bluesy
bluey104817053blu_ey
bluffed16326433bluffed
bluffer15396883bluffer
blurry11437673blurry
bouffe14438313bouffe
buff125229863_buff_
buffi136112203_buffi
buffo135112183_buffo
buffs135519513_buffs
chaffy20456473chaffy
chuff164812493chuff_
chuffs17427783chuffs
cliff135917133cliff_
cliffs14477593cliffs
clubby1534683clubby
clumpy15409573clumpy
clumsy13326193clumsy
clunky15447893clunky
cuff125327993_cuff_
cuffs135017493_cuffs
daffy155510283_daffy
draffy16486633draffy
duff114326643_duff_
duffs125216623_duffs
falsify1643613falsify
faulty12429363faulty
feoff10711053feoff_
feoffs1163703feoffs
fifty145211423f_ifty
flabby1634573flabby
flaggy14415923flaggy
flakey164410513flakey
flaky155715583fl_aky
flamy135217473fl_amy
flappy1654483flappy
flashy15498173flashy
flatly123110213flatly
flaunty1354413flaunty
flawy145913383fl_awy
flaxy189012293fl_axy
flay106332803fl__ay
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flimsy14345563flimsy
flinty126112493flinty
flippy1654613flippy
flirty12499143flirty
floaty124210943floaty
flocky18468423flocky
flooey123910173flooey
floosy12368153floosy
floozy21356613floozy
floppy1654873floppy
flossy12517703flossy
flouncy1543673flouncy
floury12449573floury
flu66530213flu___
flub95721883flu__b
flubs105515443flu_bs
flue75329853flu__e
flued95021253flu_ed
fluency1545353fluency
fluent9313933fluent
flues84626923flu_es
fluffers13335293fluffers
fluffier13264333fluffier
fluffing14275413fluffing
fluid94013963flu_id
fluidly1434813fluidly
fluids10349423fluids
fluish1239333fluish
fluke125016893flu_ke
fluked145112093fluked
flukes135114193flukes
flukily1735213flukily
flume106021173flu_me
flumed124915263flumed
flumes115119733flumes
flump124614723flu_mp
flumps135112503flumps
flung95114583flu_ng
flunk125014383flu_nk
flunkey17405793flunkey
flunks13469863flunks
fluor84512773flu_or
fluors94311373fluors
flus75626543flu__s
flush115116073flu_sh
flute86823753flu_te
fluted104917163fluted
fluter95316863fluter
flutes95421783flutes
flux145617743flu__x
fluxed17509673fluxed
fluxes165212933fluxes
fluyt114614203flu_yt
fluyts12367153fluyts
fly97124953fl___y
flyboy17113913flyboy
flyby1676003fl_yby
flyoff1444023flyoff
flyoffs1542253flyoffs
flyway18134693flyway
foully1239013foully
fruity12429693fruity
frumpy16466883frumpy
fubsy13589273f_ubsy
fuddy135211153f_uddy
fuggy135411673f_uggy
fulfil1246423fulfil
fully114820863f_ully
fumy127118583f_u_my
funky154315133f_unky
funny114614833f_unny
furry116719283f_urry
fury107727973f_u_ry
furzy2010116063f_urzy
fussy115613953f_ussy
fusty115016513f_usty
fuzzy1929814513f_uzzy
gliff124915663gliff_
gliffs13436323gliffs
gluey95715263glu_ey
gluily10308293gluily
glumly12356623glumly
glumpy14527193glumpy
gruff124712143gruff_
gruffly17413893gruffly
gruffs13337453gruffs
guff114624933_guff_
guffs124414823_guffs
gulfy124612003_gulfy
huff135623843_huff_
huffs144514743_huffs
iffy135312283__iffy
jiffy21458313_jiffy
kludgy15294223kludgy
klutzy2243003klutzy
leafy116316213_leafy
lefty115613563_lefty
lofty115813303_lofty
lucky145515013_lucky
luffas12337483_luffas
luffed133810823_luffed
lumpy126615913_lumpy
luny77324133_lu_ny
lusty85417573_lusty
miffy163910203_miffy
muff124723863_muff_
muffs134114213_muffs
plucky17406583plucky
plummy15375663plummy
plumy124213233plu_my
plunky15377953plunky
plushy14406973plushy
pouff135215423pouff_
pouffe14448263pouffe
pouffs14418123pouffs
puff125525433_puff_
puffs134114933_puffs
ruff105127653_ruff_
ruffe114713813_ruffe
ruffly15336673_ruffly
ruffs114516743_ruffs
scruffy1842643scruffy
scuff133914893scuff_
scuffs14419053scuffs
scurfy14338763scurfy
sludgy11366253sludgy
sluffed14308303sluffed
sluicy1166483sluicy
slummy13325863slummy
slurry9378603slurry
slushy12417223slushy
slutty9248003slutty
sniffy15337193sniffy
snuff113514043snuff_
snuffly16305203snuffly
snuffs12358533snuffs
spiffy17326223spiffy
squiffy2542573squiffy
stuff113817053stuff_
stuffs123810223stuffs
surfy115319473_surfy
taffy145110823_taffy
toffy145310283_toffy
truffe1276233truffe
tuff104528523_tuff_
tuffs115118263_tuffs
tufty114810413_tufty
turfy114315403_turfy

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.393454684.5
2DLD Change Limit1127162304.85623211.7
3Display Results2302300.0802875.0
 (SQL Overall)1786912305.32933531.8
 
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.