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

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
procrastinating2072191procrastinating_
procrastination1962453procrastinati_on
procrastinate1772374procrastinat___e
procrastinated1992054procrastinat__ed
procrastinates1882234procrastinat__es
procrastinator1881944procrastinat__or
procrastinators1981764procrastinat_ors
predestinating1854275pr_edestinating_
prognosticating2172135prognosticating_
repristinating1783065_repristinating_
castigating1546006___c_astigating_
patinating1339886p____a_tinating_
procreating1647696procr____eating_
propitiating1755006pro__piti_ating_
proportionating2072346pro_portionating_
prostituting1573956pro___stituting_
prostrating1449396pro___st_rating_
protonating1448596pro____tonating_
recriminating1864936_recr_iminating_
assassinating1461457__assassinating_
bastinading1573557____bastinading_
brominating1696097bro____minating_
captivating1944887___c_aptivating_
castrating1349777___c_ast_rating_
catenating1348687___c_a_tenating_
cocultivating2162347_coc_ultivating_
compassionating2271937_compassionating_
concatenating1853267_conca_tenating_
conglutinating1862427_conglutinating_
constipating1775397___constipating_
contaminating1854917_conta_minating_
coordinating1653917_coor__dinating_
criminating1646857___cr_iminating_
decorticating1984247decor__ticating_
deracinating1645227__dera_cinating_
discriminating2063957discr_iminating_
domesticating1953027_do_mesticating_
fantasticating2061887_fantasticating_
fascinating1745257____fascinating_
festinating1547377____festinating_
fractionating1953087___fractionating_
incriminating1854177_incr_iminating_
ingratiating1454067_ingra_ti_ating_
irradiating1353777ir__ra_di_ating_
masticating1647837____masticating_
orchestrating1982847or_chest_rating_
originating1344907__o_r_iginating_
overestimating2054327_overestimating_
paginating1447537p____a_ginating_
passivating1743787p____assivating_
pepsinating1645377p___eps_inating_
peregrinating1752977p__eregrinating_
personating1447677p__er_s_onating_
photostating18135847pho_tost__ating_
pollinating1445627p_o___llinating_
postdating1447167p_o___st_dating_
postmating1548607p_o___st_mating_
postulating1447507p_o___stulating_
potentiating1554287p_o_tenti_ating_
precasting15169837prec_as____ting_
precipitating2074037prec__ipitating_
predesignating1962557pr_edesignating_
predestination1765487pr_edestinati_on
predestinations1865007pr_edestinations
predestining1654467pr_edestin__ing_
predominating1964347pr__edominating_
prefabricating2461737pr_efabricating_
prenominating1854697pr__enominating_
preprinting1647417prepr___in_ting_
pretraining1446507pretra__in__ing_
prevaricating2153077pr_eva_ricating_
processioning1853747proc_essi_oning_
proclaiming1843877procla__i__ming_
procrustean1551217procrust_ea__n__
prognostication2082297prognosticati_on
prognosticative2381807prognosticati_ve
pronating12313767pro______nating_
propagating1754887pro_pa___gating_
prorating12314287pro_r_____ating_
prorogating1556067pro_r___ogating_
protracting1646937protra____cting_
reactivating1844757_r__eactivating_
reconstituting1763237_reconstituting_
recultivating1953017_rec_ultivating_
reestimating1545937_r__eestimating_
repristination16204107_repristinati_on
repristinations17193927_repristinations
reradiating1347267_r_era_di_ating_
resinating11313737____res_inating_
revaccinating2152707_r_evaccinating_
rusticating1446317____rusticating_
sophisticating2272057_sophisticating_
underestimating1972077underestimating_

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 Filter178691950240.343520965.0
2DLD Change Limit95024939.36010152.1
3Display Results93930.0801162.5
 (SQL Overall)178691939.78318265.5
 
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.