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

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
obscure114533(None) 
obscured1343891obscured
obscurer1243521obscurer
obscures1245511obscures
obscene1145242obscene
obscurely1652122obscurely
obscurest1343412obscurest
oscule838192o_scule
abjure1536743ab_jure
abscise1145953abscise
absurd935903abs_urd
assure6610773_assure
bascule1136573bascule
becurse1136183_becurse
bordure1035783bordure
boscage1276533boscage
bosque17257733bosqu_e
cure66149123___cure
dasyure1153823dasyure
ensure63416003ens_ure
epicure1136823epicure
fescue1137493fescu_e
fissure1036783fissure
gesture839243gesture
insecure1044653insecure
insure63416603ins_ure
lobscouse1351853lobscouse
miscue10412223miscu_e
moisture1046653moisture
nonsecure1145243nonsecure
obscener1244323obscener
obscurant13124183obscurant
obscuring1444023obscuring
obscurity1652803obscurity
observe1245333observe
obtrude1044243obtrude
obtuse8147483ob_tuse
occur9137323o_ccur_
occurs10136553o_ccurs
ochre103411593o__chre
onshore10310013onshore
oospore939013oospore
opuscule1242823opuscule
ordure756813o_rdure
oscine8311563o_scine
oscula837293o_scula
oscules938123o_scules
ossature843303ossature
outcurse1045833outcurse
outcurve1344433outcurve
outscore10169203outscore
overcure132210053overcure
pasture9311463pasture
posture9313253posture
precure11312553precure
procure1138573procure
rasure6311423ras_ure
rescore95616203rescore
rescue8313003rescu_e
rescuer939033rescuer
resecure1047183resecure
scare75334463__scare
score75526743__score
scurf104719323__scurf
scute75520943__scute
secure8513533_secure
sucre75019103__sucre
sure45447413__s_ure
tonsure758783tons_ure
unsure62815413uns_ure
vesture10310373vesture

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 Filter1786911340270.406440125.6
2DLD Change Limit134027715.75023309.0
3Display Results71710.0302366.7
 (SQL Overall)178691716.18628886.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.