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 “protonation” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

41 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
protonation1351043(None) 
protonations1449071protonations
profanation16186102profanation
prolongation1563712prolongation
pronation11415702pr__onation
prorogation1447392prorogation
protonating1448592protonating
provocation1847352provocation
bromination1547813bromination
coronation12412073_coronation
detonation11310943_detonation
erotization20412063erotization
intonation10410263_intonation
ozonation1845673__ozonation
patination12312573p_atination
pectination15410333pectination
personation1349483personation
phonation1439393p__honation
potation101716783p_ot__ation
premonition1547353premonition
probation13412183pr__obation
procreation1547953procreation
procuration1548293procuration
profanations17175253profanations
prolongations1673353prolongations
promotion1359503promo__tion
pronations12314033pr__onations
propagation1646443propagation
proportion1448993propo_rtion
proposition1588743proposition
proration11415983pr__oration
prorogations1556723prorogations
prostration13410793prostration
protection14511473prot_ection
protestation1456363protestation
protonate11412573protonat__e
protonated1348593protonat_ed
protonates12411693protonat_es
protraction1547213protraction
provocations1956873provocations
rotation81615453_rot__ation

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633415.25023168.2
3Display Results41410.0162562.5
 (SQL Overall)178691415.65631593.2
 
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.