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

132 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
granola83791(None) 
granolas938051granolas
canola8313622_canola
crapola1136912crapola
girandola1152542girandola
grana65722092gran__a
grandly1238742grandly
grandma1136912grandma
grandpa1135412grandpa
granita82111302granita
granular946892granular
granule839472granule
ranula6311812_ranula
anoa45634473__ano_a
anole55330383__anole
araroba945763araroba
areola6813673ar_eola
arugola844353arugola
braciola1245273braciola
canolas9313993_canolas
canula8312963_canula
crania82418433cran_ia
cranial92114683cranial
crankle133610063crankle
crankly16358123crankly
crapolas1247403crapolas
frankly17315633frankly
frenula1045623frenula
gala55635163g_a__la
ganglia946613g_anglia
gangly113911583g_angly
ganja131410003g_an_ja
ganof95420363g_ano_f
ganofs104010293g_anofs
ganoid8314443g_anoid
gaol56925413g_a_ol_
gaols66717573g_a_ols
genoa64315823g_eno_a
geranial949283geranial
geraniol945143geraniol_
geraniols1044743geraniols
girandolas1252243girandolas
girandole1143543girandole
girasol874623girasol_
girasole984423girasole
girasols984273girasols
gladiola10113413gladiola
goanna736653goan_na
gondola946663gondola
graal64316503gra_al_
graals74112913gra_als
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
gradual936943gradual
grail64622873gra_il_
grails77518783gra_ils
grama85620283gra__ma
gramma11499803gra_mma
grampa115010173gra_mpa
gran56335013gran___
granary1157793granary
grand75122693gran__d
grandad1038453grandad
grandam1139393grandam
granddad1244253granddad
granddam1344693granddam
grandee93115513grandee
grander93315873grander
grandmas1236923grandmas
grandpas1236003grandpas
grands84218243gran_ds
grange83716203gran_ge
granger93514213granger
granges93516523granges
granitas92610223granitas
granite82017083granite
grannie8310353grannie
granny104311163gran_ny
granolith1345273granolith
grans64832543gran__s
grant64840023gran__t
granted94715103granted
grantee83217133grantee
granter84117133granter
grantor84010933grantor
grantors93810353grantors
grants73722473gran_ts
granulate1059183granulate
granules939933granules
granuloma1252393granuloma
granum9310913gran_um
grapnel1035603grapnel_
grapnels1134393grapnels
grappa11396443gra_ppa
grapple12378003grapple
gravel105313823gravel_
gravels113611143gravels
gravely14469063gravely
gravida12366563gravida
gravlax1842643gra_vlax
graylag1283113gra_ylag
grayly13287963gra_yly
grayout1148503grayout
gringa838553grin_ga
gruntle8257053gruntle
guano69213983guano__
guanos73811993guano_s
mandola1039023_mandola
manila84518303_manila
parabola1246653parabola
paranoea1048563paranoea
paranoia10410563paranoia
payola11208113_payola
planula935773planula
pronota939763pronota
radula749313_radula
rambla103510933_rambla
ramona8412413_ramona
rankle103414883_rankle
rankly133910453_rankly
ranular739433_ranular
ranulas7311773_ranulas
rugola736293_rugola
stanol6310723stanol_
stanols739733stanols
urania62516123uran_ia
uranous7310733uranous
uranyl936293uranyl_
uranyls1034453uranyls
variola1068893variola
wrangle1137383wrangle

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.406440125.6
2DLD Change Limit1340271325.85622887.1
3Display Results1321320.0462869.6
 (SQL Overall)1786911326.30828327.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.