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

232 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
bluffing1727549(None) 
buffing163411391b_uffing
fluffing14275411fluffing
luffing143310101_luffing
sluffing15247301sluffing
baffing164011602b_affing
biffing163510012b_iffing
blubbing12257012blubbing
bludging13297462bludging
bluefin1245122bluefin_
bluefins1345112bluefins
blueing103710202blu_eing
bluing94914482blu__ing
bluming123511282blu_ming
blunging12328412blunging
blunting11319842blunting
blurbing13326502blurbing
blurring11277232blurring
blurting11258772blurting
blushing14339332blushing
boffing16339982b_offing
chuffing2055042chuffing
cuffing163210252_cuffing
gruffing1635272gruffing
huffing17278832_huffing
muffing163210402_muffing
puffing162910942_puffing
ruffing143210842_ruffing
scuffing17287112scuffing
snuffing15256792snuffing
stuffing15247842stuffing
baffling1756053baffling
barfing134615093b_arfing
baulking1536003baulking
beefing133911473b_eefing
begulfing1642843begulfing
biffin14369103b_iffin_
biffins15358533b_iffins
blabbing12266723blabbing
blacking174213603blacking
blading113615363bl_ading
blagging13319163blagging
blaming123515693bl_aming
blanking154411933blanking
blaring104317113bl_aring
blasting114013423blasting
blatting114111653blatting
blawing134012753bl_awing
blazing193612393bl_azing
blearing113111943blearing
bleating113514503bleating
blebbing12265673blebbing
bleeding12359053bleeding
bleeping13377933bleeping
blending12249963blending
blessing1137593blessing
blinding123210163blinding
blinking153510623blinking
blipping15306803blipping
blissing1136873blissing
blitzing2035903blitzing
bloating113512813bloating
blobbing12246923blobbing
blocking174510573blocking
blogging13369013blogging
blooding122410653blooding
blooming13299433blooming
blooping13248843blooping
blotting113910433blotting
blousing1138793blousing
blowing133813053bl_owing
bluefish1645143bluefish
blueings11305513blu_eings
blueline1036873blueline
bluff134413833bluff___
bluffed16326433bluff_ed
bluffer15396883bluff_er
bluffers16405703bluffers
bluffest1664633bluffest
bluffly1833433bluff_ly
bluffs14388373bluff__s
bluings10327963blu__ings
boffin14359053b_offin_
boffins15329073b_offins
bouffant1643683bouffant
bouncing13318773bouncing
bounding123012133bounding
bousing103718043bou_sing
briefing1436943briefing
bruising11279143bruising
bruiting11259973bruiting
brushing14359963brushing
bruting102612993bru_ting
bruxing17236823bru_xing
bucking163617573b_ucking
budding123712403b_udding
budging124313023b_udging
buffering1835223b_uffering
buffeting1843783b_uffeting
buffi136112203b_uffi__
buffier1568403b_uffier
bugging123515183b_ugging
bugling113615343b_ugling
bulging113514213b_ulging
bulking143815123b_ulking
bulling104324793b_ulling
bullring11388423bullring
bullying14329293bullying
bumming143410783b_umming
bumping143812493b_umping
bunging113616503b_unging
bunking144016193b_unking
bunting103718833b_unting
buoying13379953b_uoying
burking143716323b_urking
burling104421133b_urling
burning104215503b_urning
burping124012943b_urping
burring104016993b_urring
burying133413913b_urying
bushing134018583b_ushing
busing96420593b_u_sing
busking144116573b_usking
bussing103614623b_ussing
busting104221793b_usting
busying134211993b_usying
butling103516813b_utling
butting103519283b_utting
buying124213833b_u_ying
buzzing18186543b_uzzing
chaffing2036323chaffing
cheffing2034463cheffing
clefting14347583clefting
clubbing15266513clubbing
clucking17429993clucking
clueing104110093clu_eing
cluing93913503clu__ing
clumping15319883clumping
clunking15329433clunking
coffing163811253_coffing
coiffing1755933coiffing
daffing15369733_daffing
doffing15357793_doffing
eluding93412113elu_ding
eluting84115293elu_ting
feoffing1432963feoffing
flubbing16275883flubbing
fluffier13264333fluffier
fluffily1652923fluffily
fluking154410513flu_king
fluming133512793flu_ming
flumping16287583flumping
flunking16317773flunking
flushing15288833flushing
fluting113815093flu_ting
fluxing18398923flu_xing
gaffing15379733_gaffing
glueing9338713glu_eing
glugging10316353glugging
gluing83812053glu__ing
glutting10247643glutting
gulfing12339473_gulfing
kludging15264513kludging
kluging13356593klu_ging
leafing113313583_leafing
lifting113313273_lifting
loafing11319793_loafing
lofting113311313_lofting
lubing94114043_lu_bing
lucking143615833_lucking
lugeing9359113_lugeing
lugging104114353_lugging
luging83915293_lu_ging
lulling83616803_lulling
lumping123314643_lumping
lunging93714213_lunging
lunting83817743_lunting
luring73820753_lu_ring
lurking123710853_lurking
lushing114316113_lushing
lusting83619323_lusting
luting75221753_lu_ting
miffing16298403_miffing
muffin14298873_muffin_
muffins15308343_muffins
muffling1765503_muffling
naffing14359033_naffing
offing13368643__offing
outbluffing2071603outbluffing
piaffing1733923piaffing
plucking17357723plucking
plugging13306893plugging
plumbing15286433plumbing
pluming123412043plu_ming
plumping15277633plumping
plunging12357673plunging
plunking15328483plunking
puffin141149003_puffin_
puffins15278913_puffins
quaffing2434353quaffing
rebuffing1843263rebuffing
reffing143712173_reffing
riffing144011273_riffing
ruffling1546093_ruffling
sclaffing1843363sclaffing
scoffing17275943scoffing
scuffling1843603scuffling
shuffling1933443shuffling
slubbing13248033slubbing
sludging11268363sludging
slugging11339423slugging
sluicing1137063sluicing
sluing74315883slu__ing
slumming13278383slumming
slumping13359973slumping
slurping11278123slurping
slurring9288833slurring
slushing12299643slushing
sniffing15227453sniffing
snuffling1643553snuffling
spiffing17237083spiffing
staffing15247493staffing
stiffing15248703stiffing
stuffings16233493stuffings
surfing112914483_surfing
tiffing14339383_tiffing
tufting11289873_tufting
turfing113010053_turfing
uncuffing1843703uncuffing
waffing173710243_waffing
whiffing2134703whiffing
yaffing17337823_yaffing

Search took 8 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 Filter1786911461620.233766914.2
2DLD Change Limit1461622327.59619242.0
3Display Results2322320.0932494.6
 (SQL Overall)1786912327.92222556.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.