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

88 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
overprogramed228258(None) 
overprogrammed2561851overprogrammed
overprogram1952952overprogram__
overprograms2062702overprogram_s
deprogramed1863213_de_programed
overprograming2362533overprograming
preprogramed2062503pre_programed
reprogramed1763763_re_programed
deprogrammed2152634_de_programmed
misprogramed2051904_misprogramed
overgraded1656594ove__r_graded
overgrazed2466004ove__r_grazed
overprocessed2172584overprocessed
overproduced2153234overpro_duced
overprogramming2671714overprogramming
overpromised2053944overpro_mised
overpromoted2063304overpro_moted
overprotected2162844overprotected
preprogrammed2362014pre_programmed
programed1585894____programed
reprogrammed2063014_re_programmed
deprogram1555915_de_program__
deprogrammer2062775_de_programmer
deprograms1655465_de_program_s
misprogrammed2061695_misprogrammed
overarmed1538105ove__r_ar_med
overarranged1752645overar__ranged
overborrowed2151555over_borrowed
overbraked2046055ove__r_braked
overbroad1545435overbro__a__d
overbrowsed2043355overbro__wsed
overconsumed2052675over_consumed
overcrammed2143945overcr__ammed
overcropped2143585overcro__pped
overcrowded2143185overcro__wded
overdecorated2053445overdecorated
overencouraged2191785overencouraged
overglazed2475415ove__r_glazed
overgoaded1655575ove__r_goaded
overgrade1457625ove__r_grade_
overgrades1556935ove__r_grades
overgraze2276675ove__r_graze_
overgrazes2356285ove__r_grazes
overinformed2162375overinfor_med
overloaded1566595over_lo__aded
overlorded1555865over_lo_r_ded
overoperated1876045over_operated
overpackaged2552035overp_ackaged
overpedaled1844305overp__edaled
overpeopled1944115overpeo__pled
overpersuaded20122085overpersuaded
overplayed19206755overp___layed
overplotted1743905overplo__tted
overpopulated2194415overpopulated
overpowered2043635overp_o_wered
overpraised1746215overpr__aised
overprescribed2481945overprescribed
overpriced18107525overp___riced
overprinted1785935overpr__inted
overprized2587635overp___rized
overprocesses2072975overprocesses
overproduce1953485overpro_duce_
overproduces2053525overpro_duces
overpromise1854815overpro_mise_
overpromises1954245overpro_mises
overpromote1863665overpro_mote_
overpromotes1963365overpro_motes
overproud1545485overpro____ud
overrated13313085ove__r__rated
overregulated1894425over_regulated
overroasted1545115over_ro_asted
oversaturated1754095oversaturated
overscored1646365oversco_r__ed
oversoaked1845825over_so__aked
overtraded1557075ove__r_traded
overtreated1547415overtr__eated
overtrimmed1943315overtr__immed
overurged1496675overur_g___ed
overwarmed1945355ove__rwar_med
overworked2145185over_wo_r_ked
preprogram1754695pre_program__
preprograms1864115pre_program_s
programer1475605____programer
programmed1883885____programmed
reprogram1456615_re_program__
reprograms1556225_re_program_s
retrograded1453105_re_trograded
unprogrammed2062015__unprogrammed

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.1401276364.3
2DLD Change Limit124790888.61014493.6
3Display Results88880.0461913.0
 (SQL Overall)178691888.79620315.0
 
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.