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 “boughten” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

63 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
boughten144419(None) 
foughten1544001foughten
boughed143810262bough_ed
bought125115632bought__
brighten1466242brighten
oughted1236222_oughted
roughen11338832rough_en
toughen11329202tough_en
abought1346143abought__
bighted142810923b_ighted
blighted1546863blighted
blighter1466853blighter
bogymen1534763bo_gymen
boogymen1643103boogymen
bouchee143313543bouch_ee
bouchees15339533bouchees
bough115719313bough___
boughless1543873boughless
boughpot1643503boughpot
boughs125414373bough__s
bougie93613273boug_ie_
bougies103715183boug_ies
bounden10389453bou_nden
bouton8311533bou__ton
brightens1565373brightens
brighter1476663brighter
brought13308683brought__
burthen1236363b_urthen
bushmen1436303b_ushmen
coughed143310903cough_ed
cougher133711733cough_er
daughter1344503daughter
doughier1335483doughier
dought114915513dought__
doughtier1443463doughtier
doughty15436023dought_y
fought135112393fought__
frighten1566443frighten
heighten1545703heighten
laughter1245113laughter
lighten112811523_lighten
nought104713963nought__
noughts11478083nought_s
ought95221533_ought__
oughting1335953_oughting
oughts104710183_ought_s
roughed124210943rough_ed
roughens12286893rough_ens
rougher113511033rough_er
roughhew1842873roughhew
roughhewn1951643roughhewn
roughies1298323roughies
roughleg1343403roughleg
soughed123811623sough_ed
sought106315053sought__
tighten11288973_tighten
toughed123511693tough_ed
toughens12286723tough_ens
tougher114210983tough_er
toughie1187593toughie_
toughies1278243toughies
waughted1643483waughted
youthen1336153youth_en

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 Limit146162637.28020077.2
3Display Results63630.0331909.1
 (SQL Overall)178691637.71923149.5
 
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.