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

328 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
wallows13361353(None) 
allows94517681_allows
fallows133713971fallows
gallows113513511gallows
hallows134417391hallows
mallows123714321mallows
sallows103915551sallows
swallows14295891swallows
tallows103313741tallows
wallops123410411wallops
wallow123913511wallow_
willows13299751willows
allods73615082_allods
allots64019172_allots
allow85420662_allow_
alloys94014562_alloys
ballons93916962ballons
ballots94116032ballots
barlows12259972barlows
bellows124313302bellows
billows123611292billows
callous93516602callous
callow114714662callow_
fallow124713852fallow_
fellows134212432fellows
follows13409922follows
gallons83015952gallons
gallops103211652gallops
gallous82813952gallous
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
hollows134412332hollows
mallow114014742mallow_
mellows123812232mellows
pallors9314362pallors
pillows122610122pillows
sallow94315752sallow_
sallowy13369342sallowy
shallows14388862shallows
swallow13355752swallow_
tallols73311362tallols
tallow93714202tallow_
tallowy13347632tallowy
wallahs13409472wallahs
wallas95719392wall_as
wallets103914832wallets
wallies103320742wallies
wallop113310292wallo_p
wallowed15148162wallowed
wallower14158932wallower
wallowers15127652wallowers
walls85529382wall__s
willow12369692willow_
willowy16276352willowy
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
arrows92813483_arrows
avows114910983_a_vows
azlons154110423_azlons
bailors93212413bailors
balboas113710073balboas
ballads104212913ballads
ballers94421013ballers
ballets93719513ballets
ballies93725743ballies
ballon84117493ballo_n
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
balls76236413ball__s
barlow112911423barlow_
barrows123411683barrows
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
elbows1196713_elbows
falcons1239123falcons
fallals103310193fallals
fallers103917993fallers
falloff1245953falloff
falloffs1343253falloffs
fallout10313503fallout
fallouts1137883fallouts
fallowed15127753fallowed
falls85727653fall__s
farrows13259783farrows
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
hallowed15179493hallowed
hallower14139813hallower
hallowers15137723hallowers
halls85633783hall__s
haloes94623863ha_loes
halons95720713ha_lons
halos85230253ha_lo_s
harlots103413293harlots
harrows132611033harrows
haymows1883813haymows
helloes103717463helloes
hellos95321683hello_s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollow124212663hollow_
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
inflows1335523inflows
jailors14328753jailors
jalops15329593ja_lops
jellos134714283jello_s
lallans74113533lallans
lalls55324133lall__s
lollops9227443lollops
lows75843013___lows
maillots1037473maillots
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
malls76233433mall__s
maltols939403maltols
marrows122911823marrows
mellow114112223mellow_
narrows10258843narrows
pallets93919303pallets
pallor8313673pallo_r
palls74332563pall__s
parlors9312913parlors
parlous9414293parlous
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
rallies73823343rallies
rallyes10348553rallyes
reallots837993reallots
reflows13258983reflows
reglows11288843reglows
replows12329703replows
reswallows1661213reswallows
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
swallowed1663583swallowed
swallower1554333swallower
swallowers1653813swallowers
tailors73212393tailors
talcous939483talcous
talions7314113talions
tallboys1374623tallboys
tallies73624603tallies
tallis63319963tall_is
tallits73215993tallits
tallol63612223tallo_l
tallowed12157713tallowed
talls55133433tall__s
talons64019443ta_lons
thallous1136523thallous
unhallows15122123unhallows
upflows1543513upflows
valleys13407483valleys
valors93413773va_lors
villous102810023villous
wackos155210993wacko_s
wadmols1333913wadmols
waggons1235503waggons
wagons103911213wa_gons
wahoos122310593wa_hoos
wailers103916803wailers
wails86631483wail__s
walers94824463wa_lers
wales86142833wa_l_es
walies95324523wa_lies
walkers143411473walkers
walkout1447933walkout
walkouts1544253walkouts
walks126218503wa_l_ks
walkups1633013walkups
wall76236103wall___
walla85321033wall__a
wallaby1535073wallaby
wallah124011993wall_ah
wallaroos1244113wallaroos
walled104021293wall_ed
wallet93327093wall_et
walleye1336243walleye
walleyes1435603walleyes
wallie93216803wall_ie
walling113520973walling
walloped14146833walloped
walloper13147113walloper
wallopers14136273wallopers
wallowing1666073wallowing
wally114625093wall__y
walnuts1033843walnuts
walrus956433wa_lrus
waltzes1935953waltzes
wanions104011373wanions
wantons103713013wantons
warless104015103warless
warlock1636293warlock
warlocks1735363warlocks
warlord1136293warlord
warlords1245303warlords
warsaws1335763warsaws
wauls86120553waul__s
wawls115416473wawl__s
waws106834903wa___ws
waylays1634673waylays
wayless13308243wayless
wazoos18288553wa_zoos
weblogs1334223weblogs
weldors11238003weldors
wellies103719073wellies
wells85426193well__s
whitlows1743083whitlows
widows1376563w_idows
willers103517913willers
willets104414323willets
willies103920153willies
willowed15156763willowed
willower14127453willower
willowers15166693willowers
wills84528963will__s
windows1447743windows
winnows1334533winnows
wows104633493w___ows
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.703254183.5
2DLD Change Limit1340273286.75019855.9
3Display Results3283280.1232666.7
 (SQL Overall)1786913287.57623586.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.