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

63 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
dismantlement188350(None) 
dismantlements19103021dismantlements
disablement1655973dis_a_blement
disgruntlement18132103disgruntlement
mismanagement1762583mismanagement
disablements1754914dis_a_blements
disagreement1654314dis_agreement
disbandment1754224disban__dment
disentanglement1971834disentanglement
disgruntlements19112044disgruntlements
disinterment1565874dis_interment
dismantle1245044dismantl__e__
dismantled1443694dismantl__e_d
dismantles1344334dismantl__e_s
dismantling1543394dismantl__ing
disparagement1963794disparagement
mismanagements1862274mismanagements
startlement1364134__startlement
battlement1446095___battlement
comanagement1963405_comanagement
debatement1547075d_eba_t_ement
derangement1556465d_eran_gement
diminishment2063595di_minishment
disagreements1763655dis_agreements
disarmament1654955dis_a_rmament
disarrangement1872925disarran_gement
disbandments1853445disban__dments
disbarment1546655disba___rment
disbursement1754455dis_bursement
discontent13410255discont___ent
discontentment1963615discontentment
disembowelment24151995disembowelment
disendowment19103605dis_endowment
disengagement18153845disengagement
disfigurement20112275disfigurement
disguisement1654455dis_guisement
disheartenment20202905disheartenment
disinterest1255615dis_int_erest
disinterments1664865dis_interments
dislodgement1783955dis_lodgement
dismalest1246315disma__l__est
dismemberment1972585dismemberment
disownment16115835disown___ment
disparagements2063485disparagements
displacement1954425dis_placement
disportment1656655disport__ment
dissentient1256955dissent__ient
embattlement1853075_embattlement
embranglement20122885embranglement
entanglement1554085_entanglement
impalement1647615_i_m_palement
implement1549535_i_m__plement
inclement1349925_i___nclement
management1546715___management
misstatement16113365misstat_ement
nonmanagement1862965nonmanagement
resettlement1453535res_ettlement
restatement1356265resta_t_ement
settlement1246475__s_ettlement
startlements1453395__startlements
statement1148795__sta_t_ement
tanglement1346135___tanglement
unsettlement1462885uns_ettlement

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.406440125.6
2DLD Change Limit124790638.00015598.8
3Display Results63630.0461369.6
 (SQL Overall)178691638.45221141.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.