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

93 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
procrastinating207219(None) 
procrastination1962452procrastination
procrastinate1772373procrastinat__e
procrastinated1992053procrastinat_ed
procrastinates1882233procrastinat_es
procrastinator1881943procrastinat_or
procrastinators1981763procrastinators
predestinating1854274pr_edestinating
prognosticating2172134prognosticating
repristinating1783064_repristinating
castigating1546005___c_astigating
patinating1339875p____a_tinating
procreating1647695procr____eating
propitiating1755005pro__piti_ating
proportionating2072345pro_portionating
prostituting1573955pro___stituting
prostrating1449395pro___st_rating
protonating1448595pro____tonating
recriminating1864935_recr_iminating
assassinating1461456__assassinating
bastinading1573556____bastinading
brominating1696096bro____minating
captivating1944886___c_aptivating
castrating1349776___c_ast_rating
catenating1348686___c_a_tenating
cocultivating2162346_coc_ultivating
compassionating2271936_compassionating
concatenating1853266_conca_tenating
conglutinating1862426_conglutinating
constipating1775396___constipating
contaminating1854916_conta_minating
coordinating1653916_coor__dinating
criminating1646856___cr_iminating
decorticating1984246decor__ticating
deracinating1645226__dera_cinating
discriminating2063956discr_iminating
domesticating1953026_do_mesticating
fantasticating2061886_fantasticating
fascinating1745246____fascinating
festinating1547376____festinating
fractionating1953086___fractionating
incriminating1854176_incr_iminating
ingratiating1454066_ingra_ti_ating
irradiating1353776ir__ra_di_ating
masticating1647836____masticating
orchestrating1982846or_chest_rating
originating1344906__o_r_iginating
overestimating2054326_overestimating
paginating1447526p____a_ginating
passivating1743786p____assivating
pepsinating1645376p___eps_inating
peregrinating1752976p__eregrinating
personating1447676p__er_s_onating
photostating18135846pho_tost__ating
pollinating1445616p_o___llinating
postdating1447166p_o___st_dating
postmating1548606p_o___st_mating
postulating1447506p_o___stulating
potentiating1554286p_o_tenti_ating
precasting15169836prec_as____ting
precipitating2074036prec__ipitating
predesignating1962556pr_edesignating
predestination1765486pr_edestination
predestinations1865006pr_edestinations
predestining1654466pr_edestin__ing
predominating1964346pr__edominating
prefabricating2461736pr_efabricating
prenominating1854696pr__enominating
preprinting1647416prepr___in_ting
pretraining1446506pretra__in__ing
prevaricating2153076pr_eva_ricating
processioning1853746proc_essi_oning
proclaiming1843876procla__i__ming
procrustean1551216procrust_ea__n_
prognostication2082296prognostication
prognosticative2381806prognosticative
pronating12313766pro______nating
propagating1754886pro_pa___gating
prorating12314286pro_r_____ating
prorogating1556066pro_r___ogating
protracting1646936protra____cting
reactivating1844756_r__eactivating
reconstituting1763236_reconstituting
recultivating1953016_rec_ultivating
reestimating1545936_r__eestimating
repristination16204106_repristination
repristinations17193926_repristinations
reradiating1347266_r_era_di_ating
resinating11313736____res_inating
revaccinating2152706_r_evaccinating
rusticating1446316____rusticating
sophisticating2272056_sophisticating
underestimating1972076underestimating

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.360496363.9
2DLD Change Limit95024937.61012486.7
3Display Results93930.0801162.5
 (SQL Overall)178691938.05022197.6
 
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.