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

47 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
underpopulated206187(None) 
depopulated1743643__de_populated
overpopulated2194413_overpopulated
depopulate1544414__de_populate_
depopulates1644034__de_populates
interpolated1547484interpo__lated
overpopulate19114684_overpopulate_
overpopulates2094594_overpopulates
repopulated1644474__re_populated
undercoated1546824underco___ated
undercounted1653254underco_u_nted
undereducated1872534under_educated
underinflated1852404under_inflated
underplayed1875024under__p_layed
undersaturated1662494undersaturated
demodulated1643415__de_modulated
deregulated14134735__der_egulated
interpellated1654585interp_ellated
interpolate1369335interpo__late_
interpolates1448575interpo__lates
interpopulation1963595interpopulation
outpopulated1792025__outpopulated
populated14228805_____populated
repopulate1445205__re_populate_
repopulates1544895__re_populates
superovulated1962845super_ovulated
unappropriated1872075unappropriated
unarticulated1653845un_articulated
uncirculated1753245uncir__culated
undecorated1545725unde_co__rated
undefoliated1752455unde_fo_liated
undercooled1544305underco_ol__ed
underemployed2261525underemp_loyed
underestimated1863035underestimated
underheated1647015under___heated
underloaded1444505underlo___aded
underpowered1952145underpo__wered
underprepared1961525underp_repared
underpropped1752245underprop___ped
underrated12310845under____rated
underreported1761715underrep_orted
understated1347835under___stated
undulated11310085und_____ulated
unformulated1852575unfor__mulated
uninoculated1552965un__inoculated
unmanipulated1871715un_manipulated
unregulated1344405un__r_egulated

Search took 8 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 Limit95024477.00013574.9
3Display Results47470.0331424.2
 (SQL Overall)178691477.39324170.3
 
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.