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

428 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
stroud731038(None) 
shroud1038771shroud
strouds837801strouds
estrous7712532estrous
proud84615482_proud
sarod65325872saro_d
scrod85115072scro_d
serous65023562serous
shrouds1136022shrouds
sprout8419402sprout
steroid81314862steroid
stood65517712st_ood
stored75524212stored
stound7399902st_ound
stoup75517072st_oup
stour54916742st_our
stout57434052st_out
strand74514822strand
strobe84513812strobe
strode75215972strode
stroke105116172stroke
stroked124613622stroked
stroll6311602stroll
stroma84313072stroma
strong74914882strong
strook10410302strook
strop77422242stro_p
strops86220382strops
strove95014792strove
strow88920572stro_w
strowed115312142strowed
strown96812092strown
strows96718272strows
stroy87720392stro_y
stroyed114110862stroyed
stroys95914602stroys
strum75619452str_um
strut56030732str_ut
stud56220092st__ud
trod57627952_tro_d
trout57332572_trout
abroad9310943abroad
aground9216183aground
aloud65018073_aloud
aroid65428343_aroid
around72712413_around
asteroid9511193asteroid
astound845503ast_ound
atrium8411823atrium
aurous64119263aurous
beshroud1443803beshroud
broad84817693_broad
brood84620243_brood
byroad1236623byroad
cerous85821203cerous
citrous93112993citrous
cloud86716423_cloud
croup95616783_croup
crowd115815623_crowd
crud75219613_cr_ud
droid74218543_droid
drouk1039433_drouk
earbud936283earbud
enshroud1243093enshroud
estrone7413953estrone
estrum81810513estr_um
estrus61912113estr_us
fraud939863_fraud
frond95316343_frond
ground82310273_ground
group85413923_group
grout65330423_grout
hotrod1048803hotro_d
inroad737933inroad
loud55228043__loud
lustrous877803lustrous
maraud938943maraud
nitrous73512483nitrous
oestrous869923oestrous
osteoid848193osteoid
oud47439073___oud
parous84024163parous
petrous92714423petrous
porous84419483porous
prod76129503_pro_d
road56332113__road
rod47953893__ro_d
rood56733003__rood
roue45941743__roue
round64318433__round
roup66627693__roup
rout46153283__rout
roux117419363__roux
sajou12311693sajou_
sajous13310583sajous
sapour83812373sapour
sarcoid10310453sarcoid
sarcous9312933sarcous
sard55344243sar__d
sarode75317513sarode
sarods74918573sarods
sarong73914873sarong
saros55238063saro_s
savour94110703savour
schrod1247883schro_d
scold85414863s_cold
scored94621133scored
scour75315533s_cour
scout75031453s_cout
screed95718933screed
scried95817303scried
scrods94111613scrods
scroll8310173scroll
scroop10299783scroop
scrota8310203scrota
scrotum1145133scrotum
scrouge1036353scrouge
scrouged1235383scrouged
scrub94914203scr_ub
scrum95418203scr_um
scud76221283s__cud
seatrout8411593seatrout
second9411153second
sered65737293ser_ed
serged84118773serged
serious73616283serious
serosa6313023serosa
serow86720443sero_w
serows96016393serows
serum75223473ser_um
served104616813served
setous64917373setous
setout64719473setout
shod86225063s_ho_d
shoed95723013s_hoed
shooed103916083shooed
shored105723653shored
should1038033s_hould
shout85433173s_hout
shred98125613shr_ed
shrewd136810783shrewd
shroff1538503shroff
shrouded1333603shrouded
shrove125412233shrove
shrub104814893shr_ub
shrug94512513shr_ug
siloed74615303siloed
sired66134283sir_ed
sirup74014913sir_up
sistroid947263sistroid
sloid64619713s_loid
slojd13378843s_lojd
sloyd9409683s_loyd
snood64616163s_nood
snored74819543snored
snout54530633s_nout
sod46053703s__o_d
sold54837413s__old
soloed74515743soloed
sorbed94916523sorbed
sord56237203s__ord
sordid83411163sordid
sored66141783sor_ed
sorned74820043sorned
sorted74523713sorted
sorus54527583sor_us
sou37853693s__ou_
souk86127173s__ouk
soul46435713s__oul
sound64420023s__ound
soup66232913s__oup
sour45935893s__our
sous46947213s__ous
sparoid102311543sparoid
spiroid10219823spiroid
spored94821793spored
sporoid102310733sporoid
spout75029633s_pout
spread9312533spread
sprouted1136393sprouted
sprouts949983sprouts
sprue74717633spr_ue
sprug85313893spr_ug
spud75818493s__pud
staged84521563staged
staid66722083st_aid
staked114621943staked
staled74728103staled
stand65923283st_and
staned74824643staned
stared75429873stared
starred85013453starred
started84217323started
startup934963startup
starved114911573starved
stated75427833stated
statue66015323statue
statued8459893statued
status65515213status
staved103918053staved
stayed104817273stayed
stead65520273st_ead
steed66024943st_eed
stereoed937883stereoed
sternum947733sternum
steroids9911443steroids
sterol6613333stero_l
sterols7313443sterols
stewed104814243stewed
stied65723033st_ied
stiped94517073stiped
stirred8359703stirred
stirrup943003stirrup
stoa45425913st_o_a
stoae55024263st_oae
stoai55417873st_oai
stoas55126023st_oas
stoat57135953st_oat
stob66724613st_o_b
stobs75718233st_obs
stock114417563st_ock
stogy95414083st_ogy
stoic7317253st_oic
stoke94922513st_oke
stoked114718293stoked
stole54928813st_ole
stoled74521593stoled
stolid74213183stolid
stoma75918273st_oma
stomp95616663st_omp
stone55431183st_one
stoned75923143stoned
stony85818643st_ony
stooge73811663stooge
stooged94310733stooged
stook95218213st_ook
stooked124312303stooked
stooks105115373stooks
stool55619893st_ool
stooled84313893stooled
stools65117023stools
stoop75821543st_oop
stooped103813833stooped
stoops85917893stoops
stop66532033st_o_p
stope74727243st_ope
stoped94721013stoped
stops74827283st_ops
stopt76528353st_opt
storax1389783storax
store56333813st_ore
storer64721673storer
stores65533663stores
storey95217613storey
storied8515163storied
stork96819693st_ork
storks106115953storks
storm76520403st_orm
stormed1039043stormed
storms85814633storms
stormy115510733stormy
story86723033st_ory
stoss54316343st_oss
stot46347333st_o_t
stots54828553st_ots
stott56929793st_ott
stounds8377823st_ounds
stoups85313273st_oups
stoure64814943st_oure
stours65015633st_ours
stoury9529943st_oury
stouts65019003st_outs
stove85220253st_ove
stow77325743st_o_w
stowed105817203stowed
stowp105614233st_owp
stows86622703st_ows
strafe95215983strafe
strafed114413333strafed
strain64919573strain
strait64025893strait
strake104017393strake
straked125415343straked
strands83711953strands
strang75718313strang
strap77925263str_ap
straps87721783straps
strass67117223strass
strata63616283strata
strath93216373strath
strati63518903strati
stratous8410703stratous
stratum9318253stratum
stratus73011733stratus
straw813321293str_aw
strawed114813613strawed
straws98718673straws
strawy1210312823strawy
stray88525573str_ay
strayed114513283strayed
strays96417933strays
streak104613623streak
stream84717293stream
streek104111413streek
streel64214023streel
street64125773street
strep77120853str_ep
streps86218063streps
stress66616673stress
strew89220663str_ew
strewed115811343strewed
strewn96710013strewn
strews96817103strews
stria55723213str_ia
striae65422273striae
strick124813203strick
strict84821043strict
stride75420963stride
strife95318363strife
strike105619733strike
string75327563string
strip77524343str_ip
stripe85822443stripe
striped105214363striped
strips85719653strips
stript85222193stript
stripy115812743stripy
strive95020963strive
strived114713663strived
strobes93813263strobes
strobic1138253strobic
strobil936963strobil
stroker114113523stroker
strokes114316323strokes
strolled937823strolled
strolls739183strolls
stromal93010593stromal
strophe1239143strophe
stropped1367343stropped
stroppy14205093stroppy
strouding1136373strouding
stroyer103510783stroyer
struck12489263struck
strudel835783str_udel
struma84313273struma
strumous1045733strumous
strums84716453strums
strung75213023strung
strunt64918913strunt
struts65616803struts
stub66221843st__ub
studs64415873st__uds
study94411793st__udy
stum65526023st__um
stun45623453st__un
stupid937593stupid
styed95815483st_yed
styled105613103styled
styloid1137553styloid
stylus9397463stylus
surd56433813sur__d
surfed103814463surfed
surged84118883surged
surround944503surround
surtout7411683surtout
sword95214123s_word
swoun84811493s_woun
swound10377633s_wound
synod9610283syno_d
syrup103010963syr_up
thou76722213_thou_
thoued10429003_thoued
thous86017263_thous
thud85613913_t_hud
toad55830183_t_oad
tod49457073_t_o_d
toed56137043_t_oed
told56132203_t_old
toroid7416013toroid
torous64319033torous
torus54329763_torus
tour45530383_t_our
tout46753823_t_out
trad55630913_tr_ad
tread64821703_tread
treed65626733_treed
trend64817453_trend
triad65217723_triad
tried65026913_tried
troak95213573_troak
trock114817603_trock
trode65322853_trode
trog57628213_tro_g
trogs67022603_trogs
trois57226093_trois
troke94821053_troke
troked114114583_troked
troll54416533_troll
tromp95815803_tromp
trona54118953_trona
trone55131863_trone
troop76417533_troop
trooz145016153_trooz
trop66833303_tro_p
trope75725803_trope
trot46351313_tro_t
troth85622203_troth
trots56629943_trots
trough108512033_trough
troupe84812433_troupe
trouped103910983_trouped
trouts66116633_trouts
trouty95211793_trouty
trove85221923_trove
trow78031423_tro_w
trowed104714653_trowed
trows88826183_trows
troy77429683_tro_y
troys86418613_troys
true46725853_tr_ue
trued65117693_trued
trug55720043_tr_ug
tryout9410763_tryout
unround8138503unround
untrod769853untro_d
viroid10411523viroid
vrouw11507343_vrouw
zeroed16409413zeroed

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.373479064.3
2DLD Change Limit1127164285.75319592.6
3Display Results4284280.1403057.1
 (SQL Overall)1786914286.26628517.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.