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

111 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
protiums123855(None) 
protium11312291protium_
erotisms10310162erotisms
podiums12227632p_odiums
premiums1437532premiums
proteus92511592proteu_s
protists10313362protists
tritiums1056392tritiums
acrotisms1347493acrotisms
bromisms1436403bromisms
brutisms1245413brutisms
chromiums1844543chromiums
coniums11311863_coniums
craniums1297913craniums
egotisms1146683egotisms
erbiums1135463er_biums
ergotisms1245303ergotisms
erotics91914153eroti_cs
erotism9312303erotism_
erotizes17311213erotizes
europiums1344113europiums
exotisms1746723exotisms
foliums1237173_foliums
ioniums938303_ioniums
iridiums1144523iridiums
muoniums1244723muoniums
niobiums1243373niobiums
odiums9337943__odiums
opiums10307073__opiums
palliums1236703palliums
pantoums1236713pantoums
parotids112610413paroti_ds
parotitis1149173parotitis
peonisms1238443peonisms
peponiums1554913peponiums
photics142810483photi_cs
pietisms1247463pietisms
platinums1343963platinums
podium112911913p_odium_
poloniums1346053poloniums
porisms113713453p_orisms
porticos1238373porticos
portions10514413portions
possums1145753p_ossums
potfuls1236293p_otfuls
potions93417423p_otions
practicums18132753practicums
pratiques20114213pratiques
prelims1139823preli_ms
premium13310363premium_
preterms1237223preterms
pretrims1238983pretrims
prims95425933pr__i_ms
primus103712173pr__imus
prisms104915503pr__isms
probits112712573probi_ts
problems1434343problems
proctitis1348363proctitis
prodrugs1242483prodrugs
proems104711163pro__ems
profiles133211233profiles
profits122911243profi_ts
programs1339783programs
prolines102619693prolines
promethiums2052193promethiums
promines123018803promines
promises122916763promises
proms95426413pro___ms
pronouns1047203pronouns
propines122618933propines
proprium1447373proprium_
prosaisms1346273prosaisms
prosties101421193prosti_es
protases102115033protases
protasis102411973protasis
proteans102811543proteans
proteas92015123prot_eas
protects1239743protects
proteges1149923proteges
proteides12238783proteides
proteids11259943proteids
proteins102114283proteins
protends113010353protends
proteome12228423proteome
proteomes13248653proteomes
protests10310493protests
proteuses11238993proteuses
protist9320223proti_st
protons93118003prot_ons
protrude1144703protrude
protrudes1245173protrudes
protyles13249833protyles
protyls12298463prot_yls
provides1439883provides
provirus1345453provirus
provisos1336913provisos
proxies163014933proxi_es
proximo1845143proxi_mo
radiums10299313_radiums
rhodiums1443763rhodiums
rostrums1046083_rostrums
rotguts833763_rotguts
rotis56327063_roti__s
scrotums1243973scrot_ums
sodiums10177213_sodiums
strontiums1253343strontiums
thoriums13166403thoriums
triticums1343243triticums
tritium969013tritium_
tropisms1247723tropisms
uraniums10117163uraniums

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.1561145455.1
2DLD Change Limit1461621116.83021400.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.03225411.1
 
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.