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

219 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
grappled1433609(None) 
grapple12378001grapple_
grappler13336191grappler
grapples13348121grapples
crapped143912622crapp_ed
crippled15336792crippled
dappled1336392_dappled
frapped15318852frapp_ed
gapped124217122g_app_ed
grabbled14327372grabbled
graphed1498472gra_phed
grapplers14274302grapplers
grasped11409062grasp_ed
graveled13417362graveled
gripped13419342gripp_ed
gripple12416612gripple_
rapped114122682_rapp_ed
rappeled1335002_rappeled
rippled123110272_rippled
trampled13247902trampled
trapped124512212trapp_ed
wrapped15338022wrapp_ed
apple94517673__apple_
apples104315763__apples
applet105917433__applet
applied1247483__applied
brabbled12337633brabbled
brailed103914013bra_iled
brailled1147193brailled
brambled15316723brambled
brattled11196723brattled
brawled133910123bra_wled
capped134721853_capp_ed
chapped172711443chapp_ed
clapped143511173clapp_ed
craaled10339423cra_aled
crackled17428863crackled
cradled113410813cra_dled
cramped144712183cramp_ed
crankled15408153crankled
craped116120523cra_p_ed
crapper133913193crapp_er
crappie13298983crappie_
crappier14288133crappier
crappies142911153crappies
crawled133710393cra_wled
crimpled15366933crimpled
cripple13378583cripple_
crippler14826713crippler
cripples14298403cripples
cropped143812063cropp_ed
crumpled15296873crumpled
dapped124516763_dapp_ed
dapple1138853_dapple_
dapples1238993_dapples
drabbled14367053drabbled
draggled1254673draggled
draped105314363dra_p_ed
drawled12368343dra_wled
dripped13408083dripp_ed
dropped13329283dropp_ed
exampled2043353exampled
flapped15328253flapp_ed
frappe13286953frapp_e_
frappes14328383frapp_es
frazzled20303993frazzled
gabbled134112453g_abbled
gabled105518453g_a_bled
gaggled11359913g_aggled
galled84622853g_a_lled
gambled134112163g_ambled
gaoled84814493g_a_oled
gaped96123533g_a_p_ed
gappier12369843g_appier
garbled114512803g_arbled
gargled104210673g_argled
gasped104814293g_asp_ed
gaveled12399133g_aveled
gawped13509073g_awp_ed
gipped124815903g_ipp_ed
glopped13347613glopp_ed
gnarled9287723gna_rled
goaled85014353goa__led
grabbed13368643gra_bbed
grabble12339643grabble_
grabbler13377693grabbler
grabbles13339893grabbles
graced105217903gra__ced
gracile102512603gracile_
graciles112511613graciles
grackle14338893grackle_
grackles15309183grackles
gradated1157433gradated
graded94919553gra__ded
grafted124110223gra_fted
grained93814273gra_ined
granted94715103gra_nted
granule839473granule_
granules939933granules
grape84824663gra_p_e_
grapes95123123gra_p_es
grapey126012303gra_p_ey
grapier103712603gra_pier
graplin1058443gra_plin
grapnel1035603gra_pnel
grapnels1134393grapnels
grappa11396443grapp__a
grappas12357103grapp_as
grappling1544993grappling
grasper10389783grasp_er
grassed93812793gra_ssed
grated84523923gra__ted
graupel1034133graup_el
graupels1133103graupels
graved114818813gra__ved
gravelled1475553gravelled
grayed115415643gra__yed
grazed174115913gra__zed
griddled1244203griddled
grilled94012833gr_illed
griped104114713gr_ip_ed
grippe115310323gripp_e_
gripper124410713gripp_er
grippes124810373gripp_es
grippier1355203grippier
grizzled18334893grizzled
groped107515053gr_op_ed
grouped11419193group_ed
groveled13345453groveled
growled12278163gr_owled
grueled937133gr_ueled
gruelled1034893gruelled
grumbled14256753grumbled
grumped13337333grump_ed
gruntled10274943gruntled
gypped15377113g_ypp_ed
happed144820103_happ_ed
hoppled15338083_hoppled
knapped16397103knapp_ed
kraaled12254983kra_aled
lapeled10258893_lapeled
lapped114320033_lapp_ed
mapped134015883_mapp_ed
napped114218163_napp_ed
nippled12307643_nippled
poppled11339233_poppled
prattled11246533prattled
preapplied1442703preapplied
prepped11329893prepp_ed
propped113311953propp_ed
rabbled123514423_rabbled
raddled103812223_raddled
raffled14429083_raffled
railed74727543_ra_iled
ralphed1334363_ralphed
rambled123913513_rambled
ramped114617903_ramp_ed
rankled123910653_rankled
raped85334623_ra_p_ed
rappee103618673_rapp_ee
rappees113611453_rappees
rappel104211953_rapp_el
rappelled1443703_rappelled
rappels11448803_rappels
rappen103512713_rapp_en
rapper104621573_rapp_er
rasped94715203_rasp_ed
rassled83310443_rassled
rattled84012953_rattled
raveled114113633_raveled
reapplied1443673reapplied
repled93319773_r_epled
repped114616723_repp_ed
rimpled123311423_rimpled
ripped114419013_ripp_ed
ripple103413913_ripple_
rippler113210103_rippler
ripples113513293_ripples
ripplet113412583_ripplet
rumpled123810013_rumpled
sampled123410783_sampled
sapped114422013_sapp_ed
scrapped1556533scrapp_ed
scrapple1434683scrapple_
scrapples1534793scrapples
slapped123511843slapp_ed
snapped124611203snapp_ed
stapled103613693sta_pled
stippled1345303stippled
stoppled1345003stoppled
strapped1357813strapp_ed
suppled1248463_suppled
swapped15429143swapp_ed
tapped113820053_tapp_ed
tippled12358393_tippled
toppled12348843_toppled
trachled1438313trachled
trailed83415673tra_iled
traipsed1134753traipsed
trameled11309073trameled
tramped124312433tramp_ed
trample11299703trample_
trampler12278003trampler
tramples122610203tramples
trapesed1136473trapesed
trapper113912793trapp_er
traveled12349453traveled
trawled113411523tra_wled
tripled104113833tr_ipled
tripped123911693tripp_ed
unapplied1443743unapplied
wapped144416473_wapp_ed
whapped18367573whapp_ed
wrangled1335593wrangled
wrapper14368333wrapp_er
wrassled12325373wrassled
wrastled12346433wrastled
yapped144415143_yapp_ed
zapped204213523_zapp_ed

Search took 9 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 Filter1786911461620.220812231.8
2DLD Change Limit1461622198.42017358.9
3Display Results2192190.0962281.3
 (SQL Overall)1786912198.73620454.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.