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

57 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
technostructure2281531technostructure_
macrostructure20143155mac_rostructure_
macrostructures21152935mac_rostructures
microstructure20163515mic_rostructure_
microstructures21173205mic_rostructures
deconstructed1953706decon_struct__ed
deconstructive22124106decon_structive_
deconstructor1863646decon_structor__
deconstructors1963626decon_structor_s
macrostructural2182246mac_rostructural
microstructural2182476mic_rostructural
nonstructured1663446____nonstructured
reconstructed1854266recon_struct__ed
reconstructive21124466recon_structive_
reconstructor1764096recon_structor__
reconstructors1863936recon_structor_s
restructure13195456re____structure_
restructured15164436re____structured
restructures14205306re____structures
unstructured1553316___un_structured
constructed1646257__con_struct__ed
constructive1957447__con_structive_
constructor1576527__con_structor__
constructors1676477__con_structor_s
contracture1576627__c__ontracture_
contractures1676047__c__ontractures
deconstruct1654147decon_struct____
deconstructing20113907decon_struct_ing
deconstruction19134437decon_struct_ion
deconstructions20124367decon_structions
deconstructs1753717decon_struct___s
infrastructure1972107_infrastructure_
infrastructures2072017_infrastructures
nonstructural1573677____nonstructural
overstructured2062337__overstructured
preconstructed21102717precon_struct__ed
prestructure16174177___prestructure_
prestructured18173357___prestructured
prestructures17153847___prestructures
reconstruct1554907recon_struct____
reconstructible2172377recon_structible
reconstructing1974437recon_struct_ing
reconstruction1894777recon_struct_ion
reconstructions19124737recon_structions
reconstructs1654247recon_struct___s
structure1145247______structure_
structured1343997______structured
structures1245457______structures
substructure1663117___substructure_
substructures1762867___substructures
superstructure1873167_superstructure_
superstructures1972847_superstructures
technocracies1962307techno_crac__ies
ultrastructure1692747_ultrastructure_
ultrastructures17102497_ultrastructures
unconstructed1853927uncon_struct__ed
unconstructive21104217uncon_structive_

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.373479064.3
2DLD Change Limit95024578.65610977.8
3Display Results57570.0501140.0
 (SQL Overall)178691579.07919681.8
 
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.