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

85 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
smartened124426(None) 
heartened1347062heartened
sharpened1544482sharpened
shortened1345662shortened
smarted105012612smart__ed
smarten9348862smarten__
smartens10286662smarten_s
smartweed1542112smartweed
smattered12186782smattered
bartend1038753_barten_d
bartended1344663_bartended
bartered113113013_bartered
battened11259573_battened
careened1139193_careened
cartoned111312833_cartoned
chartered15158393chartered
chastened1545883chastened
coarsened1245143coarsened
darkened1435943_darkened
fastened12257853_fastened
fattened12268283_fattened
flattened13185303flattened
gardened1137003_gardened
gartered10319593_gartered
hardened1338613_hardened
harkened1637483_harkened
hastened12239103_hastened
hearkened1744453hearkened
heartener1256763heartener
hoarsened1344053hoarsened
latened8711923_la_tened
maddened1334893_maddened
margented1346813_margented
margined1237743_margined
marketed1537323_marketed
marooned1138563_marooned
marted94425213_mart__ed
marten84518263_marten__
martens93714953_marten_s
martinet10319643_martinet
martyred1434283_martyred
marveled1436433_marveled
mastered112614003_mastered
mattered112412903_mattered
mittened1136363_mittened
neatened937043nea_tened
pattened11299393_pattened
quartered19155963quartered
rattened9218623_rattened
saddened1135343s_addened
sarcenet10413313s_arcenet
sardined10268663s_ardined
sarsenet8412943s_arsenet
sauteed8349613s_aute_ed
scarpered1435113scarpered
scarted104816123scart__ed
scattered12197353scattered
screened1137413s_creened
sharpener1444583sharpener
shattered13178203shattered
shortener1245773shortener
slackened1644243slackened
smaltine1037833smaltine_
smaltines1136993smaltines
smartening1344993smartening
smarter94113133smart__er
smartest10310183smarte_st
smartie9310173smart_ie_
smarties10312873smart_ies
smarting113212453smartin_g
smartness1136143smartness
smartweeds1651433smartweeds
smatterer11185813smatterer
smoothened1642483smoothened
softened1235663s_oftened
sparteine1185483sparteine_
sparteines12105173sparteines
spattered12187643spattered
stamened1137633sta_mened
started84217323start__ed
startled9208563start_led
stoutened1053573stoutened
straitened1143783straitened
sweetened1343253sweetened
tautened935423_tautened

Search took 9 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 Limit148641857.56319653.7
3Display Results85850.0461847.8
 (SQL Overall)178691858.03222247.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.