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

132 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
scantness113573(None) 
scantiness1236881scantiness
canoness1039392_canoness
saltness82610242s_altness
saneness82313722s_aneness
scaliness1149302scaliness
scanners10379702scan_ners
scantest101710182scant_est
scanties103215422scantie_s
scantiest112611002scantiest
scantnesses1376532scantnesses
scariness11310182scariness
scentless1135112scentless
smartness1136142smartness
swartness1236112swartness
vacantness1562512vacantness
apartness1146053apartness
aptness9268573__aptness
blandness1235973blandness
blankness1544673blankness
bluntness1144343bluntness
caginess11310303_caginess
cakiness1449553_cakiness
calmness1236643_calmness
canines93724033_canine_s
cannels93413363_can_nels
canners93822663_can_ners
canniness1138643_canniness
canteens1038573_canteens
canters94827733_cant_ers
cantles94721413_cantle_s
cattiness112310633_cattiness
centners1057243_centners
curtness1037263_curtness
daftness1235533_daftness
dankness13256693_dankness
distantness1254333distantness
exactness1843623exactness
faintness1235833faintness
fastness11238763_fastness
fatness103311293_fa_tness
flatness1138153fla_tness
frankness1655223frankness
gastness9278473_gastness
gauntness1044203gauntness
giantess933893giant_ess
grandness1138303grandness
inaneness948383inaneness
inaptness1144333inaptness
instantness1154083instantness
lankness12237043_lankness
leanness837373lean_ness
meanness1037183mean_ness
neatness839153nea_tness
pastness102510503_pastness
patness92912283_pa_tness
peartness1137773peartness
planeness1138153planeness
pliantness1263643pliantness
quaintness1943203quaintness
rankness12267943_rankness
raptness1046733_raptness
recentness1245463recentness
sadness8310613s_a_dness
safeness11239633s_afeness
sageness92111983s_ageness
saltiness93312113s_altiness
saltless8259343s_altless
sameness102712683s_ameness
sandiness102111713s_andiness
sandless93212343s_andless
scaleless1135513scaleless
scanned104110893scan_ne_d
scanner94411813scan_ne_r
scanted104114393scant_e_d
scanter94215183scant_e_r
scantier10309983scantie_r
scantinesses1437313scantinesses
scants85219723scant___s
scarceness1444763scarceness
scarless10189053sca_rless
scathes124515713sca_the_s
scatters103612753sca_tters
scattiest11268363scattiest
scrannels1143513scran_nels
scrawniness1652153scrawniness
scunners10357303scun_ners
seaminess11310473seaminess
seatless83213003sea_tless
shadiness1337463shadiness
shakiness1637083shakiness
shanteys14395513shant_eys
shanties113116583shantie_s
sharpness1434933sharpness
shininess1237333shininess
shortness1236733shortness
silentness1044573silentness
slackness1535433slackness
slanginess1146273slanginess
slatiness92511363slatiness
smallness1174513smallness
snakiness1367473snakiness
soapiness1138293soapiness
softness1136433s_oftness
soundness1036963soundness
spaciness1337083spaciness
spanless10247363span_less
spanners103710773span_ners
spareness1139863spareness
spininess1137963spininess
squatness1844943squatness
staginess1038753staginess
staidness1037033staidness
staleness9310783staleness
stanines85115673stanine_s
starkness1335963starkness
stoniness938343stoniness
stoutness945863stoutness
straitness1046293straitness
suaveness1247703suaveness
sunniness9247943sunniness
swankiness1744253swankiness
sweetness1245683sweetness
swiftness1543653swiftness
tacitness1134873tacitness
tartness82210133_tartness
tautness8217183_tautness
unaptness1154173unaptness
vastness11257293_vastness
wanness102610683_wan_ness
whatness1435093wha_tness
zaniness1738663_zaniness

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.436409841.7
2DLD Change Limit1486411327.65619415.0
3Display Results1321320.0602200.0
 (SQL Overall)1786911328.15221919.9
 
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.