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

289 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
slams7492790(None) 
blams95023851blams
clams95127671clams
flams105125011flams
glams85822931glams
lams66552261_lams
scams94423971scams
seams75731661seams
shams105829411shams
slabs75322641slabs
slags66525901slags
slam67737971slam_
slaps76025711slaps
slats55436901slats
slaws85222711slaws
slays85723681slays
slims75423651slims
slums74623431slums
spams94922191spams
alamo7418142alamo
alamos8415002alamos
alans55636172alans
alarms85913052alarms
alas46358122ala_s
almas76629772almas
alms65834922al_ms
alums75720602alums
balms95723922balms
bams87044452_bams
beams95328172beams
blabs95619632blabs
blahs105616512blahs
blam86131702blam_
blame95625492blame
blames105121862blames
blats75132502blats
blaws105620462blaws
calms95222352calms
cams87047282_cams
chams126028502chams
clads85722732clads
clags85621122clags
claims105211572claims
clam86332292clam_
clamp115517652clamp
clamps124515082clamps
clans75031012clans
claps95626182claps
class75525482class
claws106020832claws
clays105521332clays
crams96229152crams
dams77444372_dams
drams86025832drams
elans55527752elans
elms67322702el_ms
exams14199082exams
flabs105818642flabs
flags95321282flags
flam96333292flam_
flame105124442flame
flames114723692flames
flamy135217472flamy
flans85327972flans
flaps105621382flaps
flats86429742flats
flaws115920342flaws
flays116321052flays
fleams115011942fleams
foams105017952foams
gams76648882_gams
glads75620612glads
glam76529342glam_
glans65125832glans
glass65518132glass
gleams94812252gleams
glims87417672glims
gloams95210662gloams
gloms85219782gloms
glums84621422glums
grams85327312grams
halms105225212halms
hams96446132_hams
imams91511112imams
jams135231072_jams
kalams12310602kalams
labs67145122_labs
lacs66942482_lacs
lads56549132_lads
lags56546222_lags
lam57666712_lam_
lama66635292_lama
lamas75532792_lamas
lamb86832142_lamb
lambs95921412_lambs
lame66849292_lame
lames75445542_lames
lamp86233822_lamp
lamps95624832_lamps
laps66848872_laps
lars46956572_lars
las37281472_la_s
lass47444542_lass
lats45962702_lats
lavs76734152_lavs
laws76441682_laws
lays76043252_lays
llama799892llama
llamas888972llamas
loams75619862loams
lums65734242_lums
malms95021552malms
ogams84112682ogams
palms94921752palms
pams85641762_pams
plans75731272plans
plasm94114632plasm
plasms103711332plasms
plats75531372plats
plays106320772plays
plums94619952plums
prams96125512prams
psalms1045672psalms
rams65950772_rams
reams75729622reams
roams74919612roams
sabs66643742s_abs
sacs65739072s_acs
sags55948402s_ags
salaams997702salaams
salads75316962salads
salals65120082salals
salami8313102salami
salamis9313512salamis
sales56055592sales
salmi7815862salmi
salmis8514272salmis
salps74423242salps
sals46851672s_als
salts55431882salts
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
scums95017422scums
seals54839702seals
seam66645972seam_
seamy105921272seamy
sears54744912sears
seas45755272sea_s
seats54844342seats
seems75525022seems
selahs9313212selahs
shads95124482shads
shags95123862shags
shahs115919512shahs
sham96436362sham_
shamas113717942shamas
shame105726702shame
shames114726222shames
shamos114216982shamos
shamus114112812shamus
shawms14579562shawms
shaws116226262shaws
shays116021432shays
shims104422552shims
sials54227242sials
simas75727552simas
sims65737172s_ims
skags104316072skags
skas85325712ska_s
skats94621542skats
skims114517192skims
slab67133762sla_b
slack115021762slack
slacks124416532slacks
slag55934352sla_g
slain54923572slain
slake93724052slake
slakes104021882slakes
slaloms9106542slaloms
slang66324022slang
slangs75615342slangs
slank95822772slank
slant55238702slant
slants64819082slants
slap66434042sla_p
slash84719682slash
slat46959022sla_t
slate55438282slate
slates64934062slates
slaty86523152slaty
slave84224032slave
slaves95023022slaves
slaw77930712sla_w
slay76436382sla_y
sleds64418852sleds
slews86220352slews
slim66631962slim_
slime74925752slime
slimes84722042slimes
slimsy11407722slimsy
slimy105417422slimy
slips76023722slips
slits56128852slits
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slots54830532slots
slows85323462slows
slubs74719532slubs
slues54527172slues
slugs64618562slugs
slum65430512slum_
slump94816632slump
slumps104313582slumps
slurs54123372slurs
sluts54523982sluts
smarms105712532smarms
snags64421312snags
snaps74719562snaps
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soars54732512soars
solans64122492solans
solums85211332solums
somas76030372somas
soms66239372s_oms
spaes76029972spaes
spam85930042spam_
spans74528732spans
spars75431542spars
spas67036722spa_s
spasm94514172spasm
spasms10418972spasms
spats75031382spats
spays105520512spays
splats84817302splats
splays114910872splays
stabs76221382stabs
stags66226742stags
stamp95217362stamp
stamps105614022stamps
stars55836572stars
stats55933362stats
stays86022022stays
steams84916902steams
stems75219952stems
stums75320082stums
sums65837582s_ums
swabs105817272swabs
swags94921252swags
swam96329982swam_
swami105614522swami
swamis114212292swamis
swamp125015322swamp
swamps135910262swamps
swamy136714402swamy
swans84625012swans
swaps104819202swaps
swarms116112172swarms
swats85726862swats
sways115518462sways
swims105514142swims
tams67247932_tams
teams75726512teams
trams75327672trams
ulama7711472ulama
ulamas8910452ulamas
ulans54921302ulans
whams135515642whams
yams95330732_yams
ylems1039262ylems

Search took 4 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.610292936.1
2DLD Change Limit538002893.28016402.4
3Display Results2892890.0803612.5
 (SQL Overall)1786912893.97045010.3
 
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.