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

448 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
strands8371195(None) 
stands75118051st_ands
strand74514821strand_
brands95118942_brands
errands847602errands
grands84218242_grands
rands65930452__rands
sands65228582s__ands
sarans64224432saran_s
solands84412342solands
sprangs104610052sprangs
stand65923282st_and_
stanes64933402st_anes
stangs75018162st_angs
stanks104917702st_anks
steads74116222stea_ds
stounds8377822stounds
strafes104516002strafes
strains74218152strains
straits74916322straits
strakes114218072strakes
stranded102710812stranded
strander97112062strander
stranders10389932stranders
strang75718312stran_g
strange85416342strange
stranges94516762stranges
straps87721782stra_ps
strass67117222stra_ss
stratas73013582stratas
straths102711722straths
stratus73011732stratus
straws98718672stra_ws
strays96417932stra_ys
strings84617132strings
strouds837802strouds
strunts7429542strunts
tranks104017762_tranks
tranqs155210312_tranqs
trans54933042_tran_s
trends75513542_trends
alands75418373_alands
ands57833613___ands
astounds964233astounds
astrals75515243astra_ls
atmans84413963atman_s
attends8257593attends
bands85233423__bands
boranes93720403boranes
brads85528293_bra_ds
braids95015693_braids
brand85124493_brand_
brandy124712063_brandy
branks124817383_branks
brans75437433_bran_s
brants85723053_brants
burans85019303buran_s
cranes84330753_cranes
cranks125015313_cranks
demands114311413demands
desands94810163desands
elands74914773_elands
entrants8311753entrants
errand758793errand_
errants7410643errants
estrange9488893estrange
estranges10359983estranges
estrays10529403estra_ys
estrins7315853estrin_s
estrones8313323estrones
ethanes103713513ethanes
expands17195733expands
farads104713273fara_ds
francs114112193_francs
franks134912733_franks
frauds1036753_frauds
fronds106412343_fronds
furanes103214863furanes
furans94515953furan_s
garlands1038323garlands
gerunds935183gerunds
glands85314403_glands
gormands1266563gormands
grads75625753_gra_ds
grand75122693_grand_
grans64832543_gran_s
grants73722473_grants
grinds84511843_grinds
hands95327383__hands
hatbands1446293hatbands
heralds1137713heralds
inlands838783inlands
intrants8312863intrants
islands837323islands
jurants14379213jurants
lands65426903__lands
ligands9438983ligands
lorans65117603loran_s
marauds1037553marauds
misbrands1445153misbrands
norlands936443norlands
operands1146813operands
orangs74116033_orangs
ostracods1253843ostracods
ourangs8318503ourangs
outlands988563outlands
outranks12298823outranks
parangs104314373parangs
piranas9912603piranas
prangs94816233_prangs
pranks124814723_pranks
puranas9712643puranas
pyrans11411063pyran_s
rads56046603__ra_ds
raids65827513__raids
rand55839573__rand_
randy95022083__randy
ranids75118703__ranids
ranis55235833__ranis
ranks95225733__ranks
rants55935343__rants
relands85214883relands
remands104914883remands
rends65129953__rends
ribands10208393ribands
rinds64826143__rinds
robands10219863robands
rynds9569973__rynds
saids65328853s__aids
salads75316963sala_ds
sand55338473s__and_
sandy94221133s__andy
sanes55649073s__anes
sans45153363s__an_s
sarabands1245593sarabands
saran53730303saran__
sarapes94617753sarapes
sardanas937823sardanas
sards64736183s__ards
sarins63932623sarin_s
sarods74918573sar_ods
sarongs84511803sarongs
satangs8479713satangs
satraps95011643satra_ps
saturants946383saturants
savants1038653savants
scads85419963s_ca_ds
scalds94813693s_calds
scans74625103s_can_s
scants85219723s_cants
scends95213003s_cends
scrags95713803scra_gs
scrams105216623scra_ms
scrapes116217663scrapes
scraps106017243scra_ps
scrawls12177283scrawls
screeds106210293screeds
scrods94111613scr_ods
seastrands1143123seastrands
secants93413893secants
seconds1038283seconds
sedans74816093sedan_s
sends65528243s__ends
seracs84418573sera_cs
serails73318363serails
serais64326133sera_is
serapes95218103serapes
seraphs12408093seraphs
serenes73222903serenes
serines74229543serines
serins64029673serin_s
serranids1045533serranids
serranos857873serranos
servants1138003servants
sewans95215903sewan_s
shads95124483s_ha_ds
shandy134710033s_handy
shanks135315583s_hanks
shards104319173s_hards
sharns95516983sharn_s
shends105313773s_hends
shetlands1343743shetlands
shorans102812413shoran_s
shrank13359123shran_k
shreds105613053shr_eds
shrines104618693shrines
shrinks14397913shrinks
shrouds1136023shrouds
siganids1045303siganids
silanes72517163silanes
sirens65318153siren_s
skalds11437833s_kalds
skanks94710833s_kanks
skeanes113610713skeanes
skeans104512913skean_s
slangs75615343s_langs
slants64819083s_lants
smaragds1243303smaragds
soland75115043soland_
solanos74412853solanos
solans64122493solan_s
somans84619303soman_s
sonants7511233sonants
sopranos1046433sopranos
soras55041013sora__s
sords64527803sor__ds
sorings83817253sorings
sorns55028423sor_n_s
sounds74616183s_ounds
sovrans1036483sovran_s
sowans94215893sowan_s
spanks124514123s_panks
spans74528733s_pan_s
sparids103512123sparids
speans85417143spean_s
spends94714473s_pends
spirants1088283spirants
sprags95715823spra_gs
sprains93013593sprains
sprang95713523spran_g
sprats85819933spra_ts
sprawls12176373sprawls
sprays115913643spra_ys
spreads1039763spreads
springs104415923springs
sprints94113773sprints
squads164410293squa_ds
stabs76221383st_a_bs
stacks124317263st_acks
stade64825303st_a_de
stades74626243st_ades
staffs12349753st_affs
stages75629493st_ages
stags66226743st_a_gs
staid66722083st_aid_
staigs75414813st_aigs
stains64923653st_ains
stairs65416333st_airs
stakes103927293st_akes
stales65538293st_ales
stalks104614553st_alks
stalls64019933st_alls
stamps105614023st_amps
stance84316913st_ance
stances93715963st_ances
stanch113812373st_anch
standby1334423st_andby
standbys1443203st_andbys
standee83514513st_andee
standees93310143st_andees
stander84316163st_ander
standers93514303st_anders
standish1238543st_andish
standup1034353st_andup
standups1143963st_andups
stane55933003st_an_e
staned74824643st_aned
stang66424683st_an_g
stank95823303st_an_k
stanol6310723st_anol
stanols739733st_anols
stanza1537073st_anza
stanzas1636363st_anzas
stapes85028733st_apes
staphs114411033st_aphs
stared75429873stared_
starers74522313starers
stares66038753st_ares
starets73515923starets
starnose8136693starnose
stars55836573st_a_rs
starts65423123st_arts
starves104614553starves
stases64225563st_ases
stasis63116873st_asis
states64337083st_ates
stats55933363st_a_ts
status65515213st_atus
staves94525193st_aves
stays86022023st_a_ys
stead65520273stea_d_
steady103510203stea_dy
steaks104415853stea_ks
steals64020063stea_ls
steams84916903stea_ms
steeds73814883st_eeds
steins64818343stein_s
stenos63915773st_enos
stents65019453st_ents
sterns64616763stern_s
steroids9911443steroids
stewards1236383stewards
stings76220183st_ings
stinks105616833st_inks
stints65119763st_ints
stipends11304793stipends
stoas55126023stoa__s
stoats65117483stoa_ts
stones65130033st_ones
storages9311103storages
storaxes1536883storaxes
stound7399903stound_
straddle10186223straddle
straddles11216403straddles
strafe95215983stra_fe
strafed114413333strafed
strafer103912463strafer
strafers11379913strafers
strain64919573stra_in
strained9412253strained
strainer8512223strainer
strainers9510383strainers
strait64025893stra_it
strake104017393stra_ke
straked125415343straked
stramash1344573stramash
stranding1149653stranding
stranger94715103stranger
strangers104112163strangers
strangest103210843strangest
strangle98411503strangle
strangles103011553strangles
strap77925263stra__p
strappy14205263strappy
strasses81311443strasses
strata63616283stra_ta
stratal72710603stratal
strath93216373stra_th
strati63518903stra_ti
stratous8410703stratous
stratum9318253stratum
stratums10266803stratums
straw813321293stra__w
strawed114813613strawed
strawy1210312823stra_wy
stray88525573stra__y
strayed114513283strayed
strayer104312503strayer
strayers113510143strayers
streaks114411273streaks
streams94713373streams
streeks11378713streeks
streels73811343streels
streets73312613streets
streps86218063str_eps
stress66616673str_ess
strews96817103str_ews
striates83417083striates
stricks134310693stricks
stride75420963str_ide
strides84520393strides
strifes104716583strifes
strikes114719093strikes
string75327563strin_g
stringy114111073stringy
stripes95320573stripes
strips85719653str_ips
strives104119373strives
strobes93813263strobes
strode75215973str_ode
strokes114316323strokes
strolls739183strolls
strong74914883stron_g
strops86220383str_ops
stroud7310383stroud_
strows96718273str_ows
stroys95914603str_oys
strumas9419833strumas
strums84716453str_ums
strung75213023strun_g
strunt64918913strun_t
struts65616803str_uts
studs64415873st__uds
stuns54719493st_un_s
stunts65615253st_unts
stupids1035273stupids
styraxes1833493styraxes
styrenes11116623styrenes
subtrends1244063subtrends
summands1344713summands
sunlands936383sunlands
surahs94515543sura_hs
suras55336333sura__s
surds65624663sur__ds
sutras64818593sutra__s
swanks134811563s_wanks
swans84625013s_wan_s
swards105415133s_wards
swounds11405643swounds
syrens94911993syren_s
tads57143943_t_a_ds
tangs65028343_t_angs
tanks94624733_t_anks
tans46154823_t_an_s
tarns56433953_tarn_s
teinds738263_teinds
tends65425583_t_ends
tetrads82910193tetra_ds
thanes94918983_thanes
thanks134313133_thanks
titrants838483titrants
toads65621073_toa_ds
traces85329933_traces
tracks124818843_tracks
tracts85019073_tracts
trad55630913_tra_d_
trade65026043_tra_de
trades75724503_trades
tragus749233_tragus
traiks104013713_traiks
trails64622513_trails
trains64725343_trains
traits65121983_traits
tramps105114453_tramps
trams75327673_tra_ms
trance84718763_trance
trances93919643_trances
trank96222423_tran_k
tranny94210863_tranny
tranq145416893_tran_q
trapes85024463_trapes
traps75727483_tra_ps
trass56226473_tra_ss
traves94222743_traves
trawls94412393_trawls
trays85623433_tra_ys
treads74817923_treads
trend64817453_trend_
trendy10469603_trendy
triads74513533_triads
trines64132563_trines
trolands936423_trolands
tronas63816903_tronas
trones65629283_trones
truants738163_truants
trunks10429753_trunks
twangs10358093_twangs
tyrants1037453tyrants
unhands1137773unhands
uplands1036943uplands
upstands1144093upst_ands
uptrends1142833uptrends
veranda1156323veranda
verandas1246233verandas
viands1047813_viands
wands96425483__wands
wetlands1244763wetlands
wrangs104611913_wrangs

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.403443402.0
2DLD Change Limit1340274486.62620227.4
3Display Results4484480.1562871.8
 (SQL Overall)1786914487.18524870.0
 
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.