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

75 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
presidencies175448(None) 
residencies1445971_residencies
precedencies1953722precedencies
residences1368232_residenc_es
nonresidencies1762523nonresidencies
pendencies1547023p_e_ndencies
persistencies1752563persistencies
pertinencies1654573pertinencies
precedences1845513precedenc_es
prepotencies1884293prepotencies
presciences17127273prescienc_es
presences132113793pres__enc_es
presidency1844653presidenc__y
presidential1554573presidential
presidents1347023presiden__ts
providences1953823providenc_es
pruriencies1553613pruri_encies
renitencies1346093_renitencies
residence1268903_residenc_e_
resiliencies1453723_resiliencies
reticencies1545683_reticencies
ardencies1247854ar___dencies
credences1498144cre__denc_es
decadencies1753874_decadencies
desinences1347214_desinenc_es
dissidences15164134dissidenc_es
eminencies1445934__eminencies
evidences1556334__evidenc_es
exigencies2045264__exigencies
frequencies2553944fre_quencies
hesitancies1643994_hesitancies
leniencies1246194_leni_encies
nonresidences1663764nonresidenc_es
penitences1447974p_enitenc_es
permanencies1853564permanencies
persistences1653864persistenc_es
pertinences1545744pertinenc_es
pestilences1544694p_estilenc_es
precedence1746114precedenc_e_
preeminences1883524preeminenc_es
preferences1876184preferenc_es
prefinances1875014prefinanc_es
pregnancies1644564pre_gnancies
prescience16157294prescienc_e_
presence122213514pres__enc_e_
presentees1247924pres__entees
presentences1655694presentenc_es
president12410994presiden___t
presidentships2271174presidentships
presiders1248214preside___rs
presides11414914presid____es
presidios1245774presid___ios
presignifies1852704presignifies
pretences132312614pre__tenc_es
prevalences1845094prevalenc_es
proficiencies2261814proficiencies
prominences1744864prominenc_es
providence1854094providenc_e_
prudences1446684pr__udenc_es
pruriences1444704pruri_enc_es
pudencies1445784p___udencies
recencies13312254_re__cencies
redenies9615714_re__den_ies
redolencies1454564_redolencies
regencies1249284_re__gencies
renitences1248444_renitenc_es
residency1565514_residenc__y
residential1255274_residential
residents1038424_residen__ts
resiliences1375244_resilienc_es
reticences1447454_reticenc_es
stridencies1454034_stridencies
subsidences1653774subsidenc_es
tendencies1346344_te_ndencies
transiencies1456004transi_encies

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 Filter1786911247900.390458182.1
2DLD Change Limit124790757.61016398.2
3Display Results75750.0461630.4
 (SQL Overall)178691758.04622208.7
 
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.