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

145 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
swartness123611(None) 
smartness1136141smartness
apartness1146052apartness
awareness1236342awareness
dwarfness1642792dwarfness
peartness1137772peartness
saltness82610242s_altness
scantness1135732scantness
scariness11310182scariness
sharpness1434932sharpness
shortness1236732shortness
spareness1139862spareness
starkness1335962starkness
swarthiness1743382swarthiness
swartnesses1436712swartnesses
sweetness1245682sweetness
swiftness1543652swiftness
tartness82210132_tartness
wariness11313212_wariness
warmness1337062_warmness
wartless11279922_wartless
alertness946053alertness
aptness9268573__aptness
artiness81615403__artiness
artless73712513__artless
awayness1443303awa_yness
bareness10912813_bareness
baroness101210063_baroness
chariness14310063chariness
chartless1435703chartless
curtness1037263_curtness
daftness1235533_daftness
darkness13247343_darkness
dearness939973dear_ness
exactness1843623exactness
farness102912203_far_ness
fastness11238763_fastness
fatness103311293_fa_tness
flatness1138153fla_tness
gastness9278473_gastness
glariness1038553glariness
hardness122411083_hardness
harness102413933_har_ness
heartiness1338033heartiness
heartless1236393heartless
hoariness1238823hoariness
inaptness1144333inaptness
inertness947973inertness
inwardness1443773inwardness
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
smallness1174513smallness
smarminess1444303smarminess
smartass1044273smart_ass
smartens10286663smart_ens
smartest10310183smart_est
smarties10312873smartie_s
smartnesses1337143smartnesses
snakiness1367473snakiness
soapiness1138293soapiness
softness1136433s_oftness
soreness8914793s_oreness
sorriness939583sorriness
sourness839543sour_ness
spaciness1337083spaciness
sparseness1245493sparseness
sportiness1278233sportiness
spryness1334003s_pryness
squareness1944763squareness
squatness1844943squatness
staginess1038753staginess
staidness1037033staidness
staleness9310783staleness
stalwartness1551503stalwartness
starless81610843star_less
starters83714773start_ers
startlers9236743startlers
startles82111963startle_s
sternness946093sternness
stoutness945863stoutness
straitness1046293straitness
suaveness1247693suaveness
sureness8912903s_ureness
swampiness1773353swampiness
swankiness1744253swankiness
swarajes1843743swaraje_s
swarmers1346323swar_mers
swarthiest1644743swarthiest
swarths13537323swart__hs
swathers144512083swa_thers
swathes134115513swa_the_s
swatters113911793swa_tters
sweatiness1336463sweatiness
tartiness92112053_tartiness
tautness8217183_tautness
teariness9310633teariness
unaptness1154173unaptness
unwariness1365883unwariness
upwardness1642653upwardness
vastness11257293_vastness
waeness102512783_wa_eness
waitress1135223_waitress
wanness102610683_wa_nness
wardless12249303_wardless
wardress12256163_wardress
warless104015103_war_less
warners103315563_war_ners
wartiest113614643_wartiest
wattless11268723_wattless
waviness1437723_waviness
waxiness1836723_waxiness
weariness1238843weariness
wetness10277723_w_etness
whatness1435093_whatness
wiriness1138953_wiriness
witness103010013_w_itness
wornness1136363_wornness
wryness13113983_w_ryness

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.1561145455.1
2DLD Change Limit1486411458.15618224.7
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.37521336.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.