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

223 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
grapple1237800(None) 
grappled14336091grappled
grappler13336191grappler
grapples13348121grapples
gripple12416611gripple
apple94517672__apple
crappie13298982crappie
cripple13378582cripple
dapple1138852_dapple
frappe13286952frapp_e
grabble12339642grabble
gracile102512602gracile
grackle14338892grackle
granule839472granule
grape84824662gra_p_e
grapnel1035602grapnel
grappa11396442grapp_a
grappas12357102grappas
grapplers14274302grapplers
graupel1034132graupel
grippe115310322gripp_e
rappee103618672_rappee
rappel104211952_rappel
ripple103413912_ripple
scrapple1434682scrapple
trample11299702trample
ample94720303__ample
appel94615893__appel
apples104315763__apples
applet105917433__applet
apply125111393__apply
arable81821003ara_ble
brabble10349973brabble
braille939713braille
bramble133710033bramble
brattle9249253brattle
carpale113414353carpale
chappie16298653chappie
crabapple1751183crabapple
crackle153611253crackle
cradle93313163cra_dle
crankle133610063crankle
crape96128443cra_p_e
crapola1136913crapola
crapped143912623crapped
crapper133913193crapper
crappier14288133crappier
crappies142911153crappies
crappy15446803crapp_y
crimple13408693crimple
crippled15336793crippled
crippler14826713crippler
cripples14298403cripples
croppie13278793croppie
crumple13368363crumple
dappled1336393_dappled
dapples1238993_dapples
drabble12238883drabble
draggle1056103draggle
drapable1377573drapable
drape85319633dra_p_e
example1844283example
fipple13329063_fipple
fragile1147843fragile
frapped15318853frapped
frappes14328383frappes
frazzle18305223frazzle
gabble113815723g_abble
gable85325523g_a_ble
gaggle93412623g_aggle
gale56347323g_a__le
gamble115417183g_amble
gape75134513g_a_p_e
gapped124217123g_apped
gappier12369843g_appier
gappy136212033g_app_y
garble94118453g_arble
gargle84215463g_argle
garpike1435093garpike
girasole984423girasole
graal64316503gra_al_
graals74112913gra_als
grabbled14327373grabbled
grabbler13377693grabbler
grabbles13339893grabbles
grace85124543gra__ce
graciles112511613graciles
grackles15309183grackles
gradable1238823gradable
gradate9511233gradate
grade75126093gra__de
gradine93317033gradine
grail64622873gra_il_
grails77518783gra_ils
gramme114210333gra_mme
gramp106218323gramp__
grampa115010173gramp_a
grampas12399253grampas
gramps114114273gramp_s
grampus12356313grampus
grandee93115513grandee
grandly1238743grandly
grange83716203gra_nge
granite82017083granite
grannie8310353grannie
granola837913granola
grantee83217133grantee
granules939933granules
grapelike1644663grapelike
grapery13457953grapery
grapes95123123gra_pes
grapey126012303gra_pey
graph115315613gra_p_h
graphed1498473graphed
grapheme1644013grapheme
graphic1537353graphic
graphite1447153graphite
graphs124510153gra_phs
grapier103712603grapier
graplin1058443graplin
grapline1138723grapline
grapnels1134393grapnels
grappling1544993grappling
grapy115416433gra_p_y
grasp84814483grasp__
graspable1444873graspable
grasped11409063grasped
grasper10389793grasper
grasps9489253grasp_s
grate64932883gra__te
gratine84719193gratine
graupels1133103graupels
grave94624873gra__ve
gravel105313823gravel_
graveled13417363graveled
gravels113611143gravels
gravely14469063gravely
gravure1134953gravure
grayly13287963gra_yly
grazable2036223grazable
graze155820053gra__ze
gribble12297273gribble
griddle1035503griddle
grille74315743gr_ille
gripe84622963gr_ip_e
gripped13419343gripped
gripper124410713gripper
grippes124810373grippes
grippier1355203grippier
grippy14447763gripp_y
gristle8169223gristle
grizzle16306113grizzle
grope84821613gr_op_e
groupie1045783groupie
grumble12349233grumble
gruntle8257053gruntle
guayule1142823guayule
hopple132910483_hopple
maple95521143_ma_ple
mayapple1741703mayapple
nappe96114993_napp_e
nappie104112263_nappie
nipple103410373_nipple
oracle84313293ora_cle
papule102212133_papule
popple92710983_popple
prattle9208833prattle
preapply1443303preapply
preppie1058093preppie
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramble104519973_ramble
rampole1139693_rampole
rankle103414883_rankle
rape65041633_ra_p_e
raphae114311733_raphae
raphe104916423_ra_phe
rapine85023083_rapine
rapped114122683_rapped
rappees113611453_rappees
rappeled1335003_rappeled
rappels11448803_rappels
rappen103512713_rappen
rapper104621573_rapper
raptly11338913_raptly
rassle63813203_rassle
rattle64717613_rattle
reapply1434323reapply
rimple103814583_rimple
rippled123110273_rippled
rippler113210103_rippler
ripples113513293_ripples
ripplet113412583_ripplet
ripply13348003_ripply
rumple103913013_rumple
sample104215013_sample
scrapples1534793scrapples
staple84415823sta_ple
stipple1146623stipple
stopple1156583stopple
supple10410203_supple
swipple1444633swipple
tipple103411913_tipple
topple104411323_topple
trachle12311853trachle
traipse935873traipse
trampled13247903trampled
trampler12278013trampler
tramples122610203tramples
trapeze1836253trapeze
trapped124512213trapped
trapper113912803trapper
trappose1245813trappose
triple84215923tr_iple
wrangle1137383wrangle
wrapped15338023wrapped
wrapper14368333wrapper
wrassle10357173wrassle
wrastle10368993wrastle

Search took 8 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.436409841.7
2DLD Change Limit1340272236.73619897.1
3Display Results2232230.0762934.2
 (SQL Overall)1786912237.24824653.8
 
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.