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

286 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
ruffly1533667(None) 
gruffly17413891gruffly
ruffle124111671ruffle
bluffly1833432bluffly
buffy165013372buff_y
duffle13368532duffle
gruffily1863082gruffily
gruffy16396012gruff_y
huffily1934692huffily
huffy174810232huff_y
muffle14339642muffle
outfly1238272outfly
puffily1834842puffily
puffy164410752puff_y
raffle123910702raffle
refly113914562r_efly
rifely123710032rifely
riffle124210232riffle
rubbly133710612rubbly
rudely10389972rudely
ruff105127652ruff__
ruffe114713812ruff_e
ruffed134312742ruffed
ruffes124112422ruffes
ruffled14369152ruffled
ruffler13369722ruffler
ruffles133512272ruffles
ruffs114516742ruff_s
ruly76323142ru__ly
rumbly134412162rumbly
rumply13348572rumply
snuffly16305202snuffly
truffle1384892truffle
waffly18305432waffly
auntly95211063auntly
baffle14399873baffle
baffy165511923baff_y
barfly14339653barfly
biffy164711133biff_y
botfly1436093botfly
briefly1534573briefly
brutely1235933brutely
bubbly124110353bubbly
buff125229863buff__
buffalo1553723buffalo
buffed154313143buffed
buffer144512683buffer
buffet143113783buffet
buffi136112203buff_i
buffo135112183buff_o
buffos14447853buffos
buffs135519513buff_s
bully105124813bu_lly
burbly134311153burbly
burly104922833bu_rly
busily112211503busily
chuffy20445863chuff_y
coffle14359043coffle
crudely1336273crudely
cruelly1236563cruelly
crumbly16347523crumbly
crumply16336093crumply
crusily12199093crusily
cuddly13388413cuddly
cuff125327993cuff__
cuffed154311213cuffed
cuffs135017493cuff_s
cully105520463cu_lly
curly105321233cu_rly
curtly1149283curtly
cutely115312803cutely
daffily1735143daffily
daffy155510283daff_y
daftly1335443daftly
dayfly1633813dayfly
deafly13389123deafly
deftly1336533deftly
draffy16486633draff_y
drumly1235703dru_mly
dually103210063dually
duff114326643duff__
duffel13407753duffel
duffels14296453duffels
duffer134711663duffer
duffles14308923duffles
duffs125216623duff_s
dully94921633du_lly
duly85323033du__ly
dumbly14399603dumbly
fluffily1652923fluffily
fluffy14315783fluff_y
fly97124953___fly
fully114820863fu_lly
gadfly1434663gadfly
gruff124712143gruff__
gruffed1544943gruffed
gruffer1475793gruffer
gruffs13337453gruff_s
grumbly15355403grumbly
guff114624933guff__
guffaw1642793guffaw
guffs124414823guff_s
gulfy124612003gulf_y
gully94020683gu_lly
hubbly16478413hubbly
huff135623843huff__
huffed163710153huffed
huffs144514743huff_s
hugely1336803hugely
humbly164010523humbly
hurly115819293hu_rly
iffy135312283_iff_y
jiffy21458313jiff_y
jungly17407693jungly
justly16307253justly
liefly1266363liefly
luff104426703luff__
luffa11409023luff_a
luffas12337483luffas
luffed133810823luffed
luffs114516283luff_s
lushly12247343lushly
mayfly1734403mayfly
medfly1535223medfly
miffy163910203miff_y
muchly1686203muchly
muddly13418603muddly
muff124723863muff__
muffed154210593muffed
muffin14298873muffin
muffled16377783muffled
muffler15398343muffler
muffles153910453muffles
muffs134114213muff_s
muhly1358523mu_hly
mumbly15319463mumbly
murkly15368303murkly
muscly1337453muscly
mutely113811653mutely
nubbly13369673nubbly
nudely10299033nudely
numbly134410663numbly
piffle14418233piffle
pouffy17395883pouff_y
puddly13438133puddly
puff125525433puff__
puffed153510603puffed
puffer144610733puffer
puffery18235113puffery
puffin141149003puffin
puffs134114933puff_s
punily11311773punily
purely114013633purely
purfle112511183purfle
purply13369053purply
pussly11407373pussly
racily11715173racily
raff104933043raff__
raffia12287703raffia
raffled14429083raffled
raffler13339223raffler
raffles133611853raffles
raffs115017523raff_s
rally84725903r_ally
rankly133910453rankly
raptly11338913raptly
rarely93513653rarely
rashly123410213rashly
rattly94111543rattly
rawly115115833r_awly
really93315613really
redly94217203r_edly
reefy114217703reef_y
refall94314393refall
refel84920813refel_
refell94214443refell
refels94618053refels
refelt94521423refelt
reffed134712513reffed
refile95122373refile
refill94514053refill
refilm114311403refilm
refold103812113refold
refry114412463r_efry
reify114814973reif_y
rely75428953r__ely
reply104015853r_eply
richly1438013richly
riff104430113riff__
riffed133811563riffed
riffled14338603riffled
riffler13328353riffler
riffles133911173riffles
riffs115114613riff_s
rifle85518333r_ifle
ripely112511153ripely
ripply13348003ripply
roily86121113r_oily
ropily113312443ropily
rosily93914713rosily
roughly14507293roughly
roundly1136723roundly
roupily1246653roupily
rubble104315673rubble
rubby124413863ru_bby
rubel75416833rubel_
rubels84112993rubels
ruble74521253ru_ble
ruby97819943ru__by
ruckle124414583ruckle
ruddily1236303ruddily
ruddle83414203ruddle
ruddy104511753ru_ddy
rudery10419033rudery
rueful948203rueful
ruefully1445223ruefully
ruffian1344133ruffian
ruffianly1851623ruffianly
ruffing143210843ruffing
rufflers14347193rufflers
rufflier1434013rufflier
rufflike1843253rufflike
ruffling1546093ruffling
rufous948273rufous
rugal65916093rugal_
rugby11448133ru_gby
rugola736293rugola
rule49938423ru__le
rumble103718813rumble
rummy124212413ru_mmy
rumple103913013rumple
rundle73214233rundle
runkle103611543runkle
runny84613483ru_nny
runty86119043ru_nty
runway12105973runway
rural55821173rural_
rurally1038303rurally
rushy115414813ru_shy
rustily103112993rustily
rustle63615413rustle
rusty85221053ru_sty
rutile65217683rutile
ruttily10338613ruttily
rutty85617803ru_tty
safely12249393safely
sawfly1535133sawfly
scruffily2041883scruffily
scruffy1842643scruff_y
scuffle15266893scuffle
shuffle16276923shuffle
sniffly16265643sniffly
snuffily17124323snuffily
snuffle13267833snuffle
snuffy15356243snuff_y
softly12457763softly
souffle13306803souffle
stiffly16235173stiffly
stuffily17124163stuffily
stuffy15317083stuff_y
suably112814533suably
subtly11249263subtly
suffer124314513suffer
suffix1935233suffix
sully84622903su_lly
supply1346893supply
surely93816463surely
surfy115319473surf_y
surly85124433su_rly
taffy145110823taff_y
toffy145310283toff_y
truffe1276233truff_e
truffes1356773truffes
truffled1563993truffled
truffles1485593truffles
truly84111553tru__ly
tuff104528523tuff__
tuffet122612083tuffet
tuffs115118263tuff_s
tufoli933973tufoli
tuftily1335573tuftily
tufty114810413tu_fty
turfy114315403turf_y
ugly86012383_u_gly
waffle15369183waffle
wifely15429423wifely

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.376475242.0
2DLD Change Limit1127162865.65619928.6
3Display Results2862860.0933075.3
 (SQL Overall)1786912866.12529174.0
 
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.