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

168 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
morrion95900(None) 
morion86217731mo_rion
morrions1077671morrions
carrion9312672carrion
marron83717542marr_on
morions94014642mo_rions
moron76925422mo_r_on
morris83814732morri_s
morro73216952morr_o_
morros83714672morr_os
morrow113510092morr_ow
motion85217552mo_tion
portion9615492portion
torsion7310802torsion
abortion1048103abortion
amorino9310253amo_rino
amotion9710473amo_tion
barrio8312573barrio_
barrios9310773barrios
boron76727143bo_r_on
borrow114310723borr_ow
bourbon1135813bourbon
bourdon1036423bourdon
carrions10312453carrions
carryon1237033carryon
chorion12311773chorion
clarion9311663clarion
coercion1246573coercion
coition9314313coition
cordon95017293co_rdon
coreign1037343coreign
corrasion1146483corrasion
corrida1078513corrida
corridor1145033corridor
corrie83621233corri_e
corries94026803corries
corrosion1146053corrosion
cortin82423153corti_n
dormin9312313dormi_n
durion7510963_durion
emersion1047733emersion
emotion9711303emo_tion
erosion7311113erosion
fermion1236763fermion
foreign1136833foreign
forrit91916623forri_t
fourgon1134863fourgon
garrison943983garrison
garron73113493garr_on
godroon946043godroon
gonion73612833go_nion
gorgon8310243go_rgon
horizon1955763horizon
horrid10311563horri_d
horrify1635023horrify
horror988723horr_or
logion76013723lo_gion
lorgnon844423lorgnon
lorries74518353lorries
lotion65716523lo_tion
macron103615673macr_on
mansion9611543mansion
margin94016853margi_n
marlin84220903marli_n
maroon83118203m_aroon
marrano939423marrano
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
marrons93216973marr_ons
marrow112812603marr_ow
martian93514683martian
martin84122523marti_n
matron83918313matr_on
mention9314373mention
merino8315093m_erino
merlin83916683merli_n
merlon83012353m_erlon
merrier92612303merrier
merrily1238633merrily
micron103714283micr_on
midiron1046003midiron
mikron12318503mikr_on
million91813143million
minion83416243m_inion
mirin75023153m_iri_n
mirliton1044183mirliton
mirror848003mirr_or
mission9312743mission
monaxon1644913monaxon
monition10311723monition
monsoon938493monsoon
monuron937463monuron
moon67140813mo___on
moorhen1236023moorhen
moorier93113073moorier
mooring102514443mooring
moorish123311783moorish
moraine9314573moraine
morbid112511463morbi_d
moreen8313343mo_reen
morgan9311373mo_rgan
morgen9312203mo_rgen
morn66237563mo_r__n
morning103215043morning
morons84919543mo_r_ons
morphin1439003morphin
morpho13158443morpho_
morphos14159083morphos
morrises10711073morrises
morrows12318723morrows
mortice11711493mortice
mortify1536223mortify
mortise9713533mortise
motions94215003mo_tions
mouflon12104083mouflon
moulin8313283mouli_n
mourn77215013mour__n
mouton8410853mo_uton
mullion91911173mullion
munnion935863munnion
murein8311763murei_n
murrain937763murrain
murries94118673murries
murrine9411483murrine
myrmidon1641763myrmidon
noniron738373noniron
notion64516583no_tion
onion54320973_o_nion
option83612713_option
oration71617713_oration
orcin72716573_orci_n
orison6411663_orison
orlon5415003_o_rlon
orpin73415533_orpi_n
orrice81410163_orrice
orris54516553_orri_s
pereion9312053pereion
perron83216623perr_on
porcino1138113porcino
portions10514413portions
potion84519573po_tion
prion75119993__prion
ronion63315643ro_nion
scorpion1244803scorpion
solion6616383so_lion
sordino8219443sordino
sorption1037513sorption
sorrier72313733sorrier
sorrily1039833sorrily
sorrow9339443sorr_ow
ternion739493ternion
tompion11247103tompion
torchon1237363torchon
torrid7311853torri_d
torrify1335013torrify
torsions839183torsions
turion6313163_turion
version10310923version
vibrion1245253vibrion
virion9310683_virion
warrior1045363warrior
worried11308693worried
worrier102311683worrier
worries104117133worries
worrit92313313worri_t
worrits10258683worrits

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 Limit1340271687.01619103.1
3Display Results1681680.0632666.7
 (SQL Overall)1786911687.48523873.2
 
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.