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

244 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
sunrays103708(None) 
sunray9310121sunray_
hurrays13386152hurrays
runways13134442runways
sprays115913642s_prays
strays96417932s_trays
subways1536162subways
sundaes8313092sundaes
sunnahs10326592sunnahs
sunnas63914562sunna_s
suntans72111732suntans
surahs94515542su_rahs
suras55336332su_ra_s
surras65919532surra_s
surreys10489442surreys
sutras64818592sutra_s
unlays93810492_unlays
unsays9399542_unsays
affrays1644063affrays
anurans73810553anurans
arrays95311683_arrays
ashtrays14534203ashtrays
auras55932563au_ra_s
bendays13327513bendays
betrays12127823betrays
bewrays15145113bewrays
brays106723113__brays
bunas75126573bun_a_s
bunraku1343433bunraku
bunrakus1441893bunrakus
bunyas11359433bunya_s
burans85019303bu_rans
buras74736303bu_ra_s
cuirass934973cuirass
cullays12347703cullays
currans9310613currans
defrays1436113defrays
derays105514253_derays
drays95819773__drays
dunams937833dun_ams
duras65727733du_ra_s
durras74713373durra_s
estrays10529403estrays
forays124813003_forays
frays116920103__frays
funerals1146453funerals
fungals11276783fungals
furans94515953fu_rans
grays95621333__grays
guanays1134953guanays
gunplays1442713gunplays
gurneys11406463gurneys
henrys12366103henr_ys
hoorays13418373hoorays
hunkeys17386193hunkeys
hurrahs13336773hurrahs
hurray12459913hurray_
inlays9389873_inlays
juntas134210503junta_s
jurats134213203ju_rats
lunars65012813lun_ars
lunas55025013lun_a_s
lungans8399053lungans
morays114613883_morays
mudras94212263mudra_s
murals84016763mu_rals
muras75329583mu_ra_s
murras84916013murra_s
murreys12367323murreys
nays75931593__n_ays
nongays11176533nongays
onlays9398713_onlays
orfrays1343533orfrays
outlays102610903outlays
outprays13236933outprays
outsays102710403outsays
prays105022433__prays
punas74826753pun_a_s
punkahs16284783punkahs
punkas123410673punka_s
punkeys16366493punkeys
quays174612043qu__ays
rays77642353___rays
runaways1442853runaways
runway12105973runway_
sabras85116363sabra_s
sacrals93311793sacrals
sandals82715203sandals
sangars83116253sangars
sangas75222653sanga_s
sanjaks1834963sanjaks
sansars73313913sansars
sarans64224433s_arans
sashays1336333sashays
satays94411683s_atays
satraps95011643satraps
saunas63915433saun_a_s
says75942103s___ays
scarabs1137293scarabs
scrags95713803s_crags
scrams105216623s_crams
scraps106017243s_craps
seaways13307513seaways
senary93716073senary_
sendals81912263sendals
sennas64214233senna_s
senoras72714953senora_s
senryu934493senr_yu
seracs84418573s_eracs
serais64326133s_erais
shays116021433s__hays
shnaps1148083shn_aps
shorans102812413shorans
sirrahs10377303sirrahs
sirras63814863sirra_s
skyways2043223skyways
slays85723683s__lays
snags64421313s_n_ags
snaps74719563s_n_aps
snares65329033s_nares
snarfs95113423s_narfs
snarks104815733s_narks
snarls64016873s_narls
snaws86116363s_n_aws
sneaks104312493s_neaks
sneaps84510863s_neaps
sonars64818973son_ars
soras55041013s_ora_s
sovrans1036483sovrans
spays105520513s__pays
spirals93212513spirals
splays114910873s_plays
sprags95715823s_prags
sprats85819933s_prats
spray106720063s_pray_
spurreys13364603spurreys
stays86022023s__tays
stingrays1342713stingrays
storeys10559653storeys
straps87721783s_traps
strass67117223s_trass
straws98718673s_traws
stray88525573s_tray_
stroys95914603s_troys
subahs114512383su_bahs
subas74724073su_ba_s
subbass1138033subbass
subrace11313003subrace
subraces12313033subraces
subway1447073subway_
succahs1435323succahs
sucrase9310343sucrase
sucrases10310253sucrases
sucres84218893sucr_es
sudary1038703sudary_
suers55128483suer__s
sugars7312423su_gars
sugary1039013sugary_
sukkahs1382703sukkahs
suldans8299723suldans
sulfas9311563sulfa_s
sultans72411833sultans
sumacs105512103su_macs
summas104313163summa_s
sunback1548153sunback
sunbath1236423sunbath
sunbaths1344383sunbaths
sunbeams1243963sunbeams
sunbows1236023sunbows
sundae7312873sunda_e
sunders84120053sunders
sundews11398153sundews
sundials946753sundials
sundogs947103sundogs
sundress936983sundress
sundries9312023sundries
sundrops1145823sundrops
sundry1057943sundry_
sunfast1038503sunfast
sunglass945093sunglass
sunkets113511283sunkets
sunlamp1144163sunlamp
sunlamps1243293sunlamps
sunland837473sunland
sunlands936383sunlands
sunless73013693sunless
sunna55016063sunna__
sunnah9369353sunna_h
sunns55017353sun__ns
sunny84917743sun_ny_
sunrise7310813sunrise
sunrises8310693sunrises
sunroof1047053sunroof
sunroofs1144763sunroofs
sunroom947013sunroom
sunrooms1045723sunrooms
suns45841903sun___s
sunsets72911573sunsets
suntan62613003sunta_n
sunups837263sun_ups
sunward1137653sunward
sunwards1236443sunwards
supra73614253supra__
sura45740293su_ra__
surah86823253su_ra_h
sural55931263su_ra_l
surds65624663su_r_ds
surfs85022543su_r_fs
surfy115319473su_rfy_
surges73924593su_rges
surgy95118523su_rgy_
surly85124433su_rly_
surname937603surname
surnames1037273surnames
surpass938283surpass
surra55521343surra__
surrey94414583surrey_
surveys13357573surveys
sutra54217933sutra__
suttas63813793sutta_s
sways115518463s__ways
syngas10368913synga_s
trays85623433__trays
tunas54224123tun_a_s
tundras857113tundra_s
unais53420773_un_ais
unarms839243_unarms
unary8315993_unary_
unaus53216573_un_aus
unbans81912623_unbans
unbars82113033_unbars
uncaps1039813_uncaps
undraws1136893_undraws
uneasy9278853_uneasy
unhats91110623_unhats
unjams1555703_unjams
unlay84613703_unlay_
unmans82211993_unmans
unrigs7159003_unrigs
unrips8199453_unrips
unsay83212843_unsay_
unwraps1255513_unwraps
usneas638333usnea_s
vouvrays1741373vouvrays

Search took 9 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.420425454.8
2DLD Change Limit1340272447.98616782.7
3Display Results2442440.0763210.5
 (SQL Overall)1786912448.48221067.1
 
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.