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

145 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
protium1131229(None) 
protiums1238551protiums
erotism9312302erotism
podium112911912p_odium
premium13310362premium
proprium1447372proprium
proteus92511592proteus
protist9320222protist
tritium969012tritium
acrotism1248223acrotism
aerobium1246303aerobium
alodium1047583alodium
aprotic112715243aproti_c
bromism1337623bromism
brutism1146773brutism
chromium1745983chromium
conium10415313_conium
corium10315723_corium
cranium11911103cranium
egotism1038353egotism
erbium1038083er_bium
ergotism1146273ergotism
erotic82620273eroti_c
erotica92811513erotica
erotics91914153erotics
erotisms10310163erotisms
erotize16311663erotize
europium1245233europium
exotism1638123exotism
folium11310453_folium
gonium949803_gonium
ionium8610923_ionium
iridium1046303iridium
muonium1146863muonium
niobium1144723niobium
notum7611693_not_um
odium83413033__odium
onium73115533__onium
opium92812093__opium
ostium8310133_ostium
pallium1149013pallium
pantoum1138703pantoum
parotic112518043paroti_c
parotid102915513paroti_d
parotids112610413parotids
peonism11611103peonism
peponium1467493peponium
peridium1349023peridium
photic133316443photi_c
photics142810483photics
pietism1139113pietism
platinum1245443platinum
podiums12227633p_odiums
polonium1248333polonium
porism104518063p_orism
portico11310143portico
porting103021783porting
portion9615493portion
possum1057953p_ossum
potful1138083p_otful
potion84519573p_otion
practicum17133773practicum
prating103424453prating
pratique19134283pratique
prelim10311423preli_m
premiums1437533premiums
preterm11310153preterm
pretrim11310783pretrim
prim85132203pr__i_m
prism94820263pr__ism
probing123314443probing
probit103218353probi_t
probits112712573probits
probity14299683probity
problem1335983problem
prodigy1435573prodigy
prodrug1142953prodrug
proem94818273pro__em
profile123211153profile
profit113016273profi_t
profits122911243profits
program12311693program
progun968783pro_gun
proline92321593proline
prolix1538683proli_x
prom87631703pro___m
promethium1953103promethium
promine112819443promine
promise113415843promise
pronotum1245143pronotum
pronoun939033pronoun
propine113020213propine
prosaism1268043prosaism
prosier93817483prosier
prosily12611633prosily
prosing103319383prosing
prosit85124593prosi_t
prostie91617743prosti_e
prosties101421193prosties
prostomium1664143prostomium
protea82214763prot_ea
protean92412193protean
proteas92015123proteas
protect11313633protect
protege1059153protege
protei82615313prot_ei
proteid103513673proteid
proteide11239723proteide
proteids11259943proteids
protein92414733protein
proteins102114283proteins
protend104012793protend
proteome12228423proteome
protest9317533protest
protists10313363protists
proton84318893prot_on
protons93118003protons
protrude1144703protrude
protyl11308213prot_yl
protyle12229453protyle
protyls12298463protyls
proud84615483pro__ud
provide1339853provide
proving134214073proving
provirus1345453provirus
proviso1237313proviso
proxies163014933proxies
proximo1845143proximo
ptotic102713373ptoti_c
radium93513293_radium
rhodium1345343rhodium
rostrum947213_rostrum
rotgut738793_rotgut
roti46332933_roti__
rotis56327063_roti_s
scrotum1145123scrot_um
sodium92111453_sodium
strontium1144613strontium
thorium12208413thorium
triticum1254313triticum
tritiums1056393tritiums
trivium1256143trivium
tropism1139293tropism
uranium9610023uranium
uredium1076693uredium

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271457.25018486.5
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.46923924.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.