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

348 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
mellow11411222(None) 
bellow114213351bellow
fellow123712741fellow
mallow114014741mallow
mellows123812231mellows
yellow12429881yellow
allow85420662_allow
bellows124313302bellows
below104617192be_low
billow114111222billow
callow114714662callow
cello74919582cello_
cellos84517802cellos
elbow10117702_elbow
fallow124713852fallow
felloe93513922felloe
fellows134212432fellows
follow124010352follow
hallow124818322hallow
hello86522982hello_
hellos95321682hellos
hollow124212662hollow
jello126716272jello_
jellos134714282jellos
mallows123714322mallows
meadow1237402meadow
melilot9311082melilot
mell64935612mell__
melled95023022melled
mellowed14166922mellowed
mellower13167402mellower
mellowly16254002mellowly
mells75031332mell_s
melon73922082me_lon
melton8311552melton
meow95117882me__ow
merlon83012352merlon
merlot83217602merlot
pillow113110572pillow
reflow12379652reflow
reglow10339402reglow
replow114210342replow
sallow94315752sallow
tallow93714202tallow
unmellow1342242unmellow
wallow123913512wallow
willow12369692willow
yellows13329602yellows
yellowy16255692yellowy
aglow94711973_aglow
allod64418383_allod
allot54933873_allot
allows94517683_allows
alloy85519973_alloy
alow75328593__alow
ballon84117493ballon
ballot84624093ballot
barlow112911423barlow
beclog1136863beclog
beclown1435423beclown
bell66237183bell__
bellboy1445123bellboy
belle75827833bell_e
belled94626183belled
belles85325993belles
bellhop1445053bellhop
bellowed14158603bellowed
bellower13159063bellower
bells76432163bell_s
belly104625493bell_y
belon73924113be_lon
belows114614183be_lows
besnow1145713besnow
bestow1149463bestow
billon83713833billon
billows123611293billows
billowy15366903billowy
blow95827193__blow
bollox1548743bollox
cell65031723cell__
cella75420313cell_a
cellae84915933cellae
cellar84514983cellar
celled94420323celled
celli76717693cell_i
cells75428063cell_s
celom9515693ce_lom
collop107312313collop
declaw1266703declaw
dell56938203dell__
dells66630943dell_s
delly96023873dell_y
deploy1237583deploy
dollop9259363dollop
duello756783duello_
duellos845763duellos
elbows1196713_elbows
ell36735683_ell__
ells46431353_ell_s
embow1297563_embow
employ1346493employ
endow94510983_endow
enow77819873_e_now
fallows133713973fallows
fell76833073fell__
fella84918653fell_a
fellah124910773fellah
fellas95116963fellas
felled103720303felled
feller94419553feller
felloes104114383felloes
fellowed15136833fellowed
fellowly17264093fellowly
fells85327383fell_s
felly114922803fell_y
felon84619293fe_lon
fillo84319783fillo_
fillos94415083fillos
flow105924923__flow
follows13409923follows
gallon73715813gallon
gallop93311383gallop
gallows113513513gallows
gelled84718893gelled
glow85222523__glow
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallows134417393hallows
helio85321193helio_
helios94816633helios
hell75637893hell__
hellbox1944983hellbox
helled104024703helled
heller93322513heller
hellion10311133hellion
helloed113512423helloed
helloes103717463helloes
hells85032043hell_s
helo75332853he_lo_
helos84928063he_los
helot85332683he_lot
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollows134412333hollows
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
impellor1242743impellor
inflow1235293inflow
jell117125873jell__
jelled144916063jelled
jells125522163jell_s
jelly154218253jell_y
kelly124617023kell_y
kelson1038153kelson
lollop8238783lollop
low66051873___low
maillot9312173maillot
mall64639373mall__
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
malls76233433mall_s
maltol8310843maltol
marrow112812603marrow
meadows1337333meadows
meadowy1644043meadowy
meal65643173meal__
mealie82519813mealie
meals75933373meal_s
mealy104422183meal_y
medlar93010463medlar
medley1298343medley
mel56047483me_l__
meld75830473me_l_d
melded104714713melded
melder93915813melder
melds84822383me_lds
melee73729103me_lee
melees83618083melees
melena81110473melena
melic94722333me_lic
melilots1046553melilots
melling102822623melling
mellowest1445123mellowest
mellowing1545893mellowing
melody1237203melody
meloid9616003meloid
melons84117713melons
mels65941533me_l_s
melt65752893me_l_t
meltdown1442763meltdown
melted94219063melted
melter83520113melter
meltons9410923meltons
melts74930103me_lts
melty104918363me_lty
memo85924793me_mo_
memos95719113me_mos
meno66031363me_no_
mentor8414363mentor
meou65325863me__ou
meows104612683me__ows
merl65830973merl__
merle75824373merl_e
merles85322763merles
merlin83916683merlin
merlons93311273merlons
merlots92710123merlots
merls77423903merl_s
meson74118313me_son
meteor84910073meteor
method1239023method
metol75917813me_tol
metols84115773metols
metro74718803metro_
metros84217803metros
mew86137733me___w
mewl95618323mewl__
mewled123710053mewled
mewler113510233mewler
mewls105813233mewl_s
mezzo1537433mezzo_
mezzos1635053mezzos
miaow1058353m_iaow
mildew12319043mildew
mill66541483mill__
mille75029133mill_e
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
million91813143million
mills75435053mill_s
milo65536103m_ilo_
milos75428013m_ilos
minnow1135583minnow
moll66735703moll__
mollah11319453mollah
mollie83517103mollie
molls75129783moll_s
molly105222493moll_y
molto75619603molto_
morello9117793morello_
morellos10136953morellos
morrow113510093morrow
mow86650353m___ow
mudflow1642343mudflow
mull65128803mull__
mulla74317113mull_a
mullah113710733mullah
mullas84215933mullas
mulled94721553mulled
mullen83714763mullen
muller83820353muller
mullet84126823mullet
mulley114013453mulley
mullion91911173mullion
mullock1535713mullock
mulls75124153mull_s
nellie63614813nellie
nelly84618813nell_y
nelson638423nelson
niello636603niello_
niellos736143niellos
pallor8313673pallor
pellet83326553pellet
pelon74423213pe_lon
peplos101211543peplos
pillows122610123pillows
pillowy15316423pillowy
plow95923233__plow
reallot7312133reallot
reavow1235723reavow
reflew12389453reflew
reflown13316213reflown
reflows13258983reflows
reglows11288843reglows
regrow10309883regrow
relook104813743relook
replot83818593replot
replows12329703replows
reshow123111433reshow
resow88217243re_sow
sallows103915553sallows
sallowy13369343sallowy
seldom939413seldom
sell45840613sell__
selle54428313sell_e
seller63824593seller
selles64426983selles
selloff1345923selloff
sellout7313583sellout
sells55134433sell_s
serow86720443se_row
shallow13388873shallow
slow77729493__slow
smell74916233smell__
smelled103511853smelled
smeller94212783smeller
smells83914743smell_s
smelly114110363smell_y
swallow13355753swallow
tallol63612223tallol
tallows103313743tallows
tallowy13347633tallowy
teflon937453teflon
telco7511873telco_
telcos8710683telcos
tell44934703tell__
teller63519813teller
tells55828943tell_s
telly84920823tell_y
tellys9348843tellys
teloi54217383te_loi
telos55424523te_los
telson6310293telson
upflow1433523upflow
vellum1136773vellum
wallop113310293wallop
wallows133613533wallows
weblog1234223weblog
weldor10317653weldor
well75832043well__
welled103820213welled
wellie92814913wellie
wells85426193well_s
welly114620013well_y
willows13299753willows
willowy16276353willowy
yell76028323yell__
yelled104116253yelled
yeller94214513yeller
yellowed15185743yellowed
yellower14186213yellower
yellowly17283623yellowly
yells85821943yell_s
zealot15313473zealot

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127163484.86023192.6
3Display Results3483480.1103163.6
 (SQL Overall)1786913485.33033525.5
 
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.