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

401 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
sallows10391555(None) 
allows94517681_allows
fallows133713971fallows
gallows113513511gallows
hallows134417391hallows
mallows123714321mallows
sallow94315751sallow_
sallowy13369341sallowy
shallows14388861shallows
swallows14295891swallows
tallows103313741tallows
wallows133613531wallows
allods73615082_allods
allots64019172_allots
allow85420662_allow_
alloys94014562_alloys
ballons93916962ballons
ballots94116032ballots
barlows12259972barlows
bellows124313302bellows
billows123611292billows
callous93516602callous
callow114714662callow_
disallows1343392disallows
fallow124713852fallow_
fellows134212432fellows
follows13409922follows
gallons83015952gallons
gallops103211652gallops
gallous82813952gallous
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
hollows134412332hollows
mallow114014742mallow_
mellows123812232mellows
pallors9314362pallors
pillows122610122pillows
sailors73213722sailors
salchows1644202salchows
sallets73719652sallets
sallies73227812sallies
sallowed12149032sallowed
sallower11139502sallower
sallowest1246562sallowest
sallowish1544942sallowish
sallowly14344832sallowly
salmons93713262salmons
salols64017872sa_lols
salons63823692sa_lons
saloons74415322saloons
saloops93510132saloops
salvoes102811312salvoes
salvors103910912salvors
salvos94613382salvo_s
sawlogs1135392sawlogs
scallops12297392scallops
shallops13288322shallops
shallots11319502shallots
shallow13388872shallow_
slaloms9106542slaloms
slows85323462s__lows
swallow13355752swallow_
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
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
disallow1243513disallow_
dollops10287963dollops
elbows1196713_elbows
escallops1343193escallops
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_
misallots1144533misallots
narrows10258843narrows
pallets93919303pallets
pallor8313673pallo_r
palls74332563pall__s
parlors9312913parlors
parlous9414293parlous
pillow113110573pillow_
pillowy15316423pillowy
plows105419903__plows
rallies73823343rallies
rallyes10348553rallyes
reallots837993reallots
reflows13258983reflows
reglows11288843reglows
replows12329703replows
reswallows1661213reswallows
sables85026693sabl_es
sabots8314703sa_bots
sabulous1046123sabulous
safrols1036863safrols
sagos66123873sa_go_s
sailers73822323sailers
sailless82410373sailless
sailor63113753sailo_r
sails55738103sail__s
sajous13310583sa_jous
salaams997703salaams
salads75316963sa_lads
salals65120083sa_lals
salamis9313513salamis
salchow1544323salchow_
saleps85014903sa_leps
sales56055593sa_l_es
salinas73116093salinas
salines74029413salines
salivas10309603salivas
sall44544683sall___
sallet63734543sall_et
sallied83316953sallied
sallier73320423sallier
salliers83613343salliers
sallowing1357383sallowing
sallowness1343753sallowness
sally85129713sall__y
salmis8514273sa_lmis
salmon84614183salmo_n
salol55222143sa_lo_l
salon55228553sa_lo_n
saloon64418023sa_loon
saloop84212583sa_loop
salpas85116923sa_lpas
salpids1038193salpids
salps74423243sa_l_ps
sals46851673sa_l__s
salsas65316133sa_lsas
salters73622253salters
salties73725773salties
saltless8259343saltless
salts55431883sa_l_ts
salukis1136033salukis
salutes73716253salutes
salvers103916003salvers
salves94221763sa_lves
salvias10279933salvias
salvo84415643salvo__
salvoed11307063salvoed
salvor94711093salvo_r
sambos104315193sambo_s
samlets93813553samlets
sandlots938293sandlots
sanious7514103sanious
sannops936693sannops
santols73513323santols
santos64421833santo_s
sapless93313443sapless
sapors84118813sa_pors
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sa_rods
saros55238063sa_ro_s
sartors7314973sartors
sauls55128123saul__s
saults65816173saul_ts
saveloys1444013saveloys
saviors1058993saviors
savors95616103sa_vors
savoys12427893sa_voys
sawlog1035793sawlo_g
saws75839483sa___ws
scallions1145783scallions
scallop11237643scallo_p
scalls84218203scall__s
scollops12235703scollops
scows106617803s__cows
sellers73721323sellers
selles64426983sell_es
selloff1345923selloff
selloffs1443633selloffs
sellout7313583sellout
sellouts837493sellouts
sells55134433sell__s
serows96016393s_erows
shadblows1842473shadblows
shadows1437193shadows
shalloon1145683shalloon
shalloons1245223shalloons
shallop12348453shallo_p
shallot103614133shallo_t
shallowed1655083shallowed
shallower1555673shallower
shallowest1643993shallowest
shallowly1842613shallowly
shaloms1288983shaloms
sholoms1278033sholoms
shows115324583s__hows
siglos7311473siglo_s
sillers73822103sillers
sillies73425083sillies
sills55135993sill__s
silos56029433s_ilo_s
slalom888173slalo_m
slaws85222713s__laws
slews86220353s__lews
slobs74419873s__lobs
sloes54728873s__loes
slogs64521843s__logs
sloops85513623s_loops
slops75026013s__lops
slots54830533s__lots
slow77729493s__low_
smalls84514123small__s
smaltos9408193smalto_s
snows84719893s__nows
solions7513753solions
solons65120023s_olons
solos54830793s_olo_s
sorrows10278403sorrows
sows75342493s___ows
spallers102910733spallers
spalls84217343spall__s
sparrows1344803sparrows
stallions946073stallions
stalls64019933stall__s
stolons73410243stolons
stows86622703s__tows
strows96718273s_trows
sublots92410913sublots
sullies74122233sullies
sunbows1236023sunbows
sunglows1244083sunglows
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
wallahs13409473wallahs
wallas95719393wall_as
wallets103914833wallets
wallies103320743wallies
wallop113310293wallo_p
wallowed15148163wallowed
wallower14158933wallower
wallowers15127653wallowers
walls85529383wall__s
willow12369693willow_
willowy16276353willowy
yarrows13277853yarrows
yellow12429883yellow_
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 Filter1786911340270.406440125.6
2DLD Change Limit1340274017.53317792.0
3Display Results4014010.1402864.3
 (SQL Overall)1786914018.07922118.0
 
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.