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

235 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
estrays1052940(None) 
estray95713331estray_
strays96417931_strays
ashtrays14534202ashtrays
astrals75515242astrals
astray95615542astray_
betrays12127822betrays
destroys1236692destroys
entraps9109762entraps
essays965652es_says
estral64716512estra_l
estrayed1236392estrayed
estreats839422estreats
estrins7315852estrins
estrous7712532estrous
estrums9208602estrums
estrus61912112estr_us
extras13310222extra_s
resprays1344712resprays
sprays115913642_sprays
stays86022022_st_ays
straps87721782_straps
strass67117222_strass
straws98718672_straws
stray88525572_stray_
stroys95914602_stroys
trays85623432__trays
affrays1644063affrays
amtracs1198883amtracs
arrays95311683_arrays
ashrams1236653ashrams
ashtray13805553ashtray_
assays977903as_says
astral66919283astra_l
australs8359533australs
bedstraws1542403bedstraws
beltways1683903beltways
besteads11307123besteads
bestrews1335603bestrews
bestrows1337043bestrows
betray111511443betray_
bewrays15145113bewrays
brays106723113__brays
centrals102712033centrals
cestas85018543cest_a_s
cesuras958693cesura_s
citrals91111673citrals
defrays1436113defrays
derays105514253_derays
destroy1138153destroy_
dextrans1695983dextrans
drays95819773__drays
dustrags1044943dustrags
ecstasy1252603ecst_asy
embays131408333e_mbays
endways1444443endways
engrams1038073engrams
enthrals11278903enthrals
entrails8310163entrails
entrain7313073entrain
entrains8312963entrains
entrant7318873entrant
entrants8311753entrants
entrap8710563entra_p
entreats839773entreats
entrees71813773entrees
entries71523163entries
entry82414263entr_y_
entryways1851473entryways
enwraps1284833enwraps
eras45441503e__ra_s
escarps11397373escarps
escars83913133es_cars
eschars1237183eschars
escrows1235803escrows
eskars10357593es_kars
espials937093espials
esprits938393esprits
essay867623es_say_
estate64719763est_ate
estates74520183estates
esteems935243esteems
esterase849483esterase
esterases949633esterases
esters64627733est_ers
estops84011223est_ops
estragon944793estragon
estragons1044653estragons
estrange9488893estrange
estranges10359983estranges
estraying1338293estraying
estreat7314813estreat
estrin6315923estr_in
estriol747553estriol
estriols856253estriols
estrone7413953estrone
estrones8313323estrones
estrual7367933estrual
estrum81810513estr_um
estruses838483estruses
estuary1034683estuary
etas46432273e_t_a_s
etnas54713933e_tna_s
eustasy1043873eust_asy
extra1239003extra__
extract16311013extract
extracts1747623extracts
extrados1645343extrados
eyras84715923e_yra_s
forays124813003_forays
frays116920103__frays
grays95621333__grays
hoorays13418373hoorays
hurrays13386153hurrays
jetways2094053jetways
kestrels1235813kestrels
leastways1542313leastways
matrass939403matrass
mistrals101212623mistrals
morays114613883_morays
neutrals846283neutrals
oestrins8312673oestrins
oestrous869923oestrous
oestrums10156473oestrums
oestrus7169583oestr_us
olestras846583olestra_s
orfrays1343533orfrays
osetras737323osetra_s
ospreys1233143ospreys
ostraca937823ostraca
ostraka1144833ostraka
outlays102610903outlays
outprays13236933outprays
outsays102710403outsays
peytrals1355493peytrals
portrays1345293portrays
prays105022433__prays
rays77642353___rays
resays93714153res__ays
respray1236503respray_
restarts8310873restarts
restorals978073restorals
restrain8311703restrain
restrains9311623restrains
restress82511773restress
ristras7311563ristra_s
sarans64224433_sarans
satays94411683_satays
satraps95011643satraps
says75942103_s__ays
scrags95713803_scrags
scrams105216623_scrams
scraps106017243_scraps
seaways13307513seaways
seracs84418573_seracs
serais64326133_serais
shays116021433_s_hays
slays85723683_s_lays
soras55041013_sora_s
spays105520513_s_pays
splays114910873_splays
sprags95715823_sprags
sprats85819933_sprats
spray106720063_spray_
stabs76221383_st_abs
stags66226743_st_ags
stares66038753_stares
stars55836573_st_ars
starts65423123_starts
stats55933363_st_ats
stay78333723_st_ay_
steads74116223_steads
steaks104415853_steaks
steals64020063_steals
steams84916903_steams
stoas55126023_stoa_s
stoats65117483_stoats
storeys10559653_storeys
strafe95215983_strafe
strafes104516003_strafes
strain64919573_strain
strains74218153_strains
strait64025893_strait
straits74916323_straits
strake104017393_strake
strakes114218073_strakes
strand74514823_strand
strands83711953_strands
strang75718313_strang
strap77925263_stra_p
strata63616283_strata
stratas73013583_stratas
strath93216373_strath
straths102711723_straths
strati63518903_strati
stratus73011733_stratus
straw813321293_stra_w
strawy1210312823_strawy
strayed114513283_strayed
strayer104312503_strayer
strayers113510143_strayers
streaks114411273_streaks
streams94713373_streams
streps86218063_streps
stress66616673_stress
strews96817103_strews
strips85719653_strips
strops86220383_strops
strows96718273_strows
stroy87720393_stroy_
strums84716453_strums
struts65616803_struts
sunrays1037083sunrays
surahs94515543_surahs
suras55336333_sura_s
sutras64818593sutra_s
sways115518463_s_ways
tetrads82910193tetrads
tetras63017623tetra_s
trams75327673__trams
trans54933043__trans
traps75727483__traps
trass56226473__trass
tray77632593__tray_
treys85018213__treys
troys86418613__troys
ultras6310193ultra_s
unstraps1045983unstraps
ventrals112910003ventrals
vestals104612333vest_als
vestas95916683vest_a_s
vestral104111013vestra_l
vestries11314053vestries
vestry1238623vestr_y_
yesterdays1751213yesterdays

Search took 7 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.390458182.1
2DLD Change Limit1340272355.83022989.2
3Display Results2352350.0932526.9
 (SQL Overall)1786912356.31328305.2
 
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.