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

248 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
standees9331014(None) 
standee83514511standee_
standers93514301standers
grandees103211282grandees
sanders84025942s_anders
shandies122714102shandies
slanders94014012slanders
spandexes1943452spandexes
spondees1136482spondees
staddles10258692staddles
stades74626242sta_d_es
stances93715962stan_ces
stanches132312792stanches
standbys1443202standbys
stander84316162stand_er
stands75118052stand__s
standups1143962standups
stanes64933402stan__es
stanines85115672stanines
stapedes11197752stapedes
stranders10389932stranders
tandems1037632_tandems
attendees1044053attendees
awardees1243993awardees
banders104324563_banders
bandies104124863_bandies
bendees103913863_bendees
branders114313093branders
brandies11714563brandies
bystanders1642193bystanders
candies104125613_candies
candles104422343_candles
danders93921183_danders
dandies94121443_dandies
dandles94218533_dandles
fiancees1335103fiancees
ganders93521703_ganders
glanders103811503glanders
glandes95413833gland_es
grandee93115513grandee_
grantees92510973grantees
handers114224333_handers
handles114020653_handles
islanders1035283islanders
landers84026213_landers
meanders1168833meanders
panders103423733_panders
pandies104224503_pandies
randies84225663_randies
ranees64623963_ran_ees
saddens9309603s_addens
saddles95415743s_addles
sades65239893s_a_d_es
sadhes104715373s_a_dhes
sadness8310613s_adness
sandals82715203s_andals
sanded84920613s_and_ed
sander74828533s_and_er
sandhis1139993s_andhis
sandier84017843s_andier
sandiest93218683s_andiest
sandless93212343s_andless
sandmen1039413s_andmen
sandpeep1342963s_andpeep
sandpeeps1442083s_andpeeps
sands65228583s_and__s
sanes55649073s_an__es
sangers84421943s_angers
sanies63031953s_an_ies
sanseis73011603s_anseis
sarees65329943s_a_rees
scandals1136993scandals
scandent1148493scandent
scandias1137863scandias
scanners10379703scanners
scanties103215423scanties
seances93015343sean_ces
senders83022353s_enders
shaders115915553sha_ders
shades105924533sha_d_es
shannies113411253shannies
shanteys14395513shanteys
shanties113116583shanties
shindies122610503shindies
signees83510803sign_ees
skankers11316483skankers
slander84015443sland_er
slandered1137473slandered
slanderer1046673slanderer
slanderers1145143slanderers
solanders1036963solanders
sonders83820713s_onders
sondes74922873s_ond_es
sounders93214113sounders
spaders104214473spa_ders
spades94222583spa_d_es
spahees1238263spa_hees
spaldeen1142773spaldeen
spaldeens1241793spaldeens
spancels1245273spancels
spandex1735833spand_ex
spandrel1144063spandrel
spandrels1243253spandrels
spangles1138893spangles
spaniels1045963spaniels
spankers14369863spankers
spanless10247363spanless
spanners103710773spanners
spenders113211743spenders
spindles112710353spindles
spondee10310593spondee_
squanders1934443squanders
stabbers12268733stabbers
stabiles10311403stabiles
stablers103611153stablers
stables93219073sta_bles
stackers143413563stackers
stactes91914633sta_ctes
staddle9288093staddle_
stade64825303sta_d_e_
stadias8411113sta_dias
staffers14247083staffers
stagers84116673sta_gers
stages75629493sta__ges
staggers10379843staggers
staggies101210323staggies
stagnates1046733stagnates
staider83912613staid_er
staidest939803staidest
staidness1037033staidness
stainers83212173stainers
stainless9176493stainless
staithes1138953staithes
stakes103927293sta__kes
stales65538293sta__les
stalkers12369853stalkers
stamens93411483sta_mens
stammels12495563stammels
stammers123611523stammers
stampedes14315183stampedes
stampers124211603stampers
stance84316913stan_ce_
stanched14208903stanched
stancher13198813stancher
stanchers14206813stanchers
stanchest14218213stanchest
stand65923283stand___
standard1046253standard
standards1145203standards
standby1334423stand_by
standfast1343913standfast
standing103413633standing
standings11257153standings
standish1238543standish
standishes1445713standishes
standoff1543993standoff
standoffs1642673standoffs
standout948663standout
standouts1044983standouts
standpat1145723standpat
standpipes1543063standpipes
standup1034353stand_up
stane55933003stan__e_
staned74824643stan__ed
stanged94113843stan_ged
stangs75018163stan__gs
stanhopes1444453stanhopes
stanine73417073stanine_
stanks104917703stan__ks
stannites947023stannites
stannous846443stannous
stannums1043803stannums
stanols739733stan_ols
stanzaed1843873stanzaed
stanzas1636363stan_zas
stapes85028733sta__pes
staplers103111203staplers
staples93617213sta_ples
starches131912913starches
stardoms1136793stardoms
starers74522313sta_rers
stares66038753sta__res
starets73515923sta_rets
starkers123712393starkers
starless81610843starless
starlets81610083starlets
starnoses9157153starnoses
starters83714773starters
startles82111963startles
starvers11459643starvers
starves104614553sta_rves
stases64225563sta__ses
stashes103916173sta_shes
staters73922343sta_ters
states64337083sta__tes
statices102712343statices
statives112710793statives
statues74614903sta_tues
statures83711113statures
statuses8409543statuses
statutes8368893statutes
staunches1444603staunches
staves94525193sta__ves
stayers103813633sta_yers
steadies9311123steadies
stenches132110293stenches
stenoses8310443stenoses
stingers94012743stingers
stinkers123111133stinkers
stinters83312753stinters
stodges9309083st_odges
stoners74817953ston_ers
stones65130033ston__es
straddles11216403straddles
stranded102710813strand_ed
strander97112063strand_er
strands83711953strand__s
strangers104112163strangers
stranges94516763stran_ges
strangles103011553strangles
striders94412123striders
strides84520393strid_es
strudels934123strudels
studdies10207073studdies
studies82413863st_udies
stunners8277923stunners
sturdies92110273sturdies
sundaes8313093s_undaes
sunders84120053s_unders
sundews11398153s_undews
swaddles13296453swaddles
swindles12319503swindles
syndeses1245263s_yndeses
syndets1136113s_yndets
tandem9311403_tand_em
tangles83920043_tangles
tankers113416913_tankers
tanners74018393_tanners
tanrecs934823_tanrecs
tansies74521243_tansies
tardies84225863_tardies
tenders83719723_tenders
tinders84219173_tinders
tsades74310993tsa_d_es
vendees114011453_vendees
wanders114221333_wanders
whangees15275063whangees
zanders173015793_zanders

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.1561145455.1
2DLD Change Limit1461622487.17320376.7
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.42224075.9
 
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.