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

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

64 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
substructures176286(None) 
substructure1663111substructure_
substructural1762442substructural
prestructures17153843prestructures
restructures14205303_restructures
structures1245453___structures
superstructures1972843superstructures
unstructured1553313_unstructured
nonstructured1663444nonstructured
obstructives1953914_obstructives
obstructors1564004_obstructor_s
prestructure16174174prestructure_
prestructured18173354prestructured
restructure13195454_restructure_
restructured15164434_restructured
strictures1246174___strictures
structure1145244___structure_
structured1343994___structured
subcultures1554594sub__cultures
substitutes1354354subst__itutes
substrates12168554substr_at__es
substratums1551994substr_atu_ms
subtracters1573804sub_tracter_s
superstructure1873164superstructure_
abstracters1544105_abstracter_s
abstractors1554415_abstractor_s
constructors1676475constructor_s
contractures1676045_contractures
infrastructures2072015infrastructures
instructors1355385_instructor_s
instructress1452895_instruct_ress
macrostructures21152935macrostructures
microstructures21173205microstructures
nonstructural1573675nonstructural
obstructed1544235_obstruct__ed
obstructions16155525_obstructions
obstructive1854615_obstructive_
obstructor1453755_obstructor__
obstructs1344575_obstruct___s
overstructured2062335overstructured
stricture1145905___stricture_
structural1254395___structural
subculture1454425sub__culture_
subcultured1663275sub__cultured
subdirectors1761275subdirector_s
subliteratures1661075subliteratures
subsectors1444485subs__ector_s
subseizures2251575subs__eizures
substances1446325substanc___es
substantives1753765subst_antives
substates111410335subst__at__es
substitute1254625subst__itute_
substituted1453445subst__ituted
substrate11178795substr_at__e_
substratum1452695substr_atu__m
subtracted1565005sub_tract__ed
subtracter1454625sub_tract__er
subtractions1645375sub_tractions
subtractive1854665sub_tractive_
subtracts1346365sub_tract___s
subtreasuries1571045sub_treasuries
supernatures1455225su_pernatures
superstructural19102325superstructural
ultrastructures17102495ultrastructures

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 Filter1786911247900.423422437.4
2DLD Change Limit124790649.37613309.5
3Display Results64640.0461391.3
 (SQL Overall)178691649.84518150.4
 
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.