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 “recentnesses” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
recentnesses146537(None) 
presentnesses1554422presentnesses
recentness1245462recentne_s_s
ancientnesses1553283ancientnesses
erectnesses1347473_erectnesses
evennesses1345943_even_nesses
frequentnesses2661423frequentnesses
greennesses1247033gre_en_nesses
intentnesses1277123intentnesses
keennesses1445323ke_en_nesses
meetnesses1237453me_e_tnesses
reedinesses1259563re_edinesses
scantnesses1376533_scantnesses
selectnesses1446113selectnesses
serenenesses12117113serenenesses
silentnesses1275443silentnesses
vacantnesses1742973vacantnesses
abjectnesses2352564abjectnesses
adeptnesses1444834_adeptnesses
alertnesses1147234_alertnesses
aliennesses1145864alien_nesses
ancestresses1493274ancestresses
beefinesses1675954be_efinesses
beerinesses1398924be_erinesses
bluntnesses1345394_bluntnesses
brazennesses2343284brazen_nesses
breezinesses2343944bre_ezinesses
brokennesses1843304broken_nesses
canonesses1238424__canonesses
centeses1079444__cent_e_ses
covertnesses1746334covertnesses
cravennesses1744114craven_nesses
creepinesses1645254cre_epinesses
currentnesses1552994currentnesses
curtnesses1238374__curtnesses
deepnesses1366674de_e_pnesses
deftnesses1436814__deftnesses
dementednesses1853814dementednesses
devoutnesses1683934devoutnesses
directnesses1595284directnesses
drivennesses1643834driven_nesses
eerinesses10612604_e_erinesses
electresses1345964_electresses
epentheses1563804_epenthe_ses
exactnesses2044344_exactnesses
expertnesses2144844expertnesses
eyednesses1445814_eye_dnesses
eyewitnesses1852114_eyewitnesses
faintnesses1447144_faintnesses
fleetnesses1445484_fleetnesses
freenesses1339874fre_e__nesses
frozennesses2443224frozen_nesses
gauntnesses1245174_gauntnesses
geekinesses1635814ge_ekinesses
greatnesses1247794_greatnesses
greedinesses1446464gre_edinesses
ineptnesses1396384_ineptnesses
inertnesses1198724_inertnesses
inventresses1553024inventresses
jejunenesses1852624jejunenesses
leadennesses1354574leaden_nesses
leannesses10108344le_an_nesses
leerinesses11119484le_erinesses
levelnesses1445554leve_lnesses
licitnesses1346414lic_itnesses
meannesses12128164me_an_nesses
meeknesses1644804me_e_knesses
neatnesses10310014__neatnesses
needinesses1258104ne_edinesses
nicenesses12310354nice__nesses
opennesses1246314_open_nesses
overtnesses1448714_overtnesses
peartnesses1338744pe_artnesses
perfectnesses2053354perfectnesses
pertnesses12310314__pertnesses
pliantnesses1444454pliantnesses
precisenesses1756284precisenesses
presentness1345664presentne_s_s
quaintnesses2143824quaintnesses
quietnesses2045604quie_tnesses
racinesses12313514rac__inesses
raininesses11310484r_aininesses
ranknesses1438094r__anknesses
raptnesses1248524r__aptnesses
rarenesses10313114rare__nesses
readinesses12611274re_adinesses
realnesses10310854r__ealnesses
recentest11410284recent_e_s_t
receptivenesses22106054receptivenesses
recesses10312324rec____esses
recklessnesses1955844recklessnesses
recondenses1444964recon_denses
reconditenesses1863154reconditenesses
rednesses10312314r__e_dnesses
reexpresses2043614re_expresses
regalnesses1246194re_galnesses
relentless1043704relentle_s_s
relentlessly1561694relentlessly
relentlessness1452614relentlessness
remissnesses1344954remissnesses
remotenesses1446814remotenesses
repletenesses1554494repletenesses
resentences1347424resent_ences
resentfulnesses1883744resentfulnesses
restresses1049314r__estresses
resyntheses1752844resynthe_ses
retentivenesses1896404retentivenesses
richnesses1537804ric__hnesses
rifenesses1339944rife__nesses
rightnesses1546234r_ightnesses
ripenesses12310374ripe__nesses
robustnesses1443784robustnesses
rockinesses1737364roc_kinesses
rottennesses1244424rotten_nesses
rotundnesses1343824rotundnesses
roundnesses1247044r_oundnesses
rudenesses1188874rude__nesses
runninesses11137694r_unninesses
runtinesses111210964r__untinesses
scantinesses1437314_scantinesses
securenesses1445674securenesses
seedinesses1259204se_edinesses
severenesses1545614severenesses
sweetnesses1445724_sweetnesses
tacitnesses1336324tac_itnesses
unevennesses1544074uneven_nesses
vexednesses2244604vexe_dnesses
weedinesses1557074we_edinesses
weepinesses1646134we_epinesses
wetnesses12208214__we_tnesses

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901306.54619063.6
3Display Results1301300.0931397.8
 (SQL Overall)1786911307.02925422.0
 
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.