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 “obstruction” 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
obstruction1513554(None) 
obstructions16155521obstructions
abstraction1545882abstraction
construction1648082construction
destruction1446952destruction
instruction13137942instruction
obstructing1644572obstructing
obstructive1854612obstructive
obstructor1453752obstruct_or
abstractions1645783abstractions
constriction1648263constriction
constructions1747713constructions
destructions1547253destructions
distraction1449113distraction
instructions14137813instructions
obscuration1544403obscuration
observation1665063observation
obstruct1246033obstruct___
obstructed1544233obstruct_ed
obstructionism20103233obstructionism
obstructionist18113993obstructionist
obstructives1953913obstructives
obstructors1564003obstructors
obstructs1344573obstruct__s
obtrusion1153723ob_tru_sion
obturation1297143ob_turation
restriction1349363restriction
striction1148983__striction
abduction14125414ab__duction
abruption1343974ab__ruption
absolution1244404absolu_tion
absorption1444884absor_ption
abstention1254394abst_ention
abstracting1645184abstracting
abstractional1753264abstractional
abstractive1854894abstractive
abstractor1444384abstract_or
abstricting1654504abstricting
attraction1276954_attraction
castration12410804castr_ation
constrictions1747784constrictions
constructing1746754constructing
constructional1854764constructional
constructive1957444constructive
constructor1576524construct_or
contraction15411244contraction
deconstruction19134434deconstruction
destructing1546114destructing
destructive1755694destructive
detraction13138584_detraction
disruption13135734dis_ruption
distinction1447324distinction
distractions1548754distractions
extraction1967984_extraction
gastrulation1353834gastrulation
instructing1446294instructing
instructional1555094instructional
instructive1656484instructive
instructor1255164instruct_or
lustration1048354lustr_ation
menstruation1455224menstruation
objection2045094ob__jection
objurgation2152404objurgation
obscurations1644024obscurations
observations1785014observations
obstructionisms2192804obstructionisms
obstructionists19103384obstructionists
obtrusions1263154ob_tru_sions
obturations13116424ob_turations
ostracon1045264o_strac__on
overaction1547994o_veraction
protraction1547214protraction
reconstruction1894774reconstruction
restrictions1449284restrictions
retraction121310534_retraction
ruction93611614____ruction
seduction1266984__seduction
stiction1038824__st_iction
striation9313484__striation
strictions1249144__strictions
subtraction1545624subtraction
suction93713044__s__uction
traction10412684___traction

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 Filter1786911488190.420425454.8
2DLD Change Limit148819839.01616506.1
3Display Results83830.0461804.3
 (SQL Overall)178691839.48218845.3
 
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.