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

183 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
besotting1225687(None) 
besetting12268421besetting
befitting15236622befitting
begetting13186582begetting
beknotting1782812beknotting
beshouting1644022beshouting
besmutting1553352besmutting
besoothing1693162besoothing
besting104923922bes__ting
bestowing1535802bestowing
betting103921402be__tting
blotting113910432b_lotting
repotting12511122repotting
resetting102816292resetting
resitting103414872resitting
resorting10614612resorting
respotting1347112respotting
abetting1158293abe__tting
allotting1046503allotting
assorting1037303assorting
basseting1236153basseting
bassetting1344633bassetting
basting104227203bas__ting
batting104422273b__atting
beating104326873be__ating
beclothing1843873beclothing
becoming1538163beco_ming
beetling1139283be_etling
befogging1773413befogging
befooling1535053befooling
befouling1534983befouling
befretting1644793befretting
begotten1143243begotten_
beholding1634233beholding
behooving1843743behooving
behoving1734913beho_ving
behowling1843683behowling
belittling1343193belittling
belonging1335913belonging
belting104119133be__lting
bemisting1438073bemisting
bemoaning1435953bemoaning
bemocking2034653bemocking
berating113220763be_rating
berthing14209603be_rthing
bescouring1584643bescouring
beseeming1435143beseeming
beshaming1735673beshaming
besieging1344763besieging
besliming1435493besliming
besmiling1436263besmiling
besmoking18114613besmoking
besmoothing19122003besmoothing
besnowing1544123besnowing
besotted1135843besott_ed
bespousing1553413bespousing
betrothing1644673betrothing
bevomiting1843103bevomiting
beworming1734553beworming
bisecting1436973bisecting
bisontine1145673bisontine
bitting103717293b__itting
blatting114111653b_latting
bloating113512813b_loating
boating103721303b__oating
bolting104416763b__olting
boosting113311053b_oosting
booting103821363b__ooting
bosoming1336643boso_ming
bottling11279143b__ottling
boycotting1842633boycotting
brevetting1644333brevetting
busting104221793bus__ting
bustling112110063bus_tling
butting103519283b__utting
clotting113110643_clotting
decocting1538123decocting
defatting1436103defatting
dehorting1447213dehorting
demitting13239073demitting
demoting12311423demo_ting
denoting10311753deno_ting
deporting1369593deporting
deratting1139513deratting
desalting1138843desalting
deserting11713143deserting
desisting112810383desisting
desolating1239463desolating
desorbing1346363desorbing
despiting13179323despiting
devoting1338823devo_ting
dotting93314483__dotting
emitting112410353_emitting
emoting10313563_emo_ting
escorting1237713_escorting
escoting1158713_escoting
estating92614993_estating
fetting113517873fe__tting
garotting1136113garotting
gavotting1443193gavotting
gestating11229983gestating
getting93316563ge__tting
hesitating1448003hesitating
hotting113116523__hotting
insetting1079283insetting
jesting154317713jes__ting
jetting153815343je__tting
jotting152912773__jotting
knotting13236573_knotting
letting83218533le__tting
lotting82917753__lotting
nesting84320443nes__ting
nestling958893nes_tling
netting84018763ne__tting
pestling111010253pes_tling
petting103720953pe__tting
plotting113011013_plotting
potting103720893__potting
presetting131010833presetting
presorting1339983presorting
rebooting12139023rebooting
rebottling1343733rebottling
rebutting1237523rebutting
recoating121317463recoating
recutting1239483recutting
refitting132811123refitting
reknotting1564233reknotting
reletting102713943reletting
remitting122412623remitting
replotting1357043replotting
reporting12513903reporting
rerouting10311873rerouting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resettling1135893resettling
reshooting1436223reshooting
resifting133512093resifting
resisting103215313resisting
resiting93521123res_iting
resittings11264553resittings
reslating102516993reslating
resoaking1439373resoaking
resodding1237203resodding
resoling92916303reso_ling
resolving1337743resolving
resonating11311263resonating
resorbing1269353resorbing
resowing123111523reso_wing
respiting121912863respiting
restating102319413restating
resting85031183res__ting
restoking1438193restoking
restoring10314613restoring
restring91518783res_tring
resulting10311083resulting
retorting10613273retorting
retting83425883re__tting
revetting132912633revetting
revolting1339633revolting
revoting12312033revo_ting
rewetting132710443rewetting
rotting82919683__rotting
setting83621393__setting
shotting123012383_shotting
sitting83519633__sitting
slotting92612613_slotting
sooting82820963__sooting
sorting83221813__sorting
spotting112812093_spotting
stotting92811163_stotting
swotting12268483_swotting
testing86021053tes__ting
totting82816843__totting
trotting92510913_trotting
unsetting1088993unsetting
upsetting1275563upsetting
vesting114618683ves__ting
vetting114216563ve__tting
westing115020273wes__ting
wetting114117383we__tting
wotting112913843__wotting
zesting174515333zes__ting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411837.11020905.9
3Display Results1831830.0762407.9
 (SQL Overall)1786911837.60923484.2
 
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.