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

143 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
nicenesses1231035(None) 
direnesses11311482direnesses
finenesses13310712finenesses
icinesses11310072_icinesses
likenesses1449532likenesses
litenesses10513022litenesses
livenesses13411072livenesses
naivenesses1449112naivenesses
niceness1039842nicene_s_s
nighnesses1446462nighnesses
nudenesses1157862nudenesses
richnesses1537802richnesses
rifenesses1339942rifenesses
ripenesses12310372ripenesses
sicknesses1636762sicknesses
snidenesses1248652snidenesses
vilenesses13310222vilenesses
widenesses1438772widenesses
wisenesses13310822wisenesses
acidnesses1337253acidnesses
agilenesses1247773agilenesses
airinesses102613613airinesses
alikenesses1547203alikenesses
alivenesses1448873alivenesses
archnesses1547173archnesses
barenesses12311703barenesses
basenesses12310563basenesses
biasnesses1236963biasnesses
bignesses1267963bi_gnesses
bluenesses1237933bluenesses
chicnesses1745213chic_nesses
choicenesses1944673choicenesses
cutenesses12910903cutenesses
digeneses1147393digene_ses
dimnesses1238213di_mnesses
donenesses11310563donenesses
duenesses1039333_duenesses
entirenesses1249663entirenesses
ficklenesses2144153ficklenesses
fiercenesses1744313fiercenesses
finesses111912343fi__nesses
finitenesses1557723finitenesses
firmnesses1535613firmnesses
fitnesses12219373fi_tnesses
fixednesses2244853fixednesses
freenesses1339873freenesses
gamenesses1368983gamenesses
gonenesses11310253gonenesses
halenesses13312043halenesses
highnesses1746083highnesses
hipnesses1436753hi_pnesses
hugenesses1437143hugenesses
ickinesses1637183_ickinesses
idlenesses1138033idlenesses
illnesses937283_illnesses
inanenesses1149523inanenesses
incenses102411003incen__ses
inkinesses1439423inkinesses
innernesses1146733innernesses
invernesses1447033invernesses
juicinesses2035893juicinesses
kindnesses1537213kindnesses
lacinesses12312123lacinesses
lamenesses12610563lamenesses
latenesses10413363latenesses
licensees1184473licen_sees
licenses10118923licen__ses
licitnesses1346413licitnesses
liminesses121310853liminesses
limpnesses14116653limpnesses
lionesses939433li_onesses
lithenesses1447313lithenesses
lonenesses10311343lonenesses
malenesses12312223malenesses
mildnesses1397393mildnesses
mirinesses121512313mirinesses
morenesses12811393morenesses
muchnesses1744713muchnesses
mutenesses1289973mutenesses
nakednesses1645843nakednesses
nativenesses1548563nativenesses
nearnesses1039103nearnesses
neatnesses10310013neatnesses
newnesses1236123n_ewnesses
niftinesses1437243niftinesses
nimblenesses1656013nimblenesses
nimbynesses1842053nimbynesses
nippinesses1545063nippinesses
noblenesses1348073noblenesses
noisinesses1139483noisinesses
nosinesses101411323nosinesses
notednesses1247793notednesses
nownesses1236893n_ownesses
numbnesses1474693numbnesses
oilinesses101512443oilinesses
onenesses9311823_onenesses
packnesses1856633packnesses
palenesses12312663palenesses
pickinesses1996833pickinesses
pinknesses1636583pinknesses
pipinesses1448603pipinesses
pixinesses1937373pixinesses
primenesses1548993primenesses
purenesses12810743purenesses
quicknesses2643753quicknesses
racinesses12313513racinesses
rarenesses10313113rarenesses
riminesses121211413riminesses
rudenesses1188873rudenesses
safenesses1349373safenesses
sagenesses11510823sagenesses
samenesses12410853samenesses
sanenesses10412693sanenesses
sidednesses1347103sidednesses
sizinesses1938653sizinesses
slicknesses1745193slicknesses
solenesses10412703solenesses
sorenesses101313493sorenesses
spicinesses1547103spicinesses
suchnesses1536673suchnesses
surenesses101212213surenesses
tamenesses1259973tamenesses
thicknesses2043913thicknesses
tidinesses1139223tidinesses
tininesses10311163tininesses
tirednesses1247743tirednesses
titanesses1037253titanesses
tritenesses11710393tritenesses
truenesses1039313truenesses
tweenesses1345803tweenesses
uniquenesses2154713uniquenesses
unlikenesses1645813unlikenesses
unripenesses1446013unripenesses
victresses1544973victresses
waenesses1239773_waenesses
whitenesses1746653whitenesses
wickednesses2243273wickednesses
wildnesses14157363wildnesses
wilinesses131911093wilinesses
wirelesses1345333wirelesses
wirinesses131811523wirinesses
witnesses12219923wi_tnesses
woenesses1239133_woenesses

Search took 7 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.420425454.8
2DLD Change Limit1406031436.25022496.5
3Display Results1431430.0801787.5
 (SQL Overall)1786911436.75026472.7
 
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.