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

113 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
mitogen103696(None) 
mitogens1146971mitogens
amidogen1243912amidogen
biogen9310252bi_ogen
histogen1245562histogen
mitogenic1446382mitogenic
mitoses9312182mitoses
mitten83914092mit_ten
mutagen1056602mutagen
nitrogen945822nitrogen
pirogen1038262pirogen
acrogen1038203acrogen
amidogens1343653amidogens
amitoses1039053amitoses
amylogen1444263amylogen
antigen8311123antigen
autogeny1245233autogeny
automen939653automen
autopen947123autopen
betoken13386503betoken
biogens1038963bi_ogens
biogeny1336023bi_ogeny
bitchen14349733bitchen
bitten84715123bit_ten
bitumen1134503bitumen
cithren12306593cithren
citizen1845713citizen
citole8311503citole_
citoles9312553citoles
cryogen1345043cryogen
cytogeny1744083cytogeny
endogen938613endogen
estrogen946573estrogen
exogen1436513_exogen
goitrogen1152203goitrogen
halogen1138393halogen
histogens1344653histogens
hitmen11239193hit_men
ionogen837123ionogen
isogeny11196363_isogeny
isogon7227543_isogon
kerogen1236093kerogen
kitchen16287683kitchen
kitten104611483kit_ten
litotes7311183litotes
litten64014873lit_ten
lysogen1144363lysogen
metage93114453metage_
metages102714973metages
metope10611123metope_
metopes11311363metopes
metopon11137073metopon
miaoued1034583miaoued
miaowed1333883miaowed
midden104112853mi_dden
midge95016553mi_dge_
midges103516483mi_dges
midget103718453mi_dget
midtown1343673midto_wn
mien65028363mi___en
milage93414123milage_
milages103114403milages
milden94113153mi_lden
milkmen1565213milkmen
minored10310103minored
mintage101110123mintage_
mintages111110513mintages
miocene1147923mi_ocene
mioses84318853mi_oses
mirage92313653mirage_
mirages102213533mirages
misagent11410723misagent
misogyny1742763misogyny
mispen10312173mi_spen
mistaken14147833mistaken
mite66249413mit__e_
miter75734793mit__er
mitered103213233mitered
miterer92511333miterer
mites75141803mit__es
mither114218563mit_her
mitier83620673mit_ier
mitises9315543mitises
mitosis939633mitosis
mitotic1139713mitotic
mitre75522423mit_re_
mitred94414343mit_red
mitres83922073mit_res
mittens9349883mit_tens
mizen164815273mi__zen
mizzen16447953mi_zzen
monogeny1446133monogeny
morgen9312203m_orgen
motored1039933motored
motormen1245703motormen
mucinogen1452463mucinogen
mutagens1144853mutagens
muton73817003muto__n
niton55418283nito__n
nitrogens1045353nitrogens
ontogeny1244793ontogeny
pathogen1446463pathogen
pitmen102510793pit_men
piton76121583pito__n
pyrogen1337353pyrogen
sitten64113823sit_ten
smidgen11426513smi_dgen
smitten936693smit_ten
stogey105811543_stogey
stolen64315063_stolen
titmen8239883tit_men
token95419313__token
zymogen2243693zymogen

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.436409841.7
2DLD Change Limit1340271136.67020094.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.15224984.8
 
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.