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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

144 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
procrastination196245(None) 
procrastinating2072192procrastinating
procrastinator1881932procrastinat_or
procrastinate1772373procrastinat__e
procrastinated1992053procrastinat_ed
procrastinates1882233procrastinat_es
procrastinators1981753procrastinators
predestination1765484pr_edestination
prognostication2082294prognostication
repristination16204104_repristination
aromatization2457065aro_ma_tization
castigation1447975___c_astigation
democratization2963415democra_tization
parasitization2574055p__arasitization
patination12312575p____a_tination
pectination15410335p_ec___tination
predestinations1865005pr_edestinations
preordination1656155preor__dination
prioritization2584155prior_itization
privatization2755865pr_iva_tization
proclamation1853415procla___mation
procreation1547945procr____eation
profanation16186105pro_fa___nation
propitiation1656915pro__piti_ation
proselytization29111905proselytization
prostitution1454605pro___stitution
prostration13410785pro___st_ration
protestation1456355pro_test__ation
protonation13510425pro____tonation
recrimination1757405_recr_imination
repristinations17193925_repristinations
amortization2347206amo_r__tization
aromatizations2576486aro_ma_tizations
assassination1382006__assassination
bromination1547816bro____mination
calcination1548906___c_alcination
captivation1846176___c_aptivation
castigations1547206___c_astigations
castration12410806___c_ast_ration
catenation1249526___c_a_tenation
cocainization2655956_coc_ainization
cocultivation2053056_coc_ultivation
concatenation1764086_conca_tenation
concretization2754376concr_etization
conglutination1762786_conglutination
constipation1648566___constipation
contamination1766956_conta_mination
coordination1595586_coor__dination
crimination1549416___cr_imination
decortication1857536decor__tication
deracination1548866__dera_cination
destination12413836____destination
discrimination1955346discr_imination
dogmatization2655966_dogma_tization
domestication18114546_do_mestication
dramatisation1673016dr_ama_tisation
dramatization2576196dr_ama_tization
encrustation14103396_encrust__ation
erotization20412056ero____tization
fantastication1962236_fantastication
fascination1646786____fascination
focalization2649666_foc_a_lization
forestation1446996_fo_rest__ation
fractionation1853206___fractionation
incardination1655036_inc_ardination
incrimination17145656_incr_imination
incrustation14104436_incrust__ation
ingratiation1355806_ingra_ti_ation
irradiation12105606ir__ra_di_ation
localization23410436_loc_a_lization
mastication15610296____mastication
moralization23411616_mo_ra_lization
orchestration1883646or_chest_ration
ordination1149416__o_r__dination
origination1267096__o_r_igination
overestimation19125136_overestimation
pagination1348996p____a_gination
parasitizations2693566p__arasitizations
passivation16104746p____assivation
patinations13411006p____a_tinations
pectinations1649256p_ec___tinations
peregrination16125206p__eregrination
personation1349486p__er_s_onation
perspiration1656836p__er_spiration
phosphatization3462366phosphatization
pluralization2457086p_lura_lization
polarization232010436p_o_la_rization
pollination1348016p_o___llination
postulation13119126p_o___stulation
postvaccination2471306postvaccination
potentiation1455956p_o_tenti_ation
preadaptation1852146preadapt__ation
precipitation1966226prec__ipitation
predestinarian1772326pr_edestinarian
predestinating1854276pr_edestinating
predestinator1662986pr_edestinat_or
predomination1896536pr__edomination
prefabrication2392826pr_efabrication
prenomination17126756pr__enomination
preordinations1765696preor__dinations
pretermination1854776pr_etermination
prevarication2055246pr_eva_rication
prioritizations26123846prior_itizations
privatizations2855166pr_iva_tizations
proclamations1952696procla___mations
procreations1647256procr____eations
procrustean1551216procrust_ea___n
procuration1548296proc____uration
profanations17175256pro_fa___nations
prognosticating2172136prognosticating
prognosticative2381806prognosticative
prognosticator1972186prognosticat_or
pronation11415706pro______nation
pronunciation17113226pro_nunci_ation
propagation1646446pro_pa___gation
propitiations1756206pro__piti_ations
proposition1588736pro_pos_i__tion
proration11415986pro_r_____ation
prorogation1447396pro_r___ogation
proscription18124506proscr___i_ption
prostitutions1554256pro___stitutions
prostrations1449746pro___st_rations
protestations1555786pro_test__ations
protonations1449046pro____tonations
protraction1547196protra____ction
reactivation17176956_r__eactivation
recantation1349866_rec_ant__ation
recombination19106176_rec_ombination
reconstitution1663556_reconstitution
recriminations1856726_recr_iminations
reexamination22153666_reexa_mination
repristinating1783066_repristinating
reradiation12410156_r_era_di_ation
revaccination2053866_r_evaccination
robotization2346866_ro__botization
romanization2389886_ro_ma_nization
rustication1349226____rustication
socialization2449096_socia_lization
sophistication2162766_sophistication
transamination16103796transa_mination
traumatization2553886trauma_tization
underestimation1872256underestimation
vocalization2649996_voc_a_lization
workstation1852306_wo_rkst__ation

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.1231452772.4
2DLD Change Limit950241449.03310519.7
3Display Results1441440.1061358.5
 (SQL Overall)1786911449.26219292.9
 
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.