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

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
procuratorial176156(None) 
curatorial1245363___curatorial
proctorial1447513proc___torial
procurator1445513procurator___
procurators1545173procurator__s
piscatorial1553294pisc__atorial
precentorial1654984prec_entorial
preceptorial1853894prec_eptorial
procuration1548294procurat__ion
proprietorial1762394proprietorial
prosecutorial1762494prosecutorial
purgatorial1452794p___urgatorial
cocurator1347575_cocurator___
cocurators1447305_cocurator__s
cursorial1144605___cur_sorial
dictatorial1452735_dic_tatorial
doctorial1246695_doc___torial
equatorial1954205__equ_atorial
executorial2052155execu__torial
expurgatorial236975_expurgatorial
imperatorial1672885_imperatorial
improvisatorial2281355improvisatorial
moratoria1146145_mo__ratoria_
oratorical1245165__o__ratorical
pictorial1348405p_ic___torial
praetorial1257095pr___aetorial
preceptorials1962485prec_eptorials
preparatorily2091535preparatorily
pretorial11512655p____retorial
procambial1852835proc__a_mbial
procreator1465745procreator___
procreators1575715procreator__s
proctoring1546675proc___toring
procural1246925procu____r_al
procurations1647405procurat_ions
professorial1753665pro_fessorial
prostomial1446355pro___stomial
protectoral1554935pro_tector_al
rectorial11119895_rec___torial
reportorial1353625_repor_torial
spectatorial1652665spec_tatorial

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 Filter1786911247900.406440125.6
2DLD Change Limit124790418.31315011.4
3Display Results41410.0301366.7
 (SQL Overall)178691418.74920424.2
 
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.