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

121 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
erotized183856(None) 
ergotized2044731ergotized
erotize16311661erotize_
erotizes17311211erotizes
azotized1745672azotized
bromized22215902bromized
ebonized2036972ebonized
eroticized2245622eroticized
heroized21298462hero_ized
ironized1858202ironized
necrotized2245092necrotized
agatized1947073agatized
agonized19258993agonized
amortized2185933amortized
anodized1946463anodized
arabized2047173arabized
arborized2166973arborized
aromatized2257253aromatized
atomized20279323atomized
azotised1844443azotised
azotize1537083azotize_
azotizes1636853azotizes
baptized2245483baptized
broiled103811423bro_iled
bromize20238823bromize_
bromizes21258333bromizes
bronzed19308213bro_nzed
chromized2645913chromized
creolized2145643creolized
crotched16428603crotched
deionized2057153deionized
demonized2239853demonized
deputized2244333deputized
ebonised1136053ebonised
ebonize1838153ebonize_
ebonizes1938073ebonizes
elegized19145683elegized
eloined8149813elo_ined
emoted94614923emot__ed
emotive1239193emotive_
emptied1297403empti_ed
enticed101411193e_nticed
entoiled968283entoiled
epoxied1734823epoxi_ed
ermined10410603er_mined
eroded84313593ero__ded
erosive1039203erosive_
erotic82620273eroti__c
erotica92811513eroti_ca
erotical101911983erotical
eroticize2047513eroticize_
eroticizes2146943eroticizes
erotics91914153eroti_cs
erotism9312303eroti_sm
erotisms10310163erotisms
erotizing1949963erotizing
eulogized2044953eulogized
exorcized2843753exorcized
frized193510683fr__ized
frothed14288783frot_hed
grecized2134433grecized
groined92710813gro_ined
grottoed10234503grottoed
hepatized2446253hepatized
heroicized2544173heroicized
heroize193210973hero_ize_
heroizes202610983hero_izes
idolized1946003idolized
iodized18969163_iodized
ionized172611293_ionized
ironize16610373ironize_
ironizes17510373ironizes
jarovized2943413jarovized
lionized1837023lionized
melodized2245453melodized
memorized23138993memorized
morticed1377173morticed
mortised1178753mortised
motived13357763_motived
narcotized2283913narcotized
necrotize2046483necrotize_
necrotizes2146183necrotizes
noticed1037863_noticed
odorized1945843odorized
ozonized1745113ozonized
pectized22257593pectized
peptized22237523peptized
peroxided2045083peroxided
plotzed19376223plot_zed
poetized2037983poetized
prized184415393pr__ized
profiled14338523profiled
profited14279973profited
promised133010883promised
propined133111513propined
provided1536843provided
pyrolized2446123pyrolized
realized182514223realized
reoiled84316853reo_iled
reseized1839213reseized
resized174614903_resized
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
robotized2144613robotized
roiled74320053_ro_iled
rosined84911913_rosined
rotated82715293_rotated
rotifer1036993_rotifer
rotted74524433_rot_ted
sclerotized2352913sclerotized
sermonized22156913sermonized
serotine8313573serotine_
serotines9312073serotines
serotyped1543853serotyped
sortied83314103sorti_ed
terrorized2075703terrorized
trothed114010973trot_hed
trotted83711283trot_ted
unitized1839233unitized

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 Limit1461621218.17017890.1
3Display Results1211210.0502420.0
 (SQL Overall)1786911218.64320674.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.