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

188 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
pastnesses1291050(None) 
fastnesses1389071fastnesses
gastnesses11129131gastnesses
pastinesses13911701pastinesses
patnesses111611791pa_tnesses
vastnesses13128191vastnesses
apartnesses1346822apartnesses
aptnesses11168992_aptnesses
basenesses12310552basenesses
bassnesses1136832bassnesses
daftnesses1436382daftnesses
easinesses10314412easinesses
fatnesses121710462fa_tnesses
hastinesses141210682hastinesses
justnesses1736472justnesses
lostnesses1049292lostnesses
nastinesses111110722nastinesses
packnesses1856622packnesses
palenesses12312652palenesses
pastness102510502pastne_s_s
peartnesses1338712peartnesses
pertnesses12310292pertnesses
poshnesses1537452poshnesses
raptnesses1248522raptnesses
rashnesses1338712rashnesses
saltnesses10310162saltnesses
tartnesses101110712tartnesses
tastinesses111110772tastinesses
tautnesses10118282tautnesses
actresses1137933_actresses
apishnesses1646373apishnesses
artinesses10815193_artinesses
ashinesses1339153_ashinesses
assesses737383_as_sesses
badnesses1239243ba_dnesses
baldnesses1337643baldnesses
barenesses12311693barenesses
baronesses1238903baronesses
battinesses13169443battinesses
biasnesses1236943bias_nesses
brashnesses1646543brashnesses
businesses121411353businesses
bustinesses131310073bustinesses
busynesses15145493busynesses
caginesses13310933caginesses
cakinesses16310603cakinesses
calmnesses1436833calmnesses
canonesses1238413canonesses
cattinesses13129703cattinesses
chastenesses1746303chastenesses
cosinesses121012813cosinesses
crassnesses1246653crassnesses
curtnesses1238363curtnesses
dampnesses1535603dampnesses
danknesses1536253danknesses
darknesses1537013darknesses
deftnesses1436813deftnesses
distresses1148843distresses
dustinesses121110333dustinesses
exactnesses2044323exactnesses
faintnesses1447143faintnesses
fairnesses1357383fairnesses
falsenesses1446743falsenesses
farnesses122310813fa_rnesses
fastness11238763fastne_s_s
fattinesses14118973fattinesses
firstnesses1445733firstnesses
fitnesses12219373_fitnesses
flatnesses1337763flatnesses
fustinesses14129763fustinesses
gamenesses1368983gamenesses
gaminesses13410453gaminesses
gassinesses1197963gassinesses
gastness9278473gastne_s_s
gauntnesses1245173gauntnesses
gaynesses1336563ga_ynesses
gustinesses12139503gustinesses
halenesses13312033halenesses
halfnesses1636263halfnesses
hardnesses141810543hardnesses
harnesses121812073ha_rnesses
harshnesses1745853harshnesses
hazinesses2239213hazinesses
hostesses1247173host_esses
hotnesses1238903_hotnesses
inaptnesses1385633inaptnesses
lacinesses12312103lacinesses
lamenesses12610563lamenesses
lanknesses1437503lanknesses
latenesses10413353latenesses
laxnesses1646633la_xnesses
lazinesses19310143lazinesses
lushnesses1337333lushnesses
lustinesses11910403lustinesses
madnesses1239833ma_dnesses
malenesses12312203malenesses
maltinesses13310223maltinesses
massinesses12128683massinesses
matinesses12314523matinesses
mattresses1245433mattresses
mazinesses2139903mazinesses
meetnesses1237443meetnesses
mistinesses131310603mistinesses
mistresses1247993mistresses
moistnesses1347143moistnesses
mootnesses1237153mootnesses
mustinesses131010393mustinesses
nattinesses11119313nattinesses
neatnesses10310003neatnesses
nosinesses101411303nosinesses
paltrinesses1445513paltrinesses
pantdresses1443743pantdresses
pastiness112312353pastine_s_s
pastises103616053past__ises
pastless102411203pastle_s_s
patness92912283pa_tne_s_s
patronesses1346473patronesses
pawkinesses2036153pawkinesses
peskinesses1746563peskinesses
pettinesses1338623pettinesses
pinknesses1636583pinknesses
pipinesses1448593pipinesses
pixinesses1937363pixinesses
plainnesses1356203plainnesses
planenesses1349033planenesses
pliantnesses1444453pliantnesses
plushnesses1645573plushnesses
poetesses1137233poet_esses
pokinesses1669603pokinesses
poornesses1236803poornesses
portresses1247303portresses
possesses1046313pos_sesses
pottinesses1339093pottinesses
prestresses1346713prestresses
primnesses1497803primnesses
prosinesses13310843prosinesses
puninesses121110743puninesses
purenesses12810723purenesses
pursinesses1338723pursinesses
pushinesses1697323pushinesses
racinesses12313493racinesses
ranknesses1438093ranknesses
rarenesses10313093rarenesses
raspinesses1338003raspinesses
rawnesses1288123ra_wnesses
restresses1049313restresses
rosinesses101213133rosinesses
rustinesses11911523rustinesses
sadnesses10310303sa_dnesses
safenesses1349373safenesses
sagenesses11510823sagenesses
saltinesses11311443saltinesses
samenesses12410853samenesses
sanenesses10412693sanenesses
sassinesses999313sassinesses
scantnesses1376533scantnesses
smartnesses1337143smartnesses
softnesses1337603softnesses
spacinesses1538093spacinesses
sparenesses1339173sparenesses
sparsenesses1345803sparsenesses
stresses81112493__stresses
swartnesses1436713swartnesses
tacitnesses1336323tacitnesses
tallnesses1037463tallnesses
tamenesses1259963tamenesses
tartinesses111011493tartinesses
tattinesses11128943tattinesses
testinesses111210313testinesses
unaptnesses1395523unaptnesses
unstresses1046033unstresses
vainnesses1337343vainnesses
vastness11257293vastne_s_s
waenesses1239773wa_enesses
waitresses1345063waitresses
wannesses1239233wa_nnesses
warinesses131514513warinesses
warmnesses15167353warmnesses
washinesses1737253washinesses
waspinesses1636693waspinesses
wavinesses16199273wavinesses
waxinesses20138753waxinesses
wetnesses12208213_wetnesses
whatnesses1635733whatnesses
wisenesses13310803wisenesses
witnesses12219923_witnesses
yeastinesses1545563yeastinesses
zaninesses19310373zaninesses

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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031887.48318789.7
3Display Results1881880.1101709.1
 (SQL Overall)1786911887.74923059.9
 
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.