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

78 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
superstructures197284(None) 
superstructure1873161superstructure_
superstructural19102322superstructural
prestructures17153843__prestructures
substructures1762863su__bstructures
overstructured2062334_overstructured
prestructure16174174__prestructure_
prestructured18173354__prestructured
restructures14205304__re_structures
substructure1663114su__bstructure_
ultrastructures17102494_ultrastructures
infrastructures2072015infrastructures
macrostructures21152935macrostructures
microstructures21173205microstructures
restructure13195455__re_structure_
restructured15164435__re_structured
structures1245455_____structures
substructural1762445su__bstructural
supernatures1455225supe___rnatures
supersaturates16104425supersaturat__es
supersedures1564495supers___edures
superstates1349555superst__at__es
superstores13117955supers____tores
superstratum1663505superstr_atu__m
superstrikes1855865superstr___ikes
ultrastructure1692745_ultrastructure_
unstructured1553315_u__nstructured
infrastructure1972106infrastructure_
macrostructure20143156macrostructure_
microstructure20163516microstructure_
nonstructured1663446__nonstructured
portraitures1452196__por_traitures
prestructuring1991856__prestructuring
sericultures1474876s__er_icultures
serratures1044866s__er__r_atures
strictures1246176_____strictures
structure1145246_____structure_
structured1343996_____structured
superannuates1564126superannuat__es
superathletes1863446superathlet__es
superchurches2562086superchurc__hes
superclusters1752796super_cluster_s
superconductors2272156superconductor_s
superettes1249746superet___t__es
superfluities1854146super_fluit_ies
superinduces1753906superinduc___es
superinductions2063706superinductions
superiorities1556326superior_it_ies
supernature1355516supe___rnature_
superraces1449866super__rac___es
supersaturate15104556supersaturat__e_
supersaturated17113586supersaturat__ed
supersaurs12117626supers____aur_s
superscouts1555546supers___cou_ts
superscribes1855146supers___cribes
superscriptions2163346superscriptions
superscripts1864306superscript___s
supersecrecies2062306supersecrec__ies
supersecret1557216supers__ec__ret
supersedure1454696supers___edure_
supersleuths1753006supersleu_t__hs
superspectacles2391216supers_pectacles
superstars1248196supers____tar_s
superstate1249836superst__at__e_
superstations15208146superst__ations
superstimulates1982346superstimulates
superstitions15176786superst__itions
superstitious15175166superst__itious
superstocks1954116superst_oc___ks
superstore12108696supers____tore_
superstrata1355576superstr_at___a
superstrengths2061496superstr_engths
superstrike1755766superstr___ike_
superstrings15125206superstr___ings
superstuds1345776supers____tu_ds
supersubtle1553686supers__ubt_le_
supersymmetries2481326supersymmetries
ultrastructural17142146_ultrastructural

Search took 9 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 Limit95024788.11011716.9
3Display Results78780.0461695.7
 (SQL Overall)178691788.49921024.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.