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

92 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
preexistences246203(None) 
preexistence2352351preexistence_
coexistences2352863_coexistences
existences1944823___existences
inexistences2154013_inexistences
nonexistences22112953nonexistences
persistences1653863p_ersistences
preeminences1883523preemi_nences
preexistent2053633preexisten__t
coexistence2253264_coexistence_
existence1845414___existence_
inexistence2054214_inexistence_
nonexistence21173524nonexistence_
penitences1447974p__eni_tences
persistence1554154p_ersistence_
persistencies1752564p_ersistencies
preeminence1763804preemi_nence_
preexisted2043784preexist___ed
preexisting2144224preexistin__g
preexists1844734preexist____s
premoistened1752184premoisten_ed
premoistens15122904premoisten__s
presciences17127274presci__ences
presences132113794pr_e__s_ences
presentences1655694pr_esentences
pretences132312614pr_e___tences
renitences1248444_r_eni_tences
resistances1345374_r_esistances
consistences1655425_consistences
dehiscences1953935__dehiscences
desistances1444195__desistances
exigences1946325___exi_gences
existents1644985___existen_ts
freestones1345705free__ston_es
greenstones1253725gree_nston_es
impenitences1854025impeni_tences
indehiscences2162655indehiscences
insistences1355585__insistences
penitence1348095p__eni_tence_
percipiences2053145p_ercipiences
persistency1852655p_ersistenc_y
pertinences1545745p_erti_nences
pestilences1544695p_esti_lences
precedences1845515pr_e_cedences
precipitances2163095precipitances
preciseness1545785pr_ecis_eness
predestines1446995pr_edestin_es
prednisones1452985prednis_on_es
preemergence1962295preemergence_
preexcites2144165preexcit___es
preexist1747965preexist_____
preferences1876185pr_e_ferences
prefinances1875015pr_efi_nances
prehistories1755345pr_ehistories
premoisten14124115premoisten___
premoistening1851875premoistening
prepotencies1884295pr_e_potencies
prepubescences24111865prepubescences
preregistered1761585preregiste_red
preregisters1552235preregiste__rs
prescience16157295presci__ence_
presence122213515pr_e__s_ence_
presentence1546395pr_esentence_
presentenced1754045pr_esentenced
presidencies1754485pr_esi_dencies
pretence122312125pr_e___tence_
pretenses112210595pr_e___tenses
prevalences1845095pr_e_valences
priestesses13104275prie__stesses
pristanes11410435pr___istan_es
prominences1744865pr_omi_nences
proveniences1953675proveni__ences
providences1953825pr_ovi_dences
pruriences1444705pr_uri__ences
pubescences1954285pube__scences
reemergences1753045_reemergences
reexperiences2472295_reexperiences
reminiscences1962555_reminiscences
remittances1554005_r_emittances
remoistened1453175_remoisten_ed
remoistens12164525_remoisten__s
renaissances1492045_renaissances
renascences1554865_r_enascences
renitence1149055_r_eni_tence_
renitencies1346095_r_eni_tencies
resentences1347425_r_esentences
residences1368235_r_esi_dences
resiliences1375245_r_esiliences
resistance1245885_r_esistance_
reticences1447455_r_eti_cences
reviviscences23161955_reviviscences
subsistences1653005_subsistences

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.390458182.1
2DLD Change Limit124790929.01613840.9
3Display Results92920.0462000.0
 (SQL Overall)178691929.45218905.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.