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

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
disgruntlements1911204(None) 
disgruntlement18132101disgruntlement_
dismantlements19103023dis_mantlements
disgruntles1352264disgruntl__e__s
disguisements1763934disg_u_isements
dismantlement1883504dis_mantlement_
disablements1754915dis___ablements
disagreements1763655disagr___eements
disarrangements1972705disarrangements
disbursements1853915dis_bu_rsements
discouragements21182815discouragements
disfurnishments2471995disfurnishments
disgruntle1252695disgruntl__e___
disgruntled1451925disgruntl__e__d
disgruntling1551755disgruntl__in_g
disguisement1654455disg_u_isement_
disinterments1664865dis__interments
beguilements17113896_beg_u_ilements
denouncements18143806d_enoun_cements
derangements1665826d__eran_gements
dethronements1962776dethron__ements
disablement1655976dis___ablement_
disagreement1654316disagr___eement_
disarmaments1763946disar___maments
disarrangement1872926disarrangement_
disbandments1853446dis_ban__dments
disburdenments2062506dis_burdenments
disbursement1754456dis_bu_rsement_
discernments1785196discern___ments
discontentments2073006dis_contentments
discontents1447546dis_cont___ents
discouragement20162926discouragement_
disembowelments25141806disembowelments
disendowments20112996dis__endowments
disengagements19163426dis_engagements
disentanglement1971836disentanglement_
disfigurements21132146dis_figurements
disfurnishment2372096disfurnishment_
disheartenments21242646disheartenments
disinterests1353136dis__int_erests
disinterment1565876dis__interment_
dislodgements18103456dis__lodgements
disownments17114906dis_own___ments
disparagements2063486dis_paragements
displacements2053896dis__placements
disportments1755356dis_port__ments
dissentients1354226dis_sent__ients
divertissements21102026divertissements
divorcements2054416divor___cements
embranglements21132536_embranglements
embrittlements2061606_embrittlements
enshrinements1853366enshrin__ements
estrangements1684406_estran_gements
infringements1963356_infrin_gements
microelements1963856mi_cr_oelements
mismanagements1862276mis_managements
misstatements17122906mis_stat_ements
mistreatments1762776mistreat__ments
resettlements1553216res__ettlements
settlements1345546__s__ettlements
signalments1472266si_g__nal_ments
startlements1453396__s_tartlements
supplements1754596__s__upplements
unsettlements1562746uns__ettlements

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 Filter178691950240.393454684.5
2DLD Change Limit95024647.37312888.1
3Display Results64640.0461391.3
 (SQL Overall)178691647.81222873.9
 
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.