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

335 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
ager5593584(None) 
agar58726411agar
age47154331age_
aged67334251aged
agee56241491agee
agers65027851agers
ages55844591ages
agger76420891agger
anger66225871anger
aper66336231aper
auger64922471auger
aver75931881aver
cager85229221cager
eager65526961eager
eger55923561eger
gager74726291gager
jager134318131jager
lager65132861lager
pager84728201pager
sager65432051sager
wager95925051wager
yager95616751yager
abed79734132abed
abet610547942abet
abler75624312abler
ace59656832ace_
aced79540882aced
acerb9312762acerb
aces67645092aces
acre67330772acre
adder75419592adder
ae212590292a_e_
aero45435342a_ero
aery77231682a_ery
afar76720782afar
after85719792after
ag311067462ag__
aga410447232ag_a
agars66120642agars
agas55938842agas
agene65621582agene
agent65829642agent
aggers85817792aggers
aggro738002aggro
agha87417302agha
agin56132712agin
agio57828452agio
aglee65728492aglee
aglet65534142aglet
agley96917332agley
agly86821802agly
agma77623262agma
ago48845522ag_o
agog68019002agog
agon56531882agon
agora6914332agora
agree65226032agree
ags47551662ag_s
ague55725922ague
agues64919052agues
ahed89536252ahed
ahem97225362ahem
aider65431132aider
aimer75926822aimer
air38058392a_ir
airer54927892airer
aiver85725162aiver
ajar116217702ajar
ajee115928232ajee
akee85936812akee
alar46340072alar
alder65421912alder
ale36572342ale_
alec66430062alec
alee46652322alee
alef76340692alef
alert54740652alert
ales47067102ales
algor6513052algor
alter54828502alter
amber94523202amber
ameer75618982ameer
amen66733152amen
amir65129742amir
ane37866942ane_
anear55420322anear
anes45255932anes
anew76623132anew
angel65019562angel
angers75222542angers
angler74017862angler
ape57251182ape_
aped78538152aped
apers76629132apers
apery106517902apery
apes66047432apes
apex137220212apex
apter76120202apter
ar211379382a__r
are37874572are_
area45843392area
ares45871022ares
arguer74510542arguer
armer76924442armer
asea46327182asea
asker96418782asker
asper75520432asper
aster55434892aster
ate37059242ate_
ates45047922ates
augers73818702augers
augur64311212augur
ave67748702ave_
avers85127312avers
avert86029492avert
aves76142602aves
awe67746622awe_
awed88436032awed
awee76336642awee
awes76037552awes
axe108239492axe_
axed128829612axed
axel115222072axel
axes117337852axes
aye67151762aye_
ayes76543512ayes
badger105415072badger
bagel85116792bagel
bagger104619202bagger
baker115629542baker
baler75635272baler
banger94423632banger
barer74535802barer
baser74828922baser
beer65635992beer
bier65531822bier
caber95126832caber
cadger105013892cadger
cage75339062cage_
caged95426362caged
cagers95624182cagers
cages85936012cages
cagey115917822cagey
cagier93715932cagier
caner75334772caner
caper94831622caper
carer74942332carer
cater74840702cater
caver105629062caver
dagger95017302dagger
danger83722822danger
darer65230792darer
dater65332312dater
deer56739022deer
doer57734702doer
dyer85522112dyer
eagers74523682eagers
eagre64315322eagre
eater54639842eater
edger75215932edger
egers65120372egers
egger74414402egger
er28345142__er
ever77027692ever
ewer77523982ewer
eyer76127282eyer
facer105525052facer
fader94421512fader
faker124824592faker
farer86733142farer
fer66646122_fer
gae46457702gae_
gaed66031512gaed
gaen57329602gaen
gaes56348032gaes
gage65936102gage_
gaged85522312gaged
gagers84021322gagers
gages74529972gages
gagger95016512gagger
gamer84928942gamer
ganger83721462ganger
gaper86125122gaper
gar47259902_gar
gater64533642gater
gauger84714852gauger
gaur56723352gaur
gayer94519192gayer
gazer155720072gazer
gear55934972_gear
ged57044532_ged
gee45359202_gee
gel45642432_gel
gem66840222_gem
gen45950512_gen
germ75428962_germ
get47467462_get
gey75738302_gey
goer56827102goer
gor47848262_gor
haler85033522haler
hanger104023252hanger
hater85034752hater
haver115124462haver
hayer114620242hayer
hazer174820232hazer
her66547812_her
hoer76533982hoer
huger94914872huger
imager9108112imager
jaeger14397192jaeger
jagers144415722jagers
jagger154016002jagger
japer146218882japer
jeer115426462jeer
kier86526802kier
laager74312782laager
lacer75833752lacer
lader65633722lader
lagers74826142lagers
lagger85919832lagger
laker95432872laker
lamer75233702lamer
larger74417512larger
laser54633322laser
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leer46239352leer
leger65721502leger
lier45942462lier
liger65024472liger
luger65322082luger
macer912126942macer
mage75739122mage_
mages85036022mages
maker114127812maker
manger94325002manger
maser75029972maser
mater74438862mater
mauger93813482mauger
mazer165722422mazer
meager94515192meager
nagger84016122nagger
namer75622102namer
oater55433732oater
ogee57629882ogee
ogler65917442ogler
ogre56320742ogre
omer67028392omer
onager739662onager
over77227342over
oyer75927652oyer
pacer96131612pacer
page76036102page_
paged95926782paged
pagers94423252pagers
pages85235072pages
paler75436932paler
paper95128662paper
parer75839902parer
pater74740722pater
paver104225832paver
pawer104422972pawer
payer105125722payer
peer66238352peer
per56353092_per
pier66035292pier
racer75233022racer
rage55742352rage_
raged74829452raged
ragee65432662ragee
rages64539442rages
raker94529792raker
ranger73925522ranger
raper74932752raper
rarer54731702rarer
raser55633412raser
rater54943282rater
raver85631492raver
rawer84623732rawer
razer144824272razer
roger64521412roger
ruer46127562ruer
saber75330242saber
safer84721812safer
sage55044592sage_
sages65339062sages
sagger84321072sagger
sagier73717162sagier
saker95132022saker
saner54334322saner
sanger74524562sanger
sauger74316252sauger
saver84831252saver
sawer85026212sawer
sayer84926552sayer
seer45547042seer
ser36752402_ser
stager74821342stager
suer45334032suer
swager104013612swager
taber73825822taber
tagger84017702tagger
taker95229002taker
taler56034862taler
tamer75230102tamer
taper74829772taper
tater54138612tater
tawer85223442tawer
taxer125019362taxer
tier44936142tier
tiger65718632tiger
tyer75323392tyer
urger64116472urger
user45023002user
vaguer10448442vaguer
veer76229572veer
vier75428152vier
wader95325362wader
wafer114417642wafer
wage84834082wage_
waged104822782waged
wagers105122202wagers
wages95330932wages
wagger113616012wagger
waker125526592waker
waler84229262waler
water84733312water
waver115025702waver
waxer154317482waxer
weer75535092weer
yagers105114532yagers
yarer84321572yarer

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 Filter178691298720.0632836365.1
2DLD Change Limit298723351.08027659.3
3Display Results3353350.0764407.9
 (SQL Overall)1786913351.219146588.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.