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

159 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
assesses73738(None) 
assessed945021assessed
abbesses1235332abbesses
abscesses1344102abscesses
accesses1287492accesses
asceses938622asce_ses
asepses946362a_sepses
askeses1136462aske_ses
asperses104111672asperses
assess65710462asse_s_s
assessor843622assessor
assessors843932assessors
bassnesses1136842bassnesses
masseuses1144792masseuses
obsesses1036222obsesses
possesses1046322possesses
reassesses945062reassesses
abscessed1442703abscessed
abscises1246233abscises
absences1247673absences
abysses1234863a_bysses
accessed1385403accessed
actresses1137933actresses
addresses1165633addresses
admasses1135413admasses
aggresses1146143aggresses
amasses93912853a_masses
ancresses1138413ancresses
apheses12610703aphe_ses
appeases1238663appeases
aptnesses11168993aptnesses
asbestos1044353asbestos
asbestoses1242733asbestoses
asbestus1042953asbestus
asbestuses1252173asbestuses
ascesis938373asce_sis
asepsis985903a_sepsis
ashinesses1339163ashinesses
askesis1136123aske_sis
asperges11318093asperges
asperse94210663asperse_
aspersed11428293aspersed
asperser10408303asperser
aspersers11377243aspersers
aspises9611643a_spises
assassin844073assassin
assassins843933assassins
assegais943953assegais
assembles1354313assembles
assented957513assented
assenter867703assenter
assenters966993assenters
assents74512223asse_nts
asserted957903asserted
asserter877573asserter
asserters956393asserters
asserts74311793asse_rts
asses55629283a___sses
assessing1045173assessing
assessment1253613assessment
assessments1252933assessments
assetless943573assetless
assets65617663asse__ts
assholes1146743assholes
assisted936233assisted
assister836753assister
assisters936353assisters
assists738473ass_ists
assizes1638453ass_izes
assuages936273assuages
assumes967163ass_umes
assures7611403ass_ures
asswages1255053asswages
auxeses1435623auxe_ses
avenses1049643a_venses
avgasses1284193avgasses
badnesses1239253badnesses
basenesses12310563basenesses
biasnesses1236963biasnesses
blesses93812393_blesses
caresses10314063caresses
caseases10410473caseases
caseoses1039293caseoses
cassenes103611293casse_nes
cassettes1146703cassettes
cassises103811743cass_ises
cesses84221363__cesses
chesses124112633_chesses
crassnesses1246653crassnesses
cresses94219813_cresses
danseuses1044133danseuses
diseases92415813diseases
diseuses93112763diseuses
disseises1039333disseises
dresses83716173_dresses
duresses939173duresses
easinesses10314443easinesses
egresses949443egresses
essences1047563essences
esses56422973___esses
excesses1736753excesses
farnesses122310813farnesses
fastnesses1389083fastnesses
fatnesses121710463fatnesses
fesses94820253__fesses
finesses111912343finesses
gassinesses1197973gassinesses
gastnesses11129143gastnesses
gaynesses1336563gaynesses
guesses8169373_guesses
harnesses121812073harnesses
hostesses1247173hostesses
idlesses936003idlesses
jesses135215953__jesses
largesses10246273largesses
laxnesses1646633laxnesses
loesses7310033_loesses
madnesses1239833madnesses
masseuse1044253masseuse_
massinesses12128693massinesses
messes84924343__messes
miseases102614343miseases
missenses1148033missenses
nesses64718323__nesses
obsessed1144273obsessed
ogresses938473ogresses
osteoses839033osteoses
oyesses1037333_oyesses
passuses1036773pass_uses
pastnesses12910513pastnesses
patnesses111611793patnesses
possessed1244233possessed
presses93523153_presses
rashnesses1338723rashnesses
rawnesses1288123rawnesses
reassessed1143763reassessed
recesses10312323recesses
sadnesses10310303sadnesses
sasses64124393__sasses
sassies74719263sas_sies
sassinesses999323sassinesses
seises64026713__seises
senses63923943__senses
sepses84515883__sepses
sisses64520603__sisses
speises93813933_speises
speisses10245693_speisses
spenses92913573_spenses
stresses81112493stresses
susses64221053__susses
swisses10417143_swisses
tresses73719543_tresses
tsetses785453_tsetses
vastnesses13128203vastnesses
vitesses1136333vitesses
waenesses1239773waenesses
wannesses1239233wannesses
wiseasses1244043wiseasses
yesses93615813__yesses

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621597.34319904.9
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.84222786.4
 
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.