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

276 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
grappa1139644(None) 
grampa115010171grampa
grappas12357101grappas
agrapha1345132agrapha
crappy15446802crappy
frappe13286952frappe
gappy136212032g_appy
grama85620282gra_ma
gramma11499802gramma
gramp106218322gramp_
grampas12399252grampas
gramps114114272gramps
grana65722092gra_na
grandpa1135412grandpa
grape84824662gra_pe
grapes95123122grapes
grapey126012302grapey
graph115315612gra_ph
graphs124510152graphs
grapple12378002grapple
grapy115416432gra_py
grasp84814482grasp_
grasps9489252grasps
grippe115310322grippe
grippy14447762grippy
kappa13469742_kappa
nappa98511862_nappa
agraphia1445243agraphia
app76827603__app_
appal95315223__appal
apps86319693__apps
arepa75615563ar_epa
brahma1336193brahma
brava106414793bra_va
braza165214253bra_za
chuppa1543973chuppa
cramp115120693cramp_
cramps125615563cramps
crampy154710993crampy
crania82418433crania
crap85731843cra_p_
crape96128443cra_pe
craped116120523craped
crapes104727693crapes
crapola1136913crapola
crapped143912623crapped
crapper133913193crapper
crappie13298983crappie
craps95328643cra_ps
cuppa11398523_cuppa
drama85117413dra_ma
drape85319633dra_pe
draped105314363draped
draper94315693draper
drapes95419653drapes
drapey125010583drapey
drippy14445653drippy
flappy1654483flappy
fraena938063fraena
frap95925813fra_p_
frapped15318853frapped
frappes14328383frappes
fraps105620553fra_ps
gaga66625553g_a_ga
gala55635163g_a_la
galea64722933g_alea
gama77035523g_a_ma
gamba106018513g_amba
gamma106116103g_amma
gamp98833213g_amp_
gamps105323713g_amps
ganja131410003g_anja
gap67055613g_a_p_
gape75134513g_a_pe
gaped96123533g_aped
gaper86125123g_aper
gapes86030823g_apes
gapped124217123g_apped
gaps76042973g_a_ps
gapy106320913g_a_py
garda7316763g_arda
gasp76227333g_asp_
gasps85415483g_asps
gawp107618633g_awp_
gawps115911013g_awps
gloppy1454723gloppy
goanna736653goanna
graal64316503gra_al
graals74112913graals
grab75427613gra__b
grabby14336183grabby
graben9419723graben
grabs85719693gra_bs
grace85124543gra_ce
graced105217903graced
graces94523493graces
grad66829863gra__d
grade75126093gra_de
graded94919553graded
grader84919693grader
grades84926313grades
gradin83517483gradin
grads75625753gra_ds
gradual936943gradual
gradus84411223gradus
graft95327203gra_ft
grafts105013253grafts
graham1237853graham
grail64622873gra_il
grails77518783grails
grain65126253gra_in
grains74223093grains
grainy103914213grainy
gram77034583gra__m
gramas94317203gramas
grammar12406893grammar
grammas12499773grammas
gramme114210333gramme
grampus12356313grampus
grams85327313gra_ms
gran56335013gra__n
grand75122693gra_nd
grandad1038453grandad
grandam1139393grandam
grandma1136913grandma
grandpapa1552023grandpapa
grandpas1236003grandpas
grands84218243grands
grange83716203grange
granita82111303granita
granny104311163granny
granola837913granola
grans64832543gra_ns
grant64840023gra_nt
grants73722473grants
granum9310913granum
grapery13457953grapery
graphed1498473graphed
graphic1537353graphic
grapier103712603grapier
graplin1058443graplin
grapnel1035603grapnel
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
grasped11409063grasped
grasper10389793grasper
grass66125203gra_ss
grassy10619093grassy
grat55651283gra__t
grate64932883gra_te
grated84523923grated
grater74625443grater
grates75429893grates
gratin74520583gratin
gratis74819243gratis
graupel1034133graupel
grave94624873gra_ve
graved114818813graved
gravel105313823gravel
graven104513523graven
graver105018593graver
graves104624003graves
gravid113710983gravid
gravida12366563gravida
gravlax1842643gravlax
gravy125512113gra_vy
gray85329893gra__y
grayed115415643grayed
grayer106014543grayer
graylag1283113graylag
grayly13287963grayly
grays95621333gra_ys
graze155820053gra_ze
grazed174115913grazed
grazer164815763grazer
grazes164519643grazes
gringa838553gringa
grip76127023gr_ip_
gripe84622963gr_ipe
griped104114713griped
griper94114613griper
gripes94619873gripes
gripey124111203gripey
gripman1234463gripman
gripped13419343gripped
gripper124410713gripper
grippes124810373grippes
gripple12416613gripple
grips85520133gr_ips
gript85126173gr_ipt
gripy115115253gr_ipy
grope84821613gr_ope
groped107515053groped
groper94517253groper
gropes95220403gropes
group85413923group_
groups94210513groups
grump105115313grump_
grumps114510573grumps
grumpy14498153grumpy
guava938583gua_va
guppy135211273g_uppy
happy155813533_happy
kalpa114512193_kalpa
kapa106021293_ka_pa
kappas144410363_kappas
koppa13397293_koppa
napa66927263_na_pa
nappas105511613_nappas
nappe96114993_nappe
nappy126312333_nappy
pampa114913423_pampa
papa85827143_pa_pa
pappi84810893_pappi
pappy114713803_pappy
poppa8409893_poppa
prajna1535073prajna
preppy1235523preppy
prepupa1064023prepupa
raga55930813_ra_ga
raia46638383_ra_ia
raita54623073_raita
raja117918683_ra_ja
ralph1078743_ralph
ramp85934003_ramp_
ramps96224633_ramps
rap56261963_ra_p_
rape65041633_ra_pe
raped85334623_raped
raper74932753_raper
rapes75740723_rapes
raphae114311733_raphae
raphe104916423_raphe
raphia113511263_raphia
rapid86422033_rapid
rapped114122683_rapped
rappee103618673_rappee
rappel104211953_rappel
rappen103512713_rappen
rapper104621573_rapper
raps66247733_ra_ps
rapt67245313_ra_pt
rasp66029163_rasp_
rasps74316663_rasps
raspy106511703_raspy
raya75224823_ra_ya
repp85418743_repp_
repps95114343_repps
salpa75018353_salpa
sappy125413473_sappy
scrappy16234473scrappy
snappy1366103snappy
sradha1085333sradha
strappy14205263strappy
tapa65129143_ta_pa
tramp96319773tramp_
tramps105114453tramps
trampy13499253trampy
trap67532803tra_p_
trapan82412973trapan
trapes85024463trapes
trappean1244393trappean
trapped124512213trapped
trapper113912803trapper
traps75727483tra_ps
trapt76433393tra_pt
trauma838803trauma
trippy13457803trippy
urania62516123urania
wrap96821973wra_p_
wrapped15338023wrapped
wrapper14368333wrapper
wraps105617153wra_ps
wrapt105123183wra_pt
zappy21548943_zappy

Search took 6 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 Filter1786911127160.356501941.0
2DLD Change Limit1127162765.17321789.3
3Display Results2762760.0932967.7
 (SQL Overall)1786912765.62231784.2
 
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.