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

211 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
scams9442397(None) 
cams87047281_cams
scabs94818641scabs
scads85419961scads
scags85520971scags
scam85932351scam_
scamp115717311scamp
scamps125014171scamps
scans74625101scans
scars75433531scars
scats75930601scats
scrams105216621scrams
scums95017421scums
seams75731661seams
shams105829411shams
slams74927901slams
spams94922191spams
bams87044452_bams
beams95328172beams
blams95023852blams
cabs86739422_cabs
cads76144522_cads
calms95222352_calms
cam78058982_cam_
camas96333522_camas
came87648752_came
cames97047312_cames
camo85731752_camo
camos95927612_camos
camp106336452_camp
camps116330262_camps
cans65050852_cans
caps87147892_caps
cars67364762_cars
cats66356342_cats
caws96036112_caws
cays95437672_cays
chams126028502chams
clams95127672clams
crams96229152crams
cwms11439572_cwms
dams77444372_dams
drams86025832drams
escars83913132escars
exams14199082exams
flams105125012flams
foams105017952foams
gams76648882_gams
glams85822932glams
grams85327312grams
hams96446132_hams
imams91511112imams
jams135231072_jams
lams66552262_lams
loams75619862loams
ocas66729632oca_s
ogams84112682ogams
pams85641762_pams
prams96125512prams
rams65950772_rams
reams75729622reams
roams74919612roams
sabs66643742s_abs
sacks114228872sacks
sacs65739072s_acs
sags55948402s_ags
sals46851672s_als
same65245642s_ame
samp85733592s_amp
samps96124672s_amps
sans45153362s_ans
saps65346372s_aps
sass45035622s_ass
saws75839482s_aws
says75942102s_ays
scab85926712sca_b
scad75725772sca_d
scag76626892sca_g
scald84818122scald
scalds94813692scalds
scale74629142scale
scales84529312scales
scall74420372scall
scalls84218202scalls
scalp95217982scalp
scalps104315232scalps
scaly104718722scaly
scampi12469102scampi
scan65530452sca_n
scant79735072scant
scants85219722scants
scape96921842scape
scapes105122262scapes
scar66434202sca_r
scare75334462scare
scares85033002scares
scarf105427142scarf
scarfs114714682scarfs
scarp95724102scarp
scarps104718602scarps
scart76139772scart
scarts85321492scarts
scary105222592scary
scat65848372sca_t
scatt76030092scatt
scatts85914662scatts
scaup95515992scaup
scaups105411932scaups
scaur75814902scaur
scaurs85512052scaurs
schavs1436492schavs
schmo124510202schmo
schmos13379152schmos
scops95820192scops
scots74025912scots
scows106617802scows
scrags95713802scrags
scram910621622scram_
scraps106017242scraps
screams114810622screams
scrims104615932scrims
scrums104614252scrums
scuds85116242scuds
scum85924522scum_
scups95316652scups
scuts74522522scuts
seals54839702seals
seam66645972seam_
seamy105921272seamy
sears54744912sears
seas45755272sea_s
seats54844342seats
seems75525022seems
shads95124482shads
shags95123862shags
shahs115919512shahs
sham96436362sham_
shamas113717942shamas
shame105726702shame
shames114726222shames
shamos114216982shamos
shamus114112812shamus
shawms14579562shawms
shaws116226262shaws
shays116021432shays
shims104422552shims
sials54227242sials
simas75727552simas
sims65737172s_ims
skags104316072skags
skas85325712ska_s
skats94621542skats
skims114517192skims
slabs75322642slabs
slags66525902slags
slam67737972slam_
slaps76025712slaps
slats55436902slats
slaws85222712slaws
slays85723682slays
slims75423652slims
slums74623432slums
smarms105712532smarms
snags64421312snags
snaps74719562snaps
snaws86116362snaws
soaks95220292soaks
soaps75120712soaps
soars54732512soars
socas74026182soca_s
somas76030372somas
soms66239372s_oms
spaes76029972spaes
spam85930042spam_
spans74528732spans
spars75431542spars
spas67036722spa_s
spasm94514172spasm
spasms10418972spasms
spats75031382spats
spays105520512spays
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
whams135515642whams
yams95330732_yams

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.653273646.2
2DLD Change Limit538002111.70331591.3
3Display Results2112110.0464587.0
 (SQL Overall)1786912112.40274392.6
 
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.