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

(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
depopulation176506(None) 
depopulations1844491depopulations
repopulation1656101repopulation
demodulation1644692demodulation
depopulating1853732depopulating
population14810022__population
repopulations1765332repopulations
copulation141111953__copulation
decollation1448193deco_llation
demodulations1754143demodulations
depilation13312033de__pilation
depopulate1544413depopulat__e
depopulated1743643depopulat_ed
depopulates1644033depopulat_es
deportation1449303depo_rtation
deputation1339393de__putation
deregulation1446083deregulation
desolation11311403deso__lation
overpopulation21144583overpopulation
populations15148713__populations
repopulating1744483repopulating
sporulation1346403_sporulation
subpopulation1962663subpopulation
capitulation1644594capitulation
copulations151111114__copulations
dealation10313004de___alation
decapitation1748684decapitation
decollations1547364deco_llations
decoration13314424deco__ration
deflation13310654de___flation
defoliation1548314defo_liation
deformation1747664defo_rmation
degranulation1552914degranulation
deionization2249884deionization
delation92318084de____lation
demodulating1753164demodulating
demodulator1552514demodulat_or
demolition1376984demo__lition
demonization24410944demonization
denaturation1345884denaturation
denomination15118834denomination
denotation11311084deno__tation
denticulation1654564denticulation
denudation1247304de__nudation
deoxidation2045954de_oxidation
depilations14310904de__pilations
depletion1256664de__p_letion
deportations1548464depo_rtations
deposition13107834depo__sition
depravation1785694dep_ravation
deprecation1648964dep_recation
depreciation1747074depreciation
depredation1546924dep_redation
deprivation1788774dep_rivation
deputations1448344de__putations
deputization2447224deputization
deregulations1545204deregulations
derogation12410394dero__gation
desolations12310594deso__lations
desperation14510114de_speration
despoliation1546714despo_liation
detonation11310944deto__nation
detoxication2246204detoxication
devaluation1547074devalu_ation
devolution1486284devo__lution
disputation14116744d_isputation
ejaculation2096134_ejaculation
emulation11312394_e__mulation
epilation11312964_e__pilation
epoxidation2144064_epoxidation
expostulation2262614expostulation
inoculation1358714_inoculation
interpopulation1963594interpopulation
lobulation1247234__lobulation
manipulation1654664manipulation
modulation13147934__modulation
morulation12148904__morulation
neurulation1145344ne_urulation
nodulation11127994__nodulation
overpopulations22154144overpopulations
ovulation1238984___ovulation
peculation14311994__peculation
populating1547664__populating
populational1654414__populational
postulation13119134__postulation
recompilation1955154recompilation
recomputation1974394recomputation
reformulation1853974reformulation
regulation11312054re__gulation
reinoculation1554424reinoculation
reoperation13410904re_operation
repopularize25192914repopularize
repopulate1445204repopulat__e
repopulated1644474repopulat_ed
repopulates1544894repopulat_es
reputation12411884re__putation
reregulation1346414reregulation
reticulation1448054reticulation
speculation1547544_speculation
spiculation1547034_spiculation
sporulations1445684_sporulations
stipulation1356334_stipulation
subpopulations2062384subpopulations
suppuration1545894sup_puration
vesiculation1746114vesiculation

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.406440125.6
2DLD Change Limit1247901058.61014493.6
3Display Results1051050.0601750.0
 (SQL Overall)1786911059.07619688.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.