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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
overpopulates209459(None) 
overpopulate19114681overpopulate_
overpopulated2194411overpopulated
depopulates1644033_de_populates
outpopulates1682003o_utpopulates
overoperates17116613over_operates
overpopulating2274053overpopulating
overpopulation21144583overpopulation
overpopulations22154143overpopulations
overregulates1794543overregulates
overspeculates21133403overspeculates
repopulates1544893_re_populates
depopulate1544414_de_populate_
depopulated1743644_de_populated
outpopulate1592194o_utpopulate_
outpopulated1792024o_utpopulated
overeducates1854394over_educates
overinflates1853954over_inflates
overoperate1676694over_operate_
overoperated1876044over_operated
overpeoples1854094overpeop_l__es
overregulate1684494overregulate_
overregulated1894424overregulated
oversaturates1654214oversaturates
overspeculate20123504overspeculate_
overspeculated22123364overspeculated
overstimulates1983654overstimulates
populates132710674____populates
repopulate1445204_re_populate_
repopulated1644474_re_populated
underpopulated2061874underpopulated
aeroplanes1246885_aer_op_lanes
aeropulses1243085_aer_opul_ses
copulates132612465____copulates
demodulates1543755_de_modulates
deregulates13135135_der_egulates
expostulates2152355__expostulates
governorates1652765governo__rates
interpolates1448575interpo__lates
operculate1446255oper__culate_
operculated1645155oper__culated
oppilates1345455o___p_pilates
overarticulates2072625overarticulates
overcoats1438865overco___at_s
overcompensates2482845overcompensates
overcomplicates26152935overcomplicates
overcounted1745885overco_u_nted
overcounts1545715overco_u_nt_s
overdecorates1953435overdecorates
overdosages1653065overdo__sages
overeducate1754515over_educate_
overeducated1954355over_educated
overemphases2253825overemp_hases
overestimates1854865overestimates
overexplains2454835overexp_lains
overfocuses1953195overfocu__ses
overfocusses2052225overfocu_sses
overglazes2375535over___glazes
overhates15311945over____hates
overhopes1738145overhop____es
overindulges1752115overindul_ges
overinflate1753915over_inflate_
overinflated1953945over_inflated
overlades13510355over____lades
overlate11716285over____late_
overmedicates2153515overmedicates
overpackages2452095overp_ackages
overpeople1744215overpeop_l__e_
overpeopled1944115overpeop_l__ed
overpersuades19112145overpersuades
overplaids1645435over__p_laids
overplans14249575over__p_la_ns
overplanted1746235over__p_lanted
overplants15227335over__p_lants
overplayed19206765over__p_layed
overplays17287015over__p_la_ys
overplies14310465over__p_l_ies
overplots1436955over__p_lot_s
overpluses1545785over__p_luses
overproduces2053525overprodu__ces
overpromotes1963365overp_romotes
overrates12414625over____rates
overrules12129095over__rul__es
oversaturate1554425oversaturate_
oversaturated1754095oversaturated
oversouls1236605overso_ul___s
overstates131110115over___states
overstimulate1883845overstimulate_
overstimulated2093675overstimulated
oversupplies1972675oversuppl_ies
overvoltages1951625overvo_ltages
overvotes1538425overvo____tes
ovulates1148525ov_____ulates
perambulates1853485_perambulates
percolates14410425_perco__lates
perpetuates1584305_perpetu_ates
populaces15195715____populaces
populate122812095____populate_
populated14228805____populated
reinoculates1454235_reinoculates
reregulates12135805_rer_egulates
sporulates1246485___sporulates
superovulates1863565super_ovulates
terneplates1353335_ternep_lates
variolates1347465_vario__lates
vermiculate1855725_vermiculate_
vermiculated2064515_vermiculated
vermiculites1952995_vermiculites
vesiculates1646295_ve_siculates

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 Filter1786911247900.423422437.4
2DLD Change Limit1247901099.00013865.6
3Display Results1091090.0761434.2
 (SQL Overall)1786911099.49918811.6
 
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.