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

274 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
samoyed133589(None) 
samoyeds1442661samoyeds
shamoyed1744041shamoyed
sambaed1238302sambaed
sampled123410792sampled
savored1158342savored
sayed96127142sa__yed
smoked134311722s_moked
stroyed114110862stroyed
vamosed1335922vamosed
aboded104912513_aboded
adored84714243_adored
alloyed11158033alloyed
amazed18519313_amazed
ambled115116373_ambled
amole75724593_amole_
amoles84122193_amoles
amped104820513_am_ped
amused94412513_amused
annoyed1185873annoyed
armored102610473armored
assayed1135593assayed
atoned75417543_atoned
avowed1335963_avowed
azoted16388593_azoted
bammed133913243bam_med
bayed115423023ba__yed
buoyed1236693_buoyed
cajoled17428283cajoled
caloyer1238143caloyer
cameoed1238383cameoed
camped134720233cam_ped
canoed94618963cano_ed
carboyed1637183carboyed
caroled103717693caroled
caromed123713623caromed
clamored1336953clamored
cloyed125111563_cloyed
coyed114623803__coyed
dadoed9449903dado_ed
damaged1257463damaged
dammed124214793dam_med
damned104212913dam_ned
damosel10126703damosel
damozel19184353damozel
damped124315583dam_ped
decoyed14358343decoyed
demoded123611123demoded
demoed103713443demo_ed
demoted114313543demoted
emoted94614923_emoted
enamored1147033enamored
enjoyed1834523enjoyed
fagoted1236073fagoted
famed115928343fam__ed
favored1455983favored
fayed126422153fa__yed
galoped11138083galoped
gambled134112163gambled
gamboled1435873gamboled
gamed95126393gam__ed
gammed124216163gam_med
gammoned1444993gammoned
gaoled84814503ga_oled
garoted9710133garoted
haloed104717603halo_ed
hamboned1637003hamboned
hammed144116973ham_med
hayed125822013ha__yed
humored1336723humored
jambed184811403jam_bed
jammed183811503jam_med
joyed164811833__joyed
kayoed14416903kayo_ed
labored102810253labored
lambed115614783lam_bed
lamed85235293lam__ed
lammed113915623lam_med
lamped114017543lam_ped
layed95127383la__yed
majored1735853majored
mamboed14417623mamboed
mameyes14376983mameyes
masoned1039803masoned
mayed115522403__mayed
mooed85123983__mooed
moped105424733__moped
moved114218153__moved
mowed113629013__mowed
named85223063nam__ed
osmosed10134843osmosed
paroled104217633paroled
payed115925933pa__yed
ployed124310563_ployed
rambled123913523rambled
rammed113117303ram_med
ramose8314403ramose_
ramped114617903ram_ped
rayed95127503ra__yed
razored1736333razored
removed134611313removed
rumored1046643rumored
sabbed114518083sa_bbed
sabed86526813sa__bed
sabered103213023sabered
sabred95916533sa_bred
sacked135525213sa_cked
sacred94917103sa_cred
saddled103112033saddled
sagged94120013sa_gged
sailed74327763sa_iled
sained75424243sa_ined
sainted84114243sainted
saiyid10167413sa_iyid
sallied83316953sallied
sallowed12149033sallowed
salmonid1147633salmonid
salted74121203sa_lted
saluted84511713saluted
salved103916423sa_lved
salvoed11307063salvoed
same65245643sam__e_
samek114915273sam__ek
samiel8313333sam_iel
samisen937673samisen
samite83020603samite_
samites93118713samites
samlet84126563sam_let
samosa8510203samo_sa
samosas939303samosas
samovar1244243samovar
sample104215013sample_
sampler113212013sampler
samples112815453samples
sanded84920613sa_nded
saned65636273sa__ned
sapote8314363sapote_
sapotes9313943sapotes
sapped114422013sa_pped
sarod65325873saro__d
sarode75317513sarode_
sarodes84216143sarodes
saroses73619333saroses
sashayed1543553sashayed
sashed105622943sa_shed
sassed76116173sa_ssed
sated66238533sa__ted
sauced93913303sa_uced
saunaed836703saunaed
sauted74119603sa_uted
sauteed8349613sauteed
savaged1236993savaged
saved95127113sa__ved
savorer1057883savorer
savoured1234793savoured
savoy114713883savoy__
savoys12427893savoy_s
savvied1433803savvied
sawed95628403sa__wed
sawyer12438043sa_wyer
sayeds10469253sa__yeds
sayer84926553sa__yer
sayid95516723sa__yid
sayyid13185353sa_yyid
scammed14479543scam_med
scamped144711963scam_ped
scooped124611753scooped
scooted103612283scooted
scoped115116663s_coped
scored94621133s_cored
scowed124413833s_cowed
seamed94823883seam__ed
seasoned948113seasoned
shadowed1644483shadowed
shambled16156153shambled
shamed125120213sham__ed
shammed153911423sham_med
shammied16265543shammied
shamoy14379913shamoy__
shamoys15367283shamoy_s
shampooed1742943shampooed
shmoes114612103shmo_es
shmoozed23254363shmoozed
shoed95723013s_ho_ed
shooed103916083s_hooed
shooled115212663shooled
shored105723653s_hored
shoved134214283s_hoved
showed135016973s_howed
siloed74615303silo_ed
sjamboked2541723sjamboked
skyed13529923s__kyed
slalomed1134283slalomed
slammed123511103slam_med
slayed104716223s_layed
sloped94216853s_loped
slowed104617073s_lowed
sloyd9409683s_loy_d
smacked163710993smacked
smarted105012613smarted
smashed133711223smashed
smiled93716433s_miled
smocked16398223s_mocked
smoke115015823s_moke_
smoker124311693s_moker
smokes124814343s_mokes
smokey15398653s_mokey
smote75820283s_mote_
snooded94110363snooded
snooked123711493snooked
snooled84513943snooled
snooped103711813snooped
snooted84213283snooted
snoozed173410133snoozed
snored74819543s_nored
snowed104613623s_nowed
soled65835173s__oled
soloed74515743solo_ed
sooted73922593s_ooted
sored66141783s__ored
sowed94933863s__owed
spammed14348523spam_med
spayed124213613s_payed
splayed13357813splayed
spoked134413893s_poked
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spoored104411293spoored
spored94821793s_pored
sprayed13398903sprayed
stamened1137633stamened
stamped124812813stam_ped
stayed104817273s_tayed
stoked114718293s_toked
stoled74521593s_toled
stomped124110533stomped
stoned75923143s_toned
stooged94310733stooged
stooked124312303stooked
stooled84313893stooled
stooped103813833stooped
stoped94721013s_toped
stored75524213s_tored
stowed105817203s_towed
strayed114513283strayed
stroked124613623stroked
strowed115312143strowed
stroyer103510783stroyer
styed95815483s__tyed
summed114014043sum_med
summoned1345723summoned
swamped15498443swam_ped
swayed133510263s_wayed
swooned11368593swooned
swooped13418753swooped
symboled1644493symboled
tabooed10267383tabooed
tabored102810563tabored
taloned8310223taloned
tamed85528513tam__ed
tamped114317043tam_ped
tamponed1336023tamponed
toyed96019803__toyed
tutoyed1133943tutoyed
unmoved13248903unmoved
vamoosed1443923vamoosed
vamose1159283vamose_
vamoses1239153vamoses
vamped144211013vam_ped
vapored1336923vapored
wagoned1256223wagoned
wambled153610753wambled

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.406440125.6
2DLD Change Limit1340272746.59620319.4
3Display Results2742740.0932946.2
 (SQL Overall)1786912747.09525185.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.