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

514 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
sherry12451041(None) 
cherry144810761cherry
herry114922471_herry
serry84824121s_erry
skerry13356101skerry
wherry15477341wherry
berry104521772_berry
charry145012112charry
cheery144913152cheery
cherty144612472cherty
derry94721372_derry
ferry116020802_ferry
gharry13546272gharry
harry115322952_harry
henry114014472_henry
herby134715312_herby
hurry114917182_hurry
jerry155016182_jerry
kerry124916092_kerry
merry104721492_merry
perry105222712_perry
scarry116311182scarry
scurry11419592scurry
sharny124711832sharny
sharpy145211032sharpy
shear85424832shear_
shears93820902shears
sheeny124912192sheeny
sheer84726892sheer_
sheerly13337702sheerly
sheers94322402sheers
shelly124414472shelly
shelty124011552shelty
shelvy15377862shelvy
sherd96321152she_rd
sherds105614722sherds
sherif122915242sherif
sherpa1138092sherpa
sherris10168802sherris
shirr84716922shirr_
shirrs94413172shirrs
shirty124312562shirty
shorty124313202shorty
sierra637312sierra
slurry9378602slurry
smeary114110802smeary
sneery93610412sneery
sorry84618252s_orry
sparry115111302sparry
sphery14318882sphe_ry
spurry11429122spurry
starry94911672starry
terry84721872_terry
theory121098362theory
whirry15477062whirry
abhenry1543333abhenry
aery77231683_ae_ry
anergy10156863anergy
apery106517903ape_ry
ashtray13805553ashtray
aweary1237303aweary
beery105220123_beery
bleary115112553bleary
blurry11437673blurry
burry105221563_burry
carry105823783_carry
charr104821783charr_
charro114212963charro
charrs115219193charrs
chary135023133ch_ary
cheeky18448613cheeky
cheer105420383cheer_
cheerly15417603cheerly
cheero114712943cheero
cheers114518913cheers
cheesy14419193cheesy
chert105232103che_rt
cherts115617233cherts
cherub1337263cherub
chesty144610503chesty
chevre14318313chevre
chevy16479993che_vy
chewy165011903che_wy
chirpy16498913chirpy
chirr105015903chirr_
chirre114111853chirre
chirrs114514983chirrs
churr104512853churr_
churro11448353churro
churrs115111513churrs
clergy1234993clergy
curry105920343_curry
deary95826843_deary
decry115514353_decry
deray95024183_deray
derby114715343_derby
dreary104611673dreary
eery76129623__eery
emery104814333eme_ry
energy10137513energy
equerry1943053equerry
err35626533__err_
errs45622533__errs
every115215453eve_ry
eyry106315883__eyry
faery116015483fae_ry
ferly115517353_ferly
ferny115816183_ferny
fiery114714793fie_ry
firry115713533_firry
fishery16397733fishe_ry
fleury12417353fleury
flurry12397113flurry
furry116719283_furry
germy115113663_germy
gharri10386163gharri
gherao1036753gherao
gurry94515413_gurry
hairy115316833_hairy
hardy125622063_hardy
harpy136418213_harpy
heady125117263_heady
heapy135914983_heapy
hear76143883_hear_
heard95222753_heard
hears86737373_hears
heart85440743_heart
hearty126313633_hearty
heavy144814183_heavy
hedgy134510753_hedgy
hefty146112133_hefty
heir77523803_heir_
heirs85618563_heirs
hempy154912763_hempy
henrys12366103_henrys
her66547813_he_r_
herb94730963_he_rb
herbs105520503_herbs
herd84933063_he_rd
herds96424683_herds
here76447103_he_re
hereby14468333_hereby
heres86245903_heres
heresy125011233_heresy
herl75834553_he_rl
herls85226433_herls
herm95636153_he_rm
herma105318893_herma
herms105626433_herms
hern76134893_he_rn
herns84825583_herns
hero74635783_he_ro
heron85025503_heron
heronry1346043_heronry
heros84930863_heros
hers75844873_he_rs
hertz174919043_hertz
hey96741063_he__y
hoary114516763_hoary
horary12310383_horary
horny115619623_horny
horsy116318393_horsy
hurly115819293_hurly
hurray12459913_hurray
jerky196712423_jerky
knarry1334613knarry
leary85927383_leary
leery85919133_leery
lorry86315673_lorry
marry104821693_marry
mercy125916183_mercy
murry105120233_murry
nerdy95014703_nerdy
nervy114610863_nervy
ochery14319443oche_ry
onery8414123one_ry
orrery936783orrery
overdry1435903overdry
overly122411363overly
parry105323753_parry
peery105719443_peery
perdy115417333_perdy
perky145319483_perky
poetry1139383poetry
predry1237873predry
quarry1837473quarry
query174212083que_ry
qwerty2133583qwerty
redry94314363_redry
refry114412463_refry
retry84718083_retry
rheumy1433353rheumy
salary9515213salary
sarky125521783s_arky
saury84317223s_aury
savory124310563savory
scarey115016983scarey
scary105222593s_cary
scenery1236563scenery
scherzi2143583scherzi
scherzo2153943scherzo
screwy14659463screwy
scry96017763s__cry
scurfy14338763scurfy
scurvy14386103scurvy
seamy105921273s_eamy
sear47353843s_ear_
sears54744913s_ears
sedgy104512793s_edgy
seedy94821533s_eedy
seely84522633s_eely
seemly1138433seemly
seepy104717973s_eepy
seer45547043s_eer_
seers55136383s_eers
senary93716073senary
senryu934493s_enryu
sentry92912053sentry
sepoy10314303s_epoy
ser36752403s_e_r_
sera46141393s_e_ra
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
sere46153473s_e_re
sered65737293s_ered
serer55935513s_erer
seres55448893s_eres
serf76340113s_e_rf
serfs84922013s_erfs
serge64727473s_erge
serif84132133s_erif
serin55434443s_erin
serow86720443s_erow
sers45746653s_e_rs
serum75223473s_erum
serve85425963s_erve
servo84516683s_ervo
sexy146418023s_e_xy
shabby1635803shabby
shadberry1842043shadberry
shady125416513sh_ady
shaggy14478043shaggy
shaird10288703shaird
shairn9269063shairn
shaky154616843sh_aky
shaley123714993shaley
shaly114322863sh_aly
shammy16388503shammy
shamoy14379913shamoy
shandy134710033shandy
shanny124110093shanny
shanty124715123shanty
shard96125963sh_ard
shards104319173shards
share86437083sh_are
shared105829063shared
sharer95025483sharer
sharers104720623sharers
shares95236413shares
sharia93116733sharia
sharif122917123sharif
shark126225023sh_ark
sharks135019723sharks
sharn84823703sh_arn
sharns95516983sharns
sharp104922533sh_arp
sharply15406833sharply
sharps115516083sharps
shay107133343sh__ay
she66837693she___
shea76031573she__a
sheaf115424123she_af
sheafs124912883sheafs
sheal84927703she_al
sheals94420643sheals
sheared114516013sheared
shearer104414693shearer
shearers113911323shearers
sheas86331793she_as
sheath12412893sheath
sheave124514003sheave
shed86536153she__d
sheds96122703she_ds
sheen85023313she_en
sheeney13398933sheeney
sheens95116993sheens
sheep105321523she_ep
sheered113515463sheered
sheerer103813853sheerer
sheesh1237813sheesh
sheet84836963she_et
sheets93918503sheets
sheeve123412843sheeve
sheik122514663she_ik
sheikh16206993sheikh
sheiks132510013sheiks
sheila969843sheila
shekel1338383shekel
shelf115221113she_lf
shell84424123she_ll
shells94319523shells
shelta93111793shelta
shelve124012763shelve
shend94719973she_nd
shends105313773shends
shent85933503she_nt
sheol84318373she_ol
sheols94614163sheols
sheqel1846523sheqel
sherbert1348793sherbert
sherbet12311383sherbet
shereef1337743shereef
sheriff16287693sheriff
sherifs13299683sherifs
sheroot10414373sheroot
sherpas1238093sherpas
sherries111812903sherries
shes75734353she__s
sheuch14267043sheuch
sheugh13295883sheugh
shew108030763she__w
shewed134716183shewed
shewer124515113shewer
shewers134312053shewers
shewn115715703she_wn
shews115924713she_ws
shier85428943shier_
shiers94921753shiers
shifty15409263shifty
shily115222013sh_ily
shimmy16306413shimmy
shindy13449323shindy
shinny124810783shinny
shiny115122143sh_iny
shire84727133sh_ire
shires95225573shires
shirk124817843sh_irk
shirks134814123shirks
shirred113710503shirred
shirt84533903sh_irt
shirts94918343shirts
shitty124110063shitty
shivery16317023shivery
shmear1176933shmear_
shmears1277073shmears
shoaly124010773shoaly
shoddy1434543shoddy
shoer84722163shoer_
shoers94518333shoers
shoran94016043shoran
shore85432653sh_ore
shored105723653shored
shores94830413shores
shorl84720253sh_orl
shorls94516203shorls
shorn85722183sh_orn
short85040533sh_ort
shortly13387573shortly
shorts95321743shorts
showery16437243showery
showy145714013sh_owy
shred98125613sh_red
shreds105613053shreds
shrew119720173sh_rew
shrewd136810783shrewd
shrews129313923shrews
shri76021703sh__ri
shris84221453sh_ris
shrub104814893sh_rub
shrug94512513sh_rug
shy96728193sh___y
shyer114714783shyer_
shyers124712203shyers
shyly144811573sh_yly
sierran737193sierran
sierras737863sierras
sieur5911893sieur_
sieurs659043sieurs
sirra54416323s_irra
skirr94810553skirr_
skirrs10448193skirrs
sleazy18267393sleazy
sleeky13398963sleeky
sleepy11479413sleepy
sleety94112653sleety
smarmy13629353smarmy
smarty115013793smarty
smear74416393smear_
smears84714433smears
smelly114110363smelly
smerk115412723sme_rk
smerks12449713smerks
smirky15406943smirky
snarky134210843snarky
snarly93815003snarly
sneaky13427843sneaky
sneer54919953sneer_
sneers64016173sneers
sneezy18345273sneezy
soberly1236943soberly
sorely94618013sorely
sorer56236593sorer_
sourly93612213sourly
sparky154511523sparky
spear75821063spear_
spears84019473spears
speedy1218410793speedy
speer74623903speer_
speers85019953speers
speir75315363speir_
speirs85013233speirs
spendy124911143spendy
sperm93216023spe_rm
spermary1545043spermary
sperms102512603sperms
spheral1238423spheral
sphere113313663sphe_re
sphered133512313sphered
spheres123114353spheres
spheric14510073spheric
spiry105017353s_piry
sporty115112493sporty
spray106720063s_pray
spry96819123s__pry
spurrey12307813spurrey
steady103510203steady
steamy115112373steamy
steely93612573steely
steer55423863steer_
steers63820983steers
stemmy13417033stemmy
stere55328543ste_re
stereo65317913stereo
steres63929533steres
steric8317063steric
stern55319123ste_rn
sterna63712763sterna
sternly1037853sternly
sterns64616763sterns
sterol6613333sterol
stewy116112063ste_wy
stey76224413ste__y
storey95217613storey
stormy115510733stormy
story86723033s_tory
stoury9529943stoury
stray88525573s_tray
stroy87720393s_troy
sturdy1037043sturdy
sudary1038703sudary
suer45334033sue_r_
suers55128483sue_rs
suety85318493sue_ty
sugary1039013sugary
sultry938463sultry
sundry1057943sundry
sunray9310123sunray
surely93816463surely
surer54833103surer_
surety93515013surety
surfy115319473s_urfy
surgy95118523s_urgy
surly85124433s_urly
surra55521343s_urra
surrey94414583surrey
swarty125812383swarty
swear85316853swear_
swears94114073swears
sweaty123710053sweaty
sweeny12358843sweeny
sweepy14447453sweepy
sweer84918573sweer_
sweltry1333413sweltry
swerve1256293swerve
swirly12439253swirly
synergy1442943synergy
tarry85422513_tarry
teary85124053_teary
terra54419673_terra
their85512153their_
theirs94610353theirs
therapy1536613therapy
there87527393the_re
thereby1534633thereby
theres96525473theres
therm106018023the_rm
therme115814993therme
therms115914873therms
theurgy1442733theurgy
thewy146311853the_wy
they107223753the__y
thirty12378403thirty
thorny12509843thorny
tushery1335633tushe_ry
unmerry1245023unmerry
usher84517763ushe_r_
ushered1139153ushered
ushers94415533ushe_rs
veery115816253_veery
very108025643_ve_ry
weary115620613_weary
wheezy24244523wheezy
whelky19314973whelky
where117019433whe_re
whereby1842913whereby
wheres125917443wheres
wherve15568123wherve
whey135018713whe__y
wheyey1834323wheyey
whirly15448863whirly
whirr114611193whirr_
whirrs12408593whirrs
worry116114333_worry

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 Filter1786911127160.390458182.1
2DLD Change Limit1127165147.00316095.4
3Display Results5145140.1703023.5
 (SQL Overall)1786915147.56323627.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.