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

214 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
anger6622587(None) 
ager55935841a_ger
agger76420891agger
angel65019561angel
angers75222541angers
angler74017861angler
auger64922471auger
banger94423631banger
danger83722821danger
ganger83721461ganger
hanger104023251hanger
manger94325001manger
ranger73925521ranger
sanger74524561sanger
abler75624312abler
adder75419592adder
after85719792after
agar58726412a_gar
age47154332a_ge_
aged67334252a_ged
agee56241492a_gee
agers65027852a_gers
ages55844592a_ges
aggers85817792aggers
aider65431132aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alder65421912alder
algor6513052algor
alter54828502alter
amber94523212amber
ameer75618982ameer
ane37866952an_e_
anear55420322anear
anes45255932an_es
anew76623132an_ew
anga56831352ang_a
angary10311322angary
angas65827982angas
angels74416172angels
angered93013472angered
angerly1137772angerly
angle64528872angle
angled84219092angled
anglers84014822anglers
angles74426702angles
anglo65215372anglo
angora71111572angora
angrier839022angrier
angry9310862angry
angst6415492angst
annex12310882annex
answer936892answer
ante46538902ante_
anted66328242anted
antes56334322antes
anther93715062anther
antler64615552antler
antre55224522antre
aper66336232a_per
apter76120202apter
arguer74510542arguer
armer76924442armer
asker96418782asker
asper75520432asper
aster55434892aster
augers73818702augers
augur64311212augur
avenger1135492avenger
aver75931882a_ver
badger105415082badger
bagger104619202bagger
bander93928222bander
banged104923722banged
bangers104020352bangers
banker124222732banker
banner84421502banner
banter84825332banter
binger94923452binger
cadger105013912cadger
cager85229222cager
cancer104220922cancer
caner75334772can_er
canker124422522canker
canner84625982canner
canoer85121072canoer
canter85230112canter
changer134215542changer
clanger104113492clanger
conger95024272conger
dagger95017302dagger
dancer94817612dancer
dander811222992dander
danged94819482danged
dangers94818212dangers
dangler96912812dangler
danker114319662danker
dinger85323672dinger
eager65526972eager
edger75215952edger
eger55923572_eger
egger74414412egger
ender64325862ender
enter54726382enter
fanged114318222fanged
fanner94218182fanner
finger104920332finger
flanger113412622flanger
gager74726292gager
gagger95016512gagger
gander84322762gander
ganged94619192ganged
gangers94418602gangers
gauger84714852gauger
ginger84920032ginger
granger93514212granger
hander104526432hander
hangar104114512hangar
hanged114222392hanged
hangers113120812hangers
hanker134622092hanker
hinger104723332hinger
huger94914872huger
hunger104015202hunger
infer84215032infer
inker94421092inker
inner54920632inner
inter55028492inter
jaeger14397192jaeger
jager134318132jager
jagger154016002jagger
jangler153811832jangler
laager74312782laager
lager65132862lager
lagger85919832lagger
lancer84319972lancer
lander74028482lander
langur7109302langur
lanker104123002lanker
lanner64920602lanner
larger74417512larger
leger65721512leger
liger65024472liger
linger75226002linger
longer75823202longer
luger65322082luger
lunger75720422lunger
manager103413582manager
mange84930192mange_
mangel94017532mangel
mangers103521262mangers
manges94628942manges
mangey123614522mangey
mangier104114062mangier
mangler103215642mangler
manner84020512manner
mauger93813482mauger
monger94418332monger
nagger84016122nagger
namer75622102namer
onager739662onager
pager84728202pager
pander93725522pander
panged104722332panged
pangen94115912pangen
panier84425502panier
panner84224762panner
panzer174213232panzer
pinger94324092pinger
range64728412range_
ranged84824312ranged
rangers83621042rangers
ranges73826922ranges
rangier83714352rangier
ranker105021902ranker
ranter63826822ranter
ringer74526062ringer
roger64521412roger
sager65432052sager
sagger84321072sagger
sander74828532sander
saner54334322san_er
sangar73617682sangar
sangers84421942sangers
sauger74316252sauger
singer74227312singer
sneer54919952sneer
tagger84017702tagger
tanager83010942tanager
tanged84622492tanged
tangier83013902tangier
tangler83515072tangler
tanker104521122tanker
tanner63722282tanner
tiger65718632tiger
tonger74719682tonger
twanger11327432twanger
under64624212under
urger64116472urger
vanner94215842vanner
wager95925052wager
wagger113616012wagger
wander104423712wander
wangler113312652wangler
wanier93920682wanier
wanker134219972wanker
wanner94019622wanner
wanter94423052wanter
winger104125442winger
yager95616752yager
zander163417112zander
zanier154314712zanier
zinger163816702zinger

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.343520965.0
2DLD Change Limit538002141.54634799.5
3Display Results2142140.0633396.8
 (SQL Overall)1786912141.95291542.5
 
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.