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

98 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
preprograming216248(None) 
preprogramming2461841preprogramming
reprograming1863901_reprograming
deprograming1963362_deprograming
reprogramming2172922_reprogramming
deprogramming2262553_deprogramming
misprograming2161873misprograming
overprograming2362533overprograming
preprogram1754693preprogram___
preprogramed2062503preprogram_ed
preprogrammed2362013preprogrammed
preprograms1864113preprogram__s
programing1646313___programing
retrograding1553413_retrograding
misprogramming2161324misprogramming
overprogramming2671714overprogramming
perorating13313134p_e_ro_rating
preforming1846234pre_fo_r_ming
preprocessing2053554preprocessing
programings1753424___programings
programming1954204___programming
prorogating1556064pr_orog_ating
reprobating1647104_repro_bating
reprogram1456614_reprogram___
reprogramed1763764_reprogram_ed
reprogrammed2063014_reprogrammed
reprograms1556224_reprogram__s
aerobraking1852835_ae_robraking
arrogating121778395ar__rog_ating
deprogram1555915_deprogram___
deprogramed1863215_deprogram_ed
deprogrammed2152635_deprogrammed
deprogrammer2062775_deprogrammer
deprograms1655465_deprogram__s
derogating1348635_de_rog_ating
monograming1754315__monograming
overgrading1747515ove_r_grading
overgrazing2566775ove_r_grazing
perforating1747025p_e_rforating
performing1844945p_e_rfor_ming
perpetrating1745205perp_etrating
pogroming1544735___p_ogroming
prearming14139225pre___ar_ming
prearranging1652655prear__ranging
preboarding1744275pre_boar_ding
precreasing1645705precr__easing
preinforming2072695preinfor_ming
preloading1446585pre_lo__ading
prelocating1647415pre_lo_cating
preordering15124305preorder__ing
prepackaging2451505prep_ackaging
preparing14311645prep____aring
prepaving1787235prep____aving
prepaying1747975prep____aying
preplacing1746005prep___lacing
preponderating2062585preponderating
preportioning1853605preportioning
prepricing1746735prep___ricing
preprinting1647415prepr__inting
prepurchasing2361475prepurchasing
prereleasing1552905pre_releasing
prerogative1755355pre_rog_ative
prescoring1547435presco_r__ing
presignaling1652855pre_signaling
presoaking1736255pre_so__aking
presorting1339985pre_so_r_ting
prestoring13310305presto_r__ing
pretreating1448895pretr__eating
pretrimming1843035pretr__imming
prewarming18145175pre__war_ming
preworking2044235pre_wo_r_king
programmings2052545___programmings
propagating1754885prop_ag_ating
prorating12314285___pro_rating
proroguing1443125pr_orog__uing
redreaming1446445_redr__eaming
reengraving1693095_re_engraving
reforming1538565_re_fo_r_ming
reframing1538625_re___framing
refrigerating1853185_refrigerating
regrading121210205_re___grading
regrating111316215_re___grating
regrooming1464165_regro__oming
remigrating1547595_re_migrating
rephrasing1645645_rep__hrasing
reporting12513905_rep_o_r_ting
repouring12310075_rep_our__ing
reproaching1944305_repro_aching
reprobing1438075_repro___bing
reprocessing1754695_reprocessing
reproducing1744525_repro_ducing
reprographer2056255_reprographer
reprographic2296655_reprographic
reprographics2395175_reprographics
reprographies2196095_reprographies
reprography2246525_reprogra_phy
reproving1538415_repro___ving
retrogressing1553165_retrogressing

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.390458182.1
2DLD Change Limit124790988.45314762.8
3Display Results98980.0462130.4
 (SQL Overall)178691988.88920102.5
 
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.