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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
moron7692542(None) 
boron76727141boron
moon67140811mo_on
morion86217731morion
morn66237561mor_n
morons84919541morons
apron7318832apron
baron78131242baron
boon67142172bo_on
born67338412bor_n
borons85520542borons
boson76019732boson
codon86522852codon
cogon89120902cogon
colon78630192colon
coon67248942co_on
cordon95017292cordon
corn69945812cor_n
corona83817402corona
croon75522782croon
giron66118992giron
goon57236172go_on
gorgon8310242gorgon
gyron95314622gyron
heron85025502heron
horn76735612hor_n
iron46728462_iron
jomon14610082jomon
korun9411922korun
kroon94514482kroon
logon615922312logon
loon47344792lo_on
loran55925092loran
lorn46435252lor_n
macon94519952macon
macron103615672macron
maroon83118202maroon
marron83717542marron
mason74820182mason
matron83918312matron
melon73922082melon
merlon83012352merlon
meson74118312meson
micron103714282micron
mikron12318502mikron
mirin75023152mirin
moan65832022mo_an
mojo136917222mojo_
mojos145314462mojos
mon57561582m__on
mono66036722mono_
monos75930862monos
monuron937462monuron
moo58460512mo_o_
mood76332062mo_od
mool67533862mo_ol
moons75331002mo_ons
moony104818272mo_ony
moor66628552mo_or
moors74923142moors
moory105115792moory
moos66051302mo_os
moot67653622mo_ot
mor56855002mor__
mora66641272mor_a
morae75831192morae
moral75533432moral
moras76438782moras
moray105423792moray
more67154522mor_e
moreen8313342moreen
morel75729092morel
mores76249642mores
morgan9311372morgan
morgen9312202morgen
morions94014642morions
morns75527442morns
moronic11311862moronic
morose85116242morose
morph121712512morph
morrion959002morrion
morro73216952morro
morros83714672morros
morrow113510092morrow
mors65950062mor_s
morse76032702morse
mort66758832mor_t
morts75533562morts
motion85217552motion
motor75317292motor
mourn77215012mourn
mouton8410852mouton
mown95424442mo_wn
mozo157719742mozo_
mozos165516332mozos
muon65722732m_uon
muton73817002muton
noon47134622no_on
orlon5415002_orlon
poon67341262po_on
porn65636022por_n
porno75120652porno
solon55026132solon
soon46240502so_on
sorn46641062sor_n
thoron94713902thoron
toon47740632to_on
torn46044252tor_n
toro48045682toro_
toros54336192toros
torot56139942torot
toyon86715672toyon
worn75631752wor_n
zoon137326982zo_on

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001141.57634137.1
3Display Results1141140.0303800.0
 (SQL Overall)1786911141.91993116.7
 
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.