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

398 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
aggro73800(None) 
aggros836541aggros
aero45435342a_ero
agar58726412agar_
agars66120642agars
ager55935842ager_
agers65027852agers
agger76420892agger
aggers85817792aggers
aggie73415012aggie
agio57828452a_gio
ago48845522a_g_o
agora6914332agora
agorot7414992agorot
algor6513052algor
andro6314162andro
anglo65215362anglo
angry9310862angry
giro55828632_giro
gyro85217882_gyro
aargh96314083aargh
abhor10411063abhor
abmho1236793abmho
abo59045963a__bo
abort76133583abort
abri65522213a_bri
acari75020283acari
acerb9312763acerb
achoo10315083achoo
acorn75616623acorn
acre67330773a_cre
actor71116073actor
adagio847663adagio
ado49146873a__do
adobo84711593adobo
adore65723663adore
adorn64917093adorn
aegis6316783aegis
aery77231683a_ery
afar76720783afar_
afars85716513afars
afire86215913afire
afore85818603afore
ag311067463a_g__
aga410447233a_g_a
again65218113again
agama85815573agama
agape85614843agape
agaric93513623agaric
agarose838653agarose
agas55938843a_gas
agate66525143agate
agave95314033agave
agaze156113663agaze
age47154333a_g_e
aged67334253a_ged
agee56241493a_gee
agene65621583agene
agent65829643agent
ages55844593a_ges
aggada955203aggada
aggadot1045133aggadot
aggies83515513aggies
aggrade1035633aggrade
aggress935593aggress
agha87417303a_gha
aghas97014873aghas
agile65122263agile
agin56132713a_gin
aging77026353aging
agios65919863agios
agism84614063agism
agist66325583agist
agita6315423agita
aglare7312423aglare
aglee65728493aglee
aglet65534143aglet
agley96917333agley
aglow94711963aglow
agly86821803a_gly
agma77623263a_gma
agmas85919873agmas
agog68019003a_gog
agon56531883a_gon
agone65924553agone
agons66423783agons
agony96415653agony
agorae7511203agorae
agoras7613343agoras
agoroth1145133agoroth
agree65226033agree
agria65517143agria
ags47551663a_g_s
ague55725923a_gue
agues64919053agues
aigret73720023aigret
air38058393a_ir_
airn46433833a_irn
airs46447423a_irs
airt45757783a_irt
airy75734153a_iry
ajar116217703ajar_
alamo7418143alamo
alar46340073alar_
alarm76621423alarm
alary86123443alary
alert54740653alert
alga57927603alg_a
algae65319623algae
algal66518213algal
algas65624933algas
algid75415573algid
algin65718763algin
algors7312553algors
algum82711763algum
allegro844853allegro
also46423443a_lso
altho86312603altho
alto47831263a_lto
ambo88225133a_mbo
ambry123512093ambry
amido85720963amido
amigo86515453amigo
amino75425493amino
amir65129743amir_
amirs75924913amirs
ammo85520133a_mmo
amnio75218043amnio
amort75832203amort
ancho104515293ancho
andros7313303andros
anga56831353ang_a
angary10311323angary
angas65827983angas
angel65019563angel
anger66225873anger
angers75222543angers
angle64528873angle
anglos74413903anglos
angora71111573angora
angst6415493angst
antra56521923antra
antre55224523antre
apart74330673apart
aper66336233aper_
apers76629133apers
apery106517903apery
apo511142123a__po
aport75432173aport
apron7318833a_pron
ar211379383a__r_
arb510448423a__rb
arbor74818113arbor
arc510250903a__rc
arco68331543a_rco
ardor64617863ardor
are37874573a__re
arf67453373a__rf
argal65023383argal
argil65116883argil
argle65421563argle
argol65317263argol
argon65520593argon
argot67728643argot
argue64818443argue
argus66716543argus
ark77044963a__rk
arm58449623a__rm
armor75118053armor
arrow83414883a_rrow
ars37670933a__rs
art38679143a__rt
arvo76023433a_rvo
audio62917103audio
auger64922473auger
augers73818703augers
aught95120703aught
augur64311213augur
augurs7399963augurs
augury10366663augury
aura45836253a_ura
auto47432083a_uto
aver75931883aver_
avers85127313avers
avert86029493avert
avgas96912133avgas
aviso85713963aviso
avo68936233a__vo
award97118043award
aware86420023aware
awry107619683a_wry
azido155411543azido
azo128233393a__zo
azure14911483azure
bagged114519903bagged
bagger104619203bagger
baggers113915693baggers
baggie102912193baggie
baggy125615683bagg_y
bagnio937523bagnio
biro66131203_biro
bro56236603__bro
burro75018493burro
cager85229223cager_
cagers95624183cagers
cargo85322073carg_o
cero66329453_cero
chiro105320343chiro
claro75018693claro
dagga839543dagg_a
daggas937973daggas
dagger95017293dagger
daggers103714913daggers
daggle93711903daggle
dago65725083dag_o
dobro84412213dobro
doggo84410703doggo
duro56228023_duro
eager65526963eager_
eagers74523683eagers
eagre64315323eagre
eger55923563eger_
egers65120373egers
egg56918673egg__
eggar7458883eggar
eggars8398973eggars
egged85114383egged
egger74414403egger
eggers84612583eggers
eggnog941973eggnog
eggs66516153egg_s
eggy96611853egg_y
ego46726053_eg_o
ergo56420153erg_o
euro45325273_euro
fagged124717703fagged
faggot1139043faggot
faggy136514373fagg_y
faro76136923_faro
forgo94418333forgo
fro65530643__fro
fugio9310923fugio
gabbro11114953gabbro
gadjo1436913gadjo
gag57753633gag__
gaga66625553gag_a
gage65936103gag_e
gaged85522313gaged
gager74726293gager
gagers84021323gagers
gages74529973gages
gagged104817153gagged
gagger95016513gagger
gaggers103413663gaggers
gaggle93412623gaggle
gags66441063gag_s
gar47259903_gar_
garb75332673_garb
garron73113493garron
gars55750743_gars
gator64416033gator
gaur56723353gaur_
gaurs66317993gaurs
gazoo153112873gazoo
genro64914033genro
germ75428963_germ
gird65424993_gird
girl56226553_girl
girn56026863_girn
giron66118993_giron
giros65722653_giros
girt56646423_girt
go38748743__g_o
gobo76126893_gobo
gogo69722833_gogo
goo47754773__goo
gor47848263_gor_
gore55744963_gore
gorm75529393_gorm
gorp75625903_gorp
gory86129663_gory
grog65923343__grog
grok95819683__grok
grot55942053__grot
grow86127303__grow
guiro63712093guiro
guru54623913_guru
gyre84722763_gyre
gyri85415153_gyri
gyron95314623_gyron
gyros95616483_gyros
haggard13377183haggard
hagged124317703hagged
haggis11209513haggis
haggle113511983haggle
hero74635783_hero
hydro12259423hydro
igg57116793igg__
igged86012763igged
iggs66612673igg_s
igloo6410493igloo
inro45920793_inro
intro54915853intro
jager134318133jager_
jagers144415723jagers
jagg136115313jagg__
jaggary19304863jaggary
jagged164115353jagged
jagger154016003jagger
jaggers164012893jaggers
jaggery19336903jaggery
jaggs148111493jagg_s
jaggy175913143jagg_y
jagra1338173jagra
lager65132863lager_
lagers74826143lagers
laggard10347623laggard
lagged95520133lagged
lagger85919833lagger
laggers94216243laggers
largo65319783larg_o
logo57931763log_o
macro94718173macro
maduro936973maduro
maggot10311703maggot
maigre9309163maigre
malgre9299303malgre
mango85724313mang_o
maugre9308973maugre
metro74718803metro
micro94715993micro
morro73216953morro
mucro94513723mucro
nagged93916053nagged
nagger84016123nagger
naggers93812653naggers
naggy106612823nagg_y
nitro54914353nitro
ogre56320743_ogre
pager84728203pager_
pagers94423253pagers
pargo86723723parg_o
pedro8313153pedro
pogrom1138593pogrom
pro55837263__pro
puggry13374823puggry
pyro96019393_pyro
ragg65622693ragg__
ragged94620263ragged
raggee84217603raggee
raggle83712883raggle
raggs75216473ragg_s
raggy106116573ragg_y
regrow10309883regrow
repro75315913repro
retro55020953retro
rigor62714053rigor
sager65432053sager_
saggar84010853saggar
saggard10358953saggard
saggars93610683saggars
sagged94120003sagged
sagger84321073sagger
saggers94017083saggers
saggy105917463sagg_y
sago56332673sag_o
saguaro845513saguaro
sargo65424413sarg_o
segno64814743segno
sego56525183seg_o
sorgo64719723sorgo
tagged93418123tagged
tagger84017693tagger
taggers93514193taggers
tango66921173tang_o
taro46846913_taro
thoro86217873thoro
thro77726423_thro
tiro46832363_tiro
toro48045683_toro
tyro76622363_tyro
upgrow1234273upgrow
vagary1337333vagary
vagrom1235943vagrom
vigor92612423vigor
wager95925053wager_
wagers105122203wagers
wagged124616123wagged
wagger113616013wagger
waggers124613083waggers
waggery15276903waggery
waggle113612303waggle
waggly14347293waggly
waggon1136393waggon
yager95616753yager_
yagers105114533yagers
zagged183612513zagged
zero134822463_zero

Search took 5 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 Filter178691836670.1101624463.6
2DLD Change Limit836673984.23319765.4
3Display Results3983980.1103618.2
 (SQL Overall)1786913984.45340128.2
 
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.