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

106 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
myself144559(None) 
itself946262itself
mycele1335852mycele
self75138292__self
thyself1643032thyself
basely114412313basely
cypsela1442443cypsela
delf85436573__delf
dynel9569853dynel_
dynels10536813dynels
easel54521113easel_
easels65914553easels
elf66138523___elf
enserf9310763enserf
fusel85218493fusel_
fusels94412453fusels
herself1337623herself
himself1544293himself
hisself1335913hisself
hosel86024823hosel_
hosels94218613hosels
losel54419423losel_
losels64714593losels
lyse76320593lyse__
lysed95011563lyse_d
lyses84518253lyse_s
masala8311813masala
maser75029973mase_r
masers84623453masers
massif11412533massif
mel56047483m__el_
meld75830473m__eld
mell64935613m__ell
mels65941533m__els
melt65752893m__elt
merely111312593merely
micell1098193micell
mise66043593mise__
miseat82925713miseat
miser75430403mise_r
miserly12329823miserly
misers85025703misers
misery114113543misery
mises74740563mise_s
misled94719313misled
misrely12319613misrely
missel85216523missel_
missels94614813missels
model84521693model_
models94216363models
mohel104914833mohel_
mohels115011333mohels
morel75729093morel_
morels84820023morels
morsel85815893morsel_
morsels94112663morsels
mosey105922873mose_y
moseys114711713moseys
mostly113110943mostly
motel76623243motel_
motels83616903motels
muesli835183muesli
muscle10310973muscle
muscly1337453muscly
muse67136033muse__
mused85524583muse_d
muser76024123muse_r
musers84719103musers
muses75134303muse_s
museum1037703museum
mussel83412903mussel_
mussels9419843mussels
mutely113811653mutely
myases113711553myase_s
myceles1435213myceles
mycelia1444843mycelia
myelin1138973my_elin
myoses114013843myose_s
myrtle1135733myrtle
mysid11610693mys_id
mysids1246563mysids
mysost1138263mysost
mystery15436523mystery
mystic132711643mystic
mystify1843563mystify
nonself1078513nonself
oneself1046073oneself
ourself1057453ourself
ousel55222403ousel_
ousels64815283ousels
pelf97031453__pelf
resell64215203resell
seif75638733__seif
sel38253323__sel_
selfs85220243__selfs
sell45840613__sell
sels46345983__sels
serf76340113__serf
shelf115221113_shelf
unsell63512543unsell
wisely122711713wisely
yeld811423873_y_eld
yelk115320003_y_elk
yell76028323_y_ell
yelp95621353_y_elp
yield9519693_yield

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127161065.43620735.1
3Display Results1061060.0303533.3
 (SQL Overall)1786911065.85930498.5
 
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.