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

67 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
sharpened154448(None) 
sharpener1444581sharpener
happened1635652_happened
hardened1338612_hardened
harkened1637482_harkened
resharpened1752012resharpened
scarpered1435112scarpered
sharped134112052sharp__ed
sharpen12389722sharpen__
sharpeners1543892sharpeners
sharpens13377812sharpen_s
shortened1345662shortened
smartened1244262smartened
careened1139193_careened
carpeted1338953_carpeted
chartered15158393chartered
chastened1545883chastened
cheapened1743783cheapened
coarsened1245143coarsened
dampened1435623_dampened
darkened1435943_darkened
gardened1137003_gardened
hampered16239933_hampered
hardener1238883_hardener
harkener1537573_harkener
harped124418403_harp__ed
harpooned1544323_harpooned
harshened1644453_harshened
hastened12239103_hastened
havened14429243_ha_vened
hearkened1744453hearkened
heartened1347063heartened
hoarsened1344053hoarsened
rehardened1543943rehardened
saddened1135343s_addened
sarcenet10413313s_arcenet
sardined10268663s_ardined
sarsenet8412943s_arsenet
scampered1635233scampered
scarped124314403scarp__ed
scarphed1635443scarp_hed
screened1137403s_creened
shampooed1742943shampooed
shaped125020103sha_p__ed
shapen114414653sha_pen__
shared105829063shar___ed
sharked153613913shar__ked
sharpening1644883sharpening
sharper124312703sharp__er
sharpers133810943sharpe_rs
sharpest1339143sharpe_st
sharpie1238393sharp_ie_
sharpies13411223sharp_ies
sharping143011373sharpin_g
sharpness1434933sharpness
shattered13178203shattered
sheened113511703sh__eened
shortener1245773shortener
shrapnel1342133shrap_nel
shrewed14589843sh_r_ewed
shrieked16265173sh_rieked
shrieved15276073sh_rieved
shrined114112413sh_r_ined
slackened1644243slackened
stamened1137633sta_mened
stampeded15343923stampeded
steepened1244073steepened

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.406440125.6
2DLD Change Limit148641677.00021234.4
3Display Results67670.0302233.3
 (SQL Overall)178691677.43624030.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.