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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
overprotect185457(None) 
overprotects1953031overprotects
overpotent1548052overp_otent
overprotected2162842overprotected
overcorrect18144003overcorrect
overprocess1853953overprocess
overproduce1953483overproduce
overprotecting2263193overprotecting
overprotection2163613overprotection
overprotective2472493overprotective
overwrote1557693overwrote__
overcorrects19153004overcorrects
overdirect1644514over_direct
overdrove1646084overdrove__
overemote1447194overemote__
overemoted1646334overemote_d
overemotes1546704overemote_s
overgreat1347714overgr__eat
overmodest1645204over_modest
overpayment2154584overpayment
overpert13312994overp___ert
overplot1338544overplo___t
overplots1436954overplot__s
overplotted1743904overplotted
overpower1746244overp_owe_r
overpowers1844724overp_owers
overprice16108894overpr__ice
overpriced18107524overprice_d
overprices17108524overprice_s
overprint14412254overpr__int
overprinted1785934overprinte_d
overprize23118684overprize__
overprized2587634overprize_d
overprizes24107914overprize_s
overproduced2153234overproduced
overproduces2053524overproduces
overprogram1952954overprogram
overpromise1854814overpromise
overpromote1863664overpromote
overpromoted2063304overpromote_d
overpromotes1963364overpromote_s
overproof1745534overpro__of
overprotections2263344overprotections
overproud1545484overpro__ud
overrate11615694over_rate__
overrated13313084over_rate_d
overrates12414624over_rate_s
overreact1448404over_r_eact
overroast1247874over_ro_ast
overrode121810584over_rode__
overtreat1249374overtr__eat
overviolent1754104overviolent
overvote1438954over_vote__
overvoted1637504over_vote_d
overvotes1538424over_vote_s
overwrite1579084overwrite__
overwrites1658114overwrite_s
overwrought2152494overwrought
protect11313634____protect

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 Filter1786911488190.420425454.8
2DLD Change Limit148819598.94016646.4
3Display Results59590.0301966.7
 (SQL Overall)178691599.39019029.9
 
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.