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

223 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
sundries931202(None) 
foundries1345692foundries
laundries1045562laundries
sentries81318052sentries
sudaries9312752sudaries
sundaes8313092sund_aes
sundress936982sundress
sundrily1246062sundrily
sundrops1145822sundrops
sunrise7310812sun_rise
sunrises8310692sun_rises
undies73821962_und_ies
undried92314612_undried
updries10209082_updries
auguries947933auguries
aunties73920073aun_ties
bandies104124863band_ies
bawdries14136843bawdries
binaries10314183binaries
binderies12311683binderies
boundaries1345113boundaries
buddies113914353bu_ddies
budgies115312513bu_dgies
bundles103515773bund_les
bunnies94415003bun_nies
burdies104117563burd_ies
buries84633273bu__ries
canaries10318943canaries
candies104125613cand_ies
countries11313613countries
cuddies113313263cu_ddies
curies84934023cu__ries
curries93723163cu_rries
dandies94121443dand_ies
dendrites1147933dendrites
dries64733673___dries
duperies11312813duperies
durries83817353du_rries
endrins8312163_endrins
entries71523163_entries
fineries112416743fineries
fuddies123211203fu_ddies
fundraise1342823fundraise
fundraises1442693fundraises
funnies104113603fun_nies
furies95126373fu__ries
gantries91413783gantries
gauntries1046033gauntries
gentries91315263gentries
gunfires1235063gunfires
gunneries1047043gunneries
gunnies83413123gun_nies
gurries83515953gu_rries
henries102718283hen_ries
hundred1237143hundr_ed
hundreds1344003hundreds
hungrier1233893hungrier
hungriest1344543hungriest
hunkies143214503hun_kies
hurdies114015663hurd_ies
hurries103919653hu_rries
indies73822783_ind_ies
indris7311963_indri_s
junkies183711693jun_kies
juries134120633ju__ries
lindies8416583lind_ies
lunacies1038013lunacies
lunies64723013lun__ies
luxuries1544793luxuries
mandrils1138493mandrils
maundies1137853maund_ies
misandries1345063misandries
muddies113513953mu_ddies
munchies1539253munchies
murries94118673mu_rries
nudies75217093nu_d_ies
nunneries947113nunneries
outcries10313573outcries
outdrives1346703outdrives
pandies104224503pand_ies
panfries13149203panfries
pantries101817393pantries
penuries10311663penuries
pineries102419083pineries
predries112714383predries
puggries12166383puggries
punditries1343753punditries
pundits10379293pund_its
punkies134216803pun_kies
punties94520783pun_ties
quadrics2045653quadrics
quandaries2064413quandaries
quarries1749943quarries
queries16315873qu_eries
quinaries1857873quinaries
randies84225663rand_ies
redries83721713_redries
ruderies9311333ruderies
rundles83214713rund_les
salaries8319573salaries
sandflies1346513sandflies
sandhis1139993sandhi_s
sandier84017843sand_ier
sandiest93218683sand_iest
sandpiles1246303sandpiles
sandpits1146843sandpits
sangrias938373sangrias
sanies63031953san__ies
sanities81219773sanities
sauries72821623s_auries
savories11311273savories
sceneries1149393sceneries
scries85226823s__cries
scurries102911483scurries
senarius8310103senarius
senores73218113senor_es
series64540973s__eries
serries73925353s_erries
shandies122714103shand_ies
sherries111812893sherries
shindies122610503shind_ies
shoddies1336053shoddies
signories10107853signories
skerries12168673skerries
slurries82710413slurries
snares65329033s_nar_es
snores64324323s_nor_es
snuggies10246363snuggies
soddies92312853s_oddies
sondes74922873sond__es
sonnies7315223son_nies
spandrils1244163spandrils
spunkies14227593spun_kies
spurries102311323spurries
stories7324273s_tories
studdies10207073studdies
studies82413863stud_ies
sturdies92110273sturd_ies
subduces1397263subduces
subdues1099893subd_ues
subentries1246423subentries
suberins10315093suberins
suberise10813933suberise
suberises11813453suberises
suberizes20811833suberizes
subseries11312933subseries
subtribes1346233subtribes
succories1347183succories
sucres84218893su_cr_es
sudses74114503su_d_ses
sudsier868783su_dsier
sudsiest939623su_dsiest
suedes73918113sued__es
sugarier937393sugarier
sugariest1038133sugariest
sulkies114315763su_lkies
sullies74122233su_llies
sultrier837773sultrier
sultriest938653sultriest
summaries13118183summaries
sunbirds1143903sunbirds
sundae7312873sund_ae_
sundecks1544253sundecks
sunder74019823sund__er
sundered10312153sundered
sunderer9310523sunderer
sunderers1039073sunderers
sundering11312323sundering
sunders84120053sund_ers
sundew10369693sund__ew
sundews11398153sund_ews
sundial859863sund_ial
sundials946753sundials
sundogs947103sund_ogs
sundowns1285433sundowns
sundresses1146543sundresses
sundry1057943sundr__y
sunnier73412153sun_nier
sunniest82712913sun_niest
sunrays1037083sun_rays
sunshines1246583sunshines
sunsuits845963sunsuits
sunwise1036433sun_wise
superlies11314553superlies
supplies1268833supplies
sureties8316583sureties
surgeries10311363surgeries
surges73924593su__rges
surprise1037673surprise
surprises1137433surprises
surprizes2045593surprizes
suspires1038203suspires
sutures7314223sutur_es
syndeses1245263syndeses
syndics1335703synd_ics
syndromes1544503syndromes
synergies1345093synergies
tawdries12136083tawdries
tendrils946443tendrils
tundras857113tundr_as
tunnies73614263tun_nies
turneries948493turneries
underlies101414203_underlies
undines8716083_undines
undoes73917403_und_oes
undrapes1138603_undrapes
undraws1136893_undraws
undress838893_undress
undrest8313013_undr_est
undrew1037913_undr_ew
unfrees1048643_unfrees
unifies102714713_unifies
unities72520153_unities
unrigs7159003_un_rigs
unrips8199453_un_rips
unties64326923_un_ties
untried82615853_untried
untrims938613_untrims
updried11226473_updried
usuries7510633_usuries
veneries112815033veneries
vineries112716043vineries
wineries112316533wineries

Search took 10 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.450397091.1
2DLD Change Limit1461622239.00016240.2
3Display Results2232230.0962322.9
 (SQL Overall)1786912239.54618718.9
 
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.