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

392 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
gallop9331138(None) 
gallon73715811gallon
gallops103211651gallops
galop84716211ga_lop
wallop113310291wallop
allod64418372_allod
allot54933872_allot
allow85420662_allow
alloy85519972_alloy
ballon84117492ballon
ballot84624092ballot
callow114714662callow
collop107312312collop
dollop9259362dollop
fallow124713852fallow
galiot72322582galiot
gall56335992gall__
galled84622852galled
galleon8278712galleon
gallet73630852gallet
galley104215452galley
gallic9411632gallic
galliot82214132galliot
gallons83015942gallons
galloon82910642galloon
galloot82814222galloot
galloped12107142galloped
galloper11137182galloper
gallous82813952gallous
gallows113513512gallows
galls64729322gall_s
gallus74313202gallus
gally95026172gall_y
galoot72719152galoot
galops94712612ga_lops
glop76724632g__lop
hallo85127552hallo_
halloa94918122halloa
halloo95118972halloo
hallos95425102hallos
hallot95426782hallot
hallow124818322hallow
jalop144212602ja_lop
lollop8238782lollop
mallow114014742mallow
pallor8313672pallor
sallow94315752sallow
saloop84212582saloop
scallop11237642scallop
shallop12348452shallop
tallol63612222tallol
tallow93714202tallow
wallops123410412wallops
wallow123913512wallow
agalloch1442123agalloch
aglow94711963_aglow
aldol61212333_aldol
algor6513053_algor
all36148233_all__
allay85620393_allay
allee54932123_allee
alley85721673_alley
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
alls46740923_all_s
ally76935643_all_y
allyl85310543_allyl
aloe45540193_a_loe
aloof83521573_aloof
alow75328593_a_low
alp56641133_a_l_p
also46423443_also_
alto47831263_alto_
altos55822953_altos
aslope839013_aslope
atop66124753_a_top
azlon144312873_azlon
bailor83412603bailor
balboa10389963balboa
ball66043323ball__
ballad94315323ballad
balled94926893balled
baller83825203baller
ballet84733973ballet
ballons93916953ballons
balloon93711433balloon
ballots94116033ballots
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
barhop13319643barhop
barlow112911423barlow
bellhop1445053bellhop
bellow114213353bellow
billon83713823billon
billow114111223billow
bloop96116153_bloop
bollox1548743bollox
call66838673call__
calla74827073call_a
callan83619603callan
callas84526753callas
callboy1465833callboy
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
calliope1256223calliope
callose9313653callose
callous93516593callous
calls75634733call_s
callus85317073callus
calo64936443ca_lo_
calos74431903ca_los
caltrop11267633caltrop
carhop133610763carhop
cartop104213563cartop
cello74919583cello_
cellos84517803cellos
challot123613263challot
clop86929893__clop
collops112611753collops
dalles74222063dalles
dally95324743dall_y
dalton7311273dalton
dollops10287963dollops
earlap837183earlap
escallop1243183escallop
falcon11310293falcon
fall75535313fall__
fallal93612693fallal
fallen93813373fallen
faller94621233faller
falloff1245953falloff
fallout10313503fallout
fallows133713973fallows
falls85727653fall_s
felloe93513923felloe
fellow123712743fellow
fillip11268953fillip
fillo84319783fillo_
fillos94415073fillos
flop96925453__flop
follow124010353follow
gabion93211023gabion
gable85325523gabl_e
gabled105518453gabled
gables94222333gables
gaboon93211773gaboon
gadjo1436913gadjo_
gaily95020973gail_y
gal46055513ga_l__
gala55635163ga_l_a
galago838903galago
galagos938143galagos
galah95917623ga_lah
galahs105512673galahs
galas65731643ga_las
galax135314463ga_lax
galaxy17476313galaxy
gale56347323ga_l_e
galea64722933ga_lea
galeae74717453galeae
galeas74618503galeas
galena74911093galena
galere73716673galere
gales65442483ga_les
galilee8312213galilee
galiots82311323galiots
galipot1049543galipot
gallant83517113gallant
gallate83417123gallate
gallein8299043gallein
galleons9258423galleons
gallery11468743gallery
galleta8399643galleta
gallets83517403gallets
galleys11369713galleys
gallfly1433523gallfly
gallica1047463gallica
gallied94114993gallied
gallies84122713gallies
galling93921963galling
galliots9228683galliots
gallipot1145943gallipot
gallium1037943gallium
gallnut847253gallnut
galloons9289683galloons
galloots9268963galloots
gallopade1343603gallopade
gallopers12136323gallopers
galloping1356253galloping
galoots82410793galoots
galoped11138063ga_loped
galore73514843galore
galosh1038553galosh
gals57946503ga_l_s
galumph15102663galumph
galyac1235973galyac
galyak1445333galyak
gambol1138223gambol
gammon1138903gammon
gamp98833213ga__mp
ganof95420363ga_nof
gantlope1144413gantlope
gaol56925413ga__ol
gaoled84814493gaoled
gaoler73913573gaoler
gaols66717573gaol_s
gap67055613ga___p
garcon92912483garcon
garlic9310043garlic
garron73113493garron
gascon9339723gascon
gaslit7513503gaslit
gasp76227333ga__sp
gator64416033ga_tor
gault65128483gaul_t
gaults74112783gaults
gavot9321113ga_vot
gawp107618633ga__wp
gayly124513093gayl_y
gazoo153112873ga_zoo
gazoos163010223gazoos
gazump2032453gazump
gelcap1136213gelcap
gelled84718893gelled
gigaflop1551353gigaflop
giglot84013133giglot
gill56336183gill__
gilled84521633gilled
giller74519733giller
gillie74816943gillie
gills64728193gill_s
gilly94321633gill_y
glamor958183glamor
glob76623393g__lob
glom75424383g__lom
gloom87116523g_loom
glops85619553g__lops
glow85222523g__low
gluon6311223g_luon
golly95121103goll_y
goop75829483g__oop
gull54828453gull__
gulled84521373gulled
gullet74924833gullet
gulley104213163gulley
gulls65222983gull_s
gully94020683gull_y
gulp75521363g_ul_p
hall75741163hall__
hallah124115403hallah
hallal94415563hallal
hallel93514093hallel
halloas104318463halloas
halloed113314913halloed
halloes104021513halloes
halloos103716743halloos
halloth134111253halloth
hallows134417393hallows
halls85633783hall_s
hallux1637363hallux
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
harlot94422803harlot
hello86522983hello_
hellos95321683hellos
hillo84721653hillo_
hilloa94713033hilloa
hillos94618883hillos
hilltop1244783hilltop
hollo84822163hollo_
holloa94914823holloa
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
jailor13418573jailor
jalap143612473ja_lap
jalops15329593ja_lops
jalopy18325863ja_lopy
jello126716273jello_
jellos134714283jellos
lall45531313lall__
lallan63414173lallan
lalled74218753lalled
lalls55324133lall_s
laptop1076813laptop
lollops9227443lollops
lollopy12234773lollopy
loop67835013__loop
lop58255313___lop
maillot9312173maillot
mall64639363mall__
malled94626103malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
mallows123714323mallows
malls76233433mall_s
maltol8310843maltol
maypop1565143maypop
megaflop1672263megaflop
mellow114112223mellow
orlop7410903_orlop
outgallop1241743outgallop
pall65039343pall__
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallid93915273pallid
pallors9314343pallors
palls74332563pall_s
pally105727123pall_y
palmtop1343873palmtop
palp85828573pa_l_p
parlor8312673parlor
pillow113110573pillow
plop86625743__plop
pullup1045893pullup
ragtop936683ragtop
rally84725903rall_y
rallye95110163rallye
reallot7312133reallot
rollmop1142993rollmop
rolltop944043rolltop
sailor63113743sailor
salep77022953sa_lep
sall44544683sall__
sallet63734543sallet
sallows103915543sallows
sallowy13369343sallowy
sally85129713sall_y
salmon84614183salmon
salol55222143sa_lol
salols64017873salols
salon55228553sa_lon
saloon64418023saloon
saloops93510133saloops
salp64534093sa_l_p
salvo84415643salvo_
salvor94711093salvor
salvos94613383salvos
sannop837373sannop
sawlog1035793sawlog
scallops12297373scallops
scollop11275433scollop
shallops13288313shallops
shallot103614133shallot
shallow13388873shallow
slalom888173slalom
sloop76118913_sloop
slop66533873__slop
swallow13355753swallow
tailor63412503tailor
talion6317713talion
tall47240213tall__
tallboy1265133tallboy
taller63721963taller
tallis63319963tallis
tallit63422733tallit
tallols73311353tallols
tallows103313733tallows
tallowy13347633tallowy
talls55133433tall_s
tally84526863tall_y
talon55824113ta_lon
trollop944793trollop
valley124311603valley
valor83614893va_lor
walkup1534193walkup
wall76236103wall__
walla85321033wall_a
wallah124011993wallah
wallas95719393wallas
walled104021293walled
wallet93327093wallet
wallie93216803wallie
walloped14146833walloped
walloper13147113walloper
wallows133613533wallows
walls85529383wall_s
wally114625093wall_y
willow12369693willow
yellow12429883yellow

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163926.40617595.4
3Display Results3923920.1263111.1
 (SQL Overall)1786913926.67226782.2
 
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.