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

151 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
mitotic113971(None) 
amitotic1247011amitotic
litotic939241litotic
miotic103715751mi_otic
biotic103816612bi_otic
ketotic1348642ketotic
meiotic11410932meiotic
metopic1339762metopic
mimetic1338652mimetic
miotics112710652mi_otics
mitosis939632mitosis
motoric11312232motoric
mycotic1647712mycotic
myotic133112312m_yotic
ptotic102713372_ptotic
abiotic11510463abiotic
acidotic1355983acidotic
acrotic112515543acrotic
amitosis1047203amitosis
amniotic1246403amniotic
aphotic142913123aphotic
aprotic112715243aprotic
argotic10310283argotic
astatic9514193astatic
atomic104115603_atomic
atonic83420473_atonic
atopic103514143_atopic
attic75618353_at_tic
azotic172711633_azotic
bionic103614573bi_onic
biontic1148333biontic
biopic123710673bi_opic
bioptic1337563bioptic
biotics113812173bi_otics
biotin83215833bi_otin
biotitic1247573biotitic
cerotic11415063cerotic
chaotic14310043chaotic
citric102812313cit_ric
clitoric1246603clitoric
demotic12412353demotic
diatomic1346973diatomic
diatonic1138683diatonic
dichotic1647663dichotic
dicrotic1348883dicrotic
dietetic1146803dietetic
dipodic1397593dipodic
diprotic1348553diprotic
disomic1238763disomic
ectatic11310123ectatic
ectopic1338153ectopic
eidetic1039743eidetic
eidolic1047063eidolic
entopic1149953entopic
epidotic1346883epidotic
epitomic1446783epitomic
ergotic1049723ergotic
erotic82620273_erotic
exotic153112653_exotic
fibrotic1545723fibrotic
fistic11812573fi_stic
gittin72910553git_tin
glottic1036653glottic
hidrotic1446903hidrotic
historic1388943historic
iconic10411593_iconic
ictic9311803_i_ctic
idiotic1037463idiotic
iodic84816753_i_odic
ionic74622663_i_onic
iritic83213823_iritic
ironic8313773_ironic
italic839903_italic
kenotic1359713kenotic
ketonic1349923ketonic
kinetic13209173kinetic
lithic1139493lit_hic
litotes7311183litotes
lotic76420673__lotic
maieutic1243873maieutic
maloti8313213maloti_
mantic104120903m_antic
masonic1139913masonic
mastic103119173m_astic
mastitic1248263mastitic
mattin84416633mat_tin
mattoid1079283mattoid
melodic1238543melodic
meropic13310263meropic
mesonic11310093mesonic
meteoric1247303meteoric
methodic1656923methodic
metric10314683met_ric
miasmic1335743miasmic
microbic1647213microbic
militia949733militia
mimic111414323mi__mic
minutia946423minutia
miosis83615163mi_osis
mitis75425993mi__tis
mitogen1036963mitogen
mitogenic1446383mitogenic
mitoses9312183mitoses
mitt66145493mit_t__
mitten83914093mit_ten
mitts75523753mit_t_s
monodic1269783monodic
moronic11311863moronic
motif10519683m__otif
motific1446323motific
motivic1445163motivic
muonic10410183m_uonic
myopic15308463m_yopic
myotics14257603m_yotics
myotonic1547753myotonic
mystic132711643m_ystic
mythic1637273myt_hic
nepotic11310563nepotic
nicotin948383nicotin
niobic1037243ni_obic
nitric82512063nit_ric
nitrolic1046813nitrolic
orthotic1348213orthotic
osmotic11127613osmotic
otic66624823___otic
otitic83112683_otitic
parotic112518043parotic
phimotic1747153phimotic
photic133316443_photic
pionic103515953pi_onic
piratic11314293piratic
psilotic1245773psilotic
quixotic2642943quixotic
rhotic112711233_rhotic
robotic1139223robotic
semiotic12710633semi_otic
semitonic1347353semitonic
static83118683_static
stoic7317253_sto_ic
stotin63215063_stotin
titanic968553titanic
tittie63213153tit_tie
tonic74727653__tonic
topic95721503__topic
toric76529313__toric
toxic145315623__toxic
viatic11311453vi_atic
vitric112510113vit_ric
xerotic16410863xerotic
zygotic2254663zygotic
zymotic2345713zymotic

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 Limit1340271517.12618808.2
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.59523527.5
 
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.