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

68 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
prograde124718(None) 
protrade1148211protrade
paygrade1543592paygrade
program12311692progra_m
programed1585892programed
programer1475602programer
programme1694772programme
programs1339782programs
prorate9418732pro_rate
protrude1144702protrude
regrade92612032_regrade
aggrade1035633_aggrade
brigade1136493brig_ade
brocade1238533bro_cade
comrade12139213_comrade
corrade101111043_corrade
degrade10229903_degrade
grade75126093___grade
grogram1147073grogra_m
grograms1246023grograms
misgrade1247503misgrade
orthograde1552653orthograde
parade94720643p__arade
paygrades1643623paygrades
perorate10417913pero_rate
phorate12413363pho_rate
pomade113611333p_o_made
prebade12310283pr_ebade
prefade1339013pr_efade
pregame1239553preg_ame
preguide1255423preguide
premade12311443pr_emade
prerace11414123pr_erace
priorate10411733priorate
probate11414483pro_bate
procreate1348133procreate
prodrome1346203prodrome
profane122111863pro_fane
progged12409793progged_
prognose1146463prognose
programers1584393programers
programmed1883873programmed
programmer1794103programmer
programmes1784923programmes
progress1137023progress
prolate9419793pro_late
promenade1485693promenade
pronate9418873pro_nate
propane112716153pro_pane
prophage1649433prophage
prophase15410233prophase
prorated11513713pro_rated
prorates10418063pro_rates
prostate10314533prostate
prostrate11412483prostrate
protease10209893protease
proteide11239723proteide
protract12510603protract
protruded1343443protruded
protrudes1245173protrudes
provide1339853pro_vide
regraded113410763_regraded
regrades103212163_regrades
regrate82618653_regrate
retrograde1254163retrograde
roulade856993_roulade
subgrade1246053subgrade
upgrade11215823_upgrade

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.1561145455.1
2DLD Change Limit146162688.59317009.4
3Display Results68680.0332060.6
 (SQL Overall)178691688.78220347.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.