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

219 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
gradates1051078(None) 
gradate9511221gradate_
gradated1157431gradated
graduates1147681graduates
eradiates102010762eradiates
grades84926312grad__es
gradines103615252gradines
graduate1058082graduate_
graduated1245892graduated
graduses1046452graduses
grandames1346712grandames
granites92116362granites
grates75429882gr__ates
predates11615802predates
radiates92415292_radiates
redates83423862_redates
abates85825033__abates
adages8412953__adages
agates76121333__agates
aggravates1552823aggravates
aguacates1244583aguacates
airdates939713airdates
alates64833963__alates
bradawls1443673bradawls
broadaxes1943723broadaxes
bromates12413133bromates
carates95630603_carates
caudates11310253caudates
cradles103114123crad_les
craniates11310653craniates
crates85736053cr__ates
cravats1237393cravat_s
creates95225173cr_eates
cremates124215983cremates
crudites1137763crudites
cyanates13238423cyanates
dates65639153___dates
dealates92716683dealates
drayages1344503drayages
emanates10311333emanates
eradiate91911753eradiate_
eradiated11178813eradiated
eradicates1348243eradicates
ergates8314473er_gates
exudates1636623exudates
foredates13310043foredates
fracases1336993fracases
frigates12310923frigates
gadgets10348683g_adgets
galatea839943g_alatea
galateas937123g_alateas
galaxes1538873g_alaxes
gallates92815523gallates
gametes10312253g_ametes
garages9314113g_arages
garbages1238183garbages
garotes8614563g_arotes
garottes978283garottes
garrotes969363garrotes
gates65939503g___ates
gavages1237683g_avages
gelates83219583g_elates
gemmates13307673gemmates
gestates93213723gestates
glaciates1267343glaciates
glades84820343glad__es
gladiate1057053gladiate_
graals74112913gra_a_ls
grabbles13339893grabbles
graces94523493gr__aces
graciles112511613graciles
grackles15309183grackles
gradable1238823gradable
gradating1237313gradating
gradation11107713gradation
gradations1286853gradations
grade75126093grad__e_
graded94919553grad__ed
gradeless11236703gradeless
grader84919693grad__er
graders94715993grad_ers
gradine93317033gradine_
gradins93416233grad_ins
grads75625753grad___s
graduals1046203graduals
graduands1243583graduands
graduator1144573graduator
graduators1244223graduators
gradus84411213grad__us
graftages1443683graftages
grafted124110223gra_fted
grafter114211153gra_fter
grafters12409183gra_fters
grafts105013253gra_ft_s
grahams1335333graha_ms
gramaries12128293gramaries
gramaryes1572873gramaryes
gramas94317203grama__s
grammes123611323gra_mmes
granaries10159883granaries
grandads1136553granda_ds
grandame1247113grandame_
grandams1237123granda_ms
grandees103211283grandees
granges93516523gra_nges
granitas92610223granitas
granite82017083granite_
grannies9312613grannies
granted94715103gra_nted
grantee83217133gra_ntee
grantees92510973grantees
granter84117133gra_nter
granters93614133gra_nters
grants73722473gra_nt_s
granulates1148463granulates
granules939933granules
grapes95123123gr__apes
graphites1546823graphites
grapples13348123grapples
grasses84117343gra_sses
grate64932883gr__ate_
grated84523923gr__ated
grater74625433gr__ater
graters85419733gr__aters
gratis74819243gr__atis
gratulates1157133gratulates
gravamen1443933gravamen
gravamens1542783gravamens
graves104624003gr__aves
gravies11314093gra_vies
gravitas12316013gravitas
gravitates1444843gravitates
gravities1338303gravities
gravures1234903gravures
graywater1643283graywater
graywaters1742553graywaters
grazes164519643gr__azes
greases84816713gr_eases
greaten83610643gr_eaten
greatens9307593gr_eatens
greater84416493gr_eater
greatest939863gr_eatest
greats76318393gr_eat_s
greaves113311443gr_eaves
grenades1038433grenades
griddles1145753griddles
grides84422363grid__es
grimaces1355383grimaces
groats74816653gr_oat_s
grudges10349423grud_ges
guanases936233guanases
gyrates113610263g_yrates
hamates122917673_hamates
headgates1446383headgates
imamates1237653imamates
iodates8312893_iodates
irades74517393irad__es
irradiates1144293irradiates
karates115617473_karates
khanates1535733khanates
madames12310063_madames
malates93522603_malates
mandates11314093mandates
misdates111113623misdates
narrates8312753narrates
nidates8311883_nidates
orates64328613or__ates
outdates93114743outdates
oxalates1557063oxalates
oxidates1636333oxidates
palates93624933_palates
placates12311753placates
playdates1554903playdates
prates84633163pr__ates
predate10616893predate_
predated12513273predated
prelates10418563prelates
primates121515933primates
privates131812373privates
probates12414263probates
pronates10418373pronates
prorates10418063prorates
quadrates19117793quadrates
rabatos93010893_rabatos
rabats83116223_rabat_s
radars71314663_rada_rs
raddles93615703_raddles
radiate83416313_radiate_
radiated102512593_radiated
radicates12412073_radicates
radices102314263_radices
radixes15259343_radixes
radomes10311043_radomes
radwastes1364123_radwastes
ramate83921683_ramate_
rates55352013_r__ates
ratites74920683_ratites
ravages1139403_ravages
rebates95123173_rebates
redate74124683_redate_
redated93120923_redated
relates73731423_relates
remates93827103_remates
reradiates11177993reradiates
rotates72819773_rotates
savates10312953_savates
sedates83418033_sedates
tractates1159753tractates
trades75724493trad__es
traduces1136553traduces
updates10329793_updates
uralites82112723uralites
uranites82514643uranites
urates65027763ur__ates
urinates8314133urinates
vacates12312833_vacates
vanadates1345133vanadates
variates111214973variates
yardages1336203yardages

Search took 8 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.1731032896.0
2DLD Change Limit1461622197.35619869.8
3Display Results2192190.0962281.3
 (SQL Overall)1786912197.62523434.9
 
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.