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

74 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
obsessed114427(None) 
obsesses1036221obsesses
abscessed1442702abscessed
assessed945022assessed
blessed10319492_blessed
observed1444382observed
obsess845942obsess__
obsessor1043032obsessor
obtested1135452obtested
possessed1244232possessed
abbesses1235333abbesses
abscesses1344103abscesses
abscised1364133abscised
abseiled1144733abseiled
absented1156613absented
accessed1385413accessed
assesses737383assesses
bested94922763_b_ested
biassed10418703_biassed
blesser9329293_blesser
blesses93812393_blesses
blissed10388373_blissed
bossed94816533_b_ossed
brassed103612373_brassed
bussed94717053_b_ussed
caressed1139173caressed
cessed94615613__cessed
confessed1546053confessed
diseased103011713diseased
dressed93511873_dressed
egressed1046883egressed
excessed1844943excessed
fessed104515063__fessed
finessed12136793finessed
guessed9176603_guessed
hostessed1344353hostessed
jessed144112303__jessed
messed95018183__messed
noblesse1044543noblesse_
noblesses1146003noblesses
obelised1136173obelised
obese75212423ob_e_se_
obeyed1235823ob_e_yed
objected2043493objected
obscured1343893obscured
observe1245333observe_
observer1344733observer
observes1346173observes
obsessing1244263obsessing
obsession1144153obsession
obsessive1443743obsessive
obsessives1552953obsessives
obsessors1142883obsessors
obsolesced1551733obsolesced
obtected1344553obtected
obverse1234753obverse_
obverses1335803obverses
obverted1435103obverted
ogresses938473ogresses
oppressed1445123oppressed
osmosed10134843o_smosed
outblessed1343943outblessed
oyesses1037333o_yesses
possesses1046323possesses
pressed103317313_pressed
recessed1139723recessed
sassed76116173__sassed
seised74218123__seised
sensed73918163__sensed
stressed9128543stressed
sussed75015533__sussed
tressed83714263_tressed
unblessed1245323unblessed
yessed104511163__yessed

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.420425454.8
2DLD Change Limit146162747.69019006.8
3Display Results74740.0302466.7
 (SQL Overall)178691748.14021952.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.