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

40 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
enthronement175446(None) 
enthronements1863791enthronements
dethronement1863202dethronement
enshrinement1753532enshrinement
dethronements1962773dethronements
enshrinements1853363enshrinements
enthrallment1752843enthrallment
entrancement1686133ent_rancement
environment1653703environ_ment
atonement1149054_at__onement
enchainment1854124enchain_ment
enchantment1854304ench_antment
encirclement18133414encirclement
endorsement1456304endor_sement
enforcement1855684enfor_cement
enframement1855384en_framement
engorgement15115184engor_gement
engrossment1453824en_grossment
enhancement1855624en_hancement
enlargement1455854enlar_gement
enrollment1245644en__rollment
enrolment1148474en__ro_lment
entanglement1554084entanglement
enthrallments1862334enthrallments
enthrone111110114enthron__e__
enthroned1396884enthron__e_d
enthrones12910074enthron__e_s
enthroning1446034enthron__ing
enticement1489604ent__icement
entitlement1355814ent_itlement
entombment1654524ent__ombment
entrainment1356624ent_rainment
entrancements17105174ent_rancements
entrapment1447884ent_r_apment
entreatment13115644ent_reatment
entrenchment1953554ent_renchment
entrustment1354464ent_rustment
environments1753234environ_ments
estrangement15105114est_rangement
internment12412254inter_n_ment

Search took 8 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 Limit124790407.19017356.1
3Display Results40400.0133076.9
 (SQL Overall)178691407.59323533.6
 
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.