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 “grampas” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

291 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
grampas1239925(None) 
gramas94317201gram_as
grammas12499771grammas
grampa115010171grampa_
gramps114114271gramp_s
grampus12356311grampus
grappas12357101grappas
cramps125615562cramp_s
dramas95814652dram_as
gamas85431362g_am_as
gambas115817512g_ambas
gammas115714692g_ammas
gamps105323712g_amp_s
grama85620282gram_a_
gramma11499802gramma_
grammar12406892grammar
grammars13345942grammars
grammes123611322grammes
gramp106218322gramp__
grams85327312gram__s
grandpas1236002grandpas
grapes95123122gra_pes
graphs124510152gra_phs
grappa11396442grappa_
grasps9489252grasp_s
grumps114510572grump_s
lampas106615952_lampas
pampas124913992_pampas
ramps96224632_ramp_s
tramps105114452tramp_s
abamps1236253abamp_s
agamas97413453agam_as
amas67746293__am_as
amias75831473__amias
amps86230343__amp_s
arames84622573aram_es
aramids102810513aramids
arepas85515703ar_epas
armadas1038173armadas
aromas81018613arom_as
asramas938303asram_as
brahmas1436733brahmas
bravas114913323bra_vas
brazas175812433bra_zas
camas96333523_cam_as
campos125217953_campos
camps116330263_camp_s
campus125213923_campus
champac1834953champac
champacs1934633champacs
champak2034493champak
champaks2134103champaks
champs154915683champ_s
clamps124515083clamp_s
compas125817063_compas
crambes1339963crambes
crambos1336783crambos
cramp115120693cramp__
cramped144712183cramped
crampit1338863crampit
crampits1436273crampits
crampon1336943crampon
crampons1436643crampons
crampy154710993cramp_y
crams96229153cram__s
crapes104727693cra_pes
craps95328643cra_p_s
crimps124613453crimp_s
crumps124514343crump_s
damps105220413_damp_s
drama85117413dram_a_
drams86025833dram__s
drapes95419653dra_pes
fracas11311993fra_cas
framers125113823framers
frames115119863fram_es
frappes14328383frappes
fraps105620553fra_p_s
frumps13479783frump_s
galas65731643g_a_las
galeas74618513g_aleas
gama77035523g_am_a_
gamay116419113g_am_ay
gamays126310913g_amays
gamba106018513g_amba_
gambes116318313g_ambes
gambias125010733g_ambias
gambs105721123g_am_bs
gamers94420833g_amers
games86238553g_am_es
gamins94420043g_amins
gamma106116103g_amma_
gamp98833213g_amp__
gams76648883g_am__s
gamuts958783g_amuts
ganjas14149113g_anjas
gapes86030823g_a_pes
gaps76042973g_a_p_s
gasps85415483g_asp_s
gawps115911013g_awp_s
gimps105915203g_imp_s
glamors1068113glamors
glams85822933glam__s
goannas836223goannas
graal64316503gra__al
graals74112913gra_als
grabens10367003grabens
grabs85719693gra__bs
graces94523493gra_ces
graders94716013graders
grades84926313gra_des
gradins93416233gradins
grads75625753gra__ds
gradual936943gradual
graduals1046203graduals
gradus84411223gra_dus
grafts105013253gra_fts
graham1237853gra_ham
grahams1335333grahams
grails77518783gra_ils
grains74223093gra_ins
gram77034583gram___
gramary1355903gramary
gramme114210333gram_me
grampuses1442973grampuses
grana65722093gra_na_
grandad1038453grandad
grandads1136553grandads
grandam1139393grandam
grandams1237123grandams
grandmas1236923grandmas
grandpa1135413grandpa_
grands84218243gra_nds
granges93516523granges
granitas92610223granitas
granolas938053granolas
grans64832543gra__ns
grants73722473gra_nts
grape84824663gra_p_e
grapey126012303gra_pey
graph115315613gra_p_h
grapple12378003grapple
grapples13348123grapples
grapy115416433gra_p_y
grasp84814483grasp__
grasped11409063grasped
grasper10389793grasper
graspers11338403graspers
grass66125203gra__ss
grasses84117343grasses
graters85419743graters
grates75429893gra_tes
gratins84119183gratins
gratis74819243gra_tis
graupel1034133graupel
graupels1133103graupels
gravels113611143gravels
gravers114515273gravers
graves104624003gra_ves
gravidas13285803gravidas
gravies11314093gravies
gravitas12316013gravitas
gravlaks1642423gravlaks
gravlax1842643gravlax
graylag1283113graylag
graylags1372983graylags
grays95621333gra__ys
grazers175112453grazers
grazes164519643gra_zes
gremial1039153gremial
gremials1136133gremials
grimes94619033grim_es
gringas938043gringas
gripes94619873gr_ipes
gripman1234463gripman
grippes124810373grippes
grips85520133gr_ip_s
gropes95220403gr_opes
groups94210513group_s
grumes94415553grum_es
grumous1086613grumous
grump105115313grump__
grumped13337333grumped
grumphy18443623grumphy
grumpish1643763grumpish
grumpy14498153grump_y
guavas1037163gua_vas
guimpes1245073guimpes
gummas114810513g_ummas
hamzas20119013_hamzas
kalpas124112943_kalpas
kapas116021733_ka_pas
kappas144410363_kappas
karmas123013733karm_as
lamas75532793_lam_as
lamias85020613_lamias
lampad114510033_lampad
lampads12477623_lampads
lamps95624833_lamp_s
limpas105513083_limpas
llamas888973llam_as
mamas95930773_mam_as
mambas125716243_mambas
mammas94616403_mammas
napas75924353_na_pas
nappas105511613_nappas
pampa114913423_pampa_
papas94927493_pa_pas
prajnas1635453prajnas
prams96125513pram__s
preamps1336613preamp_s
primas104418103prim_as
primps124711823primp_s
prompts1337473prompts
ragas65326063_ra_gas
raias54631123_ra_ias
raitas64417673_raitas
rajas127317723_ra_jas
ralphs1135373_ralphs
ramadas1039303_ramadas
ramal74622243_ram_al
ramblas112710263_ramblas
ramees84620893_ramees
ramets83517393_ramets
ramies84630463_ramies
ramonas9311093_ramonas
ramous8417113_ramous
ramp85934003_ramp__
rampage1237453_rampage
rampages1336673_rampages
rampant11312173_rampant
rampart11311993_rampart
ramparts1245583_ramparts
ramped114617903_ramped
rams65950773_ram__s
ramus76418283_ram_us
rapes75740723_ra_pes
raps66247733_ra_p_s
rasps74316663_rasp_s
rayas85922053_ra_yas
remaps105012873_remaps
romps94617543_romp_s
rumbas102512013_rumbas
rumps95922293_rump_s
rumpus10458893_rumpus
salpas85116923_salpas
sambas104219263_sambas
sampan102511893_sampan
sampans112411003_sampans
samps96124673_samp_s
scamps125014173scamp_s
shamas113717943sham_as
shammas14358723shammas
sradhas1176153sradhas
stamps105614023stamp_s
swamps135910263swamp_s
tampan102512323_tampan
tampans113310983_tampans
tamps95524083_tamp_s
tapas74627713_ta_pas
taramas9612703taram_as
tramcar1135593tramcar
tramcars1245233tramcars
tramels93812493tramels
tramp96319773tramp__
tramped124312433tramped
tramper113812163tramper
trampers123210393trampers
trampish1535653trampish
trample11299703trample
tramples122610203tramples
trampy13499253tramp_y
trams75327673tram__s
tramway1544863tramway
tramways1643723tramways
trapan82412973tra_pan
trapans92812463tra_pans
trapes85024463tra_pes
traps75727483tra_p_s
traumas938593traumas
trompes114111623trompes
tromps104911703tromp_s
trumps104611883trump_s
ulamas8910453ulam_as
uraemias1046043uraemias
uranias72113813uranias
uremias9249503uremias
vamps125415483_vamp_s
wampus13499013_wampus
wraps105617153wra_p_s
zamias174212923_zamias

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272915.78023188.1
3Display Results2912910.0933129.0
 (SQL Overall)1786912916.02929638.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.