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

128 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
bonesets103684(None) 
boneset9316431boneset_
besets85718802b__esets
boneless10310212boneless
boneyest1347842boneyest
bonnets94812802bon_nets
bonuses94212952bonuse_s
joneses1438962jonese_s
onsets64013542_on_sets
backsets1638853backsets
bannerets11205463bannerets
bannets94013843ban_nets
banquets1935433banquets
bassets96414823b_assets
beets76131443b__e_ets
begets96215523b__egets
behests1235953behes_ts
benefits1345713benefits
bennets94712163ben_nets
berets85822523b__erets
beses75830723b__ese_s
beset76739133b__eset_
besots86415453b__esots
bests75932613b__es_ts
boasts85017923bo_as_ts
bodements1447613bodements
bolases93315003bolase_s
boletes9316063bolete_s
boluses94113833boluse_s
bomblets1436023bomblets
bonders104120663bon_ders
bondless1148813bondless
bonehead1445933bonehead
boneheads1545203boneheads
bonemeal1245163bonemeal
bonemeals1343473bonemeals
boners84825433bon__ers
bones76446533bon__e_s
bonesetter1253183bonesetter
bonesetters1352633bonesetters
boneyer1237403boneye_r
bongoes104314113bongoe_s
boniest93318993bonies_t_
boniness102211803boniness
bonkers134015303bon_kers
bonnes85621453bon_ne_s
bonnet85524633bon_net_
bonniest10310773bonniest
bonzes175116103bon_ze_s
booklets14247123booklets
boomlets12246673boomlets
boosts86115013bo_os_ts
bopeeps1333103bope_eps
boreases10310253borease_s
boreens9310403bore_ens
borshts1266543bo_rshts
boskets13409473bo_skets
bosquets19195253bosquets
bosses85925403bo_sse_s
bouquets19244523bouquets
bourses94014303bourse_s
bouses84931783bo_use_s
bowses115718863bo_wse_s
brevets12519393b_revets
congests113510383conges_ts
consents102715893consents
contests103413383contes_ts
corsets94819803co_rsets
cosets85824403co__sets
cossets95014283co_ssets
donees74519493done_e_s
doneness9411513doneness
ebonises1039223ebonise_s
foresees11311643foresees
forests104114953fores_ts
geneses82613523genese_s
goneness9310763goneness
handsets12258343handsets
honest94822423hones_t_
honester1139713honester
honestest1247303honestest
honesty13378053hones_ty
insets64016133_in_sets
ionises72916433ionise_s
jonesed1536263jonese_d
kineses113111253kinese_s
knessets1243173_knessets
locksets1435693locksets
loneness8512093loneness
loveseats1253213loveseats
mindsets1135683mindsets
molests93311563moles_ts
moneyers1337423moneyers
monists93614783monis_ts
moonsets10216413moonsets
nests55728003__nes_ts
nonets64118703non__ets
nonevents1247483nonevents
nonusers8268003nonusers
nonuses73313863nonuse_s
obtests9136233obtes_ts
offsets1333503_offsets
omelets938333_omelets
oneness7512143_oneness
oneself1046073_oneself
onset54730173_on_set_
onuses65616253_onuse_s
outsets73514923_outsets
oversets113114173_oversets
possets94212773po_ssets
presets94216423_presets
renests74014213renes_ts
resets65427613__resets
rondelets1045263rondelets
rosets65819953ro__sets
solerets839693solerets
somersets1144253somersets
sonnets74211993son_nets
sunsets72911573sun_sets
toneless8610393toneless
tonemes9311683toneme_s
tonettes839203tonettes
tonlets73212503ton_lets
tonuses73612193tonuse_s
typesets1343213typesets
unsets64116163_un_sets
worsets105512843wo_rsets
zoneless1737823zoneless

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.406440125.6
2DLD Change Limit1461621287.31319986.6
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.76523012.4
 
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.