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

56 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
overrepresented217132(None) 
misrepresented1971314_misrepresented
represented1444114____represented
unrepresented1661694__unrepresented
overimpressed2162425overimpres__sed
overprinted1785935ove_r_pr__inted
overprotected2162845ove_r_protected
overreported1863445overrep___orted
representer1353615____representer
copresented1653826____copresented
derepressed1553236_de_repres__sed
misrepresent16102926_misrepresent__
misrepresents17142206_misrepresent_s
overasserted1673466ove_r__asserted
overbejeweled296796overbe_jewe_led
overburdened1952066ove_rbur_den_ed
overcompressed2472716overcompres__sed
overcorrected2163056ove_rcor_rected
overdependence23102646overdependence_
overdependences24102256overdependences
overdependent2063216overdependent__
overdetermined2162456overdetermin_ed
overdirected1952906ove_rdir__ected
overdocumented2382046ove_rdocumented
overdressed1644976ove_r_dres__sed
overexerted2245276ov___e_rexerted
overextended2453366ove_re__xtended
overharvested2361806ove_rhar_vested
overimpresses2062766overimpres__ses
overlearned1544466overlear___n_ed
overlengthened2271516overlengthen_ed
overoperated1876046ove_rop_e_rated
overornamented2062106ove_rornamented
overpersuaded20122096overpe_r_suaded
overplanted1746236ove_r_p__lanted
overprescribed2481946ove_r_prescribed
overpressure1762596ove_r_pressure_
overpressures1872396ove_r_pressures
overprocessed2172586ove_r_processed
overpromoted2063306ove_r_pr_omoted
overreacted1745656ove_r__re_acted
overrefined1844266ove_r__refin_ed
overrefinement22162106overrefinement__
overrefinements23171846overrefinement_s
overregulated1894426overre__gulated
overresponded2071936overre__sponded
overroasted1545126overr__oas__ted
overstressed1654026ove_rstres__sed
oversweetened2062016ove_rsweeten_ed
overtreated1547426ove_r_tr__eated
overweened1744886ove_r__we_en_ed
presented12311636______presented
reprehended1852946____reprehended
represent11410076____represent__
representers1452776____representers
represents1246756____represent_s

Search took 7 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 Limit95024566.54614516.3
3Display Results56560.0301866.7
 (SQL Overall)178691566.93625762.8
 
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.