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

264 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
stranded10271081(None) 
strander97112061strander
branded114414102_branded
estranged11387662estranged
sanded84920612s__anded
standee83514512st_andee
stander84316162st_ander
staned74824642st_an_ed
stanged94113842st_anged
steaded92811672stea_ded
stounded10276212stounded
straddled12205022straddled
strafed114413332stra_fed
strained9412252strained
straked125415342stra_ked
strand74514822stran__d
stranders10389932stranders
strands83711952strand_s
strange85416342strange_
stranger94715102stranger
stranges94516762stranges
strangled11268982strangled
strapped1357822strapped
strawed114813612stra_wed
strayed114513282stra_yed
stringed102911872stringed
strunted957242strunted
traded85717682_tra_ded
tranced104414172_tranced
trended94011762_trended
abraded1138643abra_ded
arranged1036933arranged
astounded1143223astounded
astringed1145693astringed
attended1035763attended
banded105223173__banded
bradded12388713_bradded
braided114013213_braided
brander103915823_brander
brandied1259113_brandied
branned104311693_branned
brinded115112053_brinded
craned96121653_cran_ed
cranked143812843_cranked
demanded13348513demanded
deranged1137693deranged
desanded11227453desanded
entranced1247393entranced
estrange9488893estrange_
estranger10447843estranger
estranges10359983estranges
estrayed1236393estra_yed
expanded19145163expanded
franked153610053_franked
fronded12388863_fronded
garlanded1244693garlanded
graded94919553_gra_ded
grandad1038453_grandad
grandee93115513_grandee
grander93315873_grander
granted94715103_granted
grinded104210633_grinded
handed114919983__handed
heralded1335443heralded
islanded1035513islanded
landed84619243__landed
marauded1244333marauded
misbranded1644143misbranded
outranged11239043outranged
outranked14247863outranked
paraded114014263para_ded
pranced123714043_pranced
pranged114512553_pranged
pranked143712093_pranked
radded94716493__radded
raided85017703__raided
ranged84824313__ranged
ranked114620743__ranked
ranted74324703__ranted
relanded102410463relanded
remanded123011323remanded
rended84524103__rended
rinded84418983__rinded
sander74828533s__ander
saned65636273s__an_ed
scalded11409763s_calded
scanned104110893s_canned
scanted104114393s_canted
scended11329873s_cended
scragged1335823scragged
scrammed1555003scrammed
scrannel1044033scrannel
scraped124313133scra_ped
scrapped1556533scrapped
scrawled1445923scrawled
screeded1235643screeded
seconded1236353seconded
sended85121233s__ended
serenaded11215933serenaded
shaded114518873s_ha_ded
shanked153212123s_hanked
shredded1444063shredded
shrined114112413shrin_ed
shrouded1333603shrouded
skanked11338103s_kanked
slander84015443s_lander
slanged94112853s_langed
slanted83514743s_lanted
solander948123solander
sorned74820043sor_n_ed
sounded93214463s_ounded
spaded103816753s_pa_ded
spandex1735833s_pandex
spanked143111733s_panked
spanned104111223s_panned
speaned103411523spean_ed
spraddled14203463spraddled
sprained1138433sprained
sprawled1434523sprawled
sprayed13398903spra_yed
springed123911323springed
sprinted113411163sprinted
squadded2033843squadded
squander1835533squander
stabbed123510373st_abbed
stabled103514953st_abled
stacked143416123st_acked
stade64825303st_a_de_
stades74626243st_a_des
staffed14298283st_affed
staged84521563st_a_ged
stagged104212083st_agged
staider83912613st_aider
stained84215343st_ained
staked114621943st_a_ked
staled74728103st_a_led
stalked123811173st_alked
stalled83515683st_alled
stamped124812813st_amped
stance84316913st_ance_
stances93715963st_ances
stanched14208903st_anched
stand65923283st_an__d
standard1046253st_andard
standby1334423st_andby
standees93310143st_andees
standers93514303st_anders
stands75118053st_and_s
standup1034353st_andup
stane55933003st_an_e_
stanes64933403st_an_es
stanzaed1843873st_anzaed
stapled103613703st_apled
starched14199313starched
stared75429873st_a_red
starred85013453st_arred
started84217323st_arted
startled9208563startled
starved114911573st_arved
stashed113812493st_ashed
stated75427833st_a_ted
statued8459893st_atued
staved103918053st_a_ved
stayed104817273st_a_yed
steadied1036563steadied
steamed103712143stea_med
stewarded1443533stewarded
stinted82914193st_inted
stoned75923143st_on_ed
straddle10186223straddle
straddler11205113straddler
straddles11216403straddles
strafe95215983stra_fe_
strafer103912463stra_fer
strafes104516003stra_fes
straggled12296853straggled
strainer8512223strainer
straiten838613straiten
straiter8311783straiter
strake104017393stra_ke_
strakes114218073stra_kes
stranding1149653stranding
strang75718313stran__g
strangely1345413strangely
strangered1245413strangered
strangers104112163strangers
strangest103210843strangest
strangle98411503strangle
strangler10369473strangler
strangles103011553strangles
strapper1258093strapper
strasses81311443strasses
stravaged1444193stravaged
strawier1137493strawier
strayer104312503stra_yer
streaked13228453streaked
streambed1483333streambed
streamed11258903streamed
streeked13246153streeked
streeled9267863streeled
stressed9128543stressed
strewed115811343str_ewed
striated93414153striated
stridden1044273stridden
stride75420963str_ide_
strider84315723str_ider
strides84520393str_ides
stringer93812943stringer
striped105214363str_iped
stripped1357093stripped
strived114713663str_ived
strode75215973str_ode_
stroked124613623str_oked
strolled937813strolled
stronger9349693stronger
stropped1367343stropped
strowed115312143str_owed
stroyed114110863str_oyed
strudel835783str_udel
strummed1344473strummed
strutted946343strutted
studded10236873st_udded
stunned8358893st_unned
stunted83010403st_unted
surnamed1135113surnamed
swanked15359543s_wanked
swanned11358173s_wanned
swarded1238153s_warded
swounded13314563swounded
syringed13377583syringed
tandem9311403_t_andem
tanged84622493_t_anged
tanked113919293_t_anked
tanned75219953_t_anned
tended83819483_t_ended
thanked15469153_thanked
traced94821583_tra_ced
tracked143716133_tracked
trade65026043_tra_de_
trader75218763_tra_der
trades75724503_tra_des
traiked123310453_traiked
trailed83415673_trailed
trained84117203_trained
trammed123810713_trammed
tramped124312433_tramped
trance84718763_trance_
trances93919643_trances
transuded1145473_transuded
trapped124512213_trapped
trashed113514703_trashed
trawled113411523_trawled
treaded95014283_treaded
trindled10388693_trindled
trined74920713_trin_ed
truanted935373_truanted
trundled10306393_trundled
trunked12358413_trunked
twanged12387273_twanged
unbanded123010563unbanded
unbranded1336363unbranded
unhanded132910183unhanded
unranked1338563unranked
verandaed1443143verandaed

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622646.69021847.8
3Display Results2642640.1102400.0
 (SQL Overall)1786912647.23624694.7
 
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.