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

368 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
granite8201708(None) 
granita82111301granita
granites92116361granites
uranite72515691uranite
arenite71017712arenite
braunite1047252braunite
craniate10312562craniate
crinite9513632crinite
cyanite122710762cyanite
gahnite1135972gahnite
gracile102512602gracile
gradate9511232gradate
gradine93317032gradine
grandee93115512grandee
grange83716202gran_ge
granitas92610222granitas
granitic1168622granitic
grannie8310352grannie
grant64840022gran_t_
granted94715102gran_ted
grantee83217132grantee
granter84117132gran_ter
grants73722472gran_ts
granule839472granule
granulite1046922granulite
graphite1447152graphite
grate64932882gra__te
gratine84719192gratine
gravity1437182gravity
guanine8810542guanine
gunite7414402g_unite
kyanite14237312kyanite
ratite65022422_ratite
uralite71714102uralite
uranide82212092uranide
uranites82514642uranites
urbanite1097182urbanite
aconite9315473aconite
alanine7316863alanine
allanite8411093allanite
alunite7311633alunite
amanita9310453amanita
anile54634463__anile
anime75423203__anime
anise55129703__anise
ante46538903__an_te
apatite9312963apatite
aphanite1348773aphanite
arabize1849343arabize
aragonite1046463aragonite
arenites8917103arenites
arsenite8119663arsenite
axite125218253__axite
barite84224813_barite
beanie83618593beani_e
boracite1249193boracite
bornite9311183bornite
braise84318753bra_ise
braize174113113bra_ize
brant74742173bran_t_
brants85723053bran_ts
braunites1146723braunites
canine83826703_canine
carnie84421093carni_e
crane75331603cran__e
crania82418433crani_a
cranial92114683cranial
craniates11310653craniates
craning103620303craning
cranium11911103cranium
crankle133610063crankle
crate76537403cra__te
crenate93317113crenate
crinites10612763crinites
cyanate12259703cyanate
cyanide13298843cyanide
cyanine122911513cyanine
cyanites132610163cyanites
dacite91115883_dacite
dunite7315013_dunite
dunnite857333dunnite
ebonite9310293ebonite
egalite8311563egalite
emanate9312473emanate
eradiate91911753eradiate
eremite9312833eremite
erudite838483erudite
finite9316823_finite
fragile1147843fragile
fraise94214913fra_ise
francize2246853francize
frantic12310363frantic
gahnites1235703gahnites
gait56150193g_a_it_
gaited84416923g_a_ited
gaiter73819503g_a_iter
gaits65726013g_a_its
galenite91210063galenite
gamete9313593g_amete
gamine94620153g_amine
gane55145303g_an__e
gangue81310573g_angue
ganister9178993g_anister
gannet74321853g_annet
garnet73928413garnet_
garnets84115403garnets
garni6315703garni__
garnish111610843garnish
garniture1043233garniture
garote7717953g_arote
garotte868703garotte
garpike1435093garpike
garrote8510103garrote
gate55746573g_a__te
genie66124923g_eni_e
geranial949283geranial
geraniol945143geraniol
geranium1147053geranium
germanize2148263germanize
giant65430593gian_t_
giants74713503gian_ts
gite55438613g___ite
glaciate1168073glaciate
gladiate1057053gladiate
glaire74411293gla_ire
glaive10357933gla_ive
glance94312313glan_ce
gnathite1244483gnathite
goalie7413163goali_e
goonie73615563gooni_e
gothite1146403gothite
grabble12339643grabble
grace85124543gra__ce
graciles112511613graciles
gracing113216443gracing
grackle14338893grackle
gradated1157433gradated
gradates10510783gradates
grade75126093gra__de
gradin83517483gradi_n
gradines103615253gradines
grading103918713grading
gradins93416233gradins
graduate1058083graduate
graecize2044763graecize
graffiti1542983graffiti
graffito1542873graffito
graft95327203gra_ft_
grafted124110223gra_fted
grafter114211153gra_fter
grafts105013253gra_fts
grail64622873gra_i_l
grails77518783gra_ils
grain65126253gra_i_n
grained93814273grained
grainer83714063grainer
grainier9218903grainier
graining102813183graining
grains74223093gra_ins
grainy103914213gra_iny
gramme114210333gra_mme
gran56335013gran___
grana65722093gran__a
granary1157793granary
grand75122693gran__d
grandad1038453grandad
grandam1139393grandam
grandame1247113grandame
grandees103211283grandees
grander93315873grander
grandiose1145793grandiose
grandly1238743grandly
grandma1136913grandma
grandpa1135413grandpa
grands84218243gran_ds
grandsire1145123grandsire
granger93514213granger
granges93516523granges
granitoid1174683granitoid
grannies9312613grannies
granny104311163gran_ny
granola837913granola
granolith1345273granolith
grans64832543gran__s
grantees92510973grantees
granters93614143gran_ters
granting103514523granting
grantor84010933grantor
granulate1059183granulate
granules939933granules
granulites1146623granulites
granum9310913gran_um
grape84824663gra__pe
graphites1546823graphites
grapier103712603grapier
grapline1138723grapline
grapple12378003grapple
grat55651283gra__t_
grated84523923gra__ted
grater74625443gra__ter
grates75429893gra__tes
gratify1436113gratify
gratin74520583grati_n
gratinee93710783gratinee
grating93923183grating
gratins84119183gratins
gratis74819243grati_s
gratitude11134013gratitude
gratuity1244283gratuity
grave94624873gra__ve
gravesite1344443gravesite
gravid113710983gravi_d
gravida12366563gravida
gravidae13324793gravidae
gravies11314093gravies
graving123114563graving
gravitas12316013gravitas
gravitate1345543gravitate
gravities1338303gravities
graviton1244303graviton
gravure1134953gravure
graying124115883graying
grayish1437813grayish
graze155820053gra__ze
grazier173611133grazier
grazing183514553grazing
grecize1935663grecize
greenie8310123greeni_e
greige847203gr_eige
grenade938413grenade
gride75223583gr__ide
grime85021323gr__ime
gripe84622963gr__ipe
grit55247243gr__it_
grith95520373gr__ith
grits65529583gr__its
groaning102410283groaning
grunge8359583grun_ge
grunion835433grunion
grunt65523543grun_t_
grunted9339283grun_ted
grunter83110783grun_ter
gruntle8257053gruntle
grunts75511853grun_ts
guanase836213guanase
guanin7610803guani_n
guanines989773guanines
guanins8810013guanins
gummite1236133gummite
gunites8313123g_unites
gyrate104912523gyra__te
halite93624233_halite
hyalite13229473hyalite
ichnite1245983ichnite
ignite71410583_ignite
inanity1039503inanity
irate55627983ira__te
ironize16610373ironize
kainite1149543kainite
kernite1159473kernite
khanate1437073khanate
krait94726773kra_it_
kraits104912203kra_its
kyanise14236143kyanise
kyanites15216683kyanites
kyanize23265343kyanize
lanate6421263_lanate
lenite6719983_lenite
lignite81310303lignite
manito8518693_manito
manitu8315823_manitu
mannite9312903mannite
marlite92917073marlite
marmite112413993marmite
meanie83718393meani_e
melanite10512033melanite
morganite1247423morganite
nite45943583___nite
orality101111683orality
orange74016323oran_ge
orate55133303ora__te
organise939323organise
organize1849093organize
ornate6315143or_nate
pantie84326473_pantie
parakite14410423parakite
parasite10314843parasite
partite9317133partite
pinite8321243_pinite
planate9314573planate
praise84419413pra_ise
praline93019743praline
prance104318573pran_ce
prate75135983pra__te
preunite1039573preunite
pronate9418873pronate
radiate83416313_radiate
raise54828053_ra_ise
raita54623073_ra_ita
ramate83921683_ramate
ramie75027823_rami_e
rance75028513_ran_ce
ranee55438103_ran_ee
range64728413_ran_ge
rani46640113_rani__
ranid66429333_rani_d
ranids75118703_ranids
ranis55235833_rani_s
rankle103414883_rankle
ranpike1335933_ranpike
rant45864683_ran_t_
ranted74324703_ran_ted
ranter63826823_ran_ter
rants55935343_ran_ts
rapine85023083_rapine
rarity93615493_rarity
rate45458763_ra__te
ratine65131823_ratine
ratites74920683_ratites
ravine95522223_ravine
recite83625113_recite
rente54733783_ren_te
resite64128453_resite
reunite7312713reunite
rite45849453_r__ite
ruralite848963ruralite
samite83020603_samite
sanity9316203_sanity
sienite7312713sienite
slainte738543slainte
stanine73417073stanine
stannite847583stannite
syenite1039773syenite
taxite13511303_taxite
titanite898433titanite
trainee72817793trainee
trait56940843tra_it_
traits65121983tra_its
trance84718763tran_ce
tranche123312223tranche
transit7317163transit_
transited10410603transited
transits8313503transits
trinity10310843trinity
trite54730033tr__ite
umangite1144823umangite
unakite1138743unakite
unite54828383__unite
uralites82112723uralites
urania62516123urani_a
uranias72113813uranias
uranic82315183urani_c
uranides92211283uranides
uraninite946743uraninite
uranism91112513uranism
uranitic10148683uranitic
uranium9610023uranium
urate55432163ura__te
urbanise10107283urbanise
urbanites11105913urbanites
urbanity13105303urbanity
urbanize19106733urbanize
urinate7315363urinate
vanity12311933_vanity
wraith1258603wra_ith
wrangle1137383wrangle
write85522833wr__ite
zaratite1747793zaratite

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 Limit1340273686.14021828.5
3Display Results3683680.1402628.6
 (SQL Overall)1786913686.68626726.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.