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

61 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
microstructures21173201microstructures_
macrostructures21152932macrostructures_
microstructure20163512microstructure__
macrostructure20143153macrostructure__
microstructural2182473microstructur_al
macrostructural2182244macrostructur_al
infrastructures2072015infrastructures_
microcultures1964725micro__cultures_
micropunctures2272245micro_punctures_
prestructures17153845__prestructures_
restructures14205305___restructures_
ultrastructures17102495ultrastructures_
contractures1676046__c_ontractures_
infrastructure1972106infrastructure__
instructress1452896_i__nstruct_ress
microculture1864416micro__culture__
micropuncture2162256micro_puncture__
microstates1547446microst__at__es_
microtubules1862996micro_t_u_bules_
overstructured2062336over_structure_d
prestructure16174176__prestructure__
prestructured18173356__prestructure_d
restructure13195456___restructure__
restructured15164436___restructure_d
structures1245456_____structures_
substructures1762866__substructures_
superstructures1972846superstructures_
technostructure2281536technostructure__
ultrastructure1692746ultrastructure__
cirrostratus1461347cirrostr_atu__s_
constructors1676477__constructor_s_
contracture1576627__c_ontracture__
deconstructors1963627deconstructor_s_
instructors1355387_i__nstructor_s_
magistratures1661287m_agistr_atures_
microcircuits1872467microcir_c_uits_
microcultural1963637micro__cultur_al
microcuries1756727micro____c_uries_
microluces1646327micro__luc___es_
microminiature2071387microminiature__
microscales1756377micros___c_ales_
microscopes19119097micros___c_opes_
microscopies20167247micros___copies_
microspheres2154927micros___pheres_
microspores1747417micros____pores_
microsporocytes2682247microsporoc_ytes_
microstate1448017microst__at__e__
microsurgeries1962397microsur_geries_
microswitches2561667micros__witches_
microtubule1752687micro_t_u_bule__
nonstructured1663447__nonstructure_d
prestructuring1991857__prestructuring
reconstructors1863937reconstructor_s_
restructuring1672797___restructuring
strictures1246177_____strictures_
structure1145247_____structure__
structured1343997_____structure_d
substructure1663117__substructure__
superstructure1873167superstructure__
ultrastructural17142147ultrastructur_al
unstructured1553317___unstructure_d

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.343520965.0
2DLD Change Limit95024618.73610877.3
3Display Results61610.0461326.1
 (SQL Overall)178691619.12519582.6
 
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.