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

217 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
grappas1235710(None) 
grampas12399251grampas
grappa11396441grappa_
frappes14328382frappes
gramas94317202gra_mas
grammas12499772grammas
grampa115010172grampa_
gramps114114272gramp_s
grampus12356312grampus
grandpas1236002grandpas
grapes95123122gra_pes
graphs124510152gra_phs
grapple12378002grapple
grapples13348122grapples
grasps9489252grasp_s
grippes124810372grippes
kappas144410362_kappas
nappas105511612_nappas
agrapha1345133agrapha_
agraphias1545073agraphias
appal95315223__appal
appals104812943__appals
apps86319693__app_s
arepas85515703ar_epas
brahmas1436733brahmas
bravas114913323bra_vas
brazas175812433bra_zas
capias10318353_capias
chuppas1644123chuppas
cramps125615563cramp_s
crapes104727693cra_pes
crapolas1247403crapolas
crapped143912623crapped
crapper133913193crapper
crappers144011023crappers
crappie13298983crappie
crappies142911153crappies
crappy15446803crapp_y
craps95328643cra_p_s
cuppas12458593_cuppas
dramas95814653dra_mas
drapers105313353drapers
drapes95419653dra_pes
fracas11311993fra_cas
frappe13286953frapp_e
frapped15318853frapped
fraps105620553fra_p_s
galas65731643g_a_las
galeas74618513g_aleas
gamas85431363g_a_mas
gambas115817513g_ambas
gammas115714693g_ammas
gamps105323713g_amp_s
ganjas14149113g_anjas
gapers94520473g_apers
gapes86030823g_a_pes
gapped124217123g_apped
gappy136212033g_app_y
gaps76042973g_a_p_s
gasps85415483g_asp_s
gawps115911013g_awp_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
grama85620283gra_ma_
gramma11499803gramma_
grammar12406893grammar
grammars13345943grammars
grammes123611323grammes
gramp106218323gramp__
grams85327313gra__ms
grana65722093gra_na_
grandad1038453grandad
grandads1136553grandads
grandam1139393grandam
grandams1237123grandams
grandmas1236923grandmas
grandpa1135413grandpa_
grandpapas1651953grandpapas
grands84218243gra_nds
granges93516523granges
granitas92610223granitas
granolas938053granolas
grans64832543gra__ns
grants73722473gra_nts
grape84824663gra_p_e
grapery13457953grapery
grapey126012303gra_pey
graph115315613gra_p_h
graphed1498473graphed
graphic1537353graphic
graphics1645653graphics
grapier103712603grapier
grapiest112211923grapiest
graplin1058443graplin
graplins1148263graplins
grapnel1035603grapnel
grapnels1134393grapnels
grappled14336093grappled
grappler13336193grappler
grapplers14274303grapplers
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
gringas938043gringas
gripers104011463gripers
gripes94619873gr_ipes
gripman1234463gripman
grippe115310323gripp_e
gripped13419343gripped
gripper124410713gripper
grippers13358133grippers
gripple12416613gripple
grippy14447763gripp_y
grips85520133gr_ip_s
gropers104813853gropers
gropes95220403gr_opes
groups94210513group_s
grumps114510573grump_s
guavas1037163gua_vas
kalpas124112943_kalpas
kapas116021733_ka_pas
kappa13469743_kappa_
koppas14407603_koppas
lampas106615953_lampas
napas75924353_na_pas
nappa98511863_nappa_
nappes104515623_nappes
pampas124913993_pampas
papas94927493_pa_pas
pappus9408373_pappus
poppas93710713_poppas
prajnas1635453prajnas
prepupas1144133prepupas
ragas65326063_ra_gas
raias54631123_ra_ias
raitas64417673_raitas
rajas127317723_ra_jas
ralphs1135373_ralphs
ramps96224633_ramp_s
rapers84327183_rapers
rapes75740723_ra_pes
raphae114311733_raphae
raphes115117453_raphes
raphias123511083_raphias
raphis114014323_raphis
rapids94913893_rapids
rapped114122683_rapped
rappee103618673_rappee
rappees113611453_rappees
rappel104211953_rappel
rappels11448803_rappels
rappen103512713_rappen
rapper104621573_rapper
rappers113618443_rappers
raps66247733_ra_p_s
rasps74316663_rasp_s
rayas85922053_ra_yas
repps95114343_repp_s
salpas85116923_salpas
sradhas1176153sradhas
tapas74627713_ta_pas
tramps105114453tramp_s
trapan82412973tra_pan
trapans92812463trapans
trapes85024463tra_pes
trappean1244393trappean
trapped124512213trapped
trapper113912803trapper
trappers123711043trappers
trappose1245813trappose
trappous1246023trappous
traps75727483tra_p_s
traumas938593traumas
uranias72113813uranias
wrapped15338023wrapped
wrapper14368333wrapper
wrappers15306933wrappers
wraps105617153wra_p_s

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.403443402.0
2DLD Change Limit1340272175.91022678.0
3Display Results2172170.0762855.3
 (SQL Overall)1786912176.38927968.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.