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

240 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
mikron1231850(None) 
micron103714281micron
mikrons13428411mikrons
omikron1353171omikron
bicron103710772bicron
citron83112982citron
diuron738572diuron
eikon939462eik_on
giron66118992gi_ron
ikon85814952_ik_on
iron46728462_i_ron
macron103615672macron
marron83717542marron
matron83918312matron
micro94715992micro_
microns113814782microns
micros104115362micros
midiron1046002midiron
mignon937952mignon
mikra114610312mikr_a
mikvos1554022mikvos
mikvot1556762mikvot
minion83416242minion
mirin75023152mi_rin
mirror848002mirror
moron76925422m_oron
omicron1165062omicron
omikrons1462962omikrons
aileron739833aileron
airn46433833ai_r_n
apron7318833_apron
baron78131243_baron
bicorn103610103bicorn
bicrons113410473bicrons
billon83713833billon
biotron937293biotron
biro66131213bi_ro_
biros75325133bi_ros
bison75716983bi_son
boron76727143_boron
cion613330913ci__on
cistron9299883cistron
citrin82615413citrin
citrons92913223citrons
dacron94310693dacron
daikon11217243daik_on
diatron839283diatron
diurons838823diurons
eikons1038503eik_ons
einkorn1144223einkorn
fibrin1138533fibrin
fibroin1246473fibroin
firkin1337823firkin
firn76927503fi_r_n
garron73113493garron
gibbon1135323gibbon
gibson935123gibson
gipon84212413gi_pon
girn56026863gi_r_n
giro55828633gi_ro_
girons75014373gi_rons
giros65722653gi_ros
gyron95314623_gyron
hadron102913753hadron
heron85025503_heron
icon66922043_i_con
ikons96311013_ik_ons
imbrown1443883imbrown
improv1344643improv
inion54620183_inion
inro45920793_inro_
inrun52911373_inrun
intron64215023intron
ion36051023_i__on
irone55126363_i_rone
irons55324133_i_rons
irony85015903_i_rony
kaon87521023__kaon
kirn87123443ki_r_n
krona93611793__krona
krone94018733__krone
kroon94514483__kroon
ladron73413323ladron
ligroin848043ligroin
liken911818843lik_en
linuron746513linuron
lion46334443li__on
lirot5430033li_rot
macon94519953m_acon
macro94718173macro_
macrons113514893macrons
macros104017013macros
madrona10288703madrona
madrone102812663madrone
madrono10288743madrono
mako105622363mak_o_
makos116518363mak_os
mammon939643mammon
maroon83118203maroon
marrons93216973marrons
marrow112812603marrow
mascon103612743mascon
mason74820183m_ason
matrons93517633matrons
megaron10248303megaron
melon73922083m_elon
melton8311553melton
merlon83012353merlon
meson74118313m_eson
metro74718803metro_
metros84217803metros
miaou7513083mi_aou
miaow1058353mi_aow
micra96214973micr_a
microbe1338663microbe
microhm1646123microhm
midden104112853midden
midirons1145883midirons
midnoon1044683midnoon
midrib1138243midrib
midtown1343673midtown
mien65028363mi__en
mignons1037863mignons
migrant10314313migrant
mihrab1335523mihrab
mikado1344513mikado
mikados1444683mikados
mike105535293mik__e
miked125020453mik_ed
mikes115129893mik_es
miking134218463miking
mikvah18143473mikvah
mikveh18132543mikveh
mikvoth1962143mikvoth
milden94113153milden
milkman1544913milkman
milkmen1565213milkmen
milksop1542833milksop
million91813143million
millrun944183millrun
milo65536103mi_lo_
milord999573milord
milos75428013mi_los
mimeo96018683mimeo_
mimeos104511543mimeos
minions93314623minions
minnow1135583minnow
minor74920063mi_nor
minors85117103minors
minyan1138173minyan
mir57046773mi_r__
mire66748233mi_r_e
mired85729223mi_red
mires75640883mi_res
mirex146816623mi_rex
miri66730373mi_r_i
miring93723803mi_ring
mirins83918903mi_rins
mirk106729503mi_r_k
mirker123712693mirker
mirks115122143mi_rks
mirky146315523mi_rky
mirrors938623mirrors
mirs66940573mi_r_s
mirth106418893mi_rth
miry96326753mi_r_y
mirza16410443mi_rza
miscoin11311433miscoin
misdo85413183misdo_
misdone10310863misdone
misgrow1344433misgrow
misgrown1443983misgrown
misjoin1637693misjoin
misknow1643213misknow
misknown1742533misknown
miso67229903mi_so_
misos76523293mi_sos
mispen10312173mispen
mission9312743mission
mitral81314323mitral
mitre75522423mitr_e
mitred94414343mitred
mitres83922073mitres
mitring103514143mitring
mitten83914093mitten
mizen164815273mi_zen
mizzen16447953mizzen
mon57561583m___on
monuron937463monuron
moon67140813m__oon
morion86217733morion
morn66237563m_or_n
morons84919543m_orons
morrion959003morrion
morro73216953morro_
morros83714673morros
morrow113510093morrow
motion85217553motion
mourn77215013mour_n
mouton8410853mouton
mucro94513723mucro_
muon65722733m__uon
muton73817003m_uton
mutton8510453mutton
natron64116023natron
nekton1036583nekton
neuron6310373neuron
nimrod934873nimrod
ninon55517383ni_non
niton55418283ni_ton
nitro54914353nitro_
nitros64214123nitros
omicrons1275193omicrons
operon8811773operon
patron84018043patron
perron83216623perron
pigeon949413pigeon
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235293pi__on
pirn67128373pi_r_n
pirog83913673pi_rog
piston83515923piston
piton76121583pi_ton
ribbon1036533ribbon
simoon858063simoon
siphon1138463siphon
siren54525823si_ren
thoron94713903thoron
tiglon737923tiglon
tigon63914443ti_gon
tiro46832363ti_ro_
tiros54524893ti_ros
vibrion1245253vibrion
virion9310683virion
vision9311313vision
waitron1036333waitron
wigeon1037223wigeon
zircon1754953zircon

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162405.09322131.6
3Display Results2402400.0803000.0
 (SQL Overall)1786912405.56332121.3
 
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.