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

266 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
crams9622915(None) 
cams87047281c_ams
chams126028501chams
clams95127671clams
crabs95421391crabs
crags85622571crags
cram85635491cram_
cramp115120691cramp
cramps125615561cramps
craps95328641craps
crass76328041crass
craws105723121craws
creams104715251creams
drams86025831drams
grams85327311grams
prams96125511prams
rams65950771_rams
scrams105216621scrams
trams75327671trams
araks94820882araks
arame75026622arame
arames84622572arames
arms66137492ar_ms
arums75517832arums
bams87044452_bams
barms96128462barms
beams95328172beams
blams95023852blams
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breams104815042breams
brims94721622brims
cabs86739422c_abs
cads76144522c_ads
calms95222352calms
cam78058982c_am_
camas96333522c_amas
came87648752c_ame
cames97047312c_ames
camo85731752c_amo
camos95927612c_amos
camp106336452c_amp
camps116330262c_amps
cans65050852c_ans
caps87147892c_aps
carats85929022carats
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
caroms105619572caroms
carps96932252carps
carrs75730852carrs
cars67364762c_ars
carts78946292carts
cats66356342c_ats
caws96036112c_aws
cays95437672c_ays
chads116122232chads
chais107530312chais
cham115532312cham_
champ145017962champ
champs154915682champs
chaos105622862chaos
chaps125326062chaps
charms135218842charms
chars105936642chars
chasm125518792chasm
chasms135513142chasms
chats105730092chats
chaws135022462chaws
chays135319742chays
chums125015832chums
clads85722732clads
clags85621122clags
claims105211572claims
clam86332292clam_
clamp115517652clamp
clamps124515082clamps
clans75031012clans
claps95626182claps
class75525482class
claws106020832claws
clays105521332clays
coals76129602coals
coats75635002coats
comas95833002comas
corals85325142corals
corms95626222corms
craal74117752craal
craals84113302craals
crab85727672cra_b
crack134120532crack
cracks144817002cracks
craft105327662craft
crafts115312742crafts
crag75625302cra_g
crake114823522crake
crakes124921812crakes
crambe1239072crambe
crambes1339962crambes
crambo1238042crambo
crambos1336782crambos
crampy154710992crampy
crane75331602crane
cranes84330752cranes
crank114819612crank
cranks125015312cranks
crap85731842cra_p
crape96128442crape
crapes104727692crapes
crases85532312crases
crash109120012crash
crasis85020472crasis
crate76537402crate
crates85736062crates
crave105626312crave
craves115825392craves
craw97725262cra_w
crawl104916712crawl
crawls114712082crawls
craze165221462craze
crazes174720132crazes
crazy195511222crazy
creaks124315962creaks
cream95721342cream_
creamy134811362creamy
creds85418772creds
creme94319322creme
cremes104517992cremes
cress75022832cress
crews105917492crews
cribs94516752cribs
cries75438402cries
crime94822692crime
crimes105521582crimes
crimp115615802crimp
crimps124613452crimps
cris66233432cr_is
crits75527572crits
croaks125812982croaks
crocs95722432crocs
crops96125232crops
cross75124502cross
crows105727312crows
cruds85815852cruds
crumb114313592crumb
crumbs12409232crumbs
crump115616422crump
crumps124514342crumps
crus65828482cr_us
culms95314192culms
cwms11439572c_wms
cyans105714812cyans
cymas126417882cymas
czars164812912czars
dams77444372_dams
dirams94413702dirams
drabs85119672drabs
drags75521112drags
dram75832002dram_
drama85117412drama
dramas95814652dramas
drats66628372drats
draws95119372draws
drays95819772drays
dreams94513982dreams
drums85415872drums
eras45441502era_s
exams14199082exams
farms106324952farms
flams105125012flams
foams105017952foams
forams115115912forams
frags96322172frags
frame105821802frame
frames115119862frames
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
gams76648882_gams
glams85822932glams
grabs85719692grabs
grads75625752grads
gram77034582gram_
grama85620282grama
gramas94317202gramas
gramp106218322gramp
gramps114114272gramps
grans64832542grans
grass66125202grass
grays95621332grays
hams96446132_hams
harms106829012harms
ihrams1137172ihrams
imams91511112imams
jams135231072_jams
jorams154810532jorams
lams66552262_lams
loams75619862loams
ogams84112682ogams
orals55826482orals
pams85641762_pams
praams10459642praams
pram85733492pram_
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prims95425932prims
proms95426412proms
rads56046602_rads
rags55448372_rags
rais45252622_rais
ram56867272_ram_
rami66034092_rami
ramp85934002_ramp
ramps96224632_ramps
ramus76418282_ramus
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
reams75729622reams
rems66237722_rems
rims65936302_rims
roams74919612roams
roms67038962_roms
rums64833472_rums
scams94423972scams
scrags95713802scrags
scram910621612scram_
scraps106017242scraps
screams114810612screams
scrims104615932scrims
scrums104614252scrums
seams75731662seams
shams105829412shams
slams74927902slams
spams94922192spams
tams67247932_tams
teams75726512teams
tram67034552tram_
tramp96319772tramp
tramps105114452tramps
trans54933042trans
traps75727482traps
trass56226472trass
trays85623432trays
trims75021472trims
warms107726852warms
whams135515642whams
wraps105617152wraps
yams95330732_yams
zirams17438642zirams

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.0762351197.4
2DLD Change Limit538002663.15617046.9
3Display Results2662660.1401900.0
 (SQL Overall)1786912663.37252992.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.