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

383 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
mallows12371432(None) 
allows94517681_allows
fallows133713971fallows
gallows113513511gallows
hallows134417391hallows
mallow114014741mallow_
mellows123812231mellows
sallows103915551sallows
tallows103313741tallows
wallows133613531wallows
allods73615082_allods
allots64019172_allots
allow85420662_allow_
alloys94014562_alloys
ballons93916962ballons
ballots94116032ballots
barlows12259982barlows
bellows124313302bellows
billows123611292billows
callous93516602callous
callow114714662callow_
fallow124713852fallow_
fellows134212432fellows
follows13409922follows
gallons83015952gallons
gallops103211652gallops
gallous82813952gallous
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
hollows134412332hollows
maillots1037472maillots
mallees93315972mallees
mallets93318492mallets
malleus92911312malleus
malls76233432mall__s
maltols939402maltols
marrows122911832marrows
mellow114112222mellow_
pallors9314362pallors
pillows122610122pillows
sallow94315752sallow_
sallowy13369342sallowy
shallows14388862shallows
swallows14295892swallows
tallols73311362tallols
tallow93714202tallow_
tallowy13347632tallowy
wallops123410412wallops
wallow123913512wallow_
willows13299752willows
yellows13329602yellows
aglow94711973_aglow_
aldols7109713_aldols
algors7312553_algors
allays94313743_allays
allees64521483_allees
alleys95113303_alleys
allies63827673_allies
allod64418383_allo_d
allot54933873_allo_t
allowed111610083_allowed
alloy85519973_allo_y
alls46740923_all__s
allyls9437273_allyls
aloes54933673_a_loes
alow75328593_a_low_
altos55822953_alto_s
arrows92813493_arrows
avows114910983_a_vows
azlons154110423_azlons
bailors93212413bailors
balboas113710073balboas
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413ball__s
barlow112911433barlow_
barrows123411693barrows
bellow114213353bellow_
belows114614183_belows
billons93013363billons
billow114111223billow_
billowy15366903billowy
blows105423833__blows
bullous9311663bullous
cahows14399123ca_hows
callans94518473callans
callas84526753call_as
callboys1585183callboys
callees94117783callees
callers94221963callers
callets93821703callets
callose9313663callose
calloses10313393calloses
callower13159073callower
callowest1445823callowest
calls75634733call__s
callus85317073call_us
calos74431903ca_lo_s
cellos84517803cello_s
collops112611753collops
dalles74222063dall_es
dallies84023193dallies
daltons8310403daltons
dayglows1641953dayglows
disallows1343393disallows
dollops10287963dollops
elbows1196723_elbows
falcons1239123falcons
fallals103310193fallals
fallers103917993fallers
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallouts1137883fallouts
fallowed15127753fallowed
falls85727653fall__s
farrows13259793farrows
felloes104114383felloes
fellow123712743fellow_
fillos94415083fillo_s
flows115822363__flows
follow124010353follow_
galiots82311323galiots
galleons9258443galleons
gallets83517403gallets
galleys11369713galleys
gallies84122713gallies
galliots9228683galliots
gallon73715813gallo_n
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
galloots9268963galloots
gallop93311383gallo_p
gallowses1374953gallowses
galls64729323gall__s
gallus74313203gall_us
galoots82410793galoots
galops94712623ga_lops
glows95518033__glows
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallot95426783hallo_t
halloth134111253halloth
hallowed15179503hallowed
hallower14139823hallower
hallowers15137723hallowers
halls85633783hall__s
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harlots103413293harlots
harrows132611043harrows
haymows1883813haymows
helloes103717473helloes
hellos95321683hello_s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
inflows1335523inflows
jailors14328753jailors
jalops15329593ja_lops
jellos134714283jello_s
lallans74113543lallans
lalls55324133lall__s
lollops9227443lollops
lows75843013___lows
macaws1337023ma_caws
machos135217493macho_s
macles107023223macl_es
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
madtoms1236923madtoms
magalogs1245253magalogs
maggots1136563maggots
maglevs1334693maglevs
magots9312363ma_gots
mahoes11313103ma_hoes
mahzors2135123mahzors
mailers94420333mailers
mailes84329113mail_es
mailless10248583mailless
maillot9312173maillo_t
maills84215283mail_ls
mails76037783mail__s
majors154511093ma_jors
makos116518363ma_ko_s
malars85020683ma_lars
malates93522613malates
males75049793ma_l_es
malices114316623malices
maligns1038133maligns
malines93625613malines
malisons1048783malisons
malkins133311803malkins
mall64639373mall___
mallard10310273mallard
mallards1138323mallards
malled94626113mall_ed
mallee84525593mall_ee
mallei84414633mall_ei
malleoli1054053malleoli
malleolus1143513malleolus
mallet84433053mall_et
malling103623663malling
mallings113413093mallings
malms95021553ma_l_ms
malodors1144973malodors
maloti8313213ma_loti
malteds10377603malteds
malthas1237913malthas
maltol8310843malto_l
maltose939793maltose
maltoses1039863maltoses
malts76331753ma_l_ts
mamboes135011823mamboes
mambos125414493mambo_s
mamluks1543313mamluks
mammons1048513mammons
mangoes104316133mangoes
mangos94319343mango_s
maniocs113611443maniocs
manless93012933manless
manors84420883ma_nors
manos74933623ma_no_s
maples104819423mapl_es
marlins93420483marlins
marls75535163marl__s
marmots11311513marmots
maroons92615553maroons
marplots1245633marplots
marrons93216973marrons
marrow112812613marrow_
marrowy15236093marrowy
mascons113411583mascons
mascots113910343mascots
masons83916513ma_sons
matelots1047533matelots
matless93014043matless
matrons93517633matrons
matzohs2134373matzohs
matzos1749263matzo_s
maulers94213303maulers
mauls76524953maul__s
maws96437143ma___ws
mayors115714193ma_yors
mayos105521933ma_yo_s
maypops16104453maypops
meadows1337333meadows
mealless10288363mealless
melilots1046553melilots
mellowed14166933mellowed
mellower13167413mellower
mellowest1445123mellowest
mellowly16254003mellowly
mells75031333mell__s
melons84117713m_elons
meltons9410923meltons
meows104612683m__eows
merlons93311273merlons
merlots92710123merlots
miaows1145473m_iaows
mildews13365883mildews
millers93621343millers
milles84526563mill_es
millets94216843millets
millions101712433millions
mills75435053mill__s
milos75428013m_ilo_s
minnows1234913minnows
misallots1144533misallots
mollahs12328283mollahs
mollies93420233mollies
molls75129783moll__s
morrows12318723morrows
mows96340833m___ows
mudflows1742513mudflows
mullahs12388733mullahs
mullas84215933mull_as
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mullions101910353mullions
mullock1535713mullock
mullocks1645033mullocks
mulls75124153mull__s
narrows10258853narrows
pallets93919303pallets
pallor8313673pallo_r
palls74332563pall__s
parlors9312913parlors
parlous9414293parlous
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
rallies73823343rallies
rallyes10348553rallyes
reallots837993reallots
reflows13258983reflows
reglows11288843reglows
replows12329703replows
sailors73213723sailors
salchows1644203salchows
sallets73719653sallets
sallies73227813sallies
sallowed12149033sallowed
sallower11139503sallower
sallowest1246563sallowest
sallowish1544943sallowish
sallowly14344833sallowly
salmons93713263salmons
salols64017873sa_lols
salons63823693sa_lons
saloons74415323saloons
saloops93510133saloops
salvoes102811313salvoes
salvors103910913salvors
salvos94613383salvo_s
sawlogs1135393sawlogs
scallops12297393scallops
shallops13288323shallops
shallots11319503shallots
shallow13388873shallow_
slaloms9106543slaloms
slows85323463__slows
smalls84514123small__s
smaltos9408193smalto_s
swallow13355753swallow_
tailors73212393tailors
talcous939483talcous
talions7314113talions
tallboys1374623tallboys
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallo_l
tallowed12157713tallowed
talls55133433tall__s
talons64019443ta_lons
thallous1136523thallous
unhallows15122123unhallows
upflows1543513upflows
valleys13407483valleys
valors93413773va_lors
villous102810023villous
wallahs13409473wallahs
wallas95719393wall_as
wallets103914833wallets
wallies103320743wallies
wallop113310293wallo_p
wallowed15148173wallowed
wallower14158943wallower
wallowers15127653wallowers
walls85529383wall__s
willow12369693willow_
willowy16276353willowy
yarrows13277863yarrows
yellow12429883yellow_
yellowy16255693yellowy

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.393454684.5
2DLD Change Limit1340273837.14018771.3
3Display Results3833830.1402735.7
 (SQL Overall)1786913837.67323288.3
 
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.