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

59 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
obsessing124426(None) 
abscessing1543312abscessing
assessing1045172assessing
blessing1137592_blessing
observing1544382observing
obsession1144152obsession
obsessions1244272obsessions
obsessive1443742obsessive
obtesting1245882obtesting
possessing1344672possessing
abscising1444943abscising
abseiling1265343abseiling
absenting1236993absenting
accessing1445833accessing
beeswing14255763_beeswing
besting104923923_b_esting
biassing11307263_biassing
blessings1233723_blessings
blissing1136873_blissing
bossing103714603_b_ossing
brassing112612303_brassing
bussing103614623_b_ussing
caressing1238803caressing
cessing103814813__cessing
confessing1647183confessing
diseasing11310833diseasing
dressing102810423_dressing
egressing1146853egressing
excessing1945713excessing
fessing113812863__fessing
finessing1345123finessing
guessing1036243_guessing
hostessing1444573hostessing
jessing153710623__jessing
messing103916393__messing
obelising1256323obelising
obeying1336543ob_e_ying
objecting2144053objecting
obscuring1444023obscuring
obsess845943obsess___
obsessed1144273obsess_ed
obsesses1036223obsess_es
obsessional1353343obsessional
obsessives1552953obsessives
obsessor1043033obsess_or
obsessors1142883obsessors
obsolescing1651643obsolescing
obverting1536303obverting
oppressing1545973oppressing
osmosing1135223o_smosing
outblessing1443453outblessing
pressing112516443_pressing
recessing12611013recessing
sassing84615553__sassing
seising84018863__seising
sensing84116953__sensing
stressing1038333stressing
sussing84013703__sussing
yessing113210063__yessing

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 Filter1786911486410.470380193.6
2DLD Change Limit148641597.39020113.8
3Display Results59590.0163687.5
 (SQL Overall)178691597.87622688.0
 
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.