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

246 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
grackle1433889(None) 
crackle153611251crackle
gracile102512601gracile
grackles15309181grackles
rackle123917291_rackle
brickle15279932brickle
cackle143416922_cackle
crackled17428862crackled
crackles164111272crackles
crackly18397702crackly
crankle133610062crankle
freckle16106642freckle
grabble12339642grabble
grace85124542grac__e
graciles112511612graciles
granule839472granule
grapple12378002grapple
hackle154916812_hackle
mackle143716432_mackle
oracle84313292orac_le
prickle153611012prickle
rankle103414882_rankle
ruckle124414582_ruckle
shackle16409542shackle
spackle15369572spackle
tackle123815732_tackle
trachle12311852trachle
trickle133613442trickle
truckle13358862truckle
ackee115825373__ackee
ankle95220253__ankle
arable81821003ara_ble
blackleg1734233blackleg
blackly1835253blackly
brabble10349973brabble
brace95629273brac__e
bracelet12310693bracelet
braciole1246973braciole
bracken15409813bracken
bracket154117233bracket
bractlet1239283bractlet
braille939713braille
brake116025343bra_k_e
bramble133710033bramble
brattle9249253brattle
brickles162810283brickles
bricole112810493bricole
buckle144815193_buckle
cackled164613303_cackled
cackler153812573_cackler
cackles153717203_cackles
caracole12310363caracole
chuckle1836443chuckle
cockle143913573_cockle
coracle112011723corac_le
crack134120533crack__
cracked163514743cracked
cracker153114173cracker
cracklier1744823cracklier
cracknel1643703cracknel
cracks144817003crack_s
crackup1743563crackup
cracky175010223crack_y
cradle93313163cra_dle
crake114823523cra_k_e
crankled15408153crankled
crankles143510153crankles
crankly16358123crankly
crinkle13359413crinkle
darkle113813943_darkle
deckle1312012453_deckle
drabble12238883drabble
draggle1056103draggle
drake104918303dra_k_e
facile112514883_facile
fickle153912973_fickle
fragile1147843fragile
frankly17315633frankly
frazzle18305223frazzle
freckled18104443freckled
freckles17126383freckles
freckly19124593freckly
gabble113815723g_abble
gable85325523g_a_ble
gaggle93412623g_aggle
gale56347323g_a__le
gamble115417183g_amble
garble94118453g_arble
gargle84215463g_argle
girasole984423girasole
glace87420163glac__e
graal64316503gra_al_
graals74112913gra_als
grabbled14327373grabbled
grabbler13377693grabbler
grabbles13339893grabbles
graced105217903grac_ed
graceless12226893graceless
graces94523493grac_es
gracilis11247033gracilis
gracing113216443gracing
gradable1238823gradable
gradate9511233gradate
grade75126093gra__de
gradine93317033gradine
graecize2044763graecize
grail64622873gra_il_
grails77518783gra_ils
gramme114210333gra_mme
grandee93115513grandee
grandly1238743grandly
grange83716203gra_nge
granite82017083granite
grannie8310353grannie
granola837913granola
grantee83217133grantee
granules939933granules
grape84824663gra__pe
grapnel1035603grapnel
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
grate64932883gra__te
graticule1254573graticule
gratine84719193gratine
graupel1034133graupel
grave94624873gra__ve
gravel105313823gravel_
graveled13417363graveled
gravels113611143gravels
gravely14469063gravely
gravure1134953gravure
grayly13287963gra_yly
grayscale1542653grayscale
grazable2036223grazable
graze155820053gra__ze
grecize1935663grecize
gribble12297273gribble
griddle1035503griddle
grille74315743gr_ille
gripple12416613gripple
gristle8169223gristle
grizzle16306113grizzle
grumble12349233grumble
gruntle8257053gruntle
guayule1142823guayule
hackee154921833_hackee
hackie154615623_hackie
hackled173312493_hackled
hackler163512353_hackler
hackles162917063_hackles
hackly18298733_hackly
heckle153112093_heckle
huckle153913073_huckle
jackleg2135043_jackleg
keckle11359423_keckle
knuckle1254233knuckle
mackled164111923_mackled
mackles154415753_mackles
macle96127003_mac_le
macule104115273_macule
mickle143715133_mickle
miracle1138843mirac_le
muckle143413583_muckle
nickle123814483_nickle
orache114013593orac_he
oracles93212423orac_les
packly17228333_packly
pickle144215653_pickle
prattle9208833prattle
prickled17358073prickled
prickles162511093prickles
prickly18367893prickly
rabble103818243_rabble
race66746263_rac__e
raceme1039733_raceme
racily11715173_racily
rack106234883_rack__
racked134526083_racked
racker124824553_racker
racket125229423_racket
racks115028853_rack_s
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rake84841573_ra_k_e
rakee96031173_ra_kee
rale45050563_ra__le
ramble104519973_ramble
rankled123910653_rankled
rankles113114543_rankles
rankly133910453_rankly
rassle63813203_rassle
rattle64717613_rattle
retackle1445043retackle
ruckled144111033_ruckled
ruckles133414603_ruckles
runkle103611543_runkle
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
sickle124418323_sickle
slackly1635263slackly
spackled17297803spackled
spackles16319953spackles
sparkle133710213sparkle
speckle15297553speckle
stickle132410973stickle
strickle1467793strickle
suckle124015963_suckle
tackled143913193_tackled
tackler134013323_tackler
tackles133816523_tackles
tickle124616743_tickle
trace75829613trac__e
trachled1438313trachled
trachles13311753trachles
track114823013track__
trackable1736743trackable
trackage1545653trackage
tracked143716133tracked
tracker133515173tracker
trackless15246723trackless
trackmen1635573trackmen
tracks124818843track_s
tractile10311073tractile
trample11299703trample
trauchle1344963trauchle
treacle939973treac_le
trickie132611033trickie
trickled152610433trickled
trickles143013763trickles
trickly16369893trickly
truckled15327313truckled
truckler14297453truckler
truckles14319383truckles
uracil8311543uracil_
uracils939373uracils
wacke145918623_wack_e
wrack145413883wrack__
wracked174110113wracked
wracks154711113wrack_s
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle
wrinkle14296923wrinkle

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 Filter1786911340270.810220606.2
2DLD Change Limit1340272467.58017681.7
3Display Results2462460.0932645.2
 (SQL Overall)1786912468.48321064.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.