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

246 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
gradate951123(None) 
gradated1157431gradated
gradates10510781gradates
graduate1058081graduate
eradiate91911752eradiate
gladiate1057052gladiate
gradable1238822gradable
grade75126092grad__e
gradine93317032gradine
graduated1245892graduated
graduates1147682graduates
grandame1247112grandame
granite82017082granite
grate64932882gr__ate
predate10616892predate
radiate83416312_radiate
ramate83921682_ramate
redate74124682_redate
abate76627843__abate
acaudate1145973acaudate
adage7414053__adage
adnate72913483__adnate
agate66525153__agate
aggravate1443003aggravate
aguacate1144973aguacate
airdate8311323airdate
alate55340323__alate
arcuate9311963arcuate
barbate11314543barbate
bradawl1344363bradawl
broadaxe1843623broadaxe
bromate11313553bromate
carate84734003_carate
caudate10311353caudate
clavate1238713clavate
cordate10315223cordate
cradle93313163crad_le
craniate10312563craniate
crate76537403cr__ate
cravat11314443cravat_
cravats1237403cravats
create85126383cr_eate
cremate113816183cremate
crenate93317113crenate
cyanate12259703cyanate
date56443323___date
dealate83617843dealate
drayage1234423drayage
ecaudate1145313ecaudate
emanate9312473emanate
eradiated11178813eradiated
eradiates102010783eradiates
eradicate1259183eradicate
ergate7315143er_gate
erudite838483erudite
exudate1537093exudate
foredate12310913foredate
frigate11311063frigate
gadget93616183g_adget
gadje1457743g_ad_je
galatea839953g_alatea
galeate83916783galeate
gallate83417123gallate
gamete9313593g_amete
garage8314513g_arage
garbage1138053garbage
garda7316763garda__
gardai839663garda_i
gardant9314463gardant
garote7717953g_arote
garotte868703garotte
garrote8510103garrote
gate55746573g___ate
gavage1137193g_avage
gelate73421253g_elate
gemmate12418383gemmate
gestate83614073gestate
glabrate1146033glabrate
glaciate1168073glaciate
glade75121963glad__e
globate1057823globate
graal64316503gra_a_l
graals74112913gra_als
grabble12339643grabble
grace85124543gr__ace
gracile102512603gracile
grackle14338893grackle
grad66829863grad___
gradating1237313gradating
gradation11107713gradation
graded94919553grad_ed
grader84919693grad_er
graders94716013graders
grades84926313grad_es
gradin83517483grad_in
gradines103615253gradines
grading103918713grading
gradins93416233gradins
grads75625753grad__s
gradual936943gradual
graduals1046203graduals
graduand1143893graduand
graduator1144573graduator
gradus84411223grad_us
graduses1046453graduses
graft95327203gra_ft_
graftage1343683graftage
grafted124110223gra_fted
grafter114211153gra_fter
grafts105013253gra_fts
graham1237853graha_m
grahams1335333grahams
grama85620283grama__
gramary1355903gramary
gramarye1462713gramarye
gramas94317203grama_s
gramme114210333gra_mme
grana65722093grana__
granary1157793granary
grandad1038453granda_d
grandads1136553grandads
grandam1139393granda_m
grandames1346713grandames
grandams1237123grandams
grandee93115513grandee
grange83716203gra_nge
granita82111303granita
granites92116363granites
grannie8310353grannie
grant64840023gra_nt_
granted94715103gra_nted
grantee83217133grantee
granter84117133gra_nter
grants73722473gra_nts
granulate1059183granulate
granule839473granule
grape84824663gr__ape
graphite1447153graphite
grapple12378003grapple
grat55651283gr__at_
grated84523923gr__ated
grater74625443gr__ater
grates75429893gr__ates
gratine84719193gratine
gratulate1047683gratulate
gravamen1443933gravamen
grave94624873gr__ave
gravidae13324793gravida_e
gravitate1345543gravitate
gravity1437183gravity
gravure1134953gravure
graywater1643283graywater
grazable2036223grazable
graze155820053gr__aze
grease75416233gr_ease
great66034243gr_eat_
greaten83610643gr_eaten
greater84416493gr_eater
greats76318393gr_eats
greave104611493gr_eave
grenade938413grenade
griddle1035503griddle
gride75223583grid__e
grimace1255083grimace
groat65531973gr_oat_
groats74816653gr_oats
grudge9388583grud_ge
guanase836213guanase
guttate8328903guttate
gyrate104912523g_yrate
hamate113319833_hamate
headgate1346483headgate
imamate1138103imamate
iodate7313503_iodate
irade65618153irad__e
irate55627983ir__ate
irradiate1044463irradiate
karate105320923_karate
khanate1437073khanate
lanate6421263_lanate
madame1139853_madame
malate84624553_malate
mandate10315573mandate
misdate101413963misdate
narrate7313493narrate
nidate7313783_nidate
orate55133303or__ate
ornate6315143or_nate
outdate83016423outdate
oxalate1457623oxalate
oxidate1537023oxidate
palate84226783_palate
pedate93117763_pedate
placate11312433placate
planate9314573planate
playdate1465263playdate
prate75135983pr__ate
predated12513273predated
predates11615813predates
prelate9519693prelate
primate111516283primate
private121513263private
probate11414483probate
prolate9419793prolate
pronate9418873pronate
prorate9418733prorate
quadrate1888043quadrate
rabat72832223_rabat_
rabato83413263_rabato
rabats83116223_rabats
radar61316723_rada_r
radars71314673_radars
raddle84816173_raddle
radiale83813523_radiale
radiated102512593_radiated
radiates92415293_radiates
radicate11412873_radicate
radome9511873_radome
radwaste1243843_radwaste
rate45458763_r__ate
ratite65022423_ratite
ravage1039303_ravage
rebate84424113_rebate
redated93120923_redated
redates83423873_redates
relate64033633_relate
remate84428683_remate
reradiate10179033reradiate
rotate63320343_rotate
rugate75813813_rugate
savate9313783_savate
sedate73019813_sedate
trabeate1049483trabeate
tractate10411003tractate
tradable1139873tradable
trade65026043trad__e
traduce1036353traduce
update93810293_update
uralite71714103uralite
uranite72515693uranite
urate55432163ur__ate
urinate7315363urinate
vacate11314553_vacate
vanadate1245513vanadate
variate101316433variate
yardage1235733yardage

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.423422437.4
2DLD Change Limit1340272466.12621878.4
3Display Results2462460.0932645.2
 (SQL Overall)1786912466.64226903.2
 
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.