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

105 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
overpopulating227405(None) 
overpopulation21144582overpopulation
overpopulations22154142overpopulations
depopulating1853733_de_populating
outpopulating18112243o_utpopulating
overoperating1956723over_operating
overpopulate19114683overpopulat__e
overpopulated2194413overpopulat_ed
overpopulates2094593overpopulat_es
overregulating1963793overregulating
overspeculating2362773overspeculating
repopulating1744483_re_populating
overcounting1846614overco_u_nting
overeducating2054854over_educating
overinflating2053964over_inflating
overpeopling2044774overpeop_l__ing
overplanting1846974over__p_lanting
overplaying2047344over__p_laying
oversaturating1864044oversaturating
overstimulating2173184overstimulating
populating1547664____populating
copulating1549375____copulating
demodulating1753165_de_modulating
depopulation1765065_de_population
depopulations1844495_de_populations
deregulating1554015_der_egulating
expostulating2361725__expostulating
interpolating1657795interpo__lating
interpopulation1963595interpopulation
oppilating1544855o___p_pilating
overbeating17410485over___beating
overboiling1746845overbo_il__ing
overcoloring1844695overco__loring
overcommitting2462225overcommitting
overcooling1746845overco_ol__ing
overcorrecting2262755overcorrecting
overcutting1746825over__cu_tting
overdecorating2153685overdecorating
overdocumenting2471355overdocumenting
overeating141016535over____eating
overestimating2054325overestimating
overexplain2354595overexp_la_in_
overexplaining2772475overexp_laining
overexplains2454835overexp_la_ins
overexploiting2762855overexploiting
overfocusing2153335overfocu__sing
overfocussing2252315overfocu_ssing
overglazing2545975over___glazing
overgoading1746565overgo___ading
overhating17910955over____hating
overhauling1846035over_haul__ing
overheating1849935over___heating
overholding1955645overho__l_ding
overhoping1947045overhop____ing
overhunting1856525over__hu_nting
overindulging1952255overindul_ging
overlading1539325over____lading
overlaying1738445over____laying
overloading1647335overlo___ading
overmedicating2363015overmedicating
overmelting1768115over__mel_ting
overpackaging2651955overp_ackaging
overpaying1937955over__p__aying
overpedaling1945045over__pedaling
overpedalling2052725overpedal_ling
overpersuading2181855overpersuading
overplanning1844565over__p_lanning
overplotting1845045over__plotting
overplying1946515over__p_l_ying
overpowering2144465overpo__wering
overprinting1846875over__printing
overproducing2253545overprodu__cing
overprograming2362535overprograming
overpromoting2153965overp_romoting
overprotecting2263195overprotecting
overpumping2144975over__pu_mping
overrating14814205over____rating
overregulation1864345overregulation
overregulations1963855overregulations
overreporting1953805overrep_orting
overroasting1646095overro__asting
overruling1467615over__rul__ing
oversalting1548575over__sal_ting
oversoaking1956785overso___aking
overspeculation2263335overspeculation
overspilling1844535over_spil_ling
overspreading2053605over_spreading
overstating15410735over___stating
oversupplying2451935oversuppl_ying
overtoiling1547195overto_il__ing
overtopping1945655overtop___ping
overtreating1648555over__treating
overvoting1747535overvo____ting
ovulating1336955ov_____ulating
perambulating2052525_perambulating
percolating1657325_perco__lating
perpetuating1753805_perpetu_ating
reinoculating1653585_reinoculating
repopulation1656105_re_population
repopulations1765335_re_populations
reregulating1454645_rer_egulating
sporulating1445115___sporulating
superovulating2092355super_ovulating
variolating1544935_vario__lating
vesiculating1844665_ve_siculating

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 Limit950241055.70316662.1
3Display Results1051050.0761381.6
 (SQL Overall)1786911056.13929107.5
 
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.