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

154 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
graver10501859(None) 
braver114719041braver
craver114618471craver
grader84919691grader
grater74625441grater
grave94624871grave_
graved114818811graved
gravel105313821gravel
graven104513521graven
gravers114515271gravers
graves104624001graves
grayer106014541grayer
grazer164815761grazer
raver85631491_raver
aver75931882__aver
beaver114819252beaver
bracer104620582bracer
brave104925502brave_
braved124817442braved
bravers124715522bravers
bravery15428132bravery
braves115524082braves
brawer114216332brawer
brayer115315312brayer
brazer174917532brazer
carver114420152carver
caver105629062_caver
claver113816972claver
crater85026642crater
crave105626312crave_
craved125417772craved
craven114113932craven
cravers124416562cravers
craves115825392craves
draper94315692draper
drave95219272drave_
drawer104711362drawer
driver104714492driver
drover104614592drover
engraver1245332engraver
eraser64216332eraser
framer114817442framer
frater94520592frater
gager74726292g_ager
gamer84928942g_amer
gaper86125122g_aper
garner73917002garner
garter74420512garter
garvey13127872garvey
gater64533652g_ater
gave84634052g_ave_
gavel95815182g_avel
gayer94519192g_ayer
gazer155720072g_azer
giver94921202g_iver
glazer164212262glazer
glover104513532glover
gnawer10386952gnawer
grabber12389762grabber
graben9419722graben
grace85124542grace_
graced105217902graced
graces94523492graces
grade75126092grade_
graded94919552graded
graders94716012graders
grades84926312grades
grafter114211152grafter
grainer83714062grainer
grander93315872grander
granger93514212granger
granter84117132granter
grape84824662grape_
grapery13457952grapery
grapes95123122grapes
grapey126012302grapey
grapier103712602grapier
grasper10389792grasper
grate64932882grate_
grated84523922grated
graters85419742graters
grates75429892grates
gravels113611142gravels
gravely14469062gravely
gravest114011632gravest
gravid113710982gravid
gravies11314092gravies
gravure1134952gravure
gravy125512112grav_y
grayed115415642grayed
graze155820052graze_
grazed174115912grazed
grazers175112452grazers
grazes164519642grazes
grazier173611132grazier
greaser83913082greaser
greater84416492greater
greave104611492greave_
greaved12408912greaved
greaves113311442greaves
greyer104510092greyer
griever1136032griever
griper94114612griper
grivet103517822grivet
groaner82510132groaner
grocer94212142grocer
groover11358542groover
groper94517252groper
grove95219332grove_
groved114413702groved
grovel104310542grovel
groves104318102groves
grower104614932grower
haver115124462_haver
heaver124819672heaver
irater65218352irater
krater104014312krater
laver85031792_laver
leaver94321512leaver
paver104225832_paver
prater84825352prater
prayer114815292prayer
preaver121011612preaver
prover113819722prover
quaver18309312quaver
racer75233022_racer
raker94529792_raker
raper74932752_raper
rarer54731702_rarer
raser55633412_raser
rater54943282_rater
rave75542092_rave_
raved94931432_raved
ravel84621512_ravel
raven84723442_raven
ravers94628182_ravers
raves85441972_raves
rawer84623732_rawer
razer144824272_razer
reaver94524732reaver
river85731692_river
rover85527372_rover
saver84831252_saver
shaver123718912shaver
slaver94419612slaver
suaver93014232suaver
tracer84820232tracer
trader75218762trader
trave85223032trave_
travel94112982travel
traves94222742traves
trover95014662trover
waver115025702_waver
weaver123916612weaver

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511542.34335233.0
3Display Results1541540.0463347.8
 (SQL Overall)1786911542.73265406.7
 
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.