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

164 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
morel7572909(None) 
model84521691model
mohel104914831mohel
moral75533431moral
more67154521more_
morels84820011morels
mores76249641mores
morsel85815891morsel
motel76623241motel
sorel56231441sorel
amoral8314622amoral
boral75831702boral
bordel94514572bordel
bore66051332bore_
boreal84817212boreal
bored85034302bored
borer75131272borer
bores76448252bores
botel75121862botel
bowel105621202bowel
coral76033452coral
corbel103715972corbel
core67263112core_
cored85044222cored
corer75538872corer
cores76361852cores
cormel103815602cormel
cornel84020052cornel
dore56353302dore_
dorsel75315502dorsel
dowel95618192dowel
fore78351472fore_
fores85847102fores
goral65125752goral
gore55744962gore_
gored75227082gored
gores65740372gores
horal86328672horal
hosel86024812hosel
hotel85520742hotel
hovel115017682hovel
jurel124516332jurel
koel84519942ko_el
kore85834162kore_
loral55927822loral
lore45850352lore_
loreal63814312loreal
lores55045402lores
losel54419422losel
marcel103714852marcel
mare64759322mare_
mares76457632mares
marl66341612mar_l
marvel113712002marvel
mel56047482m__el
mere67244442mere_
merely111312582merely
merer75126232merer
meres75143572meres
merl65830972mer_l
merle75824372merle
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
modal85919232modal
mode75840302mode_
models94216352models
modem103717142modem
modes85537412modes
mogul8310212mogul
mohels115011322mohels
moil65534092mo_il
moire71017322moire_
moires8915632moires
moke106234222moke_
mokes114631032mokes
mol56654592mo__l
molal75120342molal
mole66251832mole_
moles74747922moles
moll66735702mo_ll
mome85239352mome_
momes95134472momes
money104826842money
mongrel1036332mongrel
mooed85123982mooed
mool67533862mo_ol
moored93814172moored
mope86838042mope_
moped105424732moped
moper94925922moper
mopes95134982mopes
mopey124821822mopey
mor56855002mor__
mora66641272mor_a
morae75831192morae
morale85220552morale
morals85324632morals
moras76438762moras
moray105423792moray
moreen8313342moreen
morelle91210802morelle
morello9117792morello
morgen9312202morgen
morn66237562mor_n
morns75527442morns
moron76925422moron
morph121712512morph
morro73216952morro
mors65950062mor_s
morse76032702morse
morsels94112652morsels
mort66758832mor_t
mortal84616852mortal
morts75533562morts
morula8710472morula
mosey105922872mosey
mote67048082mote_
motels83616892motels
motes75944002motes
motet75641192motet
motey105922952motey
moue65835572moue_
moues75732842moues
move96630722move_
moved114218152moved
mover104220862mover
moves106128422moves
mowed113629012mowed
mower104523452mower
mural75225102mural
mure65941332mure_
mured85726702mured
mures75937212mures
murex145517172murex
noel45226552no_el
novel85615992novel
oral47638122_oral
ore36661832_ore_
ores46056682_ores
oriel54920422_oriel
orle45630462_orle
pore66451262pore_
pored85234512pored
pores75849032pores
rowel84721412rowel
sore47059532sore_
sored66141782sored
sorels63921162sorels
sorely94618002sorely
sorer56236572sorer
sores55454282sores
sorrel6413542sorrel
tore47359322tore_
tores55352672tores
towel84920522towel
vowel115515012vowel
wore77144672wore_
yodel94714082yodel
yokel124812612yokel
yore76335942yore_
yores85031322yores
zoril143916692zoril

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.0931921408.6
2DLD Change Limit538001641.64032804.9
3Display Results1641640.0463565.2
 (SQL Overall)1786911641.779100444.6
 
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.