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

145 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
mitosis93963(None) 
amitosis1047201amitosis
miosis83615161mi_osis
mitoses9312181mitoses
amitoses1039052amitoses
ketosis11429732ketosis
meiosis939022meiosis
mimesis1137322mimesis
mimosas1136752mimosas
mioses84318852mi_oses
missis84417502mi_ssis
mitis75425992mit__is
mitises9315542mitises
mitotic1139712mitotic
mycosis1437762mycosis
myosis114012562m_yosis
ostosis71310122ostosis
ptosis83611822_ptosis
virosis1039022virosis
abiosis939373abiosis
acidosis1146143acidosis
adiposis1146253adiposis
aftosas10147153aftosas
aiolis6316843ai_olis
amitotic1247003amitotic
bigoses1039073bigoses
citolas939363citolas
citoles9312553citoles
clitoris1047873clitoris
diesis74013493di_esis
diplosis11128413diplosis
ectasis9249613ectasis
enosis63816423_enosis
entasis73012573entasis
epitasis1047433epitasis
fibrosis1345453fibrosis
gaposis1038423gaposis
gnosis75711213_gnosis
halitosis1245203halitosis
hematosis1447623hematosis
hidrosis1246303hidrosis
imposes113213683imposes
imposts11269003imposts
kenosis11369003kenosis
ketoses114912873ketoses
kinesis11259593kinesis
kiosks934383ki_osks
kurtosis1294403kurtosis
litchis1238373litchis
litotes7311183litotes
litotic939243litotic
lotoses73713643lotoses
maltoses1039853maltoses
meioses9310833meioses
merisis93213173merisis
metis75025903met__is
metols84115773meto_ls
metopes11311363metopes
metopic1339763metopic
miaous8511693miao_us
miaows1145473miao_ws
miasms1097383mi_asms
midis85923413mi__dis
midmosts1343773midmosts
midsts95510053mi_dsts
midtowns1443243midtowns
miladis1049823miladis
milords10117853milords
milos75428013milo__s
milreis937323milreis
mimeses1139073mimeses
mimosa1036363mimos_a
minis75432993mi__nis
miniskis1444453miniskis
minors85117103mino_rs
minuses93512703minuses
miotic103715753mi_otic
miotics112710653miotics
mises74740563mi__ses
misos76523293mi__sos
miss65339423mi__s_s
misses85130873mi_sses
missies93423983mi_ssies
missus85312293mi_ssus
mists76633903mi__sts
misuses93216023misuses
miters84328783mit_ers
mites75141803mit__es
mithers123516733mithers
mitogen1036963mitogen
mitogens1146973mitogens
mitres83922073mit_res
mittens9349883mittens
mitts75523753mit__ts
mosks116117003m__osks
moss67641033m__os_s
mosts76028543m__osts
motoric11312223motoric
motorise10311523motorise
motorist10314413motorist
motors84616603moto_rs
mucosas11146683mucosas
mutases92012043mutases
mutisms11338453mutisms
mutons84314363muto_ns
myasis114010473m_yasis
mycoses1437733mycoses
myiasis1245493myiasis
myoses114013843m_yoses
myosin113410763m_yosin
myosins12278963m_yosins
mysosts1234543mysosts
nitons64614903nito_ns
orthosis1148193orthosis
osmosis976573osmosis
osteosis846743osteosis
ostoses71213553ostoses
patois84319363pato_is
phimosis1546193phimosis
pitons85319043pito_ns
psilosis1045123psilosis
ptoses83514673_ptoses
pyosis114012123_pyosis
pyrosis12411653pyrosis
riboses9310443riboses
riposts9279403riposts
satoris7317253satoris
semiosis1059873semi_osis
situses72710493situses
sorosis72611973sorosis
stasis63116873_stasis
stoss54316343_stos_s
sycosis1238823sycosis
tatsois748373tatsois
titis56023813tit__is
topis76025833__topis
toss45637973__tos_s
uptoss836093uptos_s
viroses10310533viroses
whoosis1335453whoosis
whosis1237173_whosis
xerosis14249663xerosis
zitis145815583zit__is
zygosis20405953zygosis
zymosis21487493zymosis

Search took 9 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.830215290.4
2DLD Change Limit1340271457.36018210.2
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.25321651.6
 
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.