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

33 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
disengagement18153841disengagemen_t
disengagements19163421disengagements
disentanglement1971834disentanglemen_t
disparagement1963794disparagemen_t
disparagements2063484disparagements
engagement1447514___engagemen_t
engagements1546504___engagements
nonengagement1782914nonengagemen_t
nonengagements1882784nonengagements
reengagement1653084_reengagemen_t
reengagements1752744_reengagements
disagreement1654315dis_agreemen_t
disagreements1763655dis_agreements
disarrangement1872925disarrangemen_t
disarrangements1972705disarrangements
discouragement20162925discouragemen_t
discouragements21182815discouragements
disenchantment2292145disenchantmen_t
disenchantments2391975disenchantments
disendowment19103605disen_dowmen_t
disendowments20112995disen_dowments
disengage1243885disengag__e___
disengaged1453425disengag__e__d
disengages1344355disengag__e__s
disengaging1553475disengag__in_g
disfigurement20112275disfiguremen_t
disfigurements21132145disfigurements
dislodgement1783955dis_lodgemen_t
dislodgements18103455dis_lodgements
displacement1954425dis_placemen_t
displacements2053895dis_placements
mismanagement1762585mismanagemen_t
mismanagements1862275mismanagements

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.356501941.0
2DLD Change Limit95024336.80013974.1
3Display Results33330.0132538.5
 (SQL Overall)178691337.16924925.5
 
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.