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

255 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
myosin11341076(None) 
myosins12278961myosins
myosis114012561myosis
eosin55220922_eosin
lysin84512782ly_sin
miosis83615162miosis
myasis114010472myasis
mycosis1437762mycosis
myelin1138972myelin
myoid11512992myo_id
myopia13318442myopia
myopic15308462myopic
myoses114013842myoses
myotic133112312myotic
mysid11610692my_sid
pyosis114012122pyosis
rosin55325312_rosin
tylosin1046902tylosin
yogin98317742_yogin
aloin55227423alo_in
amylopsin1652803amylopsin
ayin76331743ay__in
basin75026923_basin
biotin83215833biotin
boson76019733_boson
bosun75113593_bosun
bromin102615693bromin
byssi10507993byssi_
chopin132712193chopin
chosen116014133chosen
chymosin1845013chymosin
closing103114843closing
coin66645353_co_in
colin76231693_colin
conin76232723_conin
cosie74728263_cosie
cosign958783_cosign
cosine83823513_cosine
cousin8517163cousin
covin105621123_covin
cyanin113911453cyanin
cycasin1445903cycasin
cyclin1339273cyclin
cyesis1148573cyesis
cymlin1337313cymlin
cytosine1346873cytosine
dioxin14118783dioxin
dosing83920273_dosing
dynein1035563dynein
eloin55923203elo_in
emodin9310353emodin
enosis63816423enosis
eosine64519413_eosine
eosins64419163_eosins
erosion7311113erosion
essoin638193essoin
florin9312653florin
foin77231563_fo_in
globin9309723globin
gnosis75711213gnosis
goosing93314083goosing
groin65521083gro_in
hosen85623883_hosen
hosing103421103_hosing
hyalin122210043hyalin
hyoid12612443hyo_id
hyoscine1644183hyoscine
hyson1138693hy_son
imposing1348463imposing
inosine7314273inosine
iodin64419353_iodin
isospin944493isospin
join116724833_jo_in
kamsin1238323kamsin
kaolin1039583kaolin
login66025003_login
loin46838723_lo_in
loosen66615963loosen
loosing83515963loosing
losing74022873_losing
lysine94210553ly_sine
lysing104710443ly_sing
lysins94610953ly_sins
lysis84511463ly_sis
main65345523m__ain
malkin122913153malkin
mansion9611543mansion
margin94016843margin
marlin84220903marlin
martin84122523martin
mason74820183m_ason
massif11412533massif
massing104318023massing
matin75132853m_atin
mattin84416633mattin
mavin105722953m_avin
mayos105521933mayos__
mayvin1436523mayvin
meiosis939023meiosis
mensing103915103mensing
meouing1059203meouing
meowing1368593meowing
merlin83916683merlin
mesian84315503m_esian
mesic93617863m_esic
meson74118313m_eson
messan83912063messan
messing103916393messing
mhos95517773mhos__
mioses84318853mioses
miotic103715753miotic
mirin75023153m_irin
missing103619073missing
mission9312743mission
missis84417503missis
mitosis939633mitosis
moan65832023m_o_an
modi76826313m_odi_
moil65534093m_o_il
moist76033583m_oist
moline84422033m_oline
momi87524483m_omi_
mon57561583m_o__n
monie75631653m_onie
mooing93718373m_ooing
moon67140813m_o_on
mooning103415553mooning
mooring102514443mooring
moos66051303moos__
moose76327193moos_e
mooting103019363mooting
moping114017103m_oping
morion86217733m_orion
morn66237563m_o_rn
moron76925423m_oron
mos57067123m_os__
mosaic10311143m_osaic
mosey105922873m_osey
mosh95227603m_os_h
moshing134214883m_oshing
mosk105622443m_os_k
mosks116117003m_osks
moss67641033m_os_s
mossing103915423mossing
mosso74715183m_osso
mossy105217063m_ossy
most66554203m_os_t
moste75925083m_oste
mosts76028543m_osts
motif10519683m_otif
motion85217553m_otion
moulin8313283moulin
mourn77215013m_ourn
mousing103816273mousing
movie105319133m_ovie
moving123913283m_oving
mowing124119093m_owing
mown95424443m_o_wn
moxie144018123m_oxie
mucin93116823m_ucin
muffin14298873muffin
muntin82915183muntin
muon65722733muo__n
muonic10410183muonic
murein8311763murein
music94316403m_usic
musing93919503m_using
muslin8312213muslin
mussing104015543mussing
myases113711553myases
mycoses1437733mycoses
mycotic1647713mycotic
mycs115314293mycs__
myeline1238253myeline
myelins1237353myelins
myiasis1245493myiasis
myoma1239273myo_ma
myomas1338303myomas
myope124010973myo_pe
myopes13419963myopes
myopias14308153myopias
myopies14309723myopies
myopy15457353myo_py
myositis1345633myositis
myosote1245853myosote
myosotis1344523myosotis
myotics14257603myotics
mysids1246563my_sids
mysost1138263mysost
mysosts1234543mysosts
mystic132711643mystic
mythic1637273mythic
myxoid1936883myxoid
noosing83315053noosing
nosing73419843_nosing
opsin7613473_opsin
outsin63617563outsin
pepsin10310853pepsin
plosion939113plosion
pocosin1169643pocosin
posing93922643_posing
posit75833333_posit
postin83521033_postin
prosing103319383prosing
prosit85124593prosit
ptosis83611823ptosis
pyin96823233py__in
pyoid11513763pyo_id
pyoses114314303pyoses
pyrosis12411653pyrosis
quoin144012323quo_in
raisin62716923raisin
resin54131053_resin
robin74820283_robin
roosing84018133roosing
rosing73925593_rosing
rosins64521863_rosins
rosiny94414533_rosiny
ryokan1353753ryokan
sasin54626573_sasin
seisin63715123seisin
sin36265893___sin
sozin14514543_sozin
stotin63215063stotin
sycosis1238823sycosis
sylvin12247303sylvin
thymosin1644483thymosin
tocsin8311003tocsin
toxin124716713_toxin
tropin83316753tropin
trypsin1245113trypsin
tyin76424003ty__in
tylosins1145723tylosins
tyrosine1147043tyrosine
violin9311983violin
whosis1237173whosis
yin67648733_y__in
yogi86120423_yogi_
yogic116114933_yogic
yogini10449143_yogini
yogins105114103_yogins
yogis95617743_yogis
yoking143912283_yoking
yomim12510083_yomim
yon67348953_yo__n
yoni77524393_yoni_
yonic105920843_yonic
yonis85020823_yonis
yourn87512773_yourn
yowie114616453_yowie
yowing133715543_yowing
zoysia1844163zoysia
zygosis20405953zygosis
zymosan2143803zymosan
zymosis21487493zymosis

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.1231452772.4
2DLD Change Limit1127162555.31321215.1
3Display Results2552550.0803187.5
 (SQL Overall)1786912555.51632395.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.