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

48 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
overproduction226405(None) 
overproductions2363781overproductions
overprotection2163612overprotection
hyperproduction2872533hyperproduction
overproducing2253543overproduc_ing
overproportion2172683overproportion
overprotections2263343overprotections
preproduction2054393pre_production
reproduction1765653_re_production
underproduction2171983underproduction
coproduction1954744__coproduction
overeducation1955374ove__reducation
overpopulation21144584overp_opulation
overproduce1953484overproduc___e
overproduced2153234overproduc__ed
overproduces2053524overproduc__es
overproportions2272544overproportions
overprotecting2263194overprotecting
overprotective2472494overprotective
overreaction1754924over_r_eaction
postproduction2162894postproduction
preproductions2153944pre_productions
production1547894____production
reproductions1865274_re_productions
coproductions2054495__coproductions
introduction1555785__introduction
nonreproductive2371715nonreproductive
overaction1547995ove__r__action
overcaution1655155ove__rcau_tion
overeducations2054985ove__reducations
overevaluation2074525overevaluation
overextraction26153545overextraction
overmedication2264005over_medication
overpersuasion19152045overpersuasion
overpopulations22154145overp_opulations
overpromoting2153965overpro_moting
overprotect1854575overprotect___
overprotected2162845overprotect_ed
overprotects1953035overprotect__s
overreactions1854725over_r_eactions
overregulation1864345over_regulation
overvaluation1965095over_valuation
photoproduction2573065photoproduction
postproductions2272505postproductions
productions1647535____productions
reintroduction1762375reintroduction
reproductive20124335_re_productive
retrodiction1555655_re_trodiction

Search took 6 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.356501941.0
2DLD Change Limit95024485.56317081.4
3Display Results48480.0301600.0
 (SQL Overall)178691485.94930037.1
 
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.