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

105 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
bluffly183343(None) 
blowfly1843242blowfly
bluely113310082blu_ely
bluff134413832bluff__
bluffed16326432bluffed
bluffer15396882bluffer
bluffs14388372bluff_s
bluntly1235222bluntly
buffy165013372b_uff_y
fluffily1652922fluffily
fluffy14315782fluff_y
gruffly17413892gruffly
ruffly15336672_ruffly
snuffly16305202snuffly
aloofly1343623aloofly
baffle14399873b_affle
baffy165511923b_aff_y
barfly14339653b_arfly
beefily1535613beefily
biffy164711133b_iff_y
blackfly2243013blackfly
blackly1835253blackly
blaff135216483blaff__
blaffs14426623blaff_s
blandly1336043blandly
blankly1634263blankly
bleakly1634663bleakly
blindly1335743blindly
blousily1345193blousily
bluefin1245123bluefin
bluejay1942723bluejay
bluesy11448983blu_esy
bluey104817053blu__ey
bluffable1942063bluffable
bluffers16405703bluffers
bluffest1664643bluffest
bluffing17275493bluffing
blurrily1343913blurrily
blurry11437673blu_rry
botfly1436093b_otfly
bouffe14438313bouff_e
bouffes15388633bouffes
briefly1534573briefly
brutely1235933brutely
bubbly124110353b_ubbly
buff125229863b_uff__
buffalo1553723b_uffalo
buffed154313143b_uffed
buffer144512683b_uffer
buffet143113783b_uffet
buffi136112203b_uff_i
buffo135112183b_uff_o
buffos14447853b_uffos
buffs135519513b_uff_s
bulkily16227123bulkily
bully105124813b_u_lly
burbly134311153b_urbly
burly104922833b_u_rly
busily112211503b_usily
chuffy20445863chuff_y
cliffy17435243cliff_y
duffle13368533_duffle
fluff103913613fluff__
fluffed13295903fluffed
fluffer12336503fluffer
fluffs11347783fluff_s
fluidly1434813fluidly
flukily1735213flukily
glowfly1742673glowfly
gluily10308293glu_ily
glumly12356623glu_mly
gruffily1863083gruffily
gruffy16396013gruff_y
huffily1934693_huffily
huffy174810233_huff_y
liefly1266363_liefly
luff104426703_luff__
luffa11409023_luff_a
luffas12337483_luffas
luffed133810823_luffed
luffs114516283_luff_s
lushly12247343_lushly
muffle14339643_muffle
outfly1238273_outfly
plumply1634223plumply
plushly15385383plushly
pouffy17395883pouff_y
puffily1834843_puffily
puffy164410753_puff_y
ruffle124111673_ruffle
scuffle15266893scuffle
shuffle16276923shuffle
sluff114016813sluff__
sluffed14308303sluffed
sluffs12349583sluff_s
sniffly16265643sniffly
snuffily17124323snuffily
snuffle13267833snuffle
snuffy15356243snuff_y
souffle13306803souffle
stiffly16235173stiffly
stuffily17124163stuffily
stuffy15317083stuff_y
truffle1384893truffle
waffly18305433_waffly

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271056.50020619.5
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.93625762.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.