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

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

59 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
procrastinators198176(None) 
procrastinator1881941procrastinator_
procrastinates1882232procrastinat_es
procrastinate1772373procrastinat__e
procrastinated1992053procrastinat_ed
procrastinating2072193procrastinating
procrastination1962453procrastination
predestinators1762504pr_edestinators
prognosticators2071914prognosticators
castigators1445545___c_astigators
predestinator1662985pr_edestinator_
procreators1575715procr____eators
prognosticator1972195prognosticator_
propitiators1653965pro__piti_ators
prostitutors1452915pro___stitutors
assassinators1261296__assassinators
captivators1853626___c_aptivators
castigator1345766___c_astigator_
castrators1247446___c_ast_rators
coconspirators2061436_coconspirators
contaminators1754886_conta_minators
coordinators1553806_coor__dinators
decorticators1862496decor__ticators
discriminators1962826discr_iminators
fascinators1644706____fascinators
fractionators1862136___fractionators
irradiators1253046ir__ra_di_ators
masticators1546326____masticators
orchestrators1872656or_chest_rators
originators1253926__o_r_iginators
ostinatos946176__o___stinato_s
personators1345546p__er_s_onators
pollinators1354546p_o___llinators
postulators1345256p_o___stulators
potentiators1453226p_o_tenti_ators
precipitators1953276prec__ipitators
predestinates1694636pr_edestinat_es
predestinations1865006pr_edestinations
prevaricators2062206pr_eva_ricators
procreations1647276procreati___ons
procreator1465746procr____eator_
procurations1647406procura_ti___ons
procurators1545176proc____urators
profanatory1952996pro_fa___natory
prognosticates1972596prognosticat_es
pronators11411306pro______nators
propagators1654226pro_pa___gators
propitiator1554226pro__piti_ator_
propitiatory1963386pro__piti_atory
propraetors1554186propra____etors
proprietors1554386propr___i_etors
prorations12314466pro_ra_ti___ons
prostitutor1353136pro___stitutor_
protractions1646646protracti___ons
protractors1546626protra____ctors
recriminatory2062646_recr_iminatory
repristinates1572496_repristinat_es
repristinations17193926_repristinations
rusticators1344946____rusticators

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 Filter178691950240.1231452772.4
2DLD Change Limit95024598.69010934.9
3Display Results59590.0301966.7
 (SQL Overall)178691598.84320207.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.