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

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

56 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
obtruded124336(None) 
obtrude1044241obtrude_
obtruder1143091obtruder
obtrudes1144071obtrudes
detruded1134882detruded
extruded1743842extruded
intruded1035992intruded
obtruders1242492obtruders
obtunded1243522obtunded
abraded1138643ab_raded
barded105426423_bar_ded
birded104414303_bir_ded
boarded113910503boar_ded
bruted95113263_b_ruted
bruxed16466983_b_ruxed
detrude936083detrude_
detrudes1036203detrudes
extrude1545013extrude_
extruder1643993extruder
extrudes1645243extrudes
intrude837403intrude_
intruder945213intruder
intrudes937493intrudes
nitrided10276753nitrided
obscured1343893obscured
obstructed1544233obstructed
obtained1136533obtained
obtected1344553obtected
obtested1135453obtested
obtruding1344123obtruding
obtund945583obt_u_nd
obturated1245953obturated
obtuse8147483obt_use_
obtuser9134453obt_user
occluded1492593occluded
outadded1135933outadded
outguided1264573outguided
outmoded12207703outmoded
outraced112414203outraced
outraged102313103outraged
outrated92219313outrated
outraved122511923outraved
outride82615683outride_
outrider92410563outrider
outrides92414993outrides
outrode82313423outrode_
outrowed1239433outrowed
outrushed1346293outrushed
outtraded1176983outtraded
overused1249443overused
protruded1343443protruded
strudel835783_strudel
traded85717683__traded
truced95312053__truced
trudged10298043__trudged
trued65117693__tru_ed

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit146162566.93621073.0
3Display Results56560.0163500.0
 (SQL Overall)178691567.35824285.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.