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

123 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
monuron93746(None) 
monurons1037091monurons
fenuron1075152fenuron
linuron746512linuron
monaxon1644912monaxon
moneran9311112moneran
monsoon938492monsoon
moron76925422mo__ron
mourn77215012mo_ur_n
mouton8410852mo_uton
noniron738372noniron
aleuron757383aleuron
anuran64313243_anuran
bonbon10310073bon_bon
boron76727143bo__ron
bourbon1135813bo_urbon
bourdon1036423bo_urdon
bourn75518483bo_ur_n
bouton8311533bo_uton
confront13411603confront
conjuror17144633conjuror
control9310693control
coupon102810993co_upon
dendron947653dendron
diuron738573_diuron
donjon1436463don_jon
fenurons1174963fenurons
fleuron1055573fleuron
fourgon1134863fo_urgon
gonion73612833gon_ion
intron64215023_intron
inurn53712863_inur_n
journo13135293jo_urno
kouroi1036513ko_uroi
kouros1039183ko_uros
linurons846333linurons
longeron945763longeron
macron103615673m_acron
maduro936983maduro_
maduros1036303maduros
mansion9611543mansion
manure8313653manur_e
manured1039473manured
manurer938583manurer
manures9313353manures
manuring1139223manuring
marron83717543m_arron
matron83918313m_atron
megaron10248303megaron
menazon1846053menazon
mention9314373mention
menudo945793menudo_
menudos1034643menudos
micron103714283m_icron
midiron1046003midiron
mikron12318503m_ikron
minion83416243min_ion
modern939523moder_n
modulo9256983modulo_
mohur1036513mohur__
mohurs1135933mohur_s
monarch1445953monarch
monarda1046613monarda
monaural1046213monaural
monaxons1744813monaxons
mondo85721233mon_do_
mondos95217333mon_dos
monerans10310343monerans
mongo810122413mon_go_
mongoe94214983mon_goe
mongol94912533mon_gol
mongos94318623mon_gos
mongrel1036333mongrel
monition10311723monition
monitor9310723monitor
mono66036723mon__o_
monocot11412013monocot
monolog10259353monolog
monopod1247493monopod
monos75930863mon__os
monotone10310153monotone
monotony1347073monotony
monsoons1047343monsoons
montero9310133montero_
monteros1039453monteros
monument1289903monument
moon67140813mo___on
morion86217733mo_rion
morn66237563mo__r_n
morons84919543mo__rons
morrion959003morrion
morro73216953mo_rro_
morros83714673mo_rros
morrow113510093mo_rrow
motion85217553mo_tion
motoneuron1251723motoneuron
mouflon12104083mouflon
moulin8313283mo_ulin
mourns84111013mo_urns
moutons9410313mo_utons
munnion935863munnion
muon65722733m__u_on
muton73817003m__uton
neuron6310373_neuron
nonagon847313nonagon
nonjuror15113803nonjuror
nonpros937473nonpros
nonunion845583nonunion
nonurban1044853nonurban
omicron1165063omicron
omikron1353173omikron
onion54320973_on_ion
operon8811773_operon
pleuron976343pleuron
polaron939843polaron
ponton83217643pon_ton
pontoon93010703pontoon
ronion63315643ron_ion
ronyon9309133ron_yon
voudon1035873vo_udon
wonton93410963won_ton
youpon11366003yo_upon
yourn87512773yo_ur_n

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 Limit1340271237.15618729.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.60823487.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.