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 “seams” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

309 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
seams7573166(None) 
beams95328171beams
reams75729621reams
scams94423971scams
seals54839691seals
seam66645971seam_
seamy105921271seamy
sears54744911sears
seas45755271sea_s
seats54844341seats
seems75525021seems
shams105829411shams
slams74927901slams
spams94922191spams
steams84916901steams
teams75726511teams
bams87044452_bams
beads85429502beads
beaks115326622beaks
beam86939232beam_
beamy126218572beamy
beans75734692beans
bears75739042bears
beats76042242beats
beaus75127112beaus
bemas96424282bemas
berms95323662berms
blams95023852blams
breams104815042breams
cams87047282_cams
chams126028502chams
clams95127672clams
crams96229152crams
creams104715252creams
dams77444372_dams
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
deems85421772deems
derms85022892derms
drams86025832drams
dreams94513982dreams
ears46356592_ears
eats47054872_eats
elms67322702_elms
ems56435492_e_ms
exams14199082exams
fears84829392fears
feats86432752feats
fems96428702fe_ms
flams105125012flams
fleams115011942fleams
foams105017952foams
gams76648882_gams
gears64628692gears
gems75329112ge_ms
germs85118872germs
geums85414112geums
glams85822932glams
gleams94812252gleams
grams85327312grams
haems105517012haems
hams96446132_hams
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
helms105619462helms
hems95534942he_ms
herms105626432herms
imams91511112imams
inseams9307902inseams
jams135231072_jams
jeans126022112jeans
keas86337092kea_s
lams66552262_lams
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lears55938732lears
leas45954182lea_s
loams75619862loams
meads85425322meads
meals75933372meals
means75831232means
meats75034052meats
mems85931502me_ms
neaps75618322neaps
nears55529422nears
neats55931902neats
neems77316292neems
nemas75321572nemas
neums75414252neums
ogams84112682ogams
pams85641762_pams
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pea_s
peats76140192peats
perms95524512perms
prams96125512prams
rams65950772_rams
reads64835272reads
realms84913492realms
reals55038652reals
ream65841612ream_
reaps75626192reaps
rearms85114652rearms
rears54739652rears
rems66237722re_ms
roams74919612roams
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
sals46851672s_als
same65245642s_ame
samp85733592s_amp
samps96124672s_amps
sans45153362s_ans
saps65346372s_aps
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scabs94818642scabs
scads85419962scads
scags85520972scags
scam85932352scam_
scamp115717312scamp
scamps125014172scamps
scans74625102scans
scars75433532scars
scats75930602scats
scrams105216622scrams
screams114810622screams
scums95017422scums
sea36161292sea__
seal45654372sea_l
seaman84015902seaman
seamed94823882seamed
seamen84518562seamen
seamer84223612seamer
seamers94719432seamers
sear47353842sea_r
seat47575562sea_t
sebums10369812sebums
secs65033892se_cs
sects75622892sects
sedans74816092sedans
sedums93910482sedums
seeds64330062seeds
seeks94724642seeks
seels55632822seels
seem65438562seem_
seeps74828752seeps
seers55136382seers
sees45361052se_es
segos64919482segos
segs54933882se_gs
seifs85019332seifs
seis45542392se_is
seism75019022seism
seisms84912142seisms
selahs9313212selahs
selfs85220242selfs
sells55134432sells
sels46345982se_ls
seme65836652se_me
semes75731582semes
semi65127222se_mi
semis74623532semis
sends65528242sends
sepals85217372sepals
septs75420602septs
seracs84418572seracs
serais64326132serais
seres55448892seres
serfs84922012serfs
sers45746652se_rs
serums83916302serums
sesame8311012sesame
sesames9310742sesames
sets45549502se_ts
setts55124322setts
sewans95215902sewans
sewars94018632sewars
sews75836022se_ws
sexes126126222sexes
sexts125118382sexts
shads95124482shads
shags95123862shags
shahs115919512shahs
sham96436362sham_
shamas113717942shamas
shame105726702shame
shames114726222shames
shamos114216982shamos
shamus114112812shamus
shawms14579562shawms
shaws116226262shaws
shays116021432shays
sheafs124912882sheafs
sheals94420642sheals
shears93820902shears
sheas86331792shea_s
shims104422552shims
sials54227242sials
simas75727552simas
sims65737172s_ims
skags104316072skags
skas85325712ska_s
skats94621542skats
skeans104512912skeans
skelms12368022skelms
skims114517192skims
slabs75322642slabs
slags66525902slags
slam67737972slam_
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slims75423652slims
slums74623432slums
smarms105712532smarms
smears84714432smears
snags64421312snags
snaps74719562snaps
snaws86116362snaws
sneaks104312492sneaks
sneaps84510862sneaps
soaks95220292soaks
soaps75120712soaps
soars54732512soars
somas76030372somas
soms66239372s_oms
spaes76029972spaes
spam85930042spam_
spans74528732spans
spars75431542spars
spas67036722spa_s
spasm94514172spasm
spasms10418972spasms
spats75031382spats
spays105520512spays
speaks125114582speaks
speans85417142speans
spears84019472spears
sperms102512602sperms
stabs76221382stabs
stags66226742stags
stamp95217362stamp
stamps105614022stamps
stars55836572stars
stats55933362stats
stays86022022stays
steads74116222steads
steaks104415852steaks
steals64020062steals
steam76322932steam_
steamy115112372steamy
stems75219952stems
streams94713372streams
stums75320082stums
sums65837582s_ums
swabs105817272swabs
swags94921252swags
swam96329982swam_
swami105614522swami
swamis114212292swamis
swamp125015322swamp
swamps135910262swamps
swamy136714402swamy
swans84625012swans
swaps104819202swaps
swarms116112172swarms
swats85726862swats
sways115518462sways
swears94114072swears
sweats94814612sweats
swims105514142swims
tams67247932_tams
teaks94222902teaks
teals56234132teals
team66238652team_
tears55436462tears
teas45851492tea_s
teats55636812teats
teems76019782teems
terms75523472terms
trams75327672trams
unseams9338912unseams
veals84926192veals
weals85428742weals
weans85326742weans
wears86030302wears
whams135515642whams
yams95330732_yams
yeahs115214552yeahs
yeans86624882yeans
years84527672years
yeas78638422yea_s
zeals145320852zeals

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit538003091.75030742.9
3Display Results3093090.0933322.6
 (SQL Overall)1786913092.15682880.8
 
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.