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

296 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
sherries11181289(None) 
cherries131812981cherries
herries104025071_herries
serries73925351s_erries
sherris10168801sherri_s
sherrises12156861sherrises
skerries12168671skerries
wherries14179021wherries
berries94423552_berries
derries83124622_derries
dhurries1255582dhurries
ferries103521082_ferries
gharries12318202gharries
harries103525492_harries
henries102718282_henries
herried113514452_herried
hurries103919652_hurries
jerries143817512_jerries
kerries113317912_kerries
perries93226602_perries
scurries102911482scurries
series64540972s_e_ries
serried82513962s_erried
sharpies13411222sharpies
sheenies111411542sheenies
shelties111111382shelties
sherifs13299682she_rifs
shorties11414582shorties
slurries82710412slurries
spurries102311322spurries
terries73425632_terries
theories11311592theories
wherried15175012wherried
whirries14136692whirries
abhenries1444503abhenries
aeries64737783_ae_ries
anergies9310453anergies
aperies9423203ape_ries
berried103714043_berried
carries94328013_carries
charlies133414233charlies
charrier1378683charrier
charriest1438253charriest
cheapies1539033cheapies
cheerier1348003cheerier
cheeriest1438213cheeriest
cheerios13317583cheerios
chertier1387873chertier
chertiest1438793chertiest
chervils1644553chervils
chevies153511443che_vies
chevres15379793chevr_es
chirres123812253chirr_es
clergies1137903clergies
corries94026793_corries
curries93723163_curries
dearies83526273_dearies
decries103319803_decries
derbies103016053_derbies
derris73615273_derri_s
derrises93012783_derrises
dhurrie1153953dhurrie_
drearies92313413drearies
durries83817353_durries
emeries91620023eme_ries
energies9310783energies
equerries1844883equerries
eyries93816813__eyries
faeries104118993fae_ries
ferlies103216693_ferlies
ferried113411523_ferried
ferrites112312833_ferrites
fisheries1548643fishe_ries
flurries11188913flurries
gharris11306433gharri_s
gheraoes1244813gheraoes
gherkins1643993gherkins
gurries83515953_gurries
hardies114923233_hardies
harpies123818313_harpies
harried113815533_harried
harrier104417753_harrier
harriers113712433_harriers
hearses104414533_hearses
hearties11315413_hearties
heavies132713873_heavies
heinies102514543_heinies
herbier1239593_herbier
herbiest1339993_herbiest
herdics13249523_herdics
heredes11313133_heredes
heres86245903_he_r_es
heresies11312693_heresies
hermits12312143_hermits
hernias10310773_hernias
heroes94923823_he_roes
heroics122912003_heroics
heroines112916573_heroines
heroins103518013_heroins
heroizes202610983_heroizes
heronries1248483_heronries
herpes115517323_he_rpes
herring113615883_herring
herrings12379533_herrings
hertzes1938303_hertzes
hurdies114015663_hurdies
hurlies103315333_hurlies
hurried113511043_hurried
hurrier103412943_hurrier
hurriers11358893_hurriers
jerkies183411583_jerkies
jerrids15277743_jerrids
kerrias11289513_kerrias
lorries74518343_lorries
marries93825283_marries
mercies113817563_mercies
merrier92612303_merrier
merriest10311473_merriest
murries94118673_murries
orreries8310123orreries
overdries13310883overdries
overlies112417043overlies
overrides131411013overrides
parries93925843_parries
peeries93623023_peeries
phereses1348093phereses
poetries10315583poetries
predries112714383predries
quarries1749943quarries
queries16315873que_ries
redries83721713_redries
refries104419733_refries
retries74129073_retries
salaries8319573salaries
sauries72821623s_auries
savories11311273savories
scarrier10298453scarrier
scarriest11188393scarriest
sceneries1149393sceneries
scries85226823s__cries
scurried11267053scurried
scurvies13248123scurvies
selkies113513353s_elkies
sentries81318053sentries
serails73318363s_erails
serais64326133s_erai_s
serapes95218103s_erapes
sereins73716113s_ereins
serenes73222903s_erenes
seres55448893s_e_r_es
serges74225963s_e_rges
serifs94017053s_e_rifs
serines74229543s_erines
serins64029673s_e_rins
serrates82617023s_errates
serves94423653s_e_rves
services1338573s_ervices
sferics1236133sfe_rics
shadberries1752723shadberries
shammies15259683shammies
shandies122714103shandies
shannies113411253shannies
shanties113116583shanties
shares95236413sh_ar_es
sharias102516003sh_arias
sharifs13279903sh_arifs
sharpie1238393sharpie_
shavies134213203sh_avies
sheared114516003shear_ed
shearer104414683shear_er
shearers113911323shearers
shearing123915903shearing
shearings13337563shearings
shearlegs1342493shearlegs
shears93820903shear__s
sheathes14610193sheathes
sheaves134412973she_aves
sheenie10159493sheenie_
sheenier11167423sheenier
sheeniest12158353sheeniest
sheered113515453sheer_ed
sheerer103813843sheer_er
sheerest11310083sheer_est
sheering123715103sheering
sheerlegs1343293sheerlegs
sheerness1236273sheerness
sheers94322403sheer__s
sheeves133911953she_eves
sheiks132510013she__iks
shellier1138393shellier
shelliest1238023shelliest
sheltie10109913sheltie_
shelves134112093she_lves
shelvier1464913shelvier
shelviest1535003shelviest
sherbet12311383she_rbet
sherbets1335213sherbets
sherds105614723she_r_ds
shereef1337743she_reef
shereefs1433863shereefs
sherif122915243she_ri_f
sheriff16287693she_riff
sheriffs17253923sheriffs
sheroots1137863sheroots
sherpas1238093she_rpas
sherry124510413sherr__y
shies86136553sh___ies
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shires95225573sh_ir_es
shirred113710503shirr_ed
shirring122910443shirring
shirrings13245323shirrings
shirrs94413173shirr__s
shirtier1137943shirtier
shirtiest1239323shirtiest
shoddies1336053shoddies
shoetrees1244353shoetrees
shores94830413sh_or_es
shortias1148093shortias
shortie10411343shortie_
shrewdies1643733shrewdies
shriek134211103sh__riek
shrieks14377673sh__rieks
shrikes144412393sh_rikes
shrines104618693sh_rines
shris84221453sh__ri_s
shrives134416173sh_rives
sierras737863sierr_as
sirrees73410573s_irrees
slurried9285943slurried
smarties10312873smarties
smearier1036953smearier
smeariest1138113smeariest
sneerier878103sneerier
sneeriest939313sneeriest
sorrier72313733s_orrier
sorriest8413883s_orriest
sorties74126403s_orties
sparrier10329143sparrier
sparriest11198783sparriest
species11314133spe_cies
spermaries1468063spermaries
spermines13310543spermines
spheres123114353sphe_r_es
spherics1537073sphe_rics
spherier1337783sphe_rier
spheriest1438373sphe_riest
spheroids1545543spheroids
spherules1443823spherules
spurrier10297693spurrier
spurriers11245063spurriers
starrier8279463starrier
starriest9159763starriest
steadies9311123steadies
stearines9311283stearines
stearins8312143stearins
steelies8312553steelies
steres63929533ste_r_es
sternites9310073sternites
steroids9911443steroids
stories7324273s_tories
sturdies92110273sturdies
sudaries9312753sudaries
sundries9312023sundries
superlies11314553superlies
sureties8316583sureties
sweenies11148763sweenies
sweeties11159723sweeties
swerves1377533swe_rves
synergies1345093synergies
tarries73324263_tarries
terrier73414963_terrier
terriers84210823_terriers
terrines82117553_terrines
territs72714503_territs
theorise1137873theorise
theorises1247813theorises
theorizes2147073theorizes
therapies1447723therapies
theres96525473the_r_es
thermes126214613the_rmes
thermites1438043thermites
thermits1338513thermits
theurgies1343353theurgies
thirties1139723thirties
tusheries1246893tushe_ries
veeries102916893_veeries
wearies103020223_wearies
wheelies1437863wheelies
wheres125917433whe_r_es
wherves16548053whe_rves
whirlies14167373whirlies
whirried15154103whirried
worries104117133_worries

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461622967.03320782.3
3Display Results2962960.1102690.9
 (SQL Overall)1786912967.29624491.6
 
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.