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

223 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
grannie831035(None) 
grannies9312611grannies
brannier10218932brannier
cannie83819362_cannie
crannied1137892crannied
crannies10313012crannies
gradine93317032gradine
grainier9218902grainier
grandee93115512grandee
grange83716202gra_nge
granite82017082granite
granny104311162grann_y
grantee83217132grantee
granule839472granule
gratine84719192gratine
greenie8310122greenie
guanine8810542guanine
nannie63713222_nannie
trannies8415012trannies
alanine7316863alanine
araneid8310803araneid
beanie83618593bea_nie
bonnie85314853_bonnie
brainier102510233brainier
brandied1259113brandied
brandies11714563brandies
branned104311693branned
branner94212373branner
branniest11199383branniest
branning112911093branning
branny115111833brann_y
brassie93411523brassie
braunite1047253braunite
brawlie12198153brawlie
brawnier13216723brawnier
brownie12178433brownie
canine83826703_canine
cannier94014163_cannier
carnie84421093_carnie
crane75331603cra_n_e
crania82418433cra_nia
craning103620303craning
crankier14339163crankier
crankle133610063crankle
crannog1044243crannog
crannoge1144263crannoge
cranny114210273crann_y
crappie13298983crappie
cyanine122911513cyanine
fannies103415643_fannies
francize2246853francize
frantic12310373frantic
gahnite1135973g_ahnite
gamine94620153g_amine
gane55145303g_a_n_e
gangue81310573g_angue
gannet74321853g_annet
ganoid8314443g_anoid
garni6315703g_arni_
gawsie1038463g_awsie
genie66124923g__enie
ginnier8298983g_innier
glance94312313gla_nce
glassie8329493glassie
goalie7413163goa_lie
goanna736653goann_a
goannas836223goannas
goonie73615563g_oonie
grabbier13316653grabbier
grabble12339643grabble
grace85124543gra__ce
gracile102512603gracile
gracing113216443gracing
grackle14338893grackle
gradate9511233gradate
grade75126093gra__de
gradin83517483gra_din
gradines103615253gradines
grading103918713grading
gradins93416233gradins
graecize2044763graecize
grail64622873gra__il
grain65126253gra__in
grained93814273grained
grainer83714063grainer
grainiest10188993grainiest
graining102813183graining
grains74223093grain_s
grainy103914213grain_y
gramme114210333gra_mme
gran56335013gra_n__
grana65722093gra_n_a
granaries10159883granaries
granary1157793granary
grand75122693gra_n_d
grandad1038453grandad
grandam1139393grandam
grandame1247113grandame
grandees103211283grandees
grander93315873grander
grandiose1145793grandiose
grandkid1543643grandkid
grandly1238743grandly
grandma1136913grandma
grandniece1452133grandniece
grandpa1135413grandpa
grands84218243gra_nds
grandsir1044313grandsir
grandsire1145123grandsire
granger93514213granger
granges93516523granges
granita82111303granita
granites92116363granites
granitic1168633granitic
granola837913granola
grans64832543gra_n_s
grant64840023gra_n_t
granted94715103granted
grantees92510973grantees
granter84117133granter
granting103514523granting
grantor84010933grantor
grants73722473gra_nts
granules939933granules
granulite1046923granulite
granum9310913gra_num
grape84824663gra__pe
graphic1537353graphic
graphite1447153graphite
grapier103712603gra_pier
graplin1058443graplin
grapline1138723grapline
grapnel1035603grapnel
grapple12378003grapple
grassier9349283grassier
grate64932883gra__te
gratin74520583gra_tin
gratinee93710783gratinee
grating93923183grating
gratins84119183gratins
gratis74819243gra_tis
grave94624873gra__ve
gravid113710983gra_vid
gravies11314093gra_vies
graving123114563graving
gravure1134953gravure
graying124115883graying
graze155820053gra__ze
grazier173611133gra_zier
grazing183514553grazing
greenier938713greenier
greenies9312673greenies
gremmie1264383gremmie
grenade938413grenade
grinned9378553grinned
grinner8329233grinner
grinning1037863grinning
groaning102410283groaning
groupie1045783groupie
groyne1037213groyn_e
grunge8359583gr_unge
grungier1034983grungier
gruntle8257053gruntle
grushie1135813grushie
guanase836213guanase
guanin7610803gua_nin
guanines989773guanines
guanins8810013guanins
gunnies83413123g_unnies
hankie133915713_hankie
johnnie1772283johnnie
mannite9312903_mannite
meanie83718393mea_nie
nannies73015203_nannies
orange74016323ora_nge
orangier947713orangier
organdie1096123organdie
panne76623653_pann_e
pannier93613353_pannier
pantie84326473_pantie
prairie938333prairie
praline93019743praline
prance104318573pra_nce
rainier71614263_rainier
ramie75027823_ra_mie
rance75028513_ra_nce
rancid9513863_rancid
randier83618473_randier
randies84225663_randies
ranee55438103_ra_nee
range64728413_ra_nge
rangier83714353_rangier
rani46640113_ra_ni_
ranid66429333_ra_nid
ranis55235833_ra_nis
rankle103414883_rankle
ranpike1335933_ranpike
rapine85023083_rapine
ratine65131823_ratine
ravine95522223_ravine
rennin63914033_rennin
runnier74010113_runnier
shannies113411263shannies
stanine73417073stanine
stannic936663stannic
stannite847583stannite
tannic82811473_tannic
tannin62613923_tannin
trainee72817793trainee
trance84718763tra_nce
tranche123312223tranche
tranny94210863trann_y
transit7317163transit
tyrannic1344143tyrannic
tyrannies1255533tyrannies
tyrannise1253713tyrannise
tyrannize2163373tyrannize
urania62516123ura_nia
uranic82315183ura_nic
uranide82212093uranide
uraninite946743uraninite
uranite72515693uranite
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.403443402.0
2DLD Change Limit1340272235.83022989.2
3Display Results2232230.0932397.8
 (SQL Overall)1786912236.32628247.1
 
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.