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

54 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
obscured134389(None) 
obscure1145331obscure_
obscurer1243521obscurer
obscures1245511obscures
obscurely1652122obscurely
obscurest1343412obscurest
abjured1735073ab_jured
abscised1364133abscised
absurd935903abs_ur_d
ascared10399523_ascared
assured858373_assured
becursed1335583_becursed
bescoured1444333bescoured
cured85932133___cured
ensured83512943ens_ured
fissured1235183fissured
gestured1036993gestured
insured83714253ins_ured
lobstered1244633lobstered
miscued1239293miscu_ed
obscene1145243obscene_
obscener1244323obscener
obscurant13124183obscurant
obscuring1444023obscuring
obscurity1652803obscurity
observed1444373observed
obsessed1144273obsessed
obtruded1243363obtruded
occurred1343483o_ccurred
ochred12328003o__chred
oscule838193o_scule_
oscules938123o_scules
osiered837123o_siered
outcursed1245133outcursed
outscored12207073outscored
overcured15148643overcured
oystered1236913oystered
pastured1138233pastured
postured1139493postured
precured1339993precured
procured1336603procured
rescored114513103rescored
rescued10410043rescu_ed
resecured1245533resecured
scared95227293__scared
scored94621133__scored
scoured103811153__scoured
secured1059723_secured
soured74921863__soured
tonsured976383tons_ured
uncured10513233_uncured
unsecured1244903unsecured
unsoured9310053unsoured
vestured1237463vestured

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162546.71621763.3
3Display Results54540.0163375.0
 (SQL Overall)178691546.88825942.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.