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

353 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
gallows11351351(None) 
allows94517681_allows
fallows133713971fallows
gallons83015951gallons
gallops103211651gallops
gallous82813951gallous
hallows134417391hallows
mallows123714321mallows
sallows103915551sallows
tallows103313741tallows
wallows133613531wallows
allods73615082_allods
allots64019172_allots
allow85420662_allow_
alloys94014562_alloys
ballons93916962ballons
ballots94116032ballots
barlows12259972barlows
bellows124313302bellows
billows123611292billows
callous93516602callous
callow114714662callow_
fallow124713852fallow_
fellows134212432fellows
follows13409922follows
galiots82311322galiots
galleons9258442galleons
gallets83517402gallets
galleys11369712galleys
gallies84122712gallies
galliots9228682galliots
gallon73715812gallo_n
galloon82910642galloon
galloons9289702galloons
galloot82814222galloot
galloots9268962galloots
gallop93311382gallo_p
gallowses1374942gallowses
galls64729322gall__s
gallus74313202gall_us
galoots82410792galoots
galops94712622ga_lops
glows95518032g__lows
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallow124818322hallow_
hollows134412332hollows
mallow114014742mallow_
mellows123812232mellows
pallors9314362pallors
pillows122610122pillows
sallow94315752sallow_
sallowy13369342sallowy
shallows14388862shallows
swallows14295892swallows
tallols73311362tallols
tallow93714202tallow_
tallowy13347632tallowy
wallops123410412wallops
wallow123913512wallow_
willows13299752willows
yellows13329602yellows
agalloch1442133agalloch
agallochs1541583agallochs
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_
gabions102410053gabions
gables94222333gabl_es
gaboons10289903gaboons
galagos938143galagos
galahs105512673ga_lahs
galas65731643ga_l_as
galaxes1538873galaxes
galeas74618513ga_leas
galenas83310343galenas
galeres83514333galeres
gales65442483ga_l_es
galilees936333galilees
galiot72322593galio_t
galipots1145213galipots
gall56335993gall___
gallant83517113gallant
gallants93310373gallants
gallate83417123gallate
gallates92815523gallates
galleass935053galleass
galled84622863gall_ed
gallein8299043gallein
galleins9258693galleins
galleon8278713galleon
gallery11468743gallery
gallet73630853gall_et
galleta8399643galleta
galletas9308133galletas
galley104215453gall_ey
gallfly1433523gallfly
galliass935423galliass
gallic9411643gall_ic
gallica1047463gallica
gallicas1136933gallicas
gallied94115003gallied
galling93921963galling
galliot82214133galliot
gallipots1243773gallipots
gallium1037943gallium
galliums1145963galliums
galliwasp1541653galliwasp
gallnut847253gallnut
gallnuts943923gallnuts
galloped12107143galloped
galloper11137183galloper
gallopers12136323gallopers
galluses936963galluses
gally95026173gall__y
galoot72719163ga_loot
galop84716223ga_lo_p
galore73514863ga_lore
galores82614333galores
galosh1038563ga_losh
gals57946503ga_l__s
galyacs1335273galyacs
galyaks1534623galyaks
gambols1238593gambols
gammons1237973gammons
gangplows1641693gangplows
ganofs104010293ga_nofs
gaolers83511563gaolers
gaols66717573ga__ols
gapless10349993gapless
garcons102411643garcons
garlics1038013garlics
garrons82713463garrons
gascons10289103gascons
gaseous839503gaseous
gasless8319013gasless
gators74115833ga_tors
gaults74112783gaul_ts
gavots1038113ga_vots
gazoos163010223ga_zoos
giglots9367863giglots
gillers84216903gillers
gillies84120963gillies
gills64728193gill__s
glamors1068113glamors
globs85616403g__lobs
gloms85219783g__loms
glooms96211683g_looms
glops85619553g__lops
gloss64319623g__loss
glow85222523g__low_
gluons738503g_luons
goalless935723goalless
grows95523923g__rows
gullets84013713gullets
gulleys11438523gulleys
gullies84717313gullies
gulls65222983gull__s
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
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
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
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.406440125.6
2DLD Change Limit1340273536.61020276.4
3Display Results3533530.1262801.6
 (SQL Overall)1786913537.14225019.7
 
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.