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

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

100 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
morons8491954(None) 
borons85520541borons
moons75331001mo_ons
morions94014631morions
morns75527441mor_ns
moron76925421moron_
amorous9311132amorous
aprons8316992aprons
barons85025382barons
boons75031912bo_ons
boron76727142boron_
bosons85016652bosons
codons96119462codons
cogons96818112cogons
colons86028682colons
coons76737282co_ons
cordons104415762cordons
corns76034762cor_ns
corona83817402corona
coronas93916902coronas
croons85418422croons
frons86124042_frons
girons75014372girons
goons65326772go_ons
gorgons938852gorgons
gyrons105511222gyrons
herons94820542herons
horns86125332hor_ns
irons55324132_irons
kroons103711242kroons
logons79818172logons
loons55731722lo_ons
lorans65117602lorans
macons104017242macons
macrons113514892macrons
maroons92615552maroons
marrons93216972marrons
masons83916512masons
matrons93517632matrons
melons84117712melons
merlons93311272merlons
mesons83215842mesons
microns113814782microns
mikrons13428412mikrons
mirins83918892mirins
moans74624362mo_ans
mojoes15399522mojoes
mojos145314462mojo_s
monos75930862mono_s
mons68152252m__ons
monurons1037092monurons
moods85224622mo_ods
mools76027172mo_ols
moon67140812mo_on_
moony104818272mo_ony
moors74923142mo_ors
moos66051302mo_o_s
moots75831662mo_ots
morals85324632morals
moras76438762mor_as
morass84614492morass
morays114613882morays
moreens939962moreens
morels84820012morels
mores76249642mor_es
morgans10310122morgans
morgens10310462morgens
morion86217732morion_
morn66237562mor_n_
moronic11311862moronic
moronism1249322moronism
morose85116242morose
morphs13149432morphs
morrions1077652morrions
morris83814722morris
morros83714672morros
morrows12318722morrows
mors65950062mor__s
morts75533562mor_ts
motions94215002motions
motors84616592motors
mourns84111012mourns
moutons9410312moutons
mozos165516332mozo_s
muons75816172m_uons
mutons84314362mutons
noons54125282no_ons
orlons6411012_orlons
poons75430972po_ons
pornos85015252pornos
porns75527342por_ns
porous84419482porous
solons65120012solons
sorns55028412sor_ns
thorons104511912thorons
toons55027532to_ons
toros54336192toro_s
torous64319022torous
toyons95512132toyons
zoons144919692zo_ons

Search took 4 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 Filter178691825510.1261418182.5
2DLD Change Limit825511002.90328436.4
3Display Results1001000.0462173.9
 (SQL Overall)1786911003.07558110.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.