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

242 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
granule83947(None) 
granules939931granules
crankle133610062crankle
glandule1043852glandule
grabble12339642grabble
gracile102512602gracile
grackle14338892grackle
grandee93115512grandee
grandly1238742grandly
grange83716202gran_ge
granite82017082granite
grannie8310352grannie
granola837912granola
grantee83217132grantee
granular946892granular
granulate1059182granulate
granulite1046922granulite
granulose1044142granulose
granum9310912granu_m
grapple12378002grapple
gravure1134952gravure
gruntle8257052gruntle
guayule1142822guayule
rankle103414882_rankle
ranula6311812_ranula
wrangle1137382wrangle
anele55628833__anele
angle64528873__angle
anile54634463__anile
ankle95220253__ankle
anole55330383__anole
arable81821003ara_ble
bangle94018953_bangle
barbule1137943barbule
brabble10349973brabble
braille939713braille
bramble133710033bramble
brattle9249253brattle
bravure1254393bravure
brindle104210103brindle
candle94321483_candle
cantle84522153_cantle
canula8312963_canula
canulae9311183_canulae
crackle153611253crackle
cradle93313163cra_dle
crane75331603cran__e
crankled15408153crankled
crankles143510153crankles
crankly16358123crankly
cringle103010353cringle
crinkle13359413crinkle
dandle84218093_dandle
dangle84119303_dangle
drabble12238883drabble
draggle1056103draggle
erasure736943erasure
fragile1147843fragile
frankly17315633frankly
frazzle18305223frazzle
frenula1045623frenula
gabble113815723g_abble
gable85325523g_a_ble
gaggle93412623g_aggle
gale56347323g_a__le
gamble115417183g_amble
gane55145303g_an__e
gangly113911583g_angly
gangue81310573g_angue
gantlet83616243g_antlet
garble94118453g_arble
gargle84215463g_argle
gauge76117903g_a_uge
gault65128483g_a_ult
gauze155712973g_a_uze
gemmule12173233gemmule
gentle74014513g_entle
girandole1143543girandole
girasole984423girasole
glance94312313glan_ce
glandules1144253glandules
globule1034383globule
graal64316503gra_al_
graals74112913gra_als
grabbled14327373grabbled
grabbler13377693grabbler
grabbles13339893grabbles
grace85124543gra__ce
graciles112511613graciles
grackles15309183grackles
gradable1238823gradable
gradate9511233gradate
grade75126093gra__de
gradine93317033gradine
gradual936943gradual
graduals1046203graduals
graduate1058083graduate
gradus84411223gradu_s
graduses1046453graduses
grail64622873gra_il_
grails77518783gra_ils
gramme114210333gra_mme
gran56335013gran___
grana65722093gran__a
granary1157793granary
grand75122693gran__d
grandad1038453grandad
grandam1139393grandam
grandame1247113grandame
grandees103211283grandees
grander93315873grander
grandma1136913grandma
grandpa1135413grandpa
grands84218243gran_ds
granduncle1451963granduncle
granger93514213granger
granges93516523granges
granita82111303granita
granites92116363granites
grannies9312613grannies
granny104311163gran_ny
granolas938053granolas
grans64832543gran__s
grant64840023gran__t
grantable1257293grantable
granted94715103granted
grantees92510973grantees
granter84117133granter
grantor84010943grantor
grants73722473gran_ts
granulated1256943granulated
granulates1148463granulates
granulites1146623granulites
granuloma1252393granuloma
granuloses1144443granuloses
grape84824663gra__pe
grapnel1035603grapnel_
grapnels1134393grapnels
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
grate64932883gra__te
graticule1254573graticule
gratine84719193gratine
gratulate1047683gratulate
graupel1034133gra_upel
grave94624873gra__ve
gravel105313823gravel_
graveled13417363graveled
gravels113611143gravels
gravely14469063gravely
gravures1234903gravures
grayly13287963gra_yly
grazable2036223grazable
graze155820053gra__ze
grenade938413grenade
gribble12297273gribble
griddle1035503griddle
grille74315743gr_ille
gripple12416613gripple
gristle8169223gristle
grizzle16306113grizzle
grouse74315023gr_ouse
grue55825713gr__u_e
gruel66014743gr__uel
grumble12349233grumble
grume86218163gr__ume
grunge8359583grun_ge
gruntled10274943gruntled
gruntles9287233gruntles
guanase836213guanase
guanine8810543guanine
guayules1243223guayules
handle104219293_handle
hantle94318203_hantle
jangle144416293_jangle
lunule638433_lunule
macule104115273_macule
mangle93921323_mangle
mantle84420923_mantle
manure8313653_manure
oracle84313293ora_cle
orange74016323oran_ge
papule102212133_papule
pinnule936003pinnule
planula935773planula
planulae1044793planulae
prance104318573pran_ce
prattle9208833prattle
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
radula749313_radula
radulae837963_radulae
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramble104519973_ramble
rance75028513_ran_ce
ranee55438103_ran_ee
range64728413_ran_ge
rankled123910653_rankled
rankles113114543_rankles
rankly133910453_rankly
ranular739433_ranular
ranulas7311773_ranulas
rassle63813203_rassle
rasure6311423_rasure
rattle64717613_rattle
rule49938423_r__ule
rundle73214233_rundle
runkle103611543_runkle
spangle1038403spangle
spansule1043623spansule
spinule9299993spinule
strangle98411503strangle
tangle74019953_tangle
trachle12311853trachle
traduce1036353traduce
trample11299703trample
trance84718763tran_ce
tranche123312223tranche
transude947083transude
triangle935533triangle
trindle83311363trindle
trundle8307873trundle
twangle1145803twangle
uranide82212093uranide
uranite72515693uranite
uranyl936293uranyl_
uranyls1034453uranyls
veinule1056243veinule
venule94411763_venule
wandle105316663_wandle
wangle103817503_wangle
wrangled1335593wrangled
wrangler1245473wrangler
wrangles1237463wrangles
wrassle10357173wrassle
wrastle10368993wrastle
wrinkle14296923wrinkle
zonule1577483_zonule

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.423422437.4
2DLD Change Limit1340272427.64017542.8
3Display Results2422420.2061174.8
 (SQL Overall)1786912428.26921609.7
 
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.