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

49 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
micromanagement2171511micromanagement_
comanagement1963404__c_omanagement_
comanagements2062734__c_omanagements
mismanagement1762584mi__smanagement_
mismanagements1862274mi__smanagements
micromanage1854025micromanag__e___
micromanaged2063015micromanag__e__d
micromanager1962965micromanag__e__r
micromanagers2072335micromanag__e_rs
micromanages1984105micromanag__e__s
micromanaging2162325micromanag__in_g
antimanagement1971316_antimanagement_
management1546716_____management_
managemental1761816_____managemental
managements1655316_____managements
microelement1864506micro___element_
microelements1963856micro___elements
microfilament2262536microfila__ment_
microfilaments2361946microfila__ments
nonmanagement1862966__nonmanagement_
arrangement1454837__ar_ran_gement_
arrangements1554327__ar_ran_gements
derangement1556467_der__an_gement_
derangements1665827_der__an_gements
disarrangement1872927disarran_gement_
disarrangements1972707disarran_gements
discouragement20162927disco_uragement_
discouragements21182817disco_uragements
dismantlement1883507di__smantlement_
dismantlements19103027di__smantlements
disparagement1963797di__sparagement_
disparagements2063487di__sparagements
encouragement1862607enc_o_uragement_
encouragements1962177enc_o_uragements
estrangement15105117estr__an_gement_
estrangements1684407estr__an_gements
microanalyses2073167micro_analyse__s
microanalyst1963257micro_ana__lyst_
microanalysts2062537micro_ana__lysts
microanatomical2371937micro_anatomical
microanatomies2062757micro_anatom_ies
microanatomy2162687micro_anatom___y
microgamete1855347micro____game_te
micronutrient1762697micro__nutrient_
micronutrients1871537micro__nutrients
ravagement1644987___r__avagement_
ravagements1754167___r__avagements
rearrangement16173227rear_ran_gement_
rearrangements17173007rear_ran_gements

Search took 10 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.360496363.9
2DLD Change Limit95024499.29610222.0
3Display Results49490.0331484.8
 (SQL Overall)178691499.68918442.7
 
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.