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 “grave” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

195 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
grave9462487(None) 
brave104925501brave
crave105626311crave
drave95219271drave
gave84634051g_ave
grace85124541grace
grade75126091grade
grape84824661grape
grate64932881grate
graved114818811graved
gravel105313821gravel
graven104513521graven
graver105018591graver
graves104624001graves
gravy125512111gravy
graze155820051graze
greave104611491greave
grove95219331grove
rave75542091_rave
trave85223031trave
agave95314032agave
agrafe1038092agrafe
arame75026622arame
ave67748702__ave
brace95629272brace
brae65639112bra_e
brake116025342brake
brava106414792brava
braved124817442braved
braver114719042braver
braves115524082braves
bravi104715752bravi
bravo105214342bravo
braze165423452braze
breve105317052breve
carve106227752carve
cave95941262_cave
clave105420152clave
crake114823522crake
crane75331602crane
crape96128442crape
crate76537402crate
craved125417772craved
craven114113932craven
craver114618462craver
craves115825392craves
craze165221462craze
deave95022332deave
drake104918302drake
drape85319632drape
drive95318002drive
drove95518062drove
eave75733582_eave
engrave1137132engrave
erase54925492erase
fave105532962_fave
frae75330472fra_e
frame105821802frame
gae46457702g_a_e
gage65936102g_age
gale56347322g_ale
game76644322g_ame
gane55145302g_ane
gape75134512g_ape
garage8314512garage
garvey13127872garvey
gate55746572g_ate
gavel95815182g_avel
gaze145032412g_aze
give85829352g_ive
glace87420152glace
glade75121962glade
glaive10357932glaive
glare65222952glare
glaze155418162glaze
glove94516292glove
graal64316502graal
grab75427612gra_b
graben9419722graben
grabs85719692grabs
graced105217902graced
graces94523492graces
grad66829862gra_d
graded94919552graded
grader84919692grader
grades84926312grades
grads75625752grads
graft95327202graft
grail64622872grail
grain65126252grain
gram77034582gra_m
grama85620282grama
gramme114210332gramme
gramp106218322gramp
grams85327312grams
gran56335012gra_n
grana65722092grana
grand75122692grand
grange83716202grange
grans64832542grans
grant64840022grant
grapes95123122grapes
grapey126012302grapey
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grass66125202grass
grat55651282gra_t
grated84523922grated
grater74625442grater
grates75429892grates
gravels113611142gravels
gravely14469062gravely
gravers114515272gravers
gravest114011632gravest
gravid113710982gravid
gravies11314092gravies
gravure1134952gravure
gray85329892gra_y
grayed115415642grayed
grayer106014542grayer
grays95621332grays
grazed174115912grazed
grazer164815762grazer
grazes164519642grazes
grease75416232grease
greaved12408912greaved
greaves113311442greaves
grebe85114942grebe
gree56641562gr_ee
gride75223582gride
grieve1047242grieve
grime85021322grime
gripe84622962gripe
grivet103517822grivet
groove10438872groove
grope84821612grope
groved114413702groved
grovel104310542grovel
groves104318102groves
grue55825712gr_ue
grume86218162grume
guava938582guava
gyrase10508772gyrase
gyrate104912522gyrate
gyve116215082g_yve
have106137072_have
heave114521812heave
irade65618152irade
irate55627982irate
knave12389462knave
lave75642142_lave
leave84723722leave
nave75732312_nave
orate55133302orate
parve109824852parve
pave96133892_pave
prase76128752prase
prate75135982prate
prove104823192prove
race66746262_race
rage55742352_rage
rake84841572_rake
rale45050562_rale
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
raved94931432_raved
ravel84621512_ravel
raven84723442_raven
raver85631492_raver
raves85441972_raves
raze135235432_raze
reave84528022reave
rive75537722_rive
rove75136982_rove
save75741362_save
shave114425892shave
slave84224032slave
soave84219052soave
stave85324992stave
suave83519872suave
thrave126010272thrave
trace75829612trace
trade65026042trade
travel94112982travel
traves94222742traves
trove85221922trove
urare56322552urare
urase54624682urase
urate55432162urate
varve115716852varve
wave105234732_wave
weave115218532weave

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001951.50035866.7
3Display Results1951950.0464239.1
 (SQL Overall)1786911951.639109024.4
 
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.