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

361 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
agrafe103809(None) 
agrafes1137521agrafes
agraffe1443331agraffe
abrade9313052abrade
aerate64830552aerate
agape85614842ag_ape
agate66525142ag_ate
agave95314032ag_ave
agaze156113662ag_aze
aggrade1035632aggrade
aglare7312422aglare
agnate73314872agnate
agorae7511202agora_e
agraffes1553042agraffes
agree65226032agr_ee
arame75026622a_rame
aurae54128112aura_e
aurate64426472aurate
carafe115416162carafe
garage8314512garage
grace85124542_grace
grade75126092_grade
graft95327202_graft
grape84824662_grape
grate64932882_grate
grave94624872_grave
graze155820052_graze
strafe95215972strafe
abaft10318063a_baft
abase76023483a_base
abate76627843a_bate
ablate82219213ablate
ablaze17239833ablaze
abraded1138643abraded
abrader1038643abrader
abrades10312073abrades
acerate92818913acerate
acre67330773acr__e
acreage1037833acreage
acuate8315633acuate
adage7414053a_dage
adnate72913483adnate
adrift10313113adrift
aerated85322373aerated
aerates74627483aerates
aerie54634603aer_ie
aerify122810113aerify
aerobe8412403aerobe
aflame1138723aflame
afraid1049713afraid
aga410447233ag_a__
again65218113ag_ain
agama85815573ag_ama
agapae9388043agapae
agapes95212413ag_apes
agar58726413ag_a_r
agaric93513623agaric
agarose838653agarose
agars66120643ag_ars
agas55938843ag_a_s
agates76121333ag_ates
agaves104611513ag_aves
age47154333ag___e
agee56241493ag__ee
agemate101210583agemate
agene65621583ag_ene
aggada955203aggada
aggie73415013ag_gie
aggraded1244183aggraded
aggrades1135853aggrades
agha87417303agha__
aghas97014873agha_s
aghast105711363aghast
agile65122263ag_ile
agitate8312063agitate
aglee65728493ag_lee
agma77623263agma__
agmas85919873agma_s
agnail739523agnail
agnates82813183agnates
agnize16329563agnize
agone65924553ag_one
agora6914333agora__
agoras7613343agora_s
agrapha1345133agrapha
agravic1345883agravic
agreed84712503agreed
agrees74915323agrees
agria65517143agr_ia
agrias74315393agrias
ague55725923ag__ue
airdate8311323airdate
airfare1047243airfare
airwave1344433airwave
alae45643753a_la_e
alane56135613a_lane
alate55340323a_late
alcade91111513alcade
algae65319623alga_e
alkane104313323alkane
amaze166016603a_maze
ambage11510593ambage
amirate91115953amirate
anlace82513923anlace
anlage72514223anlage
ansae55720973ansa_e
ansate64517863ansate
antae56828293anta_e
aortae65115473aortae
apace94718383a_pace
apyrase1236363apyrase
aquae142212713aqua_e
arable81821003a_rable
arak86929573a_ra_k
araks94820883a_raks
arames84622573a_rames
arcade91013643arcade
arcane81216743arcane
are37874573a_r__e
areae55229743a_reae
arene55329413a_rene
arete56031353a_rete
arf67453373a_r_f_
arfs76029963a_r_fs
argal65023383arga_l
argala74712663argala
argali75013743argali
argals75517703argals
argle65421563a_rgle
argue64818443a_rgue
argufy1344093argufy
argyle1066063argyle
arise56436433a_rise
arose55832083a_rose
arrack121110253arrack
arrange838683arrange
arrant6623253arrant
arras55626133arra_s
arrased8149863arrased
arrases71214543arrases
array86317143arra_y
arrayed11117153arrayed
arrayer10136703arrayer
arrays95311683arrays
arrive91311793arrive
arse46539273a_r_se
asrama839193asrama
aubade939223aubade
aura45836253aura__
aural54428963aura_l
aurar54420253aura_r
auras55932553aura_s
aurated83817793aurated
aureate72515283aureate
average1158853average
aviate9315203aviate
awake125014783a_wake
aware86420023a_ware
baggage1235633baggage
barrage10710843barrage
berake124216083berake
berate84729023berate
borage93917013borage
borane84620213borane
borate85026153borate
brace95629273_brace
brae65639113_bra_e
brake116025343_brake
brave104925503_brave
braze165423453_braze
cafe95230323__cafe
carafes125015703carafes
carate84734003carate
cerate84829463cerate
chafe135117353_chafe
craft105327663_craft
crake114823523_crake
crane75331603_crane
crape96128443_crape
crate76537403_crate
crave105626313_crave
craze165221463_craze
curare84916953curare
curate85226243curate
degrade10229903degrade
derate74531233derate
draff125615663_draff
draft95526683_draft
drake104918303_drake
drape85319633_drape
drave95219273_drave
eagre64315323eagr__e
engraft11118613engraft
engrave1137133engrave
enrage72715073enrage
erase54925493_erase
ergate7315143ergate
forage104616993forage
frae75330473_fra_e
frame105821803_frame
furane94015493furane
gae46457703_g_a_e
gaff114828153_g_aff
gaffe124111653_gaffe
gage65936103_g_age
gale56347323_g_ale
game76644323_g_ame
gane55145293_g_ane
gape75134513_g_ape
garaged1039253garaged
garages9314113garages
garbage1138053garbage
garble94118453garble
gargle84215463gargle
garote7717943garote
gate55746573_g_ate
gavage1137193gavage
gave84634053_g_ave
gaze145032413_g_aze
giraffe1442993giraffe
glace87420153_glace
glade75121963_glade
glare65222953_glare
glaze155418163_glaze
graal64316503_graal
grab75427613_gra_b
graben9419723_graben
grabs85719693_grabs
graced105217903_graced
graces94523493_graces
grad66829863_gra_d
graded94919553_graded
grader84919693_grader
grades84926313_grades
grads75625753_grads
grafted124110223_grafted
grafter114211153_grafter
grafts105013253_grafts
grail64622873_grail
grain65126253_grain
gram77034583_gra_m
grama85620283_grama
gramme114210333_gramme
gramp106218323_gramp
grams85327313_grams
gran56335013_gra_n
grana65722093_grana
grand75122693_grand
grange83716203_grange
grans64832543_grans
grant64840023_grant
grapes95123123_grapes
grapey126012303_grapey
graph115315613_graph
grapy115416433_grapy
grasp84814483_grasp
grass66125203_grass
grat55651283_gra_t
grated84523923_grated
grater74625433_grater
grates75429883_grates
graved114818813_graved
gravel105313823_gravel
graven104513523_graven
graver105018593_graver
graves104624003_graves
gravy125512113_gravy
gray85329893_gra_y
grayed115415643_grayed
grayer106014543_grayer
grays95621333_grays
grazed174115913_grazed
grazer164815763_grazer
grazes164519643_grazes
grease75416233_grease
greave104611493_greave
grebe85114943_grebe
gree56641563_gr_ee
gride75223583_gride
grief95319773_grief
griff124416453_griff
griffe13438093_griffe
grift95924463_grift
grime85021323_grime
gripe84622963_gripe
grope84821613_grope
grove95219333_grove
grue55825713_gr_ue
gruff124712143_gruff
grume86218163_grume
gyrase10508773gyrase
gyrate104912523gyrate
hagride1237553hagride
hagrode1236443hagrode
ingraft1199483ingraft
ingrate8715113ingrate
irade65618153_irade
irate55627983_irate
jagra1338173jagra__
jagras1438463jagra_s
karate105320923karate
kraft125721013_kraft
langrage10106033langrage
laurae64011663laura_e
lyrate94112103lyrate
macrame1338713macrame
magnate10512703magnate
margrave1444793margrave
migrate101314163migrate
mirage92313653mirage
morae75831193mora_e
morale85220553morale
narrate7313493narrate
ogre56320743ogr__e
orate55133303_orate
parade94720643parade
parae76335703para_e
paygrade1543593paygrade
phrase11109903phrase
pirate82322883pirate
prase76128753_prase
prate75135983_prate
race66746263__race
raff104933043__raff
raft76245913__raft
rage55742353__rage
rake84841573__rake
rale45050563__rale
rape65041633__rape
rare45348433__rare
rase46149983__rase
rate45458763__rate
rave75542093__rave
raze135235433__raze
regrade92612033regrade
regraft11310153regraft
regrate82618653regrate
rife74632323__rife
safe75930953__safe
sarape84817573sarape
scrape105917573scrape
serape84818413serape
strafed114413323strafed
strafer103912443strafer
strafes104515993strafes
strake104017393strake
strife95318363strife
tagrag837043tagra_g
tagrags936123tagrags
thrave126010273thrave
tirade7311693tirade
trace75829613_trace
trade65026043_trade
trave85223033_trave
unsafe9310693unsafe
upgrade11215823upgrade
uprate83916543uprate
urare56322553_urare
urase54624683_urase
urate55432163_urate
vagrant11410663vagrant

Search took 10 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 Filter1786911127160.280638182.1
2DLD Change Limit1127163618.72012926.1
3Display Results3613610.1262865.1
 (SQL Overall)1786913619.12619580.4
 
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.