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

373 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
granites9211636(None) 
granitas92610221granitas
granite82017081granite_
uranites82514641uranites
arenites8917102arenites
braunites1146702braunites
craniates11310652craniates
crinites10612752crinites
cyanites132610152cyanites
gahnites1235702gahnites
graciles112511612graciles
gradates10510782gradates
gradines103615252gradines
grandees103211282grandees
granges93516522gran_ges
granita82111302granit_a
granitic1168622granitic
grannies9312612grannies
granted94715102gran_ted
grantee83217132gran_tee
grantees92510972grantees
granter84117132gran_ter
granters93614132gran_ters
grants73722472gran_t_s
granules939932granules
granulites1146622granulites
graphites1546822graphites
grates75429882gra__tes
gravies11314092gravi_es
gravitas12316012gravitas
gravities1338302gravities
guanines989772guanines
gunites8313122g_unites
kyanites15216682kyanites
ratites74920682_ratites
uralites82112722uralites
uranides92211282uranides
uranite72515692uranite_
urbanites11105912urbanites
aconites10314343aconites
alanines8314793alanines
allanites949793allanites
alunites8310703alunites
amanitas1048523amanitas
animes84719593__animes
anises64826693__anises
antes56334323__an_tes
apatites10311283apatites
aphanites1448263aphanites
arabizes1969103arabizes
aragonites1145803aragonites
arenite71017713arenite_
arsenites9149163arsenites
axites134913833__axites
banties94324763_banties
barites94322333_barites
beanies93821093beani_es
boracites1347943boracites
bornites10310973bornites
braises93818873bra_ises
braizes183112453bra_izes
branches153613803branches
brandies11714563brandies
brants85723053bran_t_s
braunite1047253braunite_
braxies16711463braxi_es
brinies93317913brini_es
canines93724033_canines
canities101519243_canities
carnies94123963carni_es
chanties132615803chanties
cranches153114543cranches
cranes84330753cran__es
craniate10312563craniate_
craniums1297913craniums
crankles143510153crankles
crannies10313013crannies
crates85736053cra__tes
crazies183413853crazi_es
crinite9513633crinite_
cronies9622503croni_es
crudites1137763crudites
cyanates13238423cyanates
cyanides14258003cyanides
cyanines132710543cyanines
cyanite122710763cyanite_
dacites101114593_dacites
dunites8313593_dunites
dunnites947173dunnites
ebonites1039223ebonites
egalites9310503egalites
emanates10311333emanates
eradiates102010763eradiates
eremites10312593eremites
finites10315923_finites
fraises104215693fra_ises
francizes2346793francizes
frites94922483fr__ites
frontes104214163fron_tes
gabies93820723g_abi_es
gahnite1135973gahnite_
gaited84416923g_a_ited
gaiter73819503g_a_iter
gaiters83516533g_a_iters
gaits65726013g_a_it_s
galenites10129183galenites
gametes10312253g_ametes
gamines103618463g_amines
gangues9149753g_angues
ganister9178993g_anister
ganisters10248313g_anisters
gannets83811443g_annets
garnets84115403garnet_s
garnishes13198813garnishes
garnitures1143183garnitures
garotes8614563g_arotes
garottes978283garottes
garpikes1534373garpikes
garrotes969363garrotes
gates65939503g_a__tes
genies75324943g_eni_es
gentes75324163g_en_tes
geranials1045913geranials
geraniols1044743geraniols
geraniums1245253geraniums
germanizes2248143germanizes
ghazies2036913ghazi_es
giantess933893gian_tess
giants74713503gian_t_s
gites65630183g___ites
glaciates1267343glaciates
glacises1138503glacises
glaires84010133gla_ires
glaives11347833gla_ives
glances104113143glan_ces
glandes95413833glan_des
gnathites1344233gnathites
goalies8316023goali_es
goonies83618333gooni_es
gothites1246013gothites
grabbles13339893grabbles
graces94523493gra__ces
gracile102512603gracile_
gracilis11247033gracilis
gracious1138593gracious
grackles15309183grackles
gradate9511223gradate_
gradated1157433gradated
grades84926313gra__des
gradine93317033gradine_
gradins93416233gradi_ns
graduates1147683graduates
graduses1046453graduses
graecizes2144573graecizes
graffitis1642713graffitis
grafted124110223gra_fted
grafter114211153gra_fter
grafters12409183gra_fters
grafts105013253gra_ft_s
grails77518783gra_i_ls
grained93814273gra_ined
grainer83714063gra_iner
grainers93012073grainers
grainier9218893grainier
grainiest10188993grainiest
graininess1145783graininess
grainless1035883grainless
grains74223093gra_i_ns
grammes123611323gra_mmes
granaries10159883granaries
grandads1136553grandads
grandames1346713grandames
grandams1237123grandams
grandee93115513gran_dee
grander93315873gran_der
grandest10311573gran_dest
grandiose1145793grandiose
grandmas1236923grandmas
grandness1138303grandness
grandpas1236003grandpas
grands84218243gran__ds
grandsires1245043grandsires
grange83716203gran_ge_
granger93514213gran_ger
grangers103011973grangers
granitoid1174683granitoid
grannie8310353grannie_
granolas938053granolas
granoliths1443303granoliths
grans64832543gran___s
grant64840023gran_t__
granting103514523granting
grantor84010933gran_tor
grantors93810353grantors
granulates1148463granulates
granule839473granule_
granulite1046923granulite_
grapes95123123gra__pes
graphite1447153graphite_
grapier103712603grapi_er
grapiest112211923grapi_est
grapiness1238243grapiness
graplines1237353graplines
grapples13348123grapples
grasses84117343gra_sses
grate64932883gra__te_
grated84523923gra__ted
grater74625433gra__ter
graters85419733gra__ters
gratifies1347993gratifies
gratine84719193gratine_
gratinee93710783gratinee
gratinees10307313gratinees
gratings103910753gratings
gratins84119183grati_ns
gratis74819243gra__tis
gratitudes12114073gratitudes
gratuities1145313gratuities
graves104624003gra__ves
gravesites1443943gravesites
gravidas13285803gravidas
gravitases1443683gravitases
gravitates1444843gravitates
graviton1244303graviton
gravitons1343963gravitons
gravity1437183gravit_y
gravures1234903gravures
grazes164519643gra__zes
grazier173611133grazi_er
graziers18387123graziers
grazings19337253grazings
grecizes2035683grecizes
greenies9312673greeni_es
greiges937733gr_eiges
grenades1038433grenades
grides84422363gr__ides
grimes94619033gr__imes
grinches1436943grinches
gripes94619873gr__ipes
griths105211653gr__iths
grits65529583gr__it_s
grunges93310403grun_ges
grunions945353grunions
grunted9339283grun_ted
grunter83110783grun_ter
grunters9359023grun_ters
gruntles9287233gruntles
grunts75511853grun_t_s
guanases936233guanases
guanine8810543guanine_
guanins8810013guani_ns
guaranies10127123guarani_es
guaranties1144383guaranties
gummites1346163gummites
gunite7414403g_unite_
gunnies83413123gunni_es
gyrates113610263gyra__tes
halites103221193_halites
hyalites14208833hyalites
ichnites1345743ichnites
ignites81310573_ignites
inanities9312433inanities
ironies7517423ironi_es
ironizes17510373ironizes
kainites1238793kainites
kernites1269113kernites
khanates1535733khanates
kraits104912203kra_it_s
kyanises15206393kyanises
kyanite14237313kyanite_
kyanizes24205283kyanizes
lenites7818443_lenites
lignites9129603lignites
manitos9314053_manitos
manitus9310923_manitus
mannites10312613mannites
mantes84430783_man_tes
marlites103415263marlites
marmites122212793marmites
meanies93620743meani_es
melanites11410723melanites
morganites1346723morganites
nites55736343___nites
oralities91214113oralities
oranges84215333oran_ges
orates64328613ora__tes
organises1048683organises
organizes1948753organizes
ornithes1136423or_nithes
panties94230933_panties
parakites1549543parakites
parasites11313153parasites
pinites9319533_pinites
praises94121103pra_ises
pralines102217723pralines
prances113618773pran_ces
prates84633163pra__tes
praxises1739063praxises
preunites1138933preunites
pronates10418373pronates
rabies85226013_rabi_es
radiates92415293_radiates
radices102314263_radices
radixes15259343_radixes
raises64826543_ra_ises
raitas64417673_ra_itas
ramies84630463_rami_es
rances84625443_ran_ces
ranches123620113_ranches
randies84225663_randies
ranees64623963_ran_ees
ranges73826923_ran_ges
ranids75118703_rani_ds
ranis55235833_rani__s
rankles113114543_rankles
ranpikes1435643_ranpikes
ranted74324703_ran_ted
ranter63826823_ran_ter
ranters73323643_ran_ters
rants55935343_ran_t_s
rapines95120863_rapines
rarities8316333_rarities
rates55352013_ra__tes
ratines75328583_ratines
ratite65022423_ratite_
ravines104220233_ravines
recites93524583_recites
rentes65431193_ren_tes
resites74027793_resites
reunites8312473reunites
rites54442553_r__ites
ruralites947943ruralites
samites93118713_samites
sanies63031953_sani_es
sanities81219753_sanities
scanties103215413scanties
shanties113116573shanties
sienites8311913sienites
stanines85115663stanines
stannites947013stannites
syenites1138943syenites
taxites1449673_taxites
titanites997413titanites
trainees82712063trainees
traits65121983tra_it_s
trances93919643tran_ces
tranches132915513tranches
trannies8415013trannies
transited10410603transited
transits8313493transit_s
trinities9313333trinities
umangites1244483umangites
unakites1237543unakites
unites65024853__unites
uralite71714103uralite_
uranias72113813urani_as
uranide82212093uranide_
uraninites1045613uraninites
uranisms1099973uranisms
uranitic10148683uranitic
uraniums10117163uraniums
urates65027763ura__tes
urbanises11106643urbanises
urbanite1097183urbanite_
urbanities1245313urbanities
urbanizes20106253urbanizes
urinates8314133urinates
vanities111414493_vanities
wraiths1355033wra_iths
wrangles1237463wrangles
writes94420333wr__ites
zanies153219673_zani_es
zaratites1847003zaratites

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461623738.62616944.4
3Display Results3733730.1562391.0
 (SQL Overall)1786913738.95219961.0
 
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.