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

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

83 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
obstructions1615552(None) 
obstruction15135541obstruction_
abstractions1645782abstractions
constructions1747712constructions
destructions1547252destructions
instructions14137812instructions
obstructing1644572obstructi_ng
obstructionism20103232obstructionism
obstructionist18113992obstructionist
obstructives1953912obstructives
obstructors1564002obstruct_ors
abstraction1545883abstraction_
constrictions1747783constrictions
construction1648083construction_
destruction1446953destruction_
distractions1548753distractions
instruction13137943instruction_
obscurations1644023obscurations
observations1785013observations
obstructionisms2192803obstructionisms
obstructionists19103383obstructionists
obstructive1854613obstructi_ve
obstructor1453753obstruct_o_r
obstructs1344573obstruct___s
obtrusions1263153ob_tru_sions
obturations13116423ob_turations
restrictions1449283restrictions
strictions1249143__strictions
abductions15125384ab__ductions
abruptions1443844ab__ruptions
absolutions1344714absolu_tions
absorptions1544594absor_ptions
abstentions1364364abst_entions
abstracting1645184abstracti_ng
abstractional1753264abstractional
abstractionism20132954abstractionism
abstractionist18133864abstractionist
abstractors1554414abstract_ors
abstricting1654504abstricti_ng
attractions1376404_attractions
castrations13410054castr_ations
constriction1648264constriction_
constructing1746754constructi_ng
constructional1854764constructional
constructionist1984034constructionist
constructors1676474construct_ors
contractions16410404contractions
deconstructions20124364deconstructions
destructing1546114destructi_ng
destructionist17104964destructionist
detractions14118274_detractions
disruptions14125684dis_ruptions
distinctions1557324distinctions
distraction1449114distraction_
extractions2077744_extractions
gastrulations1463644gastrulations
instructing1446294instructi_ng
instructional1555094instructional
instructors1355384instruct_ors
lustrations1147624lustr_ations
menstruations1585054menstruations
objections2145634ob__jections
objurgations2252234objurgations
obscuration1544404obscuration_
observation1665064observation_
obstruct1246034obstruct____
obstructed1544234obstruct__ed
obstructiveness2273394obstructiveness
obtrusion1153724ob_tru_sion_
obturation1297144ob_turation_
overactions1648214o_veractions
protractions1646644protractions
reconstructions19124734reconstructions
restriction1349364restriction_
retractions13910354_retractions
ructions102811684____ructions
seductions1366874__seductions
stictions1148354__st_ictions
striations10312794__striations
striction1148984__striction_
subtractions1645374subtractions
suctions103012904__s__uctions
tractions11511624___tractions

Search took 7 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.390458182.1
2DLD Change Limit124790836.45319338.3
3Display Results83830.0461804.3
 (SQL Overall)178691836.88925938.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.