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

137 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
gravure113495(None) 
bravure1254391bravure
gravures1234901gravures
bravura1253602bravura
erasure736942erasure
granule839472granule
grave94624872grav__e
graver105018592graver_
gravers114515272gravers
rasure6311422_rasure
arcature1086503arcature
armature10106973armature
armure8710133ar_mure
azure14911483__azure
brave104925503brav__e
braver114719043braver_
bravers124715523bravers
bravery15428133bravery
bravuras1343443bravuras
crave105626313crav__e
craver114618473craver_
cravers124416563cravers
creature1038743creature
drave95219273drav__e
erasures837213erasures
feature1039853feature
fracture13147143fracture
galere73716693g_alere
galore73514873g_alore
gauge76117903g_a_uge
gaur56723353g_a_ur_
gaurs66317993g_a_urs
gauze155712973g_a_uze
gavage1137193g_avage
gave84634053g_av__e
gesture839243gesture
giaour735363giaour_
giaours834573giaours
glaire74411303gla_ire
glare65222963gla__re
grabber12389763grabber
grabble12339643grabble
grace85124543gra__ce
gracile102512603gracile
grackle14338893grackle
gradate9511233gradate
grade75126093gra__de
grader84919693grader_
graders94716013graders
gradine93317033gradine
gradual936943gradual
graduate1058083graduate
gradus84411223gradu_s
graduses1046453graduses
grafter114211153grafter
grainer83714063grainer
gramary1355913gramary
gramarye1462723gramarye
gramme114210333gra_mme
granary1157793granary
grandee93115513grandee
grander93315873grander
grange83716203gra_nge
granger93514213granger
granite82017083granite
grannie8310353grannie
grantee83217133grantee
granter84117133granter
granules939943granules
granum9310913granu_m
grape84824663gra__pe
grapery13457953grapery
grapier103712603grapier
grapple12378003grapple
grasper10389793grasper
grate64932883gra__te
grater74625443grater_
graters85419743graters
gratine84719193gratine
graupel1034133gra_upel
gravamen1443933gravamen
graved114818813grav_ed
gravel105313823grav_el
graveled13417363graveled
gravels113611143gravels
gravely14469063gravely
graven104513523grav_en
graves104624003grav_es
gravest114011633gravest
gravid113710983grav_id
gravida12366563gravida
gravidae13324793gravidae
gravies11314093gravies
graving123114563graving
gravity1437183gravity
gravlax1842643gravlax
gravy125512113grav__y
grayer106014543grayer_
graze155820053gra__ze
grazer164815763grazer_
grazers175112453grazers
grazier173611133grazier
greave104611493greav__e
grouse74315023gr_ouse
grove95219333grov__e
grue55825713gr__u_e
grume86218163gr__ume
gruyere1133123gruyere
guayule1142823guayule
guipure1043533guipure
gyplure13122013gyplure
manure8313653_manure
mature8313473_mature
measure939033measure
nature6311263_nature
nervure1034973nervure
ordure756813or_dure
parure8312523_parure
precure11312553precure
prevue1179163prevu_e
procure1138573procure
rapture937393_rapture
rare45348433_ra__re
rasures7312013_rasures
ravage1039303_ravage
rave75542093_rav__e
raver85631493_raver_
ravers94628183_ravers
ravine95522223_ravine
revere94621253_revere
revue81114453_revu_e
stature74410683stature
traduce1036353traduce
trave85223033trav__e
traverse1136213traverse
treasure846753treasure
urare56322553ura__re

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271377.00319138.5
3Display Results1371370.0433186.0
 (SQL Overall)1786911377.46623934.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.