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

345 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
shroud103876(None) 
shrouds1136011shrouds
stroud7310381stroud
beshroud1443802beshroud
enshroud1243092enshroud
proud84615482_proud
sarod65325872saro_d
schrod1247882schro_d
scrod85115062scro_d
serous65023562serous
shod86225052sh_o_d
shoed95723002sh_oed
shooed103916072shooed
shored105723642shored
should1038022sh_ould
shout85433162sh_out
shred98125612shr_ed
shrewd136810772shrewd
shroff1538492shroff
shrouded1333592shrouded
shrove125412222shrove
shrub104814892shr_ub
shrug94512512shr_ug
sprout8419402sprout
strouds837792strouds
abroad9310943abroad
aground9216183aground
ahold94714253ah_old
aloud65018063_aloud
aroid65428333_aroid
around72712413_around
aurous64119263aurous
beshrouds1543063beshrouds
broad84817693_broad
brood84620243_brood
byroad1236623byroad
cerous85821203cerous
chord115917263ch_ord
chored125321883chored
choroid13311793choroid
chorus115014763chorus
chroma132912473chroma
chrome133214813chrome
chromed153510923chromed
chromo132811013chromo
chromy16309903chromy
cloud86716423_cloud
croup95616783_croup
crowd115815623_crowd
crud75219613_cr_ud
droid74218533_droid
drouk1039433_drouk
earbud936283earbud
enshrouds1342303enshrouds
estrous7712533estrous
fraud939863_fraud
frond95316343_frond
ghoul959053gh_oul
ground82310273_ground
group85413923_group
grout65330423_grout
hod76852463_h_o_d
hoed87837983_h_oed
hold86235063_h_old
hood85132333_h_ood
hound95016483_h_ound
hour75827313_h_our
hyoid12612423_hyoid
inroad737933inroad
khoum1476633kh_oum
loud55228043__loud
maraud938943maraud
ochroid1357903ochroid
ochrous1237933ochrous
oud47439073___oud
parous84024163parous
porous84419483porous
prod76129503_pro_d
pushrod1343703pushro_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
schrods1337433schrods
scold85414863s_cold
scored94621133scored
scour75315533s_cour
scout75031453s_cout
screed95718923screed
scried95817303scried
scrods94111603scrods
scroll8310163scroll
scroop10299773scroop
scrota8310183scrota
scrotum1145103scrotum
scrouge1036353scrouge
scrouged1235373scrouged
scrub94914203scr_ub
scrum95418193scr_um
scud76221283s__cud
second9411153second
sered65737293ser_ed
serged84118763serged
serious73616283serious
serosa6313023serosa
serow86720443sero_w
serows96016393serows
serum75223473ser_um
served104616813served
setous64917373setous
setout64719463setout
shad86230913sh__ad
shaded114518873shaded
shaduf1337063shaduf
shaird10288703shaird
shaled105023953shaled
shamed125120213shamed
shamus114112813shamus
shaped125020103shaped
shard96125963sh_ard
shared105829063shared
sharked153613903sharked
sharped134112043sharped
shaul85418103sh_aul
shaved135118383shaved
shawed134817233shawed
shed86536153sh__ed
shend94719973sh_end
sheol84318363sheo_l
sheols94614153sheols
sherd96321153sh_erd
sheroot10414373sheroot
shewed134716183shewed
shied96125493sh_ied
shield106212973shield
shined104620783shined
shirked153710463shirked
shirred113710493shirred
shlock15378183shlock
shlub105411743sh_lub
shmo95318093shmo__
shmoes114612093shmoes
shnook1366333shnook
shoal83920263sh_oal
shoat85633943sh_oat
shock144917023sh_ock
shoddy1434533sh_oddy
shoe75933433sh_o_e
shoer84722153sh_oer
shoes85429653sh_oes
shog86025133sh_o_g
shogi95013993sh_ogi
shogs95319703sh_ogs
shogun1045703shogun
shoji15419943sh_oji
shone83725973sh_one
shoo75929883sh_o_o
shook124920153sh_ook
shooks134515623shooks
shool84523143sh_ool
shooled115212653shooled
shools94919003shools
shoon84022003sh_oon
shoos84226353sh_oos
shoot84235893sh_oot
shoots94619343shoots
shop95629833sh_o_p
shops104222893sh_ops
shoran94016033shoran
shore85432643sh_ore
shores94830403shores
shorl84720243sh_orl
shorls94516193shorls
shorn85722173sh_orn
short85040523sh_ort
shorted113614393shorted
shorts95321733shorts
shorty124313193shorty
shot76150243sh_o_t
shote85526083sh_ote
shots84730833sh_ots
shott85332173sh_ott
shouted113911543sh_outed
shouts94017713sh_outs
shove114421033sh_ove
shoved134214273shoved
show106229183sh_o_w
showed135016963showed
shown115216473sh_own
shows115324573sh_ows
showy145714003sh_owy
shoyu1138903sh_oyu
shoyus1265993shoyus
shrank13359123shrank
shreds105613053shreds
shrew119720163shr_ew
shrewed14589843shrewed
shrews129313913shrews
shri76021693shr__i
shriek134211103shriek
shrift12413543shrift
shrike134513243shrike
shrill94712303shrill
shrimp13478763shrimp
shrine94920053shrine
shrined114112413shrined
shrink134511733shrink
shris84221443shr_is
shrive125216953shrive
shrived144712183shrived
shroffed1842553shroffed
shroffs1634353shroffs
shrouding1434743shrouding
shrubs11409213shrubs
shrugs10469163shrugs
shrunk13357063shrunk
shul75823153sh__ul
shun75122773sh__un
shut76137583sh__ut
shuted103913163shuted
shutout1048523shutout
siloed74615303siloed
sired66134283sir_ed
sirup74014913sir_up
sloid64619693s_loid
slojd13378843s_lojd
sloyd9409683s_loyd
snood64616163s_nood
snored74819543snored
snout54530633s_nout
sod46053703s__o_d
sold54837413s__old
soloed74515743soloed
sorbed94916513sorbed
sord56237203s__ord
sordid83411153sordid
sored66141783sor_ed
sorned74820043sorned
sorted74523713sorted
sorus54527583sor_us
sou37853693s__ou_
souk86127173s__ouk
soul46435713s__oul
sound64420023s__ound
soup66232913s__oup
sour45935893s__our
sous46947213s__ous
sparoid102311533sparoid
spheroid1447283spheroid
spiroid10219823spiroid
spored94821793spored
sporoid102310723sporoid
spout75029633s_pout
spread9312533spread
sprouted1136383sprouted
sprouts949983sprouts
sprue74717633spr_ue
sprug85313893spr_ug
spud75818493s__pud
steroid81314853steroid
stood65517713s_tood
stored75524213stored
stound7399903s_tound
stoup75517073s_toup
stour54916743s_tour
stout57434053s_tout
strand74514823strand
strobe84513813strobe
strode75215973strode
stroke105116173stroke
stroked124613623stroked
stroll6311603stroll
stroma84313073stroma
strong74914883strong
strook10410303strook
strop77422243stro_p
strops86220383strops
strove95014793strove
strow88920573stro_w
strowed115312143strowed
strown96812093strown
strows96718273strows
stroy87720393stro_y
stroyed114110863stroyed
stroys95914603stroys
strum75619443str_um
strut56030733str_ut
stud56220093s__tud
surd56433813sur__d
surfed103814463surfed
surged84118883surged
surround944503surround
surtout7411673surtout
sword95214113s_word
swoun84811493s_woun
swound10377633s_wound
synod9610283syno_d
syrup103010963syr_up
theroid11313393theroid
thou76722213th_ou_
thoued10429003th_oued
thous86017253th_ous
thread105011093thread
thro77726423thro__
throat94819753throat
throb109816853thro_b
throbs118311373throbs
throe89321423thro_e
throes97518673throes
throne98517603throne
throned115412173throned
throng10539973throng
through141647513through
throve128012393throve
throw118719733thro_w
thrown1214911443thrown
throws129715233throws
thru76818943thr_u_
thrum104713633thr_um
thud85613913th__ud
thyroid1438243thyroid
toroid7416013toroid
torous64319023torous
trod57627953_tro_d
trout57332573_trout
unround8138503unround
viroid10411523viroid
vrouw11507343_vrouw
whored135512123whored
zeroed16409413zeroed

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.283631417.0
2DLD Change Limit1127163456.79616585.6
3Display Results3453450.0933709.7
 (SQL Overall)1786913457.17224915.1
 
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.