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 “miocene” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
miocene114792(None) 
diocese1036852diocese
eocene8311612_eocene
pliocene1244592pliocene
ammocete1444443ammocete
bicorne11297553bicorne
biocenose1343543biocenose
biocide1237323biocide
biogen9310253biogen_
biogens1038963biogens
biogeny1336023biogeny
croceine1248033croceine
crocine11314153crocine
diene65720133di__ene
dioceses1137113dioceses
dioxane1565423dioxane
docent92918683_docent
epicene1148593epicene
hircine1239143hircine
holocene1346143holocene
incense92410303_incense
incent83320723_incent
indene73215373_indene
iodine74618653_iodine
ionone6313443_ionone
licence11119373li_cence
license9148423li_cense
licente91210893li_cente
limonene1044573limonene
mice87442243mi_c__e
micell1098193mi_cell
micelle1178343mi_celle
miche126219243mi_c_he
mickle143715133mi_ckle
midden104112853midden_
middens11379383middens
midline102315103midline
mien65028373mi__en_
miens76118303mi__ens
milden94113153milden_
mildened1235773mildened
mildens10339933mildens
milline92519113milline
mince95325233minc__e
minced114114913mince_d
mincer104017363mince_r
mincers113714853mincers
minces104420803mince_s
mincing123314333mincing
mine67256183mi___ne
minuend1035383minuend
mioses84318853miose_s
miscite11314383miscite
miscode12310413miscode
miscue10412223misc_ue
misdone10310863misdone
mispen10312173mispen_
mispens11311073mispens
missend104411373missend
missense1037963missense
missent94318713missent
mistend103812523mistend
mistune9310653mistune
mitogen1036963mitogen_
mitogens1146973mitogens
mitten83914093mitten_
mittened1136363mittened
mittens9349883mittens
mizen164815273mi_zen_
mizens174610253mi_zens
mizzen16447953mizzen_
mizzens17366123mizzens
moderne1037123m_oderne
moline84422033m_oline
moment103319683m_oment
mooneye12116933mooneye
moreen8313343m_oreen
mycele1335853m_ycele
neogene847553neogene
nocent83217413_nocent
obscene1145243obscene
oligocene1252753oligocene
phocine1438833phocine
pinene82915653pi_nene
piscine11610973piscine
pleiocene1353123pleiocene
propene112716043propene
scene77220573__scene
sincere9310553sincere
violence1345713violence
violent102110813violent
violone1037153violone

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 Limit134027926.80019709.9
3Display Results92920.0303066.7
 (SQL Overall)178691927.23624694.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.