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

374 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
stroyer10351078(None) 
strayer104312501strayer
stroker114113521stroker
stroyed114110861stroyed
stroyers11388921stroyers
destroyer1344552destroyer
sprayer12369042sprayer
spryer11418532spr_yer
stayer94516482st_ayer
stoker104417622st_oker
stoner65823202st_oner
stooker113811732stooker
stooper93813192stooper
stoper84320102st_oper
storer64721672st_orer
stover94115642st_over
strafer103912462strafer
strayed114513282strayed
strayers113510142strayers
strewer104310412strewer
strider84315722strider
striker113714172striker
striper94514792striper
striver104315202striver
strobe84513812strobe_
strobes93813262strobes
strode75215972strode_
stroke105116172stroke_
stroked124613622stroked
strokers123910902strokers
strokes114316322strokes
stroller848182stroller
stronger9349692stronger
stropper1247762stropper
strove95014792strove_
strowed115312142strowed
stroy87720392stroy__
stroys95914602stroy_s
toyer84521552_t_oyer
trover95014662_trover
annoyer1095603annoyer
arrayer10136703arrayer
atoner64817193at_oner
betrayer1345643betrayer
brayer115315313_brayer
broker124314243_broker
caloyer1238143caloyer
caroler93816753caroler
coroner94218203coroner
coyer105222843__coyer
crower114117563_crower
crozer175112843_crozer
decoyer13348683decoyer
destroyed1445083destroyed
destroyers1443643destroyers
droner74717673_droner
drover104614593_drover
dryer95111463_dr_yer
enjoyer1744383enjoyer
enrober9218623enrober
estrayed1236393estrayed
estrogen946573estrogen
estrone7413953estrone_
estrones8313323estrones
forayer13368953forayer
foyer116416553__foyer
fryer115913433_fr_yer
grayer106014543_grayer
greyer104510093_greyer
grocer94212143_grocer
groper94517253_groper
grower104614933_grower
ironer64216453_ironer
kroner104612573_kroner
oyer75927653___oyer
partyer12337873partyer
prayer114815293_prayer
preyer114413733_preyer
prober104516073_prober
proper104319953_proper
proser84223463_proser
prover113819723_prover
prower114218123_prower
pryer104415313_pr_yer
roger64521413__roger
roper75431913__roper
rover85527373__rover
rower85430493__rower
samoyed1335893samoyed
sarkier113413313sarkier
sarode75317513sarode_
sarodes84216143sarodes
saroses73619333saroses
savorer1057883savorer
sawyer12438043s_awyer
sayer84926553s__ayer
scooper113812033scooper
scooter93312873scooter
scorer84818263s_corer
scorner9259763scorner
scoter83815483s_coter
scraper114513423scraper
screwer124410073screwer
scriber113910973scriber
serener73415763serener
serer55935513ser__er
serger73819743ser_ger
serovar1046143serovar
server94917713ser_ver
shoer84722163s_ho_er
shooter103013993shooter
shorter103515503shorter
shover124515993s_hover
shower124315113s_hower
shriver134712193shriver
shrove125412233shrove_
shyer114714783s__hyer
slayer93916333s_layer
sloper84615913s_loper
slower94016153s_lower
slyer85515123s__lyer
smoker124311693s_moker
snooker113910303snooker
snooper93511533snooper
snoozer16409193snoozer
snorer64316763s_norer
snorter74412663snorter
sober74822413s__ober
sooner64220463s_ooner
sorer56236593s__orer
sorner64720393sor_ner
soroses73117483soroses
sorrier72313733sorrier
sorrower1165043sorrower
sorter64425093sor_ter
sower85229313s__ower
spoofer12368723spoofer
spooler93711383spooler
sporter93616553sporter
sprayed13398903sprayed
sprayers13367053sprayers
sprier84119063spr_ier
sprucer11317683sprucer
stabber113610153stabber
stabler94014933stabler
stacker134416263stacker
staffer13299093staffer
stager74821343st_ager
stagger94212393stagger
stagier83513443stagier
staider83912613staider
stainer73614923stainer
staler64025823st_aler
stalker113912253stalker
stammer116013343stammer
stamper113714403stamper
stander84316163stander
stapler93913633stapler
starer64027363st_arer
starker114114693starker
starrier8279463starrier
starter73817883starter
startler8248793startler
starver104611993starver
stater64427563st_ater
stayed104817273st_ayed
stayers103813633st_ayers
stealer72913983stealer
steamer93313093steamer
steeper93812773steeper
steer55423863st__eer
steerer73113633steerer
stemmer113210183stemmer
stepper113010853stepper
sterner7411913sterner
sticker133515883sticker
stiffer13319393stiffer
stifler102911473stifler
stiller73414303stiller
stinger84314683stinger
stinker113313313stinker
stinter73614513stinter
stirrer7338233stirrer
stiver93915733st_iver
stoae55024263st_oae_
stocker133713083stocker
stogey105811543st_ogey
stoke94922513st_oke_
stoked114718293st_oked
stokers114515183st_okers
stokes104821793st_okes
stole54928813st_ole_
stoled74521593st_oled
stolen64315063st_olen
stoles63927673st_oles
stomper114111233stomper
stone55431183st_one_
stoned75923143st_oned
stoners74817953st_oners
stones65130033st_ones
stoney96217353st_oney
stonier72013793stonier
stooge73811663stooge_
stooged94310733stooged
stooges83611483stooges
stooked124312303stooked
stookers12449793stookers
stooled84313893stooled
stooped103813833stooped
stoopers103711303stoopers
stope74727243st_ope_
stoped94721013st_oped
stopers94217373st_opers
stopes84525893st_opes
stopover1344063stopover
stopper113012603stopper
store56333813st_ore_
stored75524213st_ored
storers75018683st_orers
stores65533663st_ores
storey95217613st_orey
storeyed1234643storeyed
storeys10559653storeys
storied8515163storied
stories7324273stories
stormed1039043stormed
stormier1036103stormier
story86723033story__
stour54916743st_o_ur
stoure64814943st_oure
stouter74012053stouter
stove85220253st_ove_
stovers103713733st_overs
stoves93818923st_oves
stowed105817203st_owed
strafe95215983strafe_
strafed114413333strafed
strafers11379913strafers
strafes104516003strafes
strainer8512223strainer
straiter8311783straiter
strake104017393strake_
straked125415343straked
strakes114218073strakes
strander97112063strander
stranger94715103stranger
strapper1258093strapper
strawed114813613strawed
strawier1137493strawier
stray88525573stray__
strays96417933stray_s
streaker12229483streaker
streamer10239513streamer
streek104111413str_eek
streeker12206643streeker
streel64214023str_eel
street64125773str_eet
strep77120853str__ep
strew89220663str__ew
strewed115811343strewed
strewers11409063strewers
striae65422273striae_
stricter1039423stricter
stride75420963stride_
striders94412123striders
strides84520393strides
stridor8467393stridor
strife95318363strife_
strifes104716583strifes
strike105619733strike_
strikers123611293strikers
strikes114719093strikes
stringer93812943stringer
stripe85822443stripe_
striped105214363striped
stripers103911593stripers
stripes95320573stripes
stripier1058863stripier
stripper1247123stripper
strive95020963strive_
strived114713663strived
striven103910753striven
strivers113911843strivers
strives104119373strives
strobic1138253strobic
strobil936963strobil
stroll6311603stro_ll
strolled937823strolled
strollers937553strollers
strolls739183strolls
stroma84313073stro_ma
stromal93010593stromal
strong74914883stro_ng
strook10410303stro_ok
strop77422243stro__p
strophe1239143strophe
strophes13310603strophes
stropped1367343stropped
stroppers1356713stroppers
stroppier1364453stroppier
stroppy14205093stroppy
strops86220383stro_ps
stroud7310383stro_ud
strouds837803strouds
strow88920573stro__w
strown96812093stro_wn
strows96718273stro_ws
stroying122410593stroying
strudel835783strudel
strummer1234783strummer
strutter846503strutter
studier82510053studier
stuffer13349793stuffer
stuiver10447083stuiver
stumper113610093stumper
stunner7349193stunner
sturdier9216963sturdier
stutter72911463stutter
stye76218973st__ye_
styed95815483st__yed
styes86316523st__yes
styler94013303st_yler
surer54833103sur__er
surfer93515883sur_fer
surfier102613543surfier
surger74320093sur_ger
surlier72915443surlier
swayer125210973s_wayer
swooner10358673swooner
swooper12389173swooper
thrower1386993thrower
toker95924913_t_oker
toner55336243_t_oner
tooler63818613_tooler
tooter64420803_tooter
toper75231023_t_oper
toter55932133_t_oter
tower85729203_t_ower
toyed96019803_t_oyed
toyers95516333_t_oyers
tracer84820233_tracer
trader75218763_trader
trier54328533_tr_ier
trimer85717153_trimer
triter65120593_triter
trocar848773_trocar
trode65322853_trode_
troffer13125863_troffer
troke94821053_troke_
troked114114583_troked
trokes104019263_trokes
troller73913173_troller
trone55131863_trone_
trones65629283_trones
trooper94210363_trooper
trope75725803_trope_
tropes84824353_tropes
trotter73312253_trotter
trouper93811433_trouper
trouser73812473_trouser
trove85221923_trove_
trovers103713323_trovers
troves94719113_troves
trowed104714653_trowed
trowel94211463_trowel
troy77429683_troy__
troys86418613_troy_s
truer54916643_tr_uer
tutoyer1033793tutoyer
tuyer85414293_t_uyer
twofer1234353_twofer
twyer11558523_t_wyer
tyer75323393_t__yer
wryer11489303_wr_yer

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 Filter1786911340270.423422437.4
2DLD Change Limit1340273747.04619021.7
3Display Results3743740.1402671.4
 (SQL Overall)1786913747.60923484.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.