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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
pubescences195428(None) 
pubescence1854761pubescence_
putrescences18113882putrescences
quiescences2454212quiescences
tumescences1754152tumescences
opalescences1853093opalescences
prepubescences24111863prepubescences
presciences17127273p_resciences
presences132113793p_res_ences
pubescent1545443pubescen__t
putrescence17114273putrescence_
quiescence2354433quiescence_
senescences15135563senescences
subsciences1764363sub_sciences
tumescence1654563tumescence_
turgescences1752843turgescences
virescences18134543virescences
absences1247674_ab_s_ences
acquiescences2562154acquiescences
adolescences1753614adolescences
arborescences1962464arborescences
candescences1654494candescences
coalescences1554214coalescences
dehiscences1953934dehiscences
detumescences20122444detumescences
essences1047564___essences
evanescences1953234evanescences
excrescences2253444excrescences
florescences1993884florescences
fluorescences2083234fluorescences
intumescences1983664intumescences
iridescences1793354iridescences
juvenescences2762084juvenescences
lucences12137314lu___cences
luminescences1962474luminescences
nascences1346234__nascences
nesciences1446254__nesciences
obediences1544324_obediences
opalescence1753754opalescence_
pearlescences1962854pearlescences
prepubescence23112144prepubescence_
prescience16157294p_rescience_
presence122213514p_res_ence_
pretences132312614p_re_tences
puissances1443304pu_issances
pursuances1443454pu_rsuances
purulences1444504pu_rulences
putrescines1552584putrescin_es
renascences1554864renascences
rubescent1345834rubescen__t
senescence14136074senescence_
subjacencies2552274subjacencies
sublicenses1553074sublicenses
submergences1952994submergences
suboscines1444964suboscin_es
subscience1664544sub_science_
subsenses1147474sub_s_enses
subsentences1653604subsentences
subsequences2562484subsequences
subsidences1653774subsidences
subsistences1653004subsistences
substances1446324sub_stances
turgescence1653074turgescence_
virescence17134864virescence_

Search took 9 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 Filter1786911488190.406440125.6
2DLD Change Limit148819648.04618496.0
3Display Results64640.0302133.3
 (SQL Overall)178691648.48221067.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.