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

153 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
ostosis7131012(None) 
osmosis976571osmosis
osteosis846741osteosis
ostoses71213551ostoses
exostosis1644422exostosis
ketosis11429732ketosis
mitosis939632mitosis
orthosis1148192orthosis
osmoses9138122osmoses
osteoses839032osteoses
ostomies10310582ostomies
ostosises946232ostosises
ptosis83611822_ptosis
sorosis72611972sorosis
stasis63116872_stasis
stoss54316342_stos_s
abiosis939373abiosis
aftosas10147153aftosas
amitosis1047203amitosis
apoptosis1345363apoptosis
ascesis938373ascesis
asepsis985903asepsis
askesis1136123askesis
astasia7310933astasia
astasias8410143astasias
astonies8815093astonies
astonish1148453astonish
bostons9312903bosto_ns
coniosis1048133coniosis
cosmoses1239703cosmoses
ectasis9249613ectasis
enosis63816423_enosis
entasis73012573entasis
esthesis1148463esthesis
estops84011223esto_ps
exosmosis1862973exosmosis
exostoses1655623exostoses
gaposis1038423gaposis
gnosis75711213_gnosis
hostess103210243hostes_s
kenosis11369003kenosis
ketoses114912873ketoses
kurtosis1294403kurtosis
lordosis944453lordosis
lotoses73713643lotoses
meiosis939023meiosis
miosis83615163_miosis
mitoses9312183mitoses
mostests1036833mostests
mycosis1437763mycosis
myosis114012563_myosis
nostocs947553nosto_cs
oasis56422553o__asis
obtests9136233obtests
octopi1036533octopi_
octopus1144813octopus
octrois938333octrois
opposes1149243opposes
orthoses11311133orthoses
osmoles9138363osmoles
osmols8137313osmo_ls
osmose8108003osmos_e
osmosed10134843osmosed
osmosing1135223osmosing
osmotic11127613osmotic
osmous8138183osmo_us
ossia53710403os__sia
osteitis847013osteitis
osteoid848193osteoid
osteoids945953osteoids
osteomas1045333osteomas
osteosises1044523osteosises
ostia52315583ost__ia
ostioles839273ostioles
ostlers72911203ostlers
ostomy1137833osto_my
otitis63612343o_titis
ottos54714323otto__s
outasks1138173outasks
outkiss1137783outkiss
outposts1037253outposts
outsin63617563out_sin
outsins73417863out_sins
outsit63620893out_sit
outsits73215253out_sits
patois84319363pato_is
postops11311713posto_ps
postposes1348193postposes
proptosis1348203proptosis
psilosis1045123psilosis
ptoses83514673_ptoses
pyosis114012123_pyosis
pyrosis12411653pyrosis
satoris7317253satoris
sepsis83011293_sepsis
shogis103810943_shogis
shojis16348493_shojis
soroses73117483soroses
sotols63714473soto_ls
stases64225563_stases
stenosis847993_stenosis
stoai55417873_stoai_
stoas55126023_sto_as
stoats65117483_stoats
stobs75718233_sto_bs
stocks124715633_stocks
stogie7311323_stogie
stogies8413693_stogies
stoic7317253_sto_ic
stoics8311113_stoics
stokes104821793_stokes
stoles63927673_stoles
stolid74213183_stolid
stomas84816323_stomas
stomps105612833_stomps
stones65130033_stones
stonish10410653_stonish
stooks105115373_stooks
stools65117023_stools
stoops85917893_stoops
stopes84525893_stopes
stops74827283_sto_ps
stores65533663_stores
stories7324273_stories
storks106115953_storks
storms85814633_storms
stotin63215063_stotin
stotins73213873_stotins
stots54828553_sto_ts
stotts64612863_stotts
stoups85313273_stoups
stours65015633_stours
stouts65019003_stouts
stoves93818923_stoves
stowps115710583_stowps
stows86622703_sto_ws
stypsis1245243_stypsis
sycosis1238823sycosis
synostosis1353953synostosis
tatsois748373tatsois
topis76025833__topis
tortonis848743tortonis
toss45637973__tos_s
tsooris734693tsooris
tsoris63411193ts_oris
uptoss836093uptos_s
virosis1039023virosis
whoosis1335453whoosis
whosis1237173_whosis
xerosis14249663xerosis
zoonosis1744393zoonosis
zygosis20405953zygosis
zymosis21487493zymosis

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271537.09318895.7
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.54523683.4
 
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.