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

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

94 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
proportionals176402(None) 
proportional1655811proportional_
proportionable2062382proportionable
proportionably2362562proportionably
proportionally2163492proportionally
proportionate1773872proportionate
proportionates1862872proportionates
proportions1548462proportion__s
preportions1548263preportion__s
promotional1555633promo_tional_
proportion1448993proportion___
proportionality2272233proportionality
proportionated1962583proportionated
proportionately2272093proportionately
proportioned1754403proportion_ed
proportioning1863953proportioning
propositional1755243propositional_
disproportional2071924disproportional_
optionals1145344__op__tionals
preoperational1853244preoperational_
preportion1448874preportion___
preportioned1754254preportion_ed
preportioning1853604preportioning
prepositional1755194prepositional_
probational1547084pro_bational_
processionals1754144processionals
productional1794714productional_
professionals1864044professionals
projectional2355424projectional_
promotions1448784promo_tion__s
proportionating2072344proportionating
propositions16108314proposition__s
provisionals1753764pro_visionals
apportionable1962205_apportionable
apportions1446285_apportion__s
conditionals1554975_conditionals
corporations16129485corporation__s
devotionals1552995_devo_tionals
disproportions1972285disproportion__s
distortional1353495distortional_
irrationals1154735ir__rationals
nonnationals1294895_nonnationals
operational1347525__operational_
optional1047645__op__tional_
perorational1446395pero_rational_
piperonals1453185p_iper__onals
populational1654415p_opulational_
portioners1257425___portioners
portions10514415___portion__s
positional1247905p_o_sitional_
prenotions1248295preno_tion__s
preoptions1447645pr_eoption__s
preparations1648315preparation__s
prepositionally2262515prepositionally
prepositions16108305preposition__s
prevocational2054015prevocational_
proabortion1553165proabortion___
proactions1449345pro_action__s
probationally2054095pro_bationally
probationary1953225pro_bationary
probationers1662575pro_bationers
probations14311085pro_bation__s
processional1665395processional_
procurations1647405procuration__s
productions1647535production__s
professional1754965professional_
projections2258475projection__s
promotion1359505promo_tion___
pronations12314035pro_nation__s
pronominal1446175prono_mi_nal_
propagations1745555propagation__s
properdins1546015properdi_n__s
properties141411895properti___es
prophetical2055845propheti_cal_
propionate1446435prop___ionate
propionates1545535prop___ionates
propitious1446605prop_itio__us
propitiously1954845prop_itiously
proposals1346675prop____osals
proposition1588745proposition___
propositioned1853915proposition_ed
propositioning1972795propositioning
propranolols1661195prop_ranolols
propulsions1553305propulsion__s
prorations12314465pro_ration__s
prorogations1556725prorogation__s
prostrations1449775prostration__s
protections15510705protection__s
protonations1449075protonation__s
provisional1655465pro_visional_
provocations1956875provocation__s
rationals949945_r___ationals
retortions1049145_retortion__s
rotational1048095_ro_tational_

Search took 10 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 Filter1786911247900.516346300.4
2DLD Change Limit124790948.96613918.1
3Display Results94940.0631492.1
 (SQL Overall)178691949.54518720.9
 
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.