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
sallows103915541sallows
tallows103313731tallows
wallows133613531wallows
allods73615082_allods
allots64019172_allots
allow85420662_allow_
alloys94014562_alloys
ballons93916952ballons
ballots94116032ballots
barlows12259972barlows
bellows124313302bellows
billows123611282billows
callous93516592callous
callow114714662callow_
fallow124713852fallow_
fellows134212432fellows
follows13409922follows
gallons83015942gallons
gallops103211652gallops
gallous82813952gallous
halloas104318462halloas
halloes104021512halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
hollows134412332hollows
maillots1037452maillots
mallees93315972mallees
mallets93318492mallets
malleus92911312malleus
malls76233432mall__s
maltols939402maltols
marrows122911812marrows
mellow114112222mellow_
pallors9314342pallors
pillows122610102pillows
sallow94315752sallow_
sallowy13369342sallowy
shallows14388852shallows
swallows14295882swallows
tallols73311352tallols
tallow93714202tallow_
tallowy13347632tallowy
wallops123410412wallops
wallow123913512wallow_
willows13299742willows
yellows13329602yellows
aglow94711963_aglow_
aldols7109713_aldols
algors7312553_algors
allays94313743_allays
allees64521483_allees
alleys95113303_alleys
allies63827673_allies
allod64418373_allo_d
allot54933873_allo_t
allowed111610073_allowed
alloy85519973_allo_y
alls46740923_all__s
allyls9437273_allyls
aloes54933673_a_loes
alow75328593_a_low_
altos55822953_alto_s
arrows92813483_arrows
avows114910983_a_vows
azlons154110423_azlons
bailors93212403bailors
balboas113710073balboas
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110503balloons
ballot84624093ballo_t
balls76236413ball__s
barlow112911423barlow_
barrows123411683barrows
bellow114213353bellow_
belows114614183_belows
billons93013353billons
billow114111223billow_
billowy15366903billowy
blows105423833__blows
bullous9311663bullous
cahows14399123ca_hows
callans94518473callans
callas84526753call_as
callboys1585173callboys
callees94117773callees
callers94221963callers
callets93821703callets
callose9313653callose
calloses10313383calloses
callower13159073callower
callowest1445823callowest
calls75634733call__s
callus85317073call_us
calos74431903ca_lo_s
cellos84517803cello_s
collops112611753collops
dalles74222063dall_es
dallies84023193dallies
daltons8310403daltons
dayglows1641943dayglows
disallows1343393disallows
dollops10287963dollops
elbows1196713_elbows
falcons1239123falcons
fallals103310193fallals
fallers103917993fallers
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallouts1137883fallouts
fallowed15127753fallowed
falls85727653fall__s
farrows13259783farrows
felloes104114373felloes
fellow123712743fellow_
fillos94415073fillo_s
flows115822363__flows
follow124010353follow_
galiots82311323galiots
galleons9258423galleons
gallets83517403gallets
galleys11369713galleys
gallies84122713gallies
galliots9228683galliots
gallon73715813gallo_n
galloon82910643galloon
galloons9289683galloons
galloot82814223galloot
galloots9268963galloots
gallop93311383gallo_p
gallowses1374943gallowses
galls64729323gall__s
gallus74313203gall_us
galoots82410793galoots
galops94712613ga_lops
glows95518033__glows
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallot95426783hallo_t
halloth134111253halloth
hallowed15179493hallowed
hallower14139813hallower
hallowers15137723hallowers
halls85633783hall__s
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harlots103413293harlots
harrows132611033harrows
haymows1883813haymows
helloes103717453helloes
hellos95321683hello_s
hilloas104413543hilloas
hilloes103815943hilloes
hillos94618883hillo_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
inflows1335523inflows
jailors14328743jailors
jalops15329593ja_lops
jellos134714283jello_s
lallans74113533lallans
lalls55324133lall__s
lollops9227443lollops
lows75843013___lows
macaws1337023ma_caws
machos135217493macho_s
macles107023223macl_es
macons104017243ma_cons
macrons113514893macrons
macros104017013macro_s
madtoms1236923madtoms
magalogs1245243magalogs
maggots1136553maggots
maglevs1334693maglevs
magots9312363ma_gots
mahoes11313103ma_hoes
mahzors2135123mahzors
mailers94420333mailers
mailes84329113mail_es
mailless10248583mailless
maillot9312173maillo_t
maills84215283mail_ls
mails76037783mail__s
majors154511093ma_jors
makos116518363ma_ko_s
malars85020683ma_lars
malates93522603malates
males75049793ma_l_es
malices114316623malices
maligns1038133maligns
malines93625603malines
malisons1048773malisons
malkins133311803malkins
mall64639363mall___
mallard10310273mallard
mallards1138323mallards
malled94626103mall_ed
mallee84525593mall_ee
mallei84414633mall_ei
malleoli1054053malleoli
malleolus1143513malleolus
mallet84433053mall_et
malling103623663malling
mallings113413093mallings
malms95021553ma_l_ms
malodors1144973malodors
maloti8313193ma_loti
malteds10377603malteds
malthas1237913malthas
maltol8310843malto_l
maltose939783maltose
maltoses1039853maltoses
malts76331753ma_l_ts
mamboes135011823mamboes
mambos125414493mambo_s
mamluks1543313mamluks
mammons1048513mammons
mangoes104316133mangoes
mangos94319333mango_s
maniocs113611443maniocs
manless93012933manless
manors84420883ma_nors
manos74933613ma_no_s
maples104819423mapl_es
marlins93420473marlins
marls75535163marl__s
marmots11311513marmots
maroons92615553maroons
marplots1245633marplots
marrons93216973marrons
marrow112812603marrow_
marrowy15236083marrowy
mascons113411583mascons
mascots113910343mascots
masons83916513ma_sons
matelots1047533matelots
matless93014043matless
matrons93517633matrons
matzohs2134373matzohs
matzos1749263matzo_s
maulers94213303maulers
mauls76524953maul__s
maws96437133ma___ws
mayors115714193ma_yors
mayos105521933ma_yo_s
maypops16104453maypops
meadows1337333meadows
mealless10288363mealless
melilots1046553melilots
mellowed14166923mellowed
mellower13167403mellower
mellowest1445123mellowest
mellowly16254003mellowly
mells75031333mell__s
melons84117713m_elons
meltons9410923meltons
meows104612683m__eows
merlons93311273merlons
merlots92710123merlots
miaows1145473m_iaows
mildews13365883mildews
millers93621333millers
milles84526563mill_es
millets94216843millets
millions101712423millions
mills75435053mill__s
milos75428013m_ilo_s
minnows1234913minnows
misallots1144533misallots
mollahs12328283mollahs
mollies93420233mollies
molls75129783moll__s
morrows12318723morrows
mows96340833m___ows
mudflows1742503mudflows
mullahs12388733mullahs
mullas84215933mull_as
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mullions101910343mullions
mullock1535713mullock
mullocks1645033mullocks
mulls75124153mull__s
narrows10258843narrows
pallets93919303pallets
pallor8313673pallo_r
palls74332563pall__s
parlors9312913parlors
parlous9414293parlous
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
rallies73823343rallies
rallyes10348553rallyes
reallots837983reallots
reflows13258983reflows
reglows11288843reglows
replows12329703replows
sailors73213713sailors
salchows1644203salchows
sallets73719653sallets
sallies73227813sallies
sallowed12149033sallowed
sallower11139503sallower
sallowest1246563sallowest
sallowish1544943sallowish
sallowly14344833sallowly
salmons93713253salmons
salols64017873sa_lols
salons63823683sa_lons
saloons74415303saloons
saloops93510133saloops
salvoes102811313salvoes
salvors103910903salvors
salvos94613383salvo_s
sawlogs1135393sawlogs
scallops12297373scallops
shallops13288313shallops
shallots11319493shallots
shallow13388873shallow_
slaloms9106543slaloms
slows85323463__slows
smalls84514123small__s
smaltos9408193smalto_s
swallow13355753swallow_
tailors73212383tailors
talcous939483talcous
talions7314093talions
tallboys1374613tallboys
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallo_l
tallowed12157713tallowed
talls55133433tall__s
talons64019423ta_lons
thallous1136523thallous
unhallows15122123unhallows
upflows1543513upflows
valleys13407483valleys
valors93413773va_lors
villous102810013villous
wallahs13409473wallahs
wallas95719393wall_as
wallets103914833wallets
wallies103320743wallies
wallop113310293wallo_p
wallowed15148163wallowed
wallower14158933wallower
wallowers15127653wallowers
walls85529383wall__s
willow12369693willow_
willowy16276353willowy
yarrows13277853yarrows
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.1731032896.0
2DLD Change Limit1340273836.79619721.5
3Display Results3833830.1562455.1
 (SQL Overall)1786913837.12525079.4
 
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.