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

129 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
gravures123490(None) 
gravure1134951gravure_
bravuras1343442bravuras
bravure1254392bravure_
erasures837212erasures
graduses1046452graduses
granules939932granules
gravers114515272graver_s
graves104624002grav__es
gravies11314092grav_ies
rasures7312012_rasures
arcatures1186833arcatures
armatures1166973armatures
armures9510273ar_mures
aures55137093__a_ures
azures15510183__azures
braveries1439103braveries
bravers124715523braver_s
braves115524083brav__es
bravoes12418533brav_oes
bravura1253603bravur_a
cravers124416553craver_s
craves115825393crav__es
creatures1138413creatures
erasure736943erasure_
favuses1336183_favuses
features11310333features
fractures14147233fractures
galeres83514333g_aleres
galores82614323g_alores
gauges85915993g_a_uges
gaurs66317993g_a_ur_s
gauzes164710633g_a_uzes
gavages1237683g_avages
gestures9310013gestures
giaours834573giaour_s
glaires84010133gla_ires
glares75518863gla__res
grabbers13337883grabbers
grabbles13339893grabbles
graces94523493gra__ces
graciles112511613graciles
grackles15309183grackles
gradates10510783gradates
graders94716013grader_s
grades84926313gra__des
gradines103615253gradines
graduals1046203graduals
graduates1147683graduates
gradus84411223gradu__s
grafters12409193grafters
grainers93012073grainers
gramaries12128303gramaries
gramaryes1572873gramaryes
grammes123611323gra_mmes
grampuses1442973grampuses
granaries10159883granaries
grandees103211283grandees
grangers103011973grangers
granges93516523gra_nges
granites92116363granites
grannies9312613grannies
grantees92510973grantees
granters93614143granters
granule839473granule_
graperies1239613graperies
grapes95123123gra__pes
grapples13348123grapples
graspers11338403graspers
grasses84117343gra_sses
graters85419743grater_s
grates75429893gra__tes
graupel1034133gra_upel
graupels1133103gra_upels
gravamen1443933gravamen
gravamens1542783gravamens
grave94624873grav__e_
graved114818813grav__ed
gravel105313823grav__el
graveled13417363graveled
graveless13226693graveless
gravels113611143grav_els
graven104513523grav__en
graveness13288383graveness
graver105018593grav__er
gravest114011633grav__est
gravidas13285803gravidas
gravitas12316013gravitas
gravities1338303gravities
gravlaks1642423gravlaks
grazers175112453grazer_s
grazes164519643gra__zes
graziers18387123graziers
greaves113311443greav__es
grouses84616543gr_ouses
groves104318103grov__es
grues65721963gr__u_es
grumes94415553gr__umes
gruyeres1242863gruyeres
guayules1243223guayules
guipures1143733guipures
gyplures14102153gyplures
manures9313353_manures
matures9314303_matures
measures1038913measures
natures7311963_natures
nervures1135123nervures
ordures856473or_dures
parures9512693_parures
precures12312903precures
prevues1239263prevu_es
procures1239213procures
raptures1037573_raptures
rares55247443_ra__res
rasure6311423_rasure_
ravages1139403_ravages
ravers94628183_raver_s
raves85441973_rav__es
ravines104220233_ravines
reveres103621343_reveres
revues9813903_revu_es
statures83711113statures
traduces1136563traduces
traverse1136213traverse
traverses1246343traverses
traves94222743trav__es
treasures946633treasures
uraeuses835383uraeuses
urares64519093ura__res

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.420425454.8
2DLD Change Limit1461621297.64019131.2
3Display Results1291290.0632047.6
 (SQL Overall)1786911298.12321998.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.