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

444 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
mallow11401474(None) 
allow85420661_allow
callow114714661callow
fallow124713851fallow
hallow124818321hallow
mallows123714321mallows
mellow114112221mellow
sallow94315751sallow
tallow93714201tallow
wallow123913511wallow
aglow94711972_aglow
allod64418382_allod
allot54933872_allot
allows94517682_allows
alloy85519972_alloy
alow75328592_a_low
ballon84117492ballon
ballot84624092ballot
barlow112911422barlow
bellow114213352bellow
billow114111222billow
fallows133713972fallows
fellow123712742fellow
follow124010352follow
gallon73715812gallon
gallop93311382gallop
gallows113513512gallows
hallo85127552hallo_
halloa94918122halloa
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallows134417392hallows
hollow124212662hollow
maillot9312172maillot
mall64639372mall__
malled94626112malled
mallee84525592mallee
mallei84414632mallei
mallet84433052mallet
malls76233432mall_s
maltol8310842maltol
marrow112812602marrow
mellows123812232mellows
pallor8313672pallor
pillow113110572pillow
sallows103915552sallows
sallowy13369342sallowy
shallow13388872shallow
swallow13355752swallow
tallol63612222tallol
tallows103313742tallows
tallowy13347632tallowy
wallop113310292wallop
wallows133613532wallows
willow12369692willow
yellow12429882yellow
aldol61212333_aldol
algor6513053_algor
all36148233_all__
allay85620393_allay
allee54932123_allee
alley85721673_alley
allods73615083_allods
allots64019173_allots
allowed111610073_allowed
alloys94014563_alloys
alls46740923_all_s
ally76935643_all_y
allyl85310543_allyl
aloe45540193_a_loe
aloof83521573_aloof
also46423443_also_
alto47831263_alto_
altos55822953_altos
arrow83414883_arrow
avow107816463_a_vow
azlon144312873_azlon
bailor83412603bailor
balboa10389963balboa
ball66043323ball__
ballad94315323ballad
balled94926893balled
baller83825203baller
ballet84733973ballet
ballons93916963ballons
balloon93711433balloon
ballots94116033ballots
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
barlows12259973barlows
barrow114512763barrow
bellows124313303bellows
below104617193_below
billon83713833billon
billows123611293billows
billowy15366903billowy
blow95827193__blow
bollox1548743bollox
cahow135110943ca_how
call66838673call__
calla74827073call_a
callan83619603callan
callas84526753callas
callboy1465833callboy
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
callose9313663callose
callous93516603callous
callower13159073callower
calls75634733call_s
callus85317073callus
calo64936443ca_lo_
calos74431903ca_los
cello74919583cello_
cellos84517803cellos
challot123613263challot
collop107312313collop
dalles74222063dalles
dally95324743dall_y
dalton7311273dalton
dayglow1541843dayglow
disallow1243513disallow
dollop9259363dollop
elbow10117703_elbow
falcon11310293falcon
fall75535313fall__
fallal93612693fallal
fallen93813373fallen
faller94621233faller
falloff1245953falloff
fallout10313503fallout
fallowed15127753fallowed
falls85727653fall_s
farrow12309973farrow
felloe93513923felloe
fellows134212433fellows
fillo84319783fillo_
fillos94415083fillos
flow105924923__flow
follows13409923follows
galiot72322593galiot
gall56335993gall__
galled84622863galled
galleon8278713galleon
gallet73630853gallet
galley104215453galley
gallic9411643gallic
galliot82214133galliot
gallons83015953gallons
galloon82910643galloon
galloot82814223galloot
gallops103211653gallops
gallous82813953gallous
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galoot72719163galoot
galop84716223ga_lop
glow85222523__glow
hall75741163hall__
hallah124115403hallah
hallal94415563hallal
hallel93514093hallel
halloas104318463halloas
halloed113314913halloed
halloes104021523halloes
halloos103716743halloos
halloth134111253halloth
hallowed15179493hallowed
hallower14139813hallower
halls85633783hall_s
hallux1637363hallux
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
harlot94422803harlot
harrow122610773harrow
haymow1773683haymow
hello86522983hello_
hellos95321683hellos
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollows134412333hollows
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
inflow1235293inflow
jailor13418573jailor
jalop144212603ja_lop
jello126716273jello_
jellos134714283jellos
lall45531313lall__
lallan63414173lallan
lalled74218753lalled
lalls55324133lall_s
lollop8238783lollop
low66051873___low
macaw12311763ma_caw
macho126120153macho_
machos135217493machos
macle96127003macl_e
macled116718113macled
macles107023223macles
macon94519953ma_con
macro94718173macro_
macron103615673macron
macros104017013macros
madly115218133madl_y
madtom1138023madtom
magalog1144913magalog
maggot10311713maggot
maglev1237023maglev
magot8326393ma_got
mahoe10315573ma_hoe
mahzor2035113mahzor
mail65543453mail__
mailbox1853563mailbox
maile75232223mail_e
mailed95326753mailed
mailer84724183mailer
mailes84329113mailes
maill74420793mail_l
maillots1037473maillots
maills84215283maills
mails76037783mail_s
major145212923ma_jor
mako105622363ma_ko_
makos116518363ma_kos
malady1237863malady
malar76424443ma_lar
malars85020683malars
malate84624553malate
male66052303ma_l_e
males75049793ma_les
malfed12369763malfed
malgre9299303malgre
malic94525663ma_lic
malice104818483malice
malign939853malign
maline84529083maline
malison939693malison
malkin122913153malkin
mallard10310273mallard
mallees93315973mallees
malleoli1054053malleoli
mallets93318493mallets
malleus92911313malleus
malling103623663malling
malm85129983ma_l_m
malms95021553ma_lms
malmy124816343ma_lmy
malodor1044563malodor
maloti8313213maloti
malt66254813ma_l_t
malted94819863malted
maltha1137503maltha
maltols939403maltols
maltose939783maltose
malts76331753ma_lts
malty106721703ma_lty
mambo115215743mambo_
mambos125414493mambos
mamluk1434743mamluk
mammon939643mammon
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
manly105022953manl_y
mano66536813ma_no_
manor78023933ma_nor
manos74933623ma_nos
maple95521143mapl_e
maples104819423maples
marl66341623marl__
marled95523163marled
marlin84220903marlin
marls75535163marl_s
marly106925613marl_y
marmot10318743marmot
maroon83118203maroon
marplot1149673marplot
marron83717543marron
marrows122911823marrows
marrowy15236083marrowy
mascon103612743mascon
mascot104016073mascot
mason74820183ma_son
matelot9411573matelot
matron83918313matron
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
maul64830723maul__
mauled94817823mauled
mauler84416713mauler
mauls76524953maul_s
maw87050103ma___w
mayo96524303ma_yo_
mayor106616623ma_yor
mayos105521933ma_yos
maypop1565143maypop
meadow1237403meadow
melilot9311083melilot
mell64935613mell__
melled95023023melled
mellowed14166923mellowed
mellower13167403mellower
mellowly16254003mellowly
mells75031333mell_s
melon73922083m_elon
melton8311553melton
meow95117883m__eow
merlon83012353merlon
merlot83217603merlot
miaow1058353m_iaow
mildew12319043mildew
mill66541483mill__
mille75029133mill_e
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
million91813143million
mills75435053mill_s
milo65536103m_ilo_
milos75428013m_ilos
minnow1135583minnow
misallot1047003misallot
moll66735703moll__
mollah11319453mollah
mollie83517103mollie
molls75129783moll_s
molly105222493moll_y
molto75619603molto_
morrow113510093morrow
mow86650353m___ow
mudflow1642343mudflow
mull65128803mull__
mulla74317113mull_a
mullah113710733mullah
mullas84215933mullas
mulled94721553mulled
mullen83714763mullen
muller83820353muller
mullet84126823mullet
mulley114013453mulley
mullion91911173mullion
mullock1535713mullock
mulls75124153mull_s
narrow9269143narrow
pall65039343pall__
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallid93915283pallid
pallors9314363pallors
palls74332563pall_s
pally105727123pall_y
parlor8312673parlor
pillows122610123pillows
pillowy15316423pillowy
plow95923233__plow
rally84725903rall_y
rallye95110163rallye
reallot7312133reallot
reflow12379653reflow
reglow10339403reglow
replow114210343replow
sailor63113753sailor
salchow1544323salchow
sall44544683sall__
sallet63734543sallet
sallowed12149033sallowed
sallower11139503sallower
sallowly14344833sallowly
sally85129713sall_y
salmon84614183salmon
salol55222143sa_lol
salols64017873salols
salon55228553sa_lon
saloon64418023saloon
saloop84212583saloop
salvo84415643salvo_
salvor94711093salvor
salvos94613383salvos
sawlog1035793sawlog
scallop11237643scallop
shallop12348453shallop
shallot103614133shallot
shallows14388863shallows
slalom888173slalom
slow77729493__slow
small74016263small__
smaller93410333smaller
smallpox1941843smallpox
smalls84514123small_s
smalto84410283smalto_
smaltos9408193smaltos
swallows14295893swallows
tailor63412503tailor
talion6317713talion
tall47240213tall__
tallboy1265143tallboy
taller63721963taller
tallis63319963tallis
tallit63422733tallit
tallols73311363tallols
tallowed12157713tallowed
talls55133433tall_s
tally84526863tall_y
talon55824113ta_lon
unhallow14112343unhallow
unmellow1342243unmellow
upflow1433523upflow
valley124311603valley
valor83614893va_lor
wall76236103wall__
walla85321033wall_a
wallah124011993wallah
wallas95719393wallas
walled104021293walled
wallet93327093wallet
wallie93216803wallie
wallops123410413wallops
wallowed15148163wallowed
wallower14158933wallower
walls85529383wall_s
wally114625093wall_y
willows13299753willows
willowy16276353willowy
yarrow12287933yarrow
yellows13329603yellows
yellowy16255693yellowy

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164447.95314172.8
3Display Results4444440.1403171.4
 (SQL Overall)1786914448.23321704.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.