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

191 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
mysost113826(None) 
mysosts1234541mysosts
misos76523292misos_
most66554202m__ost
accost101112263accost
almost81014433almost
amylose1237193amylose
assist6314603assist
assort64916383assort
basest84720493basest
besot76429713beso_t
besots86415453besots
boost75132473_boost
bypast13117373bypast
byssi10507993bys_si
cohost115217213cohost
cost68057943__cost
cymose13429653cymose
cyst96322813cy__st
cysts105912773cysts_
desist74818813desist
dost57248353__dost
dynast1088223dynast
frost84727833_frost
ghost96318763_ghost
glost65422933_glost
gyros95616483gyros_
gyrose105310253gyrose
host77852833__host
hypos1312014743hypos_
hyson1138693hyso_n
hysons1237633hysons
hyssop1443413hyssop
impost103011783impost
inmost8411363inmost
insist6314513insist
kybosh1842713kybosh
lost47951493__lost
lyrist9312293lyrist
lyses84518253lyses_
lysis84511463lysis_
lyssa835713lys_sa
magot8326393mago_t
magots9312363magots
mahout11415803mahout
maist75535683m_aist
makos116518363makos_
manos74933623manos_
masas75630413masas_
mascot104016073mascot
mascots113910343mascots
masks115320533masks_
mason74820183maso_n
masons83916513masons
mass66044943mas_s_
massa75518923mas_sa
masse75125293mas_se
massy104518963mas_sy
mast65959963m__ast
masts77035763masts_
mayest114614793mayest
mayos105521933mayos_
mayst106622673m_ayst
memos95719113memos_
merest84725113merest
mesas76823203mesas_
meson74118313meso_n
mesons83215843mesons
mess65932433mes_s_
messy104913833mes_sy
mhos95517773m_hos_
midmost1246153midmost
midst85922553m_idst
milos75428013milos_
mimosa1036363mimosa
misact10316683misact
miscast11312413miscast
miscut10614813miscut
miseat82925703miseat
mises74740563mises_
misfit112813833misfit
mishit112618193mishit
mislit83019693mislit
mismet103722373mismet
miso67229903miso__
miss65339423mis_s_
misset85028153misset
missort9314653missort
missout9412663missout
missy105617563mis_sy
mist66154533m__ist
mists76633903mists_
misuse83213643misuse
moat66352033m__oat
modest93818453modest
moist76033583m_oist
mojos145314463mojos_
molest85022743molest
molt66356163m__olt
mongst93512603mongst
monist84324983monist
monos75930863monos_
moos66051303m_oos_
moose76327193m_oose
moot67653623m__oot
moots75831663m_oots
morose85116243morose
mort66758833m__ort
mos57067123m__os_
mosh95227603m__osh
mosk105622443m__osk
mosks116117003mosks_
moss67641033m__oss
mosso74715183mos_so
mossy105217063mos_sy
moste75925083m__oste
mostest9314793mostest
mosts76028543m__osts
mot57279423m__o_t
mots66853163m__ots
mott66648443m__ott
mozos165516333mozos_
mucosa10166273mucosa
mucose10149313mucose
muscat10314653muscat
muses75134303muses_
musket122818203musket
muskit122813253muskit
musks116119643musks_
muss64933763mus_s_
mussy104117643mus_sy
must65145443m__ust
musts75527443musts_
mutest84218053mutest
myases113711553myases_
myasis114010473myasis_
mycoses1437733mycoses
mycosis1437763mycosis
mycs115314293my_cs_
mynas105815233mynas_
myoid11512993my_oid
myoma1239273my_oma
myope124010973my_ope
myopy15457353my_opy
myoses114013843myoses
myosin113410763myosin
myosis114012563myosis
myosote1245853myosote
myself1445593myself
mysid11610693mys_id
mysids1246563mysids
mystic132711643mystic
mythos14398463mythos_
myths135911603myths_
myxoid1936883myxoid
myxoma2043943myxoma
pesos77221623pesos_
pisos76021063pisos_
post67953363__post
prost75434103_prost
psst66118403_ps_st
pyros105718293pyros_
resist64524533resist
resort65728613resort
ripost83615003ripost
roost55730933_roost
ryot75528563ry_o_t
ryots85313783ry_ots
soft76942823__soft
soot45761063__soot
sort46264813__sort
sos37761603__sos_
sot310384303__so_t
sots45552453__sots
sysop1037193syso_p
sysops1136013sysops
tost48351923__tost
typist1139823typist
typos106015813typos_
tyros85118593tyros_
upmost1068193upmost
utmost878483utmost
volost9412643volost
wisest95016443wisest
wost76544363__wost
xylose1636763xylose
xyst144714073xy__st
xystos16356913xystos_
xysts15558123xysts_
yeast85327943_yeast
zygose19455553zygose

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161916.93616250.9
3Display Results1911910.0633031.7
 (SQL Overall)1786911917.13925030.3
 
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.