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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

38 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
disarrangements1972701disarrangements_
disarrangement1872922disarrangement__
arrangements1554324___arrangements_
disparagements2063484dispara_gements_
prearrangements2071704prearrangements_
rearrangements17173004_rearrangements_
arrangement1454835___arrangement__
derangements1665825d___erangements_
disagreements1763655disagr__eements_
disarmaments1763945disarma___ments_
disarranges1363855disarrang__e__s_
discouragements21182815discoura_gements_
disengagements19163425disenga_gements_
disparagement1963795dispara_gement__
estrangements1684405_es_trangements_
prearrangement1971875prearrangement__
rearrangement16173225_rearrangement__
arraignments1553166___arraignments_
derangement1556466d___erangement__
disablements1754916dis___ablements_
disagreement1654316disagr__eement__
disarmament1654956disarma___ment__
disarrange1253866disarrang__e____
disarranged1453406disarrang__e___d
disarranging1573126disarrang__in__g
disbandments1853446dis__ban_dments_
disbursements1853916disbur__sements_
discernments1785196discer_n__ments_
discouragement20162926discoura_gement__
disengagement18153846disenga_gement__
disentanglement1971836disentanglement__
disgruntlements19112046disgruntlements_
dislodgements18103456dis__lodgements_
dismantlements19103026dis__mantlements_
displacements2053896dis_pla_cements_
estrangement15105116_es_trangement__
infringements1963356_i_nfringements_
mismanagements1862276mis__managements_

Search took 6 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 Filter178691658740.313570897.8
2DLD Change Limit65874385.47012042.8
3Display Results38380.0301266.7
 (SQL Overall)178691385.81330739.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.