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

458 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
strawy121031282(None) 
straw813321291straw_
straws98718671straws
stray88525571stra_y
astray95615542astra_y
estray95713332estra_y
satrapy12497932satrapy
scrawl11208092scrawl
scrawly15197192scrawly
scrawny15213942scrawny
screwy14659462screwy
sprawl11188062sprawl
sprawly15166042sprawly
spray106720062spra_y
stagy96618892st_agy
starry94911672starry
staw78627692st_aw_
stay78333722st_a_y
steady103510202steady
steamy115112372steamy
stewy116112062st_ewy
strafe95215982strafe
strain64919572strain
strait64025892strait
strake104017392strake
strand74514822strand
strang75718312strang
strap77925262stra_p
strappy14205262strappy
straps87721782straps
strass67117222strass
strata63616282strata
strath93216372strath
strati63518902strati
strawed114813612strawed
strays96417932strays
streaky14447812streaky
streamy12509482streamy
strew89220662strew_
strewn96710012strewn
strews96817102strews
stripy115812742stripy
strow88920572strow_
strown96812092strown
strows96718272strows
stroy87720392str_oy
trawl84915872_trawl
tray77632592_tra_y
airway1237693airway
array86317143arra_y
arrowy12288273arrowy
ashtray13805553ashtra_y
astral66919283astra_l
astrally1148883astrally
astrals75515243astrals
ataraxy1743983ataraxy
ataxy1537313at_axy
betray111511443betra_y
braky145015813_braky
braw94829563_braw_
brawl106217963_brawl
brawly144312353_brawly
brawn106018563_brawn
brawny144710603_brawny
braws106425193_braws
braxy175410893_braxy
bray95232903_bra_y
caraway1538133caraway
craw97725263_craw_
crawl104916713_crawl
crawly144610763_crawly
craws105723123_craws
crazy195511223_crazy
curacy1339593curacy
deray95024183dera_y
draw85623013_draw_
drawl95516013_drawl
drawly134910723_drawly
drawn95614243_drawn
draws95119373_draws
dray85428093_dra_y
estral64716513estra_l
estrays10529403estrays
estuary1034683estuary
faraway1645413faraway
flawy145913383_flawy
foray115023973fora_y
fray105428903_fra_y
grapy115416433_grapy
gravy125512113_gravy
gray85329893_gra_y
horary12310383horary
moray105423793mora_y
ostiary1036463ostiary
ostraca937823ostraca
ostraka1144833ostraka
piracy1339473piracy
prawn105312433_prawn
pray96331533_pra_y
racy95825683__racy
raw67252253__raw_
rawly115115833__rawly
raws75238213__raws
ray66361993__ra_y
sagy85327083s__agy
salary9515213salary
saran53730303sara_n
sarans64224433sarans
sarape84817573sarape
sarky125521783sar_ky
satay84718463sata_y
satrap86212553satra_p
satraps95011643satraps
saw68255353s__aw_
sawn75428163s__awn
saws75839483s__aws
say67264763s__a_y
scaly104718723s_caly
scarey115016983scarey
scarry116311183scarry
scary105222593s_cary
scrag85916173scra_g
scraggy14304583scraggy
scrags95713803scrags
scram910621623scra_m
scrams105216623scrams
scrap97120403scra_p
scrape105917573scrape
scrappy16234473scrappy
scraps106017243scraps
scrawls12177283scrawls
screaky16436223screaky
screw109318543screw_
screws115513893screws
scry96017763scr__y
seamy105921273s_eamy
seaway12309993s_eaway
senary93716073senary
sera46141393sera__
serac75925203sera_c
seracs84418573seracs
serai56830163sera_i
serail64222673serail
serais64326133serais
seral56336383sera_l
serape84818413serape
seraph114011163seraph
serow86720443serow_
serows96016393serows
serry84824123ser_ry
shady125416513s_hady
shaky154616843s_haky
shaly114322863s_haly
sharny124711833sharny
sharpy145211033sharpy
shaw108132553s_haw_
shawl116217573s_hawl
shawm135316153s_hawm
shawn116417613s_hawn
shaws116226263s_haws
shay107133343s_ha_y
shoaly124010773shoaly
showy145714013s_howy
shrank13359123shrank
shrew119720173shrew_
shrewd136810783shrewd
shrews129313923shrews
sinewy12667513sinewy
sirupy11377053sirupy
skyway1933343skyway
slaty86523153s_laty
slaw77930713s_law_
slaws85222713s_laws
slay76436383s_la_y
sleazy18267393sleazy
smarmy13629353smarmy
smarty115013793smarty
smeary114110803smeary
snaky125113913s_naky
snarky134210843snarky
snarly93815003snarly
snaw78923073s_naw_
snaws86116363s_naws
sneaky13427843sneaky
snowy115011563s_nowy
soapy106114783s_oapy
sora45746913sora__
soras55041013sora_s
sorely94618013sorely
sorry84618253sor_ry
spacy125415623s_pacy
sparky154511523sparky
sparry115111303sparry
spawn107811713s_pawn
spay96631663s_pa_y
splay105816043spla_y
sprag86418693spra_g
sprags95715823sprags
sprain83614863sprain
sprang95713523sprang
sprat76635973spra_t
sprats85819933sprats
sprawls12176373sprawls
sprays115913643sprays
sprucy13356323sprucy
spry96819123spr__y
spryly1435513spryly
squaw17368983squaw_
squawk22385373squawk
squaws18438783squaws
stab67329933st_a_b
stably113314123stably
stabs76221383st_abs
stack114421693st_ack
stade64825303st_ade
staff113817713st_aff
stag57332003st_a_g
stage65330193st_age
stagey105915583stagey
staggy115510393staggy
stags66226743st_ags
staid66722083st_aid
staig65519643st_aig
stain55727943st_ain
stair54719943st_air
stairway1462923stairway
stake95927533st_ake
stale55637103st_ale
stalk94518003st_alk
stalky13499303stalky
stall54722353st_all
stamp95217363st_amp
stand65923283st_and
stane55933003st_ane
stang66424683st_ang
stank95823303st_ank
staph104314653st_aph
star48037763st_a_r
starch113013203starch
starchy15286743starchy
stare54440263st_are
stared75429873stared
starer64027363starer
stares66038753stares
stark95425623st_ark
starkly14277033starkly
stars55836573st_ars
start55642313st_art
starts65423123starts
startsy10536703startsy
starve94613743starve
stash84916973st_ash
stat47352693st_a_t
state56237333st_ate
stats55933363st_ats
stave85324993st_ave
stays86022023st_ays
stead65520273stea_d
steads74116223steads
steak95219803stea_k
steaks104415853steaks
steal56125473stea_l
steals64020063steals
steam76322933stea_m
steams84916903steams
steely93612573steely
stemmy13417033stemmy
sternly1037853sternly
sternway1443153sternway
stew77525463st_ew_
stews85519143st_ews
stey76224413st__ey
sticky154711343sticky
stilly93714093stilly
stimy105114743st_imy
stingy105213203stingy
stinky134611073stinky
stithy12398213stithy
stoa45425913stoa__
stoae55024263stoa_e
stoai55417873stoa_i
stoas55126023stoa_s
stoat57135953stoa_t
stoats65117483stoats
stocky15369153stocky
stodgy11415733stodgy
stogey105811543stogey
stogy95414083st_ogy
stoney96217353stoney
stony85818643st_ony
storage8310473storage
storax1389783stora_x
storey95217613storey
stormy115510733stormy
story86723033st_ory
stoury9529943stoury
stow77325743st_ow_
stowaway1742643stowaway
stowp105614233st_owp
stows86622703st_ows
strafed114413333strafed
strafer103912463strafer
strafes104516003strafes
straggly13355563straggly
strains74218153strains
straitly1136563straitly
straits74916323straits
straked125415343straked
strakes114218073strakes
stramony1344933stramony
strands83711953strands
strange85416343strange
stratal72710603stratal
stratas73013583stratas
strategy1244363strategy
straths102711723straths
stratify1445703stratify
stratum9318253stratum
stratus73011733stratus
strawhat1445493strawhat
strawier1137493strawier
strawing122411623strawing
strayed114513283strayed
strayer104312503strayer
streak104613623streak
streaks114411273streaks
stream84717293stream
streams94713373streams
streek104111413streek
streel64214023streel
street64125773street
strep77120853str_ep
streps86218063streps
stress66616673stress
strewed115811343strewed
strewer104310413strewer
stria55723213str_ia
striae65422273striae
striata7379953striata
striate74218953striate
strick124813203strick
strict84821043strict
stride75420963stride
strife95318363strife
strike105619733strike
string75327563string
stringy114111073stringy
strip77524343str_ip
stripe85822443stripe
strips85719653strips
stript85222193stript
strive95020963strive
strobe84513813strobe
strode75215973strode
stroke105116173stroke
stroll6311603stroll
stroma84313073stroma
strong74914883strong
strook10410303strook
strop77422243str_op
stroppy14205093stroppy
strops86220383strops
stroud7310383stroud
strove95014793strove
strowed115312143strowed
stroys95914603stroys
struck12489263struck
strum75619453str_um
struma84313273struma
strums84716453strums
strung75213023strung
strunt64918913strunt
strut56030733str_ut
struts65616803struts
stubby1345043stubby
studly10397693studly
study94411793st_udy
stuffy15317083stuffy
stumpy13458133stumpy
sturdy1037043sturdy
sty66227313st___y
stymy13358293st_ymy
styrax1675243styra_x
subway1447073subway
sudary1038703sudary
sugary1039013sugary
sunray9310123sunra_y
sura45740293sura__
surah86823253sura_h
surahs94515543surahs
sural55931263sura_l
suras55336333sura_s
surely93816463surely
surety93515013surety
surfy115319473sur_fy
surgy95118523sur_gy
surly85124433sur_ly
surrey94414583surrey
survey124111673survey
sutra54217933sutra__
sutras64818593sutra_s
swamy136714403s_wamy
swarty125812383swarty
sway107128233s_wa_y
sweaty123710053sweaty
syrupy14285823syrupy
tardy94720463_tardy
tarry85422513_tarry
tarty86328183_tarty
taw610155453_t_aw_
tawny114713653_t_awny
taws75641593_t_aws
teary85124053_teary
thaw107521313_thaw_
thaws116515463_thaws
thewy146311853_thewy
thraw1110515923thraw_
thrawn12769423thrawn
thraws129211103thraws
toady96814343_toady
towy105325473_t_owy
trace75829613_trace
track114823013_track
tract75635713_tract
trad55630913_tra_d
trade65026043_trade
tragi64717173_tragi
traik95418203_traik
trail55126773_trail
train56529113_train
trait56940843_trait
tram67034553_tra_m
tramp96319773_tramp
trampy13499253_trampy
trams75327673_trams
tramway1544863_tramway
trank96222423_trank
tranny94210863_tranny
tranq145416893_tranq
trans54933043_trans
trap67532803_tra_p
traps75727483_traps
trapt76433393_trapt
trash86119763_trash
trashy12509053_trashy
trass56226473_trass
trave85223033_trave
trawley13317303_trawley
trawls94412393_trawls
trays85623433_trays
treaty94414353_treaty
trews86118893_trews
trey77228793_tr_ey
trow78031423_trow_
trows88826183_trows
troy77429683_tr_oy
truly84111553_truly
try66529673_tr__y

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.376475242.0
2DLD Change Limit1127164584.86023192.6
3Display Results4584580.1403271.4
 (SQL Overall)1786914585.37633238.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.