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

115 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
prominences174486(None) 
prominence1644921prominence_
preeminences1883522preeminences
providences1953822providences
chrominances2152423chrominances
dominances1545683_dominances
eminences1347403__eminences
imminences16155063_imminences
permanences1754493permanences
pertinences1545743pertinences
predominances2093293predominances
preeminence1763803preeminence_
prefinances1875013prefinances
prominent1349573prominen__t
prominently1853373prominently
promines123018803promi__n_es
promisees13246863promise__es
prosinesses13310853prosinesses
provenances1854533provenances
proveniences1953673proveniences
providence1854093providence_
provinces1646853provi__nces
pruriences1444703pruri_ences
remanences1446623_remanences
abstinences1552904abstinences
brominates1448014bromin_ates
bromines122514254bromi__n_es
chrominance2052654chrominance_
cofinances1745304_cofinances
commences17139584_com_mences
continences1588584continences
desinences1347214_desinences
dominance1446214_dominance_
dominancies1653954_dominancies
eminence1247514__eminence_
eminencies1445934__eminencies
griminesses14167554griminesses
hominesses15510864_hominesses
immanences16154544_immanences
imminence15135184_imminence_
imminencies1753964_imminencies
improvidences2392044improvidences
luminances1444474_luminances
luminesces1443964_luminesces
nominees1037364_nomine__es
ordinances1344974or_dinances
patiences1367434p_ati_ences
penitences1447974p_enitences
permanence1654864permanence_
permanencies1853564permanencies
pertinence1445834pertinence_
pertinencies1654574pertinencies
pestilences1544694pestilences
phoninesses1636454phoninesses
pinenes93416674p___inen_es
poignances1543444p_oignances
pokinesses1669614p_okinesses
porkinesses1748774porkinesses
potences12710694p_o__tences
precedences1845514precedences
predominance1983524predominance_
predominancies2161954predominancies
preferences1876184preferences
prefinance1795444prefinance_
prefinanced1983184prefinanced
premieres13288234premi_e_res
presciences17127274presciences
presences132113794pr__esences
presentences1655694presentences
presidencies1754484presidencies
pretences132312614pr__etences
prevalences1845094prevalences
primenesses1548994primenesses
primines123013704primi__n_es
primnesses1497804prim_nesses
princes113015144pr__i__nces
profaneness1653584profaneness
proficiencies2261814proficiencies
progenies12314124pro__genies
prolines102619694proli__n_es
promenades1585414promen_ades
promine112819444promi__n_e_
promisee122711334promise__e_
promisers13268204promise__rs
promises122916764promi___ses
promptnesses1843634promptnesses
proneness11310444pro__neness
pronenesses1379264pronenesses
pronounces1454994pro_nounces
propenes122816514pro__pen_es
propines122618934propi__n_es
proponents1445804proponen_ts
propylenes1744374propylen_es
prosiness11311684prosine__ss
proudnesses1447504proudnesses
provenance1744494provenance_
provenience1853814provenience_
province1546924provi__nce_
prudences1446684pr__udences
prurience1344764pruri_ence_
pruriencies1553614pruri_encies
refinances15107134_refinances
remanence1346714_remanence_
reminisces1445254_reminisces
renitences1248444_renitences
residences1368234_residences
reticences1447454_reticences
retinenes9410374_retinen_es
riminesses121211414_riminesses
romances12310794_rom__ances
roominesses1337434roominesses
ropinesses121311024_ropinesses
rosinesses101213144_rosinesses
supereminences2062624supereminences
worminesses16127994worminesses

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 Filter1786911488190.436409841.7
2DLD Change Limit1488191159.37615872.3
3Display Results1151150.0631825.4
 (SQL Overall)1786911159.87518095.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.