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

149 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
smartness113614(None) 
swartness1236111swartness
apartness1146052apartness
peartness1137772peartness
saltness82610242s_altness
scantness1135732scantness
scariness11310182scariness
sharpness1434932sharpness
shortness1236732shortness
smallness1174512smallness
smarminess1444302smarminess
smartass1044272smart_ass
smartens10286662smart_ens
smartest10310182smart_est
smarties10312872smartie_s
smartnesses1337142smartnesses
spareness1139862spareness
starkness1335962starkness
tartness82210132_tartness
alertness946053alertness
amarones10311353amarone_s
aptness9268573__aptness
artiness81615403__artiness
artless73712513__artless
awareness1236343awareness
bareness10912813_bareness
baroness101210063_baroness
chariness14310063chariness
chartless1435703chartless
curtness1037263_curtness
daftness1235533_daftness
darkness13247343_darkness
dearness939973dear_ness
dwarfness1642793dwarfness
exactness1843623exactness
farness102912203_far_ness
fastness11238763_fastness
fatness103311293_fa_tness
flatness1138153fla_tness
gastness9278473_gastness
glariness1038553glariness
hardness122411083_hardness
harness102413933_har_ness
heartiness1338033heartiness
heartless1236393heartless
hoariness1238823hoariness
inaptness1144333inaptness
inertness947973inertness
madness10310073_ma_dness
maleness10312313_maleness
maltiness112910573_maltiness
mariners103113863_mariners
marines93928013_marine_s
marquess19204953_marquess
martens93714953_mart_ens
martinets1138883_martinets
martlets103310483_martlets
mastless102610023_mastless
matiness102114743_matiness
matless93014043_ma_tless
mattress1036533_mattress
maziness19239543_maziness
meetness1036653_meetness
miriness10310463_miriness
mootness1036753_mootness
moreness10911573_moreness
nearness838313near_ness
neatness839153nea_tness
overtness1238223overtness
partners102711133_partners
pastness102510503_pastness
patness92912283_pa_tness
pertness10310093_pertness
raptness1046733_raptness
rareness81112853_rareness
sadness8310613s_a_dness
safeness11239633s_afeness
sageness92111983s_ageness
saltiness93312113s_altiness
saltless8259343s_altless
sameness102712683s_ameness
saneness82313723s_aneness
sarsnets836783s_arsnets
scaliness1149303scaliness
scantiness1236873scantiness
scarceness1444763scarceness
scarless10189053scar_less
seaminess11310473seaminess
seatless83213003sea_tless
shadiness1337463shadiness
shakiness1637083shakiness
shirtless12266413shirtless
skirtless13254423skirtless
slackness1535433slackness
slatiness92511363slatiness
smaltines1136993smaltine_s
smarmiest1335903smarmiest
smartasses1243163smartasses
smarted105012613smart_e_d
smarten9348863smart_e_n
smartened1244263smartened
smarter94113133smart_e_r
smartie9310163smartie__
smarts86218003smart___s
smartweed1542113smartweed
smartweeds1651433smartweeds
smatters104011713sma_tters
smokiness1535543smokiness
smoothness1543043smoothness
smugness1143813sm_ugness
smuttiness1244403smuttiness
snakiness1367473snakiness
soapiness1138293soapiness
softness1136433s_oftness
soreness8914793s_oreness
sorriness939583sorriness
sourness839543sour_ness
spaciness1337083spaciness
sparseness1245493sparseness
sportiness1278233sportiness
spryness1334003s_pryness
squareness1944763squareness
squatness1844943squatness
staginess1038753staginess
staidness1037033staidness
staleness9310783staleness
starless81610843star_less
starters83714763start_ers
startlers9236733startlers
startles82111963startle_s
sternness946093sternness
stoutness945853stoutness
straitness1046283straitness
suaveness1247693suaveness
sureness8912903s_ureness
swarthiness1743383swarthiness
swartnesses1436713swartnesses
sweetness1245683sweetness
swiftness1543653swiftness
tartiness92112053_tartiness
tautness8217183_tautness
teariness9310633teariness
unaptness1154173unaptness
vastness11257293_vastness
wariness11313213_wariness
warmness1337063_warmness
wartless11279923_wartless
weariness1238843weariness
whatness1435093wha_tness

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.203880251.2
2DLD Change Limit1486411497.73319221.6
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.