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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
obsesses103622(None) 
obsessed1144271obsessed
abbesses1235332abbesses
abscesses1344102abscesses
assesses737382assesses
blesses93812392_blesses
noblesses1146002noblesses
observes1346172observes
obsess845942obse_s_s
obsessives1552952obsessives
obsessor1043032obsessor
obsessors1142882obsessors
obverses1335802obverses
ogresses938472ogresses
oyesses1037332o_yesses
possesses1046322possesses
abscessed1442703abscessed
abscises1246233abscises
absences1247673absences
abysses1234863ab_ysses
accesses1287493accesses
asepses946363_asepses
assessed945023assessed
basses85428303_b_asses
beses75830723_b_e_ses
biasses94911653_biasses
blessed10319493_blessed
blesser9329293_blesser
blessers10277633_blessers
blisses94911513_blisses
boreases10310253boreases
bosses85925403_b_osses
bossies94116833bos_sies
brasses93818353_brasses
brisses94314313_brisses
busses85023383_b_usses
caresses10314063caresses
caseases10410473caseases
caseoses1039293caseoses
cesses84221363__cesses
chesses124112633_chesses
confesses1438623confesses
coynesses1437573coynesses
cresses94219813_cresses
diseases92415813diseases
diseuses93112763diseuses
dresses83716173_dresses
duresses939173duresses
egresses949443egresses
esses56422973___esses
excesses1736753excesses
fesses94820253__fesses
finesses111912343finesses
goddesses1243453goddesses
guesses8169373_guesses
hostesses1247173hostesses
hotnesses1238903hotnesses
idlesses936003idlesses
jesses135215953__jesses
loesses7310033_loesses
lownesses1236983lownesses
messes84924343__messes
miseases102614343miseases
nesses64718323__nesses
noblesse1044543noblesse_
nonsenses948343nonsenses
nownesses1236893nownesses
obelises1039103obelises
obese75212423ob_e_se_
obeseness1145893obeseness
obesenesses1346763obesenesses
obscures1245513obscures
obsequies2062873obsequies
observe1245333observe_
observed1444383observed
observer1344733observer
observers1443973observers
obsessing1244263obsessing
obsession1144153obsession
obsessions1244273obsessions
obsessive1443743obsessive
obsolesces1452353obsolesces
obtested1135453obtested
obtests9136233obte_sts
obverse1234753obverse_
oddnesses1136353oddnesses
offenses1443833offenses
oldnesses1037703oldnesses
onenesses9311823onenesses
oppresses1346873oppresses
osmoses9138123o_smoses
osteoses839033osteoses
ostoses71213553o_stoses
outblesses1245493outblesses
poetesses1137233poetesses
possessed1244233possessed
presses93523153_presses
recesses10312323recesses
sasses64124393__sasses
seises64026713__seises
senses63923943__senses
sepses84515883__sepses
sisses64520603__sisses
stresses81112493stresses
subsenses1147473subsenses
susses64221053__susses
tresses73719543_tresses
tsetses785453_tsetses
vitesses1136333vitesses
votresses1236503votresses
wiseasses1244043wiseasses
woenesses1239133woenesses
yesses93615813__yesses

Search took 9 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.483369960.7
2DLD Change Limit1461621137.48319532.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911138.01222302.9
 
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.