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

130 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
cwms1143957(None) 
cams87047281cams
cwm106815081cwm_
aims67738182aims
alms65834922alms
arms66137492arms
awes76037552awes
awls75926092awls
awns75324432awns
bams87044452bams
bums85934592bums
cabs86739422cabs
cads76144522cads
calms95222352calms
cam78058982cam_
camas96333522camas
came87648752came
cames97047312cames
camo85731752camo
camos95927612camos
camp106336452camp
camps116330262camps
cans65050852cans
caps87147892caps
cars67364762cars
cats66356342cats
caws96036112caws
cays95437672cays
cees65941592cees
cels65534972cels
ceps86125952ceps
cess65326052cess
chams126028502chams
chis95933312chis
chums125015832chums
cigs75625102cigs
cis57748032c_is
clams95127672clams
cobs87043142cobs
cods76848102cods
cogs77340032cogs
cols66553082cols
coma87134852coma
comas95833002comas
comb106632112comb
combs116122962combs
come87547702come
comes97246992comes
comp106731252comp
comps115526052comps
cons66057692cons
coos67456492coos
cops86751372cops
corms95626222corms
cors66656442cors
cos510270392c_os
coss66143492coss
cots68054842cots
cowls106922212cowls
cows97046642cows
coys97537242coys
crams96229152crams
cris66233432cris
crus65828482crus
cubs85832382cubs
cuds76730472cuds
cues65438982cues
culms95314192culms
cum76440162cum_
cups85430822cups
curs65645542curs
cuss65430612cuss
cuts65841152cuts
cyma116715842cyma
cymas126417882cymas
cyme119420372cyme
cymes1210118922cymes
dams77444372dams
dims75435022dims
doms76239572doms
elms67322702elms
ems56435492_ems
ewes76328702ewes
fems96428702fems
gams76648882gams
gems75329112gems
gums75030942gums
gyms107514592gyms
hams96446132hams
hems95534942hems
hims95230972hims
hums96831422hums
isms66213472isms
iwis77117012iwis
jams135231072jams
lams66552262lams
lums65734242lums
mems85931502mems
moms86539482moms
mums85732772mums
nims66226882nims
noms65636402noms
ohms95514032ohms
oms56337512_oms
owes75137102owes
owls76022932owls
owns76819582owns
pams85641762pams
poms87037742poms
rams65950772rams
rems66237722rems
rims65936302rims
roms67038962roms
rums64833472rums
scams94423972scams
scums95017422scums
sims65737172sims
soms66239372soms
sums65837582sums
swims105514142swims
tams67247932tams
toms68343492toms
twas76824082twas
twos76718022twos
vims95423312vims
was68767562_was
wis66552332_wis
wos66953532_wos
yams95330732yams
ywis105313102ywis

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298721301.65618038.6
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.95291542.5
 
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.