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

396 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
astray9561554(None) 
ashtray13805551ashtray
astral66919281astral
estray95713331estray
stray88525571_stray
affray1534972affray
amtrac10109122amtrac
antra56521922antra_
antral65719412antral
array86317142a_rray
ashram1139052ashram
ashtrays14534202ashtrays
assay8710282as_say
astony9510522astony
astrally1148882astrally
astrals75515242astrals
austral73411512austral
betray111511442betray
estral64716512estral
estrays10529402estrays
gastral8329552gastral
pastry114913032pastr_y
satay84718462sat_ay
satrap86212552satrap
satrapy12497932satrapy
spray106720062_spray
stay78333722_st_ay
strap77925262_strap
straw813321292_straw
strawy1210312822_strawy
strays96417932_strays
stroy87720392_stroy
tray77632592__tray
wastry12388772wastr_y
aboral8314373aboral
abstract1249223abstract
acta69524803act_a_
actorly1246413actorly
actual8311023actual
actuary1245613actuary
aery77231683a_er_y
affrays1644063affrays
agora6914333agora_
agorae7511203agorae
agoras7613343agoras
airway1237693airway
airy75734153a_ir_y
alary86123443alar_y
allay85620393a_llay
altar55520643alt_ar
altars64518153altars
alway116113923a_lway
ambary134010543ambary
ambry123512103ambr_y
amoral8314633amoral
amtrack15107393amtrack
amtracs1198883amtracs
anergy10156863anergy
angary10311323angary
angry9310863angr_y
anorak1038923anorak
anta46839583ant_a_
antae56828293ant_ae
antas55432033ant_as
anthrax1757153anthrax
antiar6317173antiar
antigay1148223antigay
antre55224523antr_e
antres65021003antres
antrum8611313antrum
antsy85712793ant_sy
anural65714743anural
anuran64313243anuran
anyway1534803anyway
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
apery106517903aper_y
apiary113910383apiary
apteral9311523apteral
aptly105111813apt_ly
arak86929573a__rak
ariary94114203ariary
army96624183a__rmy
arras55626133a_rras
arrays95311683a_rrays
artal55525473art_al
artery9911453artery
artily92814713artily
artsy86012963art_sy
arty77531313a__rty
asana5315483asana_
asanas6514113asanas
asarum84610913asarum
asea46327183as_ea_
ashcan1135843ashcan
ashlar9338193ashlar
ashman1148383ashman
ashrams1236653ashrams
ashy107717353as__hy
asrama839193as_rama
assai5711543as_sai
assays977903as_says
aster55434893ast_er
asteria7316183asteria
asterias8317013asterias
astern64815813astern
asternal858323asternal
asters65631603asters
astheny1345293astheny
asthma11126563asthma
asthmas12117363asthmas
astir55517093ast_ir
astragal945623astragal
astrict9614793astrict
astride8311973astride
astute6310763astute
astylar10265063astylar
aswarm11107913aswarm
asyla839333asyla_
atap66722453a_t_ap
ataraxy1743983ataraxy
ataxy1537313a_taxy
atlas55821583a_tlas
atma68121773a_tma_
atman75520143a_tman
atmas75721013a_tmas
atomy107415193a_tomy
atony87218853a_tony
atopy106813393a_topy
atria56022343a_tria
atrial65418943a_trial
atrip75315753a_trip
attar56516693a_ttar
attars64515313attars
attract9511833attract
attrit6315753attrit
aura45836253a_ura_
aurae54128113a_urae
aural54428963a_ural
aurar54420253a_urar
auras55932563a_uras
australs8359533australs
autarky1444703autarky
aviary12338413aviary
away108024223a__way
aweary1237303aweary
awry107619683a_wr_y
bastard103012423bastard
bastardy14326003bastardy
betrays12127823betrays
bewray14147733bewray
bray95232903__bray
caltrap11297943caltrap
cantrap113310283cantrap
castaway1664573castaway
castrate10313863castrate
castrati1048643castrati
castrato1048523castrato
citral81113893citral
dastard9279703dastard
datary10310243datary
defray1337643defray
deray95024183_deray
destroy1138153destroy
diastral946993diastral
dray85428093__dray
dustrag945363dustrag
easterly11246643easterly
entrap8710563entrap
entry82414263entr_y
essay867623es_say
estrayed1236393estrayed
estreat7314813estreat
estrin6315923estrin
estrual7367933estrual
estrum81810513estrum
estrus61912113estrus
estuary1034683estuary
extra1239003extra_
extras13310223extras
foray115023973_foray
fray105428903__fray
gantry103810113gantr_y
gastraea954383gastraea
gastrea847223gastrea
gastreas957253gastreas
gastric1038633gastric
gastrin839833gastrin
gray85329893__gray
hastily133010663hastily
hasty115718763hast__y
hooray123011373hooray
hurray12459913hurray
jetway19105273jetway
lactary1237843lactary
lastly93310873last_ly
lustra6358893lustra_
lustral7339653lustral
mantra84116093mantra_
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
masterly13317653masterly
mastery124214323mastery
mistral91013643mistral
mitral81314323mitral
moray105423793_moray
nastily103011033nastily
nasty85717283nast__y
notary92310713notary
orfray1234393orfray
osetra667423osetra_
osetras737323osetras
osprey1134883osprey
osteal6312963osteal
ostia52315583ostia_
ostiary1036463ostiary
ostomy1137833ostomy
ostraca937823ostraca
ostraka1144833ostraka
outlay92711793outlay
outpray12268083outpray
outran63218893outran
outsay92611873outsay
paltry114910403paltr_y
pantry115014103pantr_y
partway1535923partway
pasta76624533past_a_
pastas85422873past_as
pastoral10310483pastoral
pastorly1345783pastorly
pastrami1246333pastrami
pastural1038413pastural
pasty105725053past__y
plastral1046913plastral
portray1237483portray
pray96331533__pray
rattrap945263rattrap
ray66361993___ray
respray1236503respray
retral64419743retral
retry84718083retr_y
ristra6310713ristra_
ristras7311563ristras
rostra6310933rostra_
rostral7311333rostral
rotary92411303rotary
sabra75317853sabra_
sabras85116363sabras
sacra74516993sacra_
sacral83414413sacral
salary9515213salary
saran53730303_saran
sarky125521783_sarky
sashay1238363sashay
satara6315533satara
sataras7315063sataras
satays94411683sat_ays
satiny93817983satiny
satraps95011643satraps
saury84317223saur_y
say67264763_s__ay
scary105222593_scary
scrag85916173_scrag
scram910621623_scram
scrap97120403_scrap
scry96017763_scr_y
sera46141393_sera_
serac75925203_serac
serai56830163_serai
seral56336383_seral
serry84824123_serry
shay107133343_s_hay
sistra639333sistra_
slay76436383_s_lay
sora45746913_sora_
soras55041013_soras
sorry84618253_sorry
spay96631663_s_pay
splay105816043_splay
sprag86418693_sprag
sprat76635973_sprat
sprays115913643_sprays
spry96819123_spr_y
stab67329933_st_ab
stag57332003_st_ag
stagy96618893_stagy
star48037763_st_ar
stare54440263_stare
stark95425623_stark
starry94911673_starry
stars55836573_stars
start55642313_start
stat47352693_st_at
staw78627693_st_aw
stays86022023_st_ays
stead65520273_stead
steady103510203_steady
steak95219803_steak
steal56125473_steal
steam76322933_steam
steamy115112373_steamy
stewy116112063_stewy
stey76224413_st_ey
stimy105114743_stimy
stoa45425913_stoa_
stoae55024263_stoae
stoai55417873_stoai
stoas55126023_stoas
stoat57135953_stoat
stogy95414083_stogy
stony85818643_stony
storax1389783_storax
storey95217613_storey
stormy115510733_stormy
story86723033_story
strafe95215983_strafe
strain64919573_strain
strait64025893_strait
strake104017393_strake
strand74514823_strand
strang75718313_strang
strappy14205263_strappy
straps87721783_straps
strass67117223_strass
strata63616283_strata
strath93216373_strath
strati63518903_strati
straws98718673_straws
strayed114513283_strayed
strayer104312503_strayer
streak104613623_streak
streaky14447813_streaky
stream84717293_stream
streamy12509483_streamy
strep77120853_strep
strew89220663_strew
stria55723213_stria
striae65422273_striae
strip77524343_strip
stripy115812743_stripy
strop77422243_strop
strow88920573_strow
stroys95914603_stroys
strum75619453_strum
strut56030733_strut
study94411793_study
sturdy1037043_sturdy
sty66227313_st__y
stymy13358293_stymy
styrax1675243_styrax
sunray9310123sunray
sura45740293_sura_
surah86823253_surah
sural55931263_sural
suras55336333_suras
surfy115319473_surfy
surgy95118523_surgy
surly85124433_surly
sutra54217933sutra_
sutras64818593sutras
sway107128233_s_way
tantra63713353tantra_
tantras73112093tantras
tastily103311643tastily
tasty84820313tast__y
tetra53417953tetra_
tetrad73612053tetrad
tetras63017623tetras
trad55630913__trad
tram67034553__tram
trap67532803__trap
trays85623433__trays
trey77228793__trey
troy77429683__troy
try66529673__tr_y
ultra539363ultra_
ultras6310193ultras
unstrap946783unstrap
usury887623usur_y
vastity1336203vastity
vastly12508723vast_ly
vasty116215923vast__y
vestral104111013vestral
vestry1238623vestr_y
votary12248333votary
washday1743383washday
washrag1444043washrag
wastery134610993wastery
wasteway1743313wasteway
wastrel1037553wastrel
wastrie101210303wastrie
yantra9449623yantra_
yantras10259003yantras

Search took 6 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.373479064.3
2DLD Change Limit1127163964.97022679.3
3Display Results3963960.1233219.5
 (SQL Overall)1786913965.46632691.4
 
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.