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

71 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
prestructures1715384(None) 
prestructure16174171prestructure_
prestructured18173351prestructured
restructures14205301_restructures
restructure13195452_restructure_
restructured15164432_restructured
prestructuring1991853prestructuring
structures1245453___structures
substructures1762863substructures
superstructures1972843superstructures
infrastructures2072014infrastructures
macrostructures21152934macrostructures
microstructures21173204microstructures
nonstructured1663444nonstructured
overstructured2062334overstructured
prefectures1844304pre__fectures
restrictives1755084_restrictives
restructuring1672794_restructuring
strictures1246174___strictures
structure1145244___structure_
structured1343994___structured
substructure1663114substructure_
superstructure1873164superstructure_
ultrastructures17102494ultrastructures
unstructured1553314_unstructured
constructors1676475constructor_s
contractures1676045_contractures
destructed1445415_destruct__ed
destructions1547255_destructions
destructive1755695_destructive_
destructs1245775_destruct___s
infrastructure1972105infrastructure_
instructors1355385_instructor_s
instructress1452895_instruct_ress
macrostructure20143155macrostructure_
microstructure20163515microstructure_
nonstructural1573675nonstructural
obstructives1953915_obstructives
obstructors1564005_obstructor_s
portraitures1452195p_ortraitures
postfracture1961995p_ostfracture_
preattunes1243975preat___tunes
precures12312905pre____c_ures
prefecture1744805pre__fecture_
prelatures1245725pre___latures
premanufactures2471945premanufactures
prematures1447055pre___matures
prescores133912175pres___c_ores
preservatives2152785preservatives
pressures1149065pres____sures
prestores114716085pres____tores
prestresses1346725prestr__esses
proestruses1353625proestr___uses
prospectuses1852485pros_pectuses
prostitutes1345175prost__itutes
prostrates12411995prostr_at__es
protractors1546625pr_otractor_s
resecures1146735_res__ec_ures
restitutes1057835_rest__itutes
restretches1653505_restr_etches
restricted1348305_restrict__ed
restrictions1449285_restrictions
restrictive1646365_restrictive_
restricts1138825_restrict___s
retextures1743005_re_t_extures
retractors12158585_re_tractor_s
stricture1145905___stricture_
structural1254395___structural
substructural1762445substructural
superstructural19102325superstructural
ultrastructure1692745ultrastructure_

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.406440125.6
2DLD Change Limit124790719.37313313.8
3Display Results71710.0461543.5
 (SQL Overall)178691719.82518187.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.