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

175 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
granary115779(None) 
gramary1355901gramary
canary11314692_canary
gantry103810112g_antry
gramarye1462712gramarye
grana65722092grana__
grandly1238742grandly
granny104311162gran_ny
grapery13457952grapery
guanay1037912guana_y
trinary1039162trinary
urinary1037242urinary
alary86123443__alary
angary10311323__angary
angry9310863__angry
ariary94114203ar_iary
beanery1237563beanery
binary11312223_binary
branchy17357913branchy
brandy124712063bran_dy
branny115111833bran_ny
bravery15428133bravery
briary114912003br_iary
canard9314763_canard
chantry15388213chantry
coronary1347693coronary
crankly16358123crankly
cranky153910633cran_ky
cranny114210273cran_ny
datary10310243_datary
deanery1137613deanery
denary105316863_denary
dramady1443553dramady
drapery13387943drapery
dreary104611673dr_eary
errantry11113463errantry
frankly17315633frankly
friary124010093fr_iary
galaxy17476313g_alaxy
gamay116419103g_ama_y
gangly113911583g_angly
garbagy1444243garbagy
garner73917003garner_
garners83815983garners
gauntry1154113gauntry
gazar154612983g_azar_
gazars164811553g_azars
gentry103410443g_entry
gharry13546273gha_rry
glairy10448273gla_iry
glary96018543g__lary
gnar56021383g__nar_
gnarl65115573g__narl
gnarly104610383g__narly
gnarr64810693g__narr
gnars66718853g__nars
graal64316503gra_a_l
graals74112913gra_als
grabby14336183gra_bby
gradate9511223gradate
grader84919693grader_
graders94715993graders
graham1237853graha_m
grahams1335333grahams
grainer83714063grainer_
grainers93012073grainers
grainy103914213gra_iny
grama85620283grama__
gramaryes1572873gramaryes
gramas94317203grama_s
gramercy1641923gramercy
grammar12406893grammar_
grammars13345943grammars
gran56335013gran___
granaries10159883granaries
grand75122693gran__d
grandad1038453grandad
grandaddy1652113grandaddy
grandads1136553grandads
grandam1139393grandam
grandame1247113grandame
grandams1237123grandams
grandbaby1851733grandbaby
grandee93115513grandee
grander93315873grander
grandma1136913grandma
grandpa1135413grandpa
grands84218243gran_ds
grange83716203gran_ge
granger93514213granger
grangers103011973grangers
granges93516523granges
granita82111303granita
granite82017083granite
grannie8310353grannie
granola837913granola
grans64832543gran__s
grant64840023gran__t
granted94715103granted
grantee83217133grantee
granter84117133granter
granters93614133granters
grantor84010933grantor
grantors93810353grantors
grants73722473gran_ts
granular946893granular_
granule839473granule
granum9310913gran_um
grapey126012303gra_pey
grapy115416433gr__apy
grassy10619093gra_ssy
grater74625433grater_
graters85419733graters
gratify1436113gratify
gravely14469063gravely
graver105018593graver_
gravers114515263gravers
gravity1437183gravity
gravure1134953gravure
gravy125512113gr__avy
gray85329893gr__a_y
grayer106014543grayer_
grayly13287963gra_yly
grazer164815763grazer_
grazers175112443grazers
greasy10419463gr_easy
greenery12265923greenery
grenade938413grenade
grindery13255513grindery
groaner82510133groaner_
groaners9248493groaners
grocery13336763grocery
grungy11345973grun_gy
guanaco1064583guanaco
guanase836213guanase
guanays1134953guanays
gunnery11376363gunnery
gurnard944773gurnard
gynandry1661743gynandry
gyratory1544163gyratory
hymnary1843033hymnary
laniary1068013_laniary
manuary1237773_manuary
nary76931223___nary
orangery12305543orangery
orangey11388833orangey
orangy105111233oran_gy
oratory1039403oratory
ordinary1244913ordinary
ornery938463or_nery
panfry14456413_panfry
pantry115014103_pantry
planar84212713planar_
plenary1237543plenary
primary1437703primary
quandary2143433quandary
quinary1936933quinary
radar61316723_radar_
radars71314663_radars
randy95022083_ran_dy
rangy95320383_ran_gy
rankly133910453_rankly
ratany93411873_ratany
rosary92810353_rosary
rotary92411303_rotary
salary9515213_salary
senary93716073_senary
stannary1144613stannary
ternary1038343ternary
tracery12399793tracery
tranny94210863tran_ny
truantry1142533truantry
unary8315993__unary
vagary1337333_vagary
zonary1838793_zonary

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.1561145455.1
2DLD Change Limit1340271757.95316852.4
3Display Results1751750.0602916.7
 (SQL Overall)1786911758.16921874.3
 
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.