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

160 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
purenesses1281074(None) 
surenesses101212211surenesses
barenesses12311702barenesses
curtnesses1238372curtnesses
cutenesses12910902cutenesses
direnesses11311482direnesses
duenesses1039332du_enesses
hugenesses1437142hugenesses
impurenesses16164432impurenesses
morenesses12811392morenesses
mutenesses1289972mutenesses
nudenesses1157862nudenesses
palenesses12312662palenesses
pertnesses12310312pertnesses
precesses13310462p_recesses
puninesses121110752puninesses
pureness101110182purene_s_s
pursinesses1338742pursinesses
rarenesses10313112rarenesses
rudenesses1188872rudenesses
sorenesses101313492sorenesses
sparenesses1339172sparenesses
truenesses1039312truenesses
acutenesses13126973acutenesses
airinesses102613613airinesses
apartnesses1346823apartnesses
awarenesses1447253awarenesses
baronesses1238913baronesses
basenesses12310563basenesses
bluenesses1237933bluenesses
burgesses1245513bur_gesses
burlinesses1338403burlinesses
businesses121411373businesses
busynesses15145503busynesses
crudenesses1476653crudenesses
cruelnesses1346253cruelnesses
curlinesses1338733curlinesses
cursednesses1554973cursednesses
darknesses1537013darknesses
demurenesses1544753demurenesses
donenesses11310563donenesses
dournesses1138243dour_nesses
drynesses1335363_drynesses
dullnesses1135993dullnesses
dulnesses1037763du_lnesses
dumbnesses1584603dumbnesses
dunnesses1037703du_nnesses
duresses939173dur__esses
eerinesses10612603eerinesses
farnesses122310813far_nesses
finenesses13310713finenesses
firmnesses1535613firmnesses
freenesses1339873freenesses
fullnesses1336213fullnesses
fulnesses1239053fu_lnesses
furrinesses1437183furrinesses
gamenesses1368983gamenesses
gonenesses11310253gonenesses
gorinesses11311553gorinesses
greynesses1446323_greynesses
halenesses13312043halenesses
hardnesses141810543hardnesses
harnesses121812073har_nesses
idlenesses1138033idlenesses
justnesses1736493justnesses
lamenesses12610563lamenesses
largenesses1247553largenesses
latenesses10413363latenesses
likenesses1449533likenesses
litenesses10513023litenesses
livenesses13411073livenesses
lonenesses10311343lonenesses
lornnesses1037823lornnesses
luridnesses1246723luridnesses
lushnesses1337343lushnesses
malenesses12312223malenesses
mirinesses121512313mirinesses
muchnesses1744713muchnesses
murderesses1443103murderesses
murkinesses17136783murkinesses
nicenesses12310353nicenesses
numbnesses1474693numbnesses
onenesses9311823_onenesses
packnesses1856633packnesses
pastnesses12910513pastnesses
patnesses111611793p_atnesses
patronesses1346473patronesses
peartnesses1338743peartnesses
peeresses1138473p_eeresses
perkinesses1748923perkinesses
phrensies1445743phren_sies
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
planenesses1349033planenesses
plumbnesses1753073plumbnesses
plumpnesses1753263plumpnesses
plushnesses1645583plushnesses
poetesses1137233p_oetesses
pokinesses1669613pokinesses
poornesses1236803poornesses
porkinesses1748773porkinesses
porteresses1345523porteresses
portresses1247313portresses
poshnesses1537463poshnesses
preblesses1445103p_reblesses
precessed1437523p_recessed
premisses13288763p_remisses
presses93523153p_r__esses
pretenses112210593p_retenses
primenesses1548993primenesses
primnesses1497803primnesses
princesses14206263p_rincesses
processes13310233p_rocesses
professes1437873p_rofesses
pronenesses1379263pronenesses
prowesses1437193p_rowesses
pudginesses1545053pudginesses
puffinesses1934513puffinesses
pugginesses1545253pugginesses
pulpinesses1536003pulpinesses
punkinesses17127223punkinesses
pushinesses1697333pushinesses
queernesses2044573queernesses
quietnesses2045603quietnesses
recesses10312323__recesses
rednesses10312313__rednesses
rifenesses1339943rifenesses
ripenesses12310373ripenesses
safenesses1349373safenesses
sagenesses11510823sagenesses
samenesses12410853samenesses
sanenesses10412693sanenesses
securenesses1445673securenesses
solenesses10412703solenesses
sournesses10310013sour_nesses
sparsenesses1345803sparsenesses
sprucenesses1694613sprucenesses
sprynesses1544973sprynesses
squarenesses2144973squarenesses
suavenesses1448423suavenesses
suchnesses1536673suchnesses
sureness8912903surene_s_s
surlinesses11310053surlinesses
tamenesses1259973tamenesses
tartnesses101110713tartnesses
tersenesses1149043tersenesses
tirednesses1247743tirednesses
tweenesses1345803tweenesses
vilenesses13310223vilenesses
waenesses1239773_waenesses
warinesses131514523warinesses
warmnesses15167353warmnesses
widenesses1438773widenesses
wirelesses1345333wirelesses
wirinesses131811523wirinesses
wisenesses13310823wisenesses
woenesses1239133_woenesses
wornnesses1337133wornnesses
wrynesses1534843_wrynesses

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.500357382.0
2DLD Change Limit1406031606.61021271.3
3Display Results1601600.0762105.3
 (SQL Overall)1786911607.18624866.5
 
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.