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

240 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
shrouds113601(None) 
shroud1038761shroud_
strouds837791strouds
beshrouds1543062beshrouds
enshrouds1342302enshrouds
sarods74918572saro_ds
schrods1337432schro_ds
scrods94111602scro_ds
serous65023562serou_s
shouts94017712sh_outs
shreds105613052shr_eds
shroffs1634352shroffs
shrouded1333592shrouded
shrubs11409212shr_ubs
shrugs10469162shr_ugs
sprouts949982sprouts
stroud7310382stroud_
aholds10469483ah_olds
aroids75118223_aroids
aurous64119263aurou_s
beshroud1443803beshroud_
broads94515143_broads
broods95416383_broods
byroads1335293byroads
cerous85821203cerou_s
chords125214633ch_ords
choroids1438683choroids
chorus115014763choru_s
chromas142512683chromas
chromes142914933chromes
chromos142610273chromos
clouds94612353_clouds
croups104312553_croups
crowds124910763_crowds
cruds85815853_cr_uds
droids84712583_droids
drouks1137123_drouks
earbuds1044633earbuds
enshroud1243093enshroud_
estrous7712533estrou_s
frauds1036753_frauds
fronds106412343_fronds
ghouls1036043gh_ouls
grounds9228303_grounds
groups94210513_groups
grouts75015613_grouts
hods87239863_h_o_ds
holds94623243_h_olds
hoods95124083_h_oods
hounds104413133_h_ounds
hours85422383_h_ours
hyoids1377673_hyoids
inroads837043inroads
khoums1594013kh_oums
marauds1037553marauds
ochrous1237933ochrou_s
ouds56430103___ouds
parous84024163parou_s
porous84419483porou_s
prods85523553_pro_ds
proud84615483_proud_
pushrods1443653pushro_ds
roads66523613__roads
rods56442063__ro_ds
roods65125283__roods
roues56039353__roues
rounds73615613__rounds
roups75118903__roups
routs57133413__routs
sajous13310583sajou_s
sapours93610613sapours
sarcoids1137803sarcoids
sarcous9312933sarcou_s
sards64736183sar__ds
sarod65325873saro_d_
sarode75317513saro_de
sarodes84216143sarodes
sarongs84511803sarongs
saros55238063saro__s
saroses73619333saroses
savours10389333savours
schrod1247883schro_d_
scolds95011233s_colds
scours84913583s_cours
scouts84817943s_couts
screeds106210283screeds
scrod85115063scro_d_
scrolls938063scrolls
scroops11288243scroops
scrotums1243963scrotums
scrouge1036353scrouge
scrouges1136683scrouges
scrubs104210313scr_ubs
scrums104614253scr_ums
scuds85116243s__cuds
seconds1038283seconds
serious73616283seriou_s
serosas7312663serosas
serows96016393sero_ws
serums83916303ser_ums
setous64917373setou_s
setouts74110333setouts
shads95124483sh__ads
shadufs1433673shadufs
shairds11216263shairds
shamus114112813shamu_s
shards104319173sh_ards
shauls94913113sh_auls
sheds96122703sh__eds
shends105313773sh_ends
sheols94614153sheo_ls
sherds105614723sh_erds
sheroots1137863sheroots
shields11538043shields
shlocks16317173shlocks
shlubs11386733sh_lubs
shmoes114612093shmo_es
shnooks1485573shnooks
shoals94215783sh_oals
shoats94117073sh_oats
shocks154414573sh_ocks
shod86225053sh_o_d_
shoddy1434533sh_oddy
shoed95723003sh_oed_
shoers94518323sh_oers
shoes85429653sh_o_es
shogis103810923sh_ogis
shogs95319703sh_o_gs
shoguns1134413shoguns
shojis16348473sh_ojis
shooed103916073shooed_
shooks134515623sh_ooks
shools94919003sh_ools
shoos84226353sh_o_os
shoots94619343sh_oots
shops104222893sh_o_ps
shorans102812403shorans
shored105723643shored_
shores94830403sh_ores
shorls94516193sh_orls
shorts95321733sh_orts
shotes95321893sh_otes
shots84730833sh_o_ts
shotts93614683sh_otts
should1038023sh_ould
shouldst1243393sh_ouldst
shout85433163sh_ou_t
shoves124919413sh_oves
shows115324573sh_o_ws
shoyus1265993sh_oyus
shred98125613shr_ed_
shrewd136810773shrewd_
shrews129313913shr_ews
shrieks14377673shrieks
shrifts1335963shrifts
shrikes144412393shrikes
shrills10389933shrills
shrimps14516753shrimps
shrines104618693shrines
shrinks14397913shrinks
shris84221443shr__is
shrives134416173shrives
shroff1538493shro_ff
shrouding1434743shrouding
shrove125412223shro_ve
shrub104814893shr_u_b
shrug94512513shr_u_g
shrunk13357063shr_unk
shuls85319713sh__uls
shuns85018143sh__uns
shutouts1143813shutouts
shuts85622473sh__uts
sirups83710533sir_ups
sloids73712693s_loids
slojds14345473s_lojds
sloyds10346293s_loyds
snoods74312443s_noods
snouts64915863s_nouts
sods54940213s__o_ds
sords64527803s__ords
soroses73117483soroses
sorosis72611963sorosis
sorus54527583sor_u_s
souks94820523s__ouks
souls55127363s__ouls
sounds74616183s__ounds
soups75322943s__oups
sours55230503s__ours
sous46947213s__ou_s
sparoids11218713sparoids
spheroids1545543spheroids
spouts85115113s_pouts
spreads1039763spreads
sprout8419403sprou_t
sprues84515763spr_ues
sprugs94010173spr_ugs
spuds85113673s__puds
steroids9911433steroids
stounds8377823s_tounds
stoups85313273s_toups
stours65015623s_tours
stouts65019003s_touts
strands83711953strands
strobes93813263strobes
strode75215973stro_de
strokes114316323strokes
strolls739183strolls
strops86220383stro_ps
strows96718273stro_ws
stroys95914603stro_ys
strums84716453str_ums
struts65616803str_uts
studs64415873s__tuds
suds56135293s___uds
surds65624663sur__ds
surrounds1043573surrounds
surtouts846203surtouts
swords104510793s_words
swounds11405643s_wounds
swouns9358243s_wouns
synods1077953syno_ds
syrups11277953syr_ups
thous86017253th_ou_s
threads11419953threads
throats104612173throats
throbs118311373thro_bs
throes97518673thro_es
thrones105715843thrones
throngs11508163throngs
through141647513through
throws129715233thro_ws
thrums11429123thr_ums
thuds95110133th__uds
thyroids1546003thyroids
toroids8310643toroids
torous64319023torou_s
trouts66116623_trouts
unrounds9145573unrounds
viroids1137923viroids
vrouws12494743_vrouws

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272407.26618445.8
3Display Results2402400.0763157.9
 (SQL Overall)1786912407.49823831.8
 
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.