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

237 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
gram7703458(None) 
cram85635491cram
dram75832001dram
gam67060061g_am
glam76529341glam
grab75427611grab
grad66829861grad
grama85620281grama
gramp106218321gramp
grams85327311grams
gran56335011gran
grat55651281grat
gray85329891gray
grim76929421grim
grum75625081grum
pram85733491pram
ram56867271_ram
tram67034551tram
am411875562__am
arak86929572arak
arame75026622arame
arm58449622ar_m
arum66129032arum
bam78560142_bam
barm86739602barm
beam86939232beam
blam86131702blam
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
bream95121812bream
brim85629372brim
cam78058982_cam
cham115532312cham
clam86332292clam
crab85727672crab
crag75625302crag
cramp115120692cramp
crams96229152crams
crap85731842crap
craw97725262craw
cream95721352cream
dam67457042_dam
diram84419472diram
drab76226452drab
drag64825052drag
drama85117422drama
drams86025832drams
drat56247832drat
draw85623012draw
dray85428092dray
dream85120392dream
drum76521592drum
engram9310652engram
era35741502era_
eras45441502eras
exam132514622exam
farm95934532farm
flam96333292flam
foam97127172foam
foram105124932foram
frae75330472frae
frag85126272frag
frame105821802frame
frap95925812frap
frat75648542frat
fray105428902fray
from96923922from
gab67155992g_ab
gad57556652g_ad
gae46457702g_ae
gag57753632g_ag
gal46055512g_al
gama77035522g_ama
gamb96331842g_amb
game76644322g_ame
gamp98833212g_amp
gams76648882g_ams
gamy105427532g_amy
gan48060132g_an
gap67055612g_ap
gar47259902g_ar
garb75332672garb
gars55750742gars
gas48870252g_as
gat46880512g_at
gaum75726422gaum
gay76856492g_ay
gear55934972gear
gem66840222g_em
gerah9315302gerah
germ75428962germ
geum75424552geum
ghat86435282ghat
glad65624012glad
glams85822932glams
gleam86916732gleam
glim76026352glim
gloam86015942gloam
glom75424382glom
glum75825102glum
gnar56021382gnar
gnat56034432gnat
gnaw86515742gnaw
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
goral65125752goral
gorm75529392gorm
graal64316502graal
grabs85719692grabs
grace85124542grace
grade75126092grade
grads75625752grads
graft95327202graft
graham1237852graham
grail64622872grail
grain65126252grain
gramas94317202gramas
gramma11499802gramma
gramme114210332gramme
grampa115010172grampa
gramps114114272gramps
grana65722092grana
grand75122692grand
grans64832542grans
grant64840022grant
granum9310912granum
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grate64932882grate
grave94624872grave
gravy125512112gravy
grays95621332grays
graze155820052graze
great66034242great
gree56641562gree
grew85620262grew
grey85624042grey
grid65829612grid
grig65424772grig
grime85021322grime
grimy114312602grimy
grin55733722grin
grip76127022grip
grit55247242grit
groan65618422groan
groat65531972groat
grog65923342grog
grok95819682grok
groom85317982groom
grot55942052grot
grow86127302grow
grub77220082grub
grue55825712grue
grume86218162grume
grump105115312grump
guan55325582guan
guar56923292guar
gum67439532g_um
gym95719062g_ym
gyral94412782gyral
ham86363282_ham
harm95637792harm
ihram10310182ihram
imam81718332imam
jam126942522_jam
joram145816982joram
lam57666712_lam
loam65630482loam
nam55953392_nam
ogam75120032ogam
ogham1138252ogham
ora37250832ora_
orad56031692orad
oral47638122oral
pam77858392_pam
praam94815612praam
prams96125512prams
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
prim85132202prim
prom87631702prom
rad47662002_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
rami66034092_rami
ramp85934002_ramp
rams65950772_rams
ran38266622_ran
rap56261962_rap
ras37575392_ras
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
ream65841612ream
rem56150042_rem
rim56052272_rim
roam67132412roam
rom59855632_rom
rum56644642_rum
scam85932352scam
scram910621622scram
seam66645972seam
sham96436362sham
slam67737972slam
spam85930042spam
swam96329982swam
tam58663422_tam
team66238652team
trad55630912trad
tramp96319772tramp
trams75327672trams
trap67532802trap
tray77632592tray
trim65329522trim
warm95935672warm
wham125321692wham
wrap96821972wrap
yam87448992_yam
ziram163912892ziram

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.280638182.1
2DLD Change Limit298722370.84335435.3
3Display Results2372370.0465152.2
 (SQL Overall)1786912371.169152858.0
 
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.