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

157 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
morelles1071049(None) 
morelle91210801morelle_
morellos10136951morellos
amarelles1145532amarelles
cordelles1248222cordelles
micelles1288832micelles
modelled1236422modelled
modeller1136612modeller
modellers1245392modellers
morales93619402mor_ales
morello9117792morell_o
morels84820012more_l_s
morselled1245952morselled
roselles8310712roselles
zorilles1736122zorilles
amarelle1045613amarelle_
areoles71016953_areoles
aureoles838283aureoles
belles85325993__belles
bordellos1243843bordellos
boreases10310253boreases
borecoles1345973borecoles
boreholes1447353boreholes
boulles93114123bo_ulles
bowelled1446173bowelled
bowelless1443833bowelless
cadelles1139953cadelles
coracles121811163coracles
corbeilles1443813corbeilles
corbelled1446613corbelled
cordelle1148433cordelle_
cordelled1346403cordelled
corelates11314853corelates
coreless103013833coreless
corollas1039203corollas
creoles9913323_creoles
dowelled1356343dowelled
duxelles1643963duxelles
echelles1346663echelles
folles93820473fo__lles
foredoes12310803foredoes
foregoes1239523foregoes
foreleg1137743fore_leg
forelegs1236613forelegs
foresees11311643foresees
foveoles1496643foveoles
gabelles11278933gabelles
gazelles18266563gazelles
girolles935523girolles
gorbellies1343683gorbellies
gorillas946373gorillas
grilles83715023_grilles
hovelled15146843hovelled
immortelles1551863immortelles
lovelies1139893lovelies
manilles102312593manilles
marbles114516653mar_bles
marcelled1445203marcelled
marceller1345153marceller
marcellers1443833marcellers
marseilles1253533marseilles
martellos1144393martellos
marvelled1544963marvelled
melees83618083m__elees
melled95023023m__elled
mells75031333m__ell_s
merles85322763m__erles
micelle1178343micelle_
micells11107683micell_s
milles84526563m__illes
mirabelles1443423mirabelles
miracles1238333miracles
mirexes1636993mire_xes
misrelies1149723misrelies
mobiles112813123mo_biles
modeled1139453mode_led
modeler1039293mode_ler
modelers1138463modelers
models94216353mode_l_s
modernes1138423modernes
modules102511003mo_dules
mofettes1386083mofettes
mohels115011323mohe_l_s
moieties10311263moieties
molecules1364613molecules
moles74747923mo___les
molies84429513mo__lies
mollies93420233mo_llies
molls75129783mo__ll_s
monellin1047373monellin
monellins1147413monellins
moneyless1444653moneyless
monocles12310673monocles
moperies12313873moperies
moraines10314343moraines
morale85220553mor_ale_
moralise10314913moralise
moralises11314003moralises
moralizes20312853moralizes
morally12411493morall_y
morals85324633mor_al_s
morasses1038903morasses
moreen8313343more__en
moreens939963more_ens
morel75729093more_l__
moreness10911573moreness
moreover1344863moreover
mores76249643mor___es
moresques2042873moresques
morgues1038273mor_gues
morrises10711063morrises
morseled1147193morseled
morsels94112653morsel_s
mortals93914003mortal_s
mortices12711553mortices
mortises10713603mortises
morulae958963morulae_
morulas959703mor_ulas
motels83616893mote_l_s
motiles93317433mo_tiles
mottles93415803mo_ttles
mouille937843mouille_
movables15175573movables
moveables16163963moveables
moveless1367753moveless
muralled1136413muralled
murexes1636973mure_xes
myceles1435213myce_les
myrtles1235733myr_tles
nacelles1048393nacelles
nouvelles1244453nouvelles
novellas1176343novellas
novelle1058233novelle_
ocellus935983_ocellus
oracles93212423_oracles
oreides8312023_oreides
orioles7412993_orioles
orles55326213_or__les
reales64934123__reales
relies65036423__relies
rilles64725503__rilles
rondelles1046623rondelles
roselle7310243roselle_
rouilles837183rouilles
rowelled1236633rowelled
selles64426983__selles
sorels63921163sore_l_s
towelled1236353towelled
trebles9311443_trebles
trellis739873_trellis
umbrellas1343093umbrellas
yodelled1334593yodelled
yodeller1244853yodeller
yodellers1343973yodellers
zorillas1745483zorillas
zorille1636673zorille_
zorillos1743733zorillos

Search took 9 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 Filter1786911461620.1601116818.8
2DLD Change Limit1461621578.31017588.7
3Display Results1571570.0632492.1
 (SQL Overall)1786911578.53320941.2
 
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.