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

127 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
erotisms1031016(None) 
egotisms1146681egotisms
ergotisms1245301ergotisms
erotism9312301erotism_
exotisms1746721exotisms
acrotisms1347492acrotisms
bromisms1436402bromisms
brutisms1245412brutisms
egoisms1065952ego_isms
egotism1038352egotism_
egotists937062egotists
elitisms1048192elitisms
eonisms92811042e_onisms
erethisms1445382erethisms
ergotism1146272ergotism_
eroticisms1457992eroticisms
erotics91914152eroti_cs
erotizes17311212erotizes
etatisms1038292etatisms
exotism1638122exotism_
helotisms1446832helotisms
heroisms1338692hero_isms
nepotisms1355392nepotisms
protists10313362protists
protiums1238552protiums
teratisms11410072teratisms
tropisms1247722tropisms
acrotism1248223acrotism_
artists74215593ar_tists
atomisms12269573atomisms
atropisms1347113atropisms
autisms94311553_autisms
azotises1737603azotises
baptisms1446033baptisms
bromism1337623bromism_
brutism1146773brutism_
bruxisms1942943bruxisms
clonisms1237793clonisms
cronyisms1643813cronyisms
cultisms12126713cultisms
demonisms1448053demonisms
demotists1247323demotists
despotisms1543143despotisms
dicrotisms1545143dicrotisms
ebonises1039223ebonises
echoisms1546143echoisms
egoism977473ego_ism_
egoists887073ego_ists
egotist8411273egotis_t
elitism939763elitism_
elitists848543elitists
embolisms1545633embolisms
emotions10610283emotions
enosises8311003enosises
eonism83213533e_onism_
erbiums1135463er_biums
eremitisms1445023eremitisms
erethism1345863erethism_
eroses65327053ero__ses
erosions8310343erosions
erotic82620273eroti__c
erotica92811513eroti_ca
erotical101911983erotical
eroticism13219183eroticism
eroticist11712073eroticist
eroticists1278183eroticists
erotize16311663eroti_ze
erotized1838553erotized
erythrisms1854033erythrisms
etatism9610293etatism_
europiums1344113europiums
exorcisms2044863exorcisms
exoticisms2155713exoticisms
exotics16229193exoti_cs
hedonisms1545603hedonisms
helotism1347703helotism_
hermetisms1745623hermetisms
hermitisms1745613hermitisms
heroinisms1546633heroinisms
heroism12311013hero_ism_
holisms123811113_holisms
idiotisms1244203idiotisms
idolisms1146353idolisms
iodisms10308483_iodisms
iritises839973iritises
ironists839293ironists
leftisms13235243leftisms
lookisms1444793lookisms
momisms10308223_momisms
monisms113512803_monisms
moronisms1348173moronisms
mortises10713613mortises
mutisms11338453_mutisms
narcotisms1444603narcotisms
nepotism1246483nepotism_
nepotists1145743nepotists
nomisms11268743_nomisms
oralisms10610973oralisms
orphisms1545993orphisms
peonisms1238443peonisms
pietisms1247463pietisms
porisms113713453_porisms
prisms104915503pr__isms
promises122916763promises
prosaisms1346273prosaisms
protases102115033protases
protasis102411973protasis
protests10310493protests
protist9320223protis_t
protium11312293protium_
provisos1336913provisos
racisms112310813_racisms
realisms102212163realisms
robotisms1375123robotisms
rotis56327063_roti__s
serotines9312073serotines
statisms1039543statisms
teratism10312173teratism_
terrorisms12125833terrorisms
tritiums1056393tritiums
troilisms1146413troilisms
tropism1139293tropism_
truisms9106823tr_uisms
uranisms1099973uranisms
utopisms1245413utopisms
verisms123011253ver__isms
wholisms1665253wholisms

Search took 9 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.423422437.4
2DLD Change Limit1461621277.75018859.6
3Display Results1271270.0632015.9
 (SQL Overall)1786911278.23621696.3
 
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.